| KENYA WOMEN FINANCE TRUST | ||||||||||||||||||||||||||||||||||||||||||
| LOAN PORTFOLIO DATA ANALYSIS MAY 2009 | ||||||||||||||||||||||||||||||||||||||||||
| MT K EAST | MT K WEST | NBI NORTH | NBI CENTRAL | CENTRAL RIFT | CENTRAL ZONE | SOUTH COAST | NORTH COAST | EASTERN | L EASTERN | EASTERN ZONE | C NYANZA | S NYANZA | WESTERN | SOUTH RIFT | NORTH RIFT | WESTERN ZONE | TOTAL | MT K EAST | MT K WEST | NBI NORTH | NAIROBI | CENTRAL RIFT | CENTRAL ZONE | SOUTH COAST | NORTH COAST | EASTERN | L EASTERN | EASTERN ZONE | C NYANZA | S NYANZA | WESTERN | SOUTH RIFT | NORTH RIFT | WESTERN ZONE | TOTAL | GRAND TOTAL | ||||||
| ACTUALS | GROUP | GROUP | GROUP | GROUP | GROUP | GROUP | GROUP | GROUP | GROUP | GROUP | GROUP | GROUP | GROUP | GROUP | GROUP | GROUP | GROUP | GROUP | INDIVIDUAL | INDIVIDUAL | INDIVIDUAL | INDIVIDUAL | INDIVIDUAL | INDIVIDUAL | INDIVIDUAL | INDIVIDUAL | INDIVIDUAL | INDIVIDUAL | INDIVIDUAL | INDIVIDUAL | INDIVIDUAL | INDIVIDUAL | INDIVIDUAL | INDIVIDUAL | INDIVIDUAL | INDIVIDUAL | GRP & IND | |||||
| Bal b/f | 249,563,103 | 406,940,470 | 437,358,177 | 505,478,867 | 483,239,810 | 2,082,580,427 | 415,236,044 | 406,170,329 | 328,300,292 | 283,358,678 | 1,433,065,343 | 266,776,171 | 499,528,460 | 905,061,626 | 422,145,290 | 564,546,839 | 2,658,058,386 | 6,173,704,156 | 31,332,883 | 27,264,292 | 56,188,841 | 114,376,602 | 100,240,557 | 329,403,175 | 25,167,948 | 20,185,403 | 18,532,913 | 27,695,303 | 91,581,567 | 14,323,085 | 10,681,415 | 83,091,615 | 45,329,474 | 106,691,985 | 260,117,574 | 681,102,315 | 6,854,806,472 | |||||
| Disbursements | 277,317,827 | 261,599,793 | 297,233,670 | 428,354,819 | 334,149,895 | 1,598,656,004 | 296,947,809 | 220,438,638 | 295,993,526 | 197,849,382 | 1,011,229,355 | 152,937,053 | 423,163,619 | 576,607,119 | 379,178,411 | 550,832,329 | 2,082,718,531 | 4,692,603,890 | 45,365,804 | 44,120,000 | 82,850,000 | 170,620,980 | 87,265,000 | 430,221,784 | 24,420,000 | 16,800,000 | 45,370,000 | 23,990,000 | 110,580,000 | 30,270,000 | 42,900,000 | 72,820,000 | 52,920,000 | 139,900,000 | 338,810,000 | 879,611,784 | 5,572,215,674 | |||||
| Repayments | 189,677,135 | 202,466,891 | 261,714,850 | 287,281,915 | 261,564,706 | 1,202,705,496 | 145,905,106 | 201,000,098 | 224,258,939 | 193,746,454 | 764,910,597 | 170,759,802 | 373,614,936 | 509,731,103 | 208,344,162 | 453,965,057 | 1,716,415,061 | 3,684,031,154 | 27,611,527 | 33,705,637 | 59,499,992 | 123,305,208 | 60,001,778 | 304,124,143 | 10,121,566 | 13,234,569 | 25,840,726 | 24,994,525 | 74,191,386 | 24,244,273 | 21,920,354 | 36,688,358 | 25,544,863 | 98,255,482 | 206,653,330 | 584,968,858 | 4,269,000,012 | #DIV/0! | ||||
| Bal c/f | 337,203,795 | 466,073,372 | 472,876,997 | 646,551,771 | 555,824,999 | 2,478,530,935 | 566,278,747 | 425,608,869 | 400,034,879 | 287,461,606 | 1,679,384,101 | 248,953,422 | 549,077,143 | 971,937,642 | 592,979,539 | 661,414,111 | 3,024,361,857 | 7,182,276,892 | 49,087,160 | 37,678,655 | 79,538,849 | 161,692,374 | 127,503,779 | 455,500,816 | 39,466,382 | 23,750,834 | 38,062,187 | 26,690,778 | 127,970,181 | 20,348,812 | 31,661,061 | 119,223,257 | 72,704,610 | 148,336,503 | 392,274,244 | 975,745,241 | 8,158,022,133 | |||||
| DUES | ||||||||||||||||||||||||||||||||||||||||||
| Bal b/f | 249,563,103 | 406,940,470 | 437,358,177 | 505,478,867 | 483,239,810 | 2,082,580,427 | 415,236,044 | 406,170,329 | 328,300,292 | 283,358,678 | 1,433,065,343 | 266,776,171 | 499,528,460 | 905,061,626 | 422,145,290 | 564,546,839 | 2,658,058,386 | 6,173,704,156 | 31,332,883 | 27,264,292 | 56,188,841 | 114,376,602 | 100,240,557 | 329,403,175 | 25,167,948 | 20,185,403 | 18,532,913 | 27,695,303 | 91,581,567 | 14,323,085 | 10,681,415 | 83,091,615 | 45,329,474 | 106,691,985 | 260,117,574 | 681,102,315 | 6,854,806,472 | |||||
| Disbursements | 277,317,827 | 261,599,793 | 297,233,670 | 428,354,819 | 334,149,895 | 1,598,656,004 | 296,947,809 | 220,438,638 | 295,993,526 | 197,849,382 | 1,011,229,355 | 152,937,053 | 423,163,619 | 576,607,119 | 379,178,411 | 550,832,329 | 2,082,718,531 | 4,692,603,890 | 45,365,804 | 44,120,000 | 82,850,000 | 170,620,980 | 87,265,000 | 430,221,784 | 24,420,000 | 16,800,000 | 45,370,000 | 23,990,000 | 110,580,000 | 30,270,000 | 42,900,000 | 72,820,000 | 52,920,000 | 139,900,000 | 338,810,000 | 879,611,784 | 5,572,215,674 | |||||
| Repayments | 194,516,337 | 207,831,243 | 262,477,033 | 290,995,642 | 268,842,227 | 1,224,662,481 | 149,734,311 | 206,092,585 | 225,101,579 | 194,481,504 | 775,409,979 | 187,957,944 | 380,918,139 | 523,169,751 | 221,729,084 | 466,803,763 | 1,780,578,682 | 3,780,651,142 | 29,151,825 | 33,705,637 | 60,456,855 | 125,134,298 | 61,816,972 | 310,265,588 | 10,369,966 | 18,327,056 | 25,840,726 | 25,104,525 | 79,642,273 | 26,780,018 | 23,280,554 | 39,677,744 | 27,654,270 | 102,313,382 | 219,705,968 | 609,613,828 | 4,390,264,970 | |||||
| Bal c/f | 332,364,593 | 460,709,020 | 472,114,814 | 642,838,044 | 548,547,478 | 2,456,573,950 | 562,449,542 | 420,516,382 | 399,192,239 | 286,726,556 | 1,668,884,719 | 231,755,280 | 541,773,940 | 958,498,994 | 579,594,617 | 648,575,405 | 2,960,198,236 | 7,085,656,904 | 47,546,862 | 37,678,655 | 78,581,986 | 159,863,284 | 125,688,585 | 449,359,371 | 39,217,982 | 18,658,347 | 38,062,187 | 26,580,778 | 122,519,294 | 17,813,067 | 30,300,861 | 116,233,871 | 70,595,203 | 144,278,603 | 379,221,606 | 951,100,271 | 8,036,757,175 | |||||
| ANALYSIS | ||||||||||||||||||||||||||||||||||||||||||
| ARREARS AMOUNTS | ||||||||||||||||||||||||||||||||||||||||||
| Period 1 To 30 Days | 1,237,260 | 307,221 | 172,983 | 566,095 | 694,747 | 2,978,306 | 655,660 | 206,500 | 65,000 | 318,266 | 1,245,426 | 62,800 | 28,450 | 512,800 | 104,485 | - | 708,535 | 4,932,267 | 632,553 | - | 756,663 | 273,590 | 695,553 | 2,358,359 | 100,400 | 206,500 | - | - | 306,900 | 73,660 | 177,040 | 149,668 | 166,477 | 336,867 | 903,712 | 3,568,971 | 8,501,238 | |||||
| Period 31 To 60 Days | 331,204 | 218,286 | 216,200 | 406,250 | 525,760 | 1,697,700 | 243,300 | 753,637 | 132,540 | 155,440 | 1,284,917 | 164,645 | 1,482,450 | 522,608 | 330,725 | 304,790 | 2,805,218 | 5,787,835 | 173,740 | - | 114,100 | 455,000 | 235,347 | 978,187 | 30,000 | 753,637 | - | 110,000 | 893,637 | 104,660 | 144,890 | - | 160,490 | - | 410,040 | 2,281,864 | 8,069,699 | |||||
| Period 61 To 90 Days | 199,834 | 293,650 | 40,000 | 128,400 | 551,960 | 1,213,844 | 158,530 | 297,452 | 262,000 | 188,949 | 906,931 | 70,250 | 2,197,656 | 177,400 | 104,485 | - | 2,549,791 | 4,670,566 | 109,320 | - | 13,800 | 778,500 | 152,197 | 1,053,817 | 30,000 | 297,452 | - | - | 327,452 | 89,060 | 125,570 | 43,334 | 52,450 | - | 310,414 | 1,691,683 | 6,362,249 | |||||
| Period 91 To 120 Days | 217,854 | 70,300 | - | 200,000 | 1,228,695 | 1,716,849 | 242,900 | 532,780 | - | 72,395 | 848,075 | 853,849 | 2,907,399 | 912,066 | 69,065 | - | 4,742,379 | 7,307,303 | 159,720 | - | 72,300 | 154,000 | 152,197 | 538,217 | 30,000 | 532,780 | - | - | 562,780 | 43,810 | 152,000 | 34,784 | 243,850 | - | 474,444 | 1,575,441 | 8,882,744 | |||||
| Period 121 And Above | 2,853,050 | 4,474,895 | 333,000 | 2,412,982 | 4,276,359 | 14,350,286 | 2,528,815 | 3,302,118 | 383,100 | - | 6,214,033 | 16,046,598 | 687,248 | 11,313,774 | 12,776,162 | 12,533,916 | 53,357,698 | 73,922,017 | 464,965 | - | - | 168,000 | 579,900 | 1,212,865 | 58,000 | 3,302,118 | - | - | 3,360,118 | 2,224,555 | 760,700 | 2,761,600 | 1,486,140 | 3,721,033 | 10,954,028 | 15,527,011 | 89,449,028 | |||||
| Total | 4,839,202 | 5,364,352 | 762,183 | 3,713,727 | 7,277,521 | 21,956,985 | 3,829,205 | 5,092,487 | 842,640 | 735,050 | 10,499,382 | 17,198,142 | 7,303,203 | 13,438,648 | 13,384,922 | 12,838,706 | 64,163,621 | 96,619,988 | 1,540,298 | - | 956,863 | 1,829,090 | 1,815,194 | 6,141,445 | 248,400 | 5,092,487 | - | 110,000 | 5,450,887 | 2,535,745 | 1,360,200 | 2,989,386 | 2,109,407 | 4,057,900 | 13,052,638 | 24,644,970 | 121,264,958 | |||||
| Check=0 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||||||||||||
| ARREARS NOS. | ||||||||||||||||||||||||||||||||||||||||||
| Period 1 To 30 Days | 192 | 66 | 44 | 34 | 94 | 430 | 43 | 13 | 7 | 63 | 126 | 15 | 6 | 78 | 11 | 60 | 170 | 726 | 30 | - | 65 | 10 | 18 | 123 | 4 | 13 | - | - | 17 | 2 | 6 | 3 | 5 | 12 | 28 | 168 | 894 | |||||
| Period 31 To 60 Days | 73 | 22 | 23 | 58 | 48 | 224 | 25 | 84 | 20 | 8 | 137 | 33 | 149 | 48 | 17 | - | 247 | 608 | 6 | - | 5 | 13 | 4 | 28 | 1 | 84 | - | 1 | 86 | 5 | 3 | - | 4 | - | 12 | 126 | 734 | |||||
| Period 61 To 90 Days | 42 | 29 | 1 | 14 | 50 | 136 | 5 | 31 | 5 | 3 | 44 | 10 | 246 | 15 | 11 | - | 282 | 462 | 4 | - | 1 | 7 | - | 12 | 1 | 31 | - | - | 32 | - | 2 | 2 | - | - | 4 | 48 | 510 | |||||
| Period 91 To 120 Days | 32 | 2 | - | 21 | 58 | 113 | 9 | 16 | - | 2 | 27 | 50 | 287 | 21 | 11 | - | 369 | 509 | 1 | - | 1 | - | 2 | 4 | 1 | 16 | - | - | 17 | 3 | 3 | 1 | 2 | - | 9 | 30 | 539 | |||||
| Period 121 And Above | 142 | 121 | 22 | 229 | 227 | 741 | 107 | 211 | 12 | - | 330 | 805 | 76 | 335 | 536 | 566 | 2,318 | 3,389 | 3 | - | - | 1 | 9 | 13 | 1 | 211 | - | - | 212 | 11 | 7 | 29 | 13 | 31 | 91 | 316 | 3,705 | |||||
| Total | 481 | 240 | 90 | 356 | 477 | 1,644 | 189 | 355 | 44 | 76 | 664 | 913 | 764 | 497 | 586 | 626 | 3,386 | 5,694 | 44 | - | 72 | 31 | 33 | 180 | 8 | 355 | - | 1 | 364 | 21 | 21 | 35 | 24 | 43 | 144 | 688 | 6,382 | |||||
| CLIENTS AND LOAN STATISTICS | ||||||||||||||||||||||||||||||||||||||||||
| No of members beg of Year | 14,685 | 17,009 | 12,856 | 12,358 | 15,803 | 72,711 | 13,770 | 11,984 | 19,559 | 11,313 | 56,626 | 12,875 | 20,865 | 28,297 | 15,562 | 25,769 | 103,368 | 232,705 | 332 | 169 | 417 | 744 | 474 | 2,136 | 144 | 115 | 107 | 129 | 495 | 166 | 221 | 598 | 240 | 755 | 1,980 | 4,611 | 237,316 | |||||
| No of new members year todate | 8,470 | 4,945 | 3,861 | 6,396 | 3,798 | 27,470 | 5,531 | 4,904 | 7,826 | 3,900 | 22,161 | 3,517 | 4,379 | 8,462 | 4,964 | 8,456 | 29,778 | 79,409 | 183 | 195 | 229 | 448 | 194 | 1,249 | 60 | 32 | 178 | 126 | 396 | 143 | 84 | 288 | 160 | 562 | 1,237 | 2,882 | 82,291 | |||||
| No of drop outs year todate | 1,452 | 1,585 | 1,219 | 1,798 | 688 | 6,742 | 666 | - | 788 | 1,454 | 1,459 | 1,394 | 3,685 | 763 | 716 | 8,017 | 16,213 | 12 | 8 | 9 | 175 | - | 204 | 9 | - | - | 33 | 42 | 17 | - | 104 | 5 | 3 | 129 | 375 | 16,588 | ||||||
| No of members year todate | 21,703 | 20,369 | 15,498 | 16,956 | 18,913 | 93,439 | 18,635 | 16,888 | 27,385 | 14,425 | 77,333 | 14,933 | 23,850 | 33,074 | 19,763 | 33,509 | 125,129 | 295,901 | 503 | 356 | 637 | 1,017 | 668 | 3,181 | 195 | 147 | 285 | 222 | 849 | 292 | 305 | 782 | 395 | 1,314 | 3,088 | 7,118 | 303,019 | |||||
| Active members | 20,251 | 18,586 | 13,281 | 16,634 | 18,180 | 86,932 | 15,203 | 15,390 | 23,628 | 14,008 | 68,229 | 10,225 | 23,141 | 29,462 | 15,960 | 32,801 | 111,589 | 266,750 | 474 | 343 | 613 | 1,005 | 633 | 3,068 | 195 | 147 | 253 | 209 | 804 | 122 | 268 | 722 | 336 | 1,299 | 2,747 | 6,619 | 273,369 | |||||
| Inactive members | 1,452 | 1,783 | 2,217 | 322 | 733 | 6,507 | 3,432 | 1,498 | 3,757 | 417 | 9,104 | 4,708 | 709 | 3,612 | 3,803 | 708 | 13,540 | 29,151 | 29 | 13 | 24 | 12 | 35 | 113 | - | - | 32 | 13 | 45 | 170 | 37 | 60 | 59 | 15 | 341 | 499 | 29,650 | |||||
| diff | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||||||||||||||||||||
| No of outstanding loans beg of yr | 12,998 | 10,354 | 11,119 | 11,272 | 14,115 | 59,858 | 15,464 | 22,531 | 18,979 | 13,674 | 70,648 | 10,216 | 16,834 | 25,082 | 12,347 | 46,275 | 110,754 | 241,260 | 283 | 144 | 395 | 719 | 435 | 1,976 | 123 | 88 | 76 | 90 | 377 | 112 | 193 | 505 | 204 | 939 | 1,953 | 4,306 | 245,566 | |||||
| No of new loans | 8,584 | 6,044 | 7,114 | 9,020 | 8,049 | 38,811 | 7,579 | 6,309 | 11,197 | 6,238 | 31,323 | 4,877 | 10,928 | 17,424 | 9,263 | 14,511 | 57,003 | 127,137 | 141 | 172 | 288 | 612 | 230 | 1,443 | 69 | 50 | 173 | 95 | 387 | 117 | 152 | 309 | 160 | 558 | 1,296 | 3,126 | 130,263 | |||||
| No of retired loans(including savings) | 5,435 | 2,237 | 4,584 | 7,344 | 7,067 | 26,667 | 5,255 | 9,031 | 5,756 | 3,743 | 23,785 | 3,137 | 6,707 | 11,679 | 5,372 | 15,593 | 42,488 | 92,940 | 20 | 25 | 166 | 347 | 224 | 782 | 31 | 33 | 30 | 55 | 149 | 27 | 123 | 136 | 5 | 152 | 443 | 1,373 | 94,314 | |||||
| No of outstanding loans end of yr | 16,147 | 14,161 | 13,649 | 12,948 | 15,097 | 72,002 | 15,462 | 17,483 | 22,094 | 13,842 | 78,186 | 11,956 | 21,055 | 30,760 | 16,238 | 45,193 | 125,202 | 275,390 | 431 | 302 | 528 | 998 | 454 | 2,713 | 161 | 105 | 219 | 130 | 615 | 202 | 222 | 678 | 359 | 1,345 | 2,806 | 6,134 | 281,515 | |||||
| Outstanding Loans _Active | 16,021 | 14,056 | 13,643 | 12,557 | 14,889 | 71,166 | 15,355 | 16,886 | 22,082 | 13,842 | 68,165 | 11,889 | 20,988 | 30,760 | 15,635 | 44,562 | 123,834 | 263,165 | 431 | 244 | 220 | 220 | 445 | 1,560 | 153 | 103 | 217 | 128 | 601 | 192 | 215 | 658 | 336 | 1,314 | 2,715 | 4,876 | 268,040 | |||||
| Outstanding Loans _Inactive | 126 | 105 | 6 | 391 | 208 | 836 | 107 | 597 | 12 | - | 716 | 67 | 67 | - | 603 | 631 | 1,368 | 2,920 | - | 58 | 308 | 778 | 9 | 1,153 | 8 | 2 | 2 | 2 | 14 | 10 | 7 | 20 | 23 | 31 | 91 | 1,258 | 13,475 | |||||
| Diff | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |||||||||||
| Savings Balance | 193,251,001 | 188,373,638 | 136,746,056 | 245,698,819 | 212,650,863 | 976,720,377 | 430,636,663 | 343,972,012 | 163,019,933 | 143,458,811 | 1,081,087,419 | 95,072,101 | 145,444,985 | 278,837,873 | 193,945,890 | 278,304,466 | 991,605,315 | 3,049,413,111 | 15,492,400 | 6,060,511 | 13,740,047 | 31,462,901 | 20,503,414 | 87,259,273 | 6,370,246 | 5,412,417 | 4,443,173 | 4,327,800 | 20,553,636 | 325,487 | 4,423,171 | 17,305,817 | 10,233,962 | 40,396,000 | 72,684,437 | 180,497,346 | 3,229,910,457 | |||||
| savings to o/s loans | 57% | 40% | 29% | 38% | 38% | 39% | 76% | 81% | 41% | 50% | 64% | 38% | 26% | 29% | 33% | 42% | 33% | 42% | 32% | 16% | 17% | 19% | 16% | 19% | 16% | 23% | 12% | 16% | 16% | 2% | 14% | 15% | 14% | 27% | 19% | 18% | 40% | |||||
| Annualized Repayments | ||||||||||||||||||||||||||||||||||||||||||
| January 09 to Mar 09 | 189,677,135 | 202,466,891 | 261,714,850 | 287,281,915 | 261,564,706 | 1,202,705,496 | 145,905,106 | 201,000,098 | 224,258,939 | 193,746,454 | 764,910,597 | 170,759,802 | 373,614,936 | 509,731,103 | 208,344,162 | 453,965,057 | 1,716,415,061 | 3,684,031,154 | 27,611,527 | 33,705,637 | 59,499,992 | 123,305,208 | 60,001,778 | 304,124,143 | 10,121,566 | 13,234,569 | 25,840,726 | 24,994,525 | 74,191,386 | 24,244,273 | 21,920,354 | 36,688,358 | 25,544,863 | 98,255,482 | 206,653,330 | 584,968,858 | 4,269,000,012 | |||||
| 4,226,993,550 | 680,637,182 | 4,907,630,732 | ||||||||||||||||||||||||||||||||||||||||
| Total | 189,677,135 | 202,466,891 | 261,714,850 | 287,281,915 | 261,564,706 | 1,202,705,496 | 145,905,106 | 201,000,098 | 224,258,939 | 193,746,454 | 764,910,597 | 170,759,802 | 373,614,936 | 509,731,103 | 208,344,162 | 453,965,057 | 1,716,415,061 | 7,911,024,704 | 27,611,527 | 33,705,637 | 59,499,992 | 123,305,208 | 60,001,778 | 304,124,143 | 10,121,566 | 13,234,569 | 25,840,726 | 24,994,525 | 74,191,386 | 24,244,273 | 21,920,354 | 36,688,358 | 25,544,863 | 98,255,482 | 206,653,330 | 1,265,606,040 | 9,176,630,745 | |||||
| Annualized repayment rate | 97.4% | 97.4% | 99.7% | 98.7% | 97.2% | 98.2% | 97.4% | 97.5% | 99.6% | 99.6% | 98.6% | 89.9% | 98.0% | 97.4% | 93.6% | 97.2% | 96.3% | 98.8% | 94.4% | 100.0% | 98.4% | 98.5% | 97.0% | 98.0% | 97.5% | 61.5% | 100.0% | 99.6% | 92.7% | 89.5% | 93.8% | 91.9% | 91.7% | 95.9% | 93.7% | 98.1% | 98.7% | |||||
| PORTFOLIO AT RISK AGEING: | ||||||||||||||||||||||||||||||||||||||||||
| Portfolio At Risk Low: | - | - | - | |||||||||||||||||||||||||||||||||||||||
| Period 1 To 30 Days | 4,290,445 | - | - | - | 2,201,800 | 6,492,245 | 3,035,342 | 35,342 | 65,000 | 318,266 | 3,453,950 | 1,488,627 | 72,047 | - | - | 2,120,000 | 3,680,674 | 13,626,869 | 772,895 | - | 499,730 | - | 1,700,030 | 2,972,655 | 35,342 | 35,342 | - | - | 70,684 | 2,346,124 | 423,115 | - | 1,330,554 | 1,660,000 | 5,759,793 | 8,803,132 | 22,430,001 | |||||
| Period 31 To 60 Days | 839,065 | - | 1,261,850 | - | 769,917 | 2,870,832 | 566,837 | 428,250 | 83,000 | 155,440 | 1,233,527 | 2,160,825 | 1,714,795 | - | 394,789 | - | 4,270,409 | 8,374,768 | 32,500 | - | 511,960 | - | 838,889 | 1,383,349 | 77,900 | 77,900 | - | 110,000 | 265,800 | 4,356,745 | 318,785 | - | 344,443 | - | 5,019,973 | 6,669,122 | 15,043,890 | |||||
| Sub total | 5,129,510 | - | 1,261,850 | - | 2,971,717 | 9,363,077 | 3,602,179 | 463,592 | 148,000 | 473,706 | 4,687,477 | 3,649,452 | 1,786,842 | - | 394,789 | 2,120,000 | 7,951,083 | 22,001,637 | 805,395 | - | 1,011,690 | - | 2,538,919 | 4,356,004 | 113,242 | 113,242 | - | 110,000 | 336,484 | 6,702,869 | 741,900 | - | 1,674,997 | 1,660,000 | 10,779,766 | 15,472,254 | 37,473,891 | |||||
| Portfolio At Risk High: | ||||||||||||||||||||||||||||||||||||||||||
| Period 61 To 90 Days | 195,360 | - | 235,060 | - | 352,614 | 783,034 | 484,688 | 484,688 | 262,000 | 188,949 | 1,420,325 | 5,326,963 | 3,425,740 | - | - | - | 8,752,703 | 10,956,062 | 129,600 | - | 167,543 | - | - | 297,143 | - | - | - | - | - | 3,225,590 | 185,820 | - | - | - | 3,411,410 | 3,708,553 | 14,664,615 | |||||
| Period 91 To 120 Days | 261,680 | - | - | - | 1,732,519 | 1,994,199 | 64,800 | 64,800 | - | 72,395 | 201,995 | 28,507,029 | 4,079,955 | - | - | - | 32,586,984 | 34,783,178 | 500,000 | - | - | - | 368,778 | 868,778 | - | - | - | - | - | 1,022,146 | 386,441 | - | 233,333 | - | 1,641,920 | 2,510,698 | 37,293,876 | |||||
| Period 121 And Above | 3,151,265 | - | - | - | 2,557,477 | 5,708,742 | - | 1,443,014 | 383,100 | 28,200 | 1,854,314 | 15,262,263 | 791,324 | - | 11,022,702 | 17,690,450 | 44,766,739 | 52,329,795 | 511,375 | - | - | - | 1,160,385 | 1,671,760 | - | - | - | - | - | 434,876 | 644,661 | - | 1,651,524 | - | 2,731,061 | 4,402,821 | 56,732,616 | |||||
| Sub total | 3,608,305 | - | 235,060 | - | 4,642,610 | 8,485,975 | 549,488 | 1,992,502 | 645,100 | 289,544 | 3,476,634 | 49,096,255 | 8,297,019 | - | 11,022,702 | 17,690,450 | 86,106,426 | 98,069,035 | 1,140,975 | - | 167,543 | - | 1,529,163 | 2,837,681 | - | - | - | - | - | 4,682,612 | 1,216,922 | - | 1,884,857 | - | 7,784,391 | 10,622,072 | 108,691,107 | |||||
| Grand total | 8,737,815 | - | 1,496,910 | - | 7,614,327 | 17,849,052 | 4,151,667 | 2,456,094 | 793,100 | 763,250 | 8,164,111 | 52,745,707 | 10,083,861 | - | 11,417,491 | 19,810,450 | 94,057,509 | 120,070,672 | 7,193,685 | - | 110,000 | 336,484 | 11,385,481 | 1,958,822 | - | 3,559,854 | 1,660,000 | 18,564,157 | 26,094,326 | 146,164,998 | ||||||||||||
| LOAN PRODUCTS | ||||||||||||||||||||||||||||||||||||||||||
| BIASHARA LOANS | ||||||||||||||||||||||||||||||||||||||||||
| Disbursements(Amounts) | ||||||||||||||||||||||||||||||||||||||||||
| Msingi | 133,344,145 | 116,760,977 | 154,079,159 | 114,816,435 | 0 | 519,000,716 | 126,059,640 | 96,396,000 | 214,917,000 | 64,767,560 | 502,140,200 | 54,755,000 | 221,256,900 | 264,958,172 | 134,350,000 | 291,675,000 | 966,995,072 | 1,988,135,988 | 1,988,135,988 | |||||||||||||||||||||||
| Uchumi | 50,240,500 | 12,890,000 | 35,265,000 | 46,803,000 | 0 | 145,198,500 | 26,905,000 | 14,255,000 | 15,635,000 | 39,750,100 | 96,545,100 | 38,750,000 | 59,270,000 | 124,225,000 | 101,459,000 | 108,255,000 | 431,959,000 | 673,702,600 | 673,702,600 | |||||||||||||||||||||||
| Mafanikio | 16,050,000 | 89,731,000 | 27,010,627 | 33,930,000 | 0 | 166,721,627 | 83,755,000 | 69,840,000 | 17,625,000 | 55,165,000 | 226,385,000 | 39,355,000 | 94,160,000 | 53,843,000 | 49,580,000 | 63,900,000 | 300,838,000 | 693,944,627 | 693,944,627 | |||||||||||||||||||||||
| Pepea | 8,350,000 | 6,530,000 | 22,673,528 | 24,800,000 | 0 | 62,353,528 | 6,750,000 | 10,890,000 | 0 | 8,840,000 | 26,480,000 | 1,000,000 | 7,960,000 | 13,770,000 | 33,910,000 | 4,000,000 | 60,640,000 | 149,473,528 | 149,473,528 | |||||||||||||||||||||||
| Biashara Star | 0 | 6,500,000 | 3,550,000 | 9,000,000 | 0 | 19,050,000 | 10,250,000 | 3,100,000 | 500,000 | 9,700,000 | 23,550,000 | 0 | 500,000 | 7,500,000 | 17,100,000 | 0 | 25,100,000 | 67,700,000 | 67,700,000 | |||||||||||||||||||||||
| Total Biashara Loans | 207,984,645 | 232,411,977 | 242,578,314 | 229,349,435 | - | 912,324,371 | 253,719,640 | 194,481,000 | 248,677,000 | 178,222,660 | 875,100,300 | 133,860,000 | 383,146,900 | 464,296,172 | 336,399,000 | 467,830,000 | 1,785,532,072 | 3,572,956,743 | 3,572,956,743 | |||||||||||||||||||||||
| MWANGAZA LOANS | ||||||||||||||||||||||||||||||||||||||||||
| Mwangaza-Gold | 12,495,000 | 600,000 | 13,215,000 | 58,080,000 | 0 | 84,390,000 | 2,120,000 | 1,000,000 | 0 | 0 | 3,120,000 | 7,700,000 | 0 | 4,395,000 | 0 | 0 | 12,095,000 | 99,605,000 | 99,605,000 | |||||||||||||||||||||||
| Mwangaza-Silver | 5,300,000 | 1,550,000 | 6,490,000 | 42,204,000 | 0 | 55,544,000 | 7,350,000 | 0 | 0 | 0 | 7,350,000 | 4,400,000 | 8,550,000 | 6,990,000 | 0 | 11,490,000 | 31,430,000 | 94,324,000 | 94,324,000 | |||||||||||||||||||||||
| Mwangaza-Bronze | 5,300,000 | 560,000 | 3,300,000 | 34,240,032 | 0 | 43,400,032 | 1,910,000 | 200,000 | 0 | 0 | 2,110,000 | 1,000,000 | 5,460,000 | 5,410,000 | 0 | 5,540,000 | 17,410,000 | 62,920,032 | 62,920,032 | |||||||||||||||||||||||
| Mwangaza Star | 0 | 1,500,000 | 4,100,000 | 45,000,000 | 0 | 50,600,000 | 1,000,000 | 0 | 0 | 0 | 1,000,000 | 0 | 0 | 3,500,000 | 0 | 1,000,000 | 4,500,000 | 56,100,000 | 56,100,000 | |||||||||||||||||||||||
| Total Mwangaza loans | 23,095,000 | 4,210,000 | 27,105,000 | 179,524,032 | - | 233,934,032 | 12,380,000 | 1,200,000 | - | - | 13,580,000 | 13,100,000 | 14,010,000 | 20,295,000 | - | 18,030,000 | 65,435,000 | 312,949,032 | 312,949,032 | |||||||||||||||||||||||
| SPECIAL LOANS | ||||||||||||||||||||||||||||||||||||||||||
| Elimu | 4,590,942 | 5,494,557 | 5,603,025 | 11,022,590 | 0 | 26,711,114 | 12,798,286 | 5,529,460 | 6,117,464 | 6,117,464 | 30,562,674 | 3,108,279 | 8,826,363 | 26,392,555 | 9,480,065 | 18,709,249 | 66,516,511 | 123,790,299 | 123,790,299 | |||||||||||||||||||||||
| Tatua | 0 | 160,000 | 0 | 0 | 0 | 160,000 | 5,740,000 | 695,000 | 180,452 | 180,452 | 6,795,904 | 0 | 931,782 | 270,000 | 0 | 690,000 | 1,891,782 | 8,847,686 | 8,847,686 | |||||||||||||||||||||||
| Consumer | 15,904,498 | 12,372,004 | 15,104,253 | 11,668,084 | 0 | 55,048,839 | 10,093,652 | 14,418,418 | 9,717,223 | 9,717,223 | 43,946,516 | 3,333,537 | 16,248,574 | 46,906,091 | 17,194,384 | 28,989,795 | 112,672,381 | 211,667,736 | 211,667,736 | |||||||||||||||||||||||
| Afya Card | 0 | 0 | 6,751,000 | 0 | 0 | 6,751,000 | 1,940,000 | 3,647,000 | 0 | 0 | 5,587,000 | 0 | 0 | 16,660,000 | 0 | 0 | 16,660,000 | 28,998,000 | 28,998,000 | |||||||||||||||||||||||
| Start up Loans | 25,183,000 | 5,825,000 | 0 | 6,790,678 | 0 | 37,798,678 | 0 | 467,760 | 2,420,000 | 2,420,000 | 5,307,760 | 0 | 0 | 1,787,301 | 11,645,000 | 15,682,000 | 29,114,301 | 72,220,739 | 72,220,739 | |||||||||||||||||||||||
| Total Special loans | 45,678,440 | 23,851,561 | 27,458,278 | 29,481,352 | - | 126,469,631 | 30,571,938 | 24,757,638 | 18,435,139 | 18,435,139 | 92,199,854 | 6,441,816 | 26,006,719 | 92,015,947 | 38,319,449 | 64,071,044 | 226,854,975 | 445,524,460 | 445,524,460 | |||||||||||||||||||||||
| Total Group Disbursements(Amounts) | 276,758,085 | 260,473,538 | 297,141,592 | 438,354,819 | - | 1,272,728,034 | 296,671,578 | 220,438,638 | 267,112,139 | 196,657,799 | 980,880,154 | 153,401,816 | 423,163,619 | 576,607,119 | 374,718,449 | 549,931,044 | 2,077,822,047 | 4,331,430,235 | 4,331,430,235 | |||||||||||||||||||||||
| INDIVIDUAL LOANS | ||||||||||||||||||||||||||||||||||||||||||
| Mwamba Loan 1 | 20,565,804 | 16,770,000 | 48,890,000 | 65,592,530 | 0 | 151,818,334 | 10,270,000 | 11,400,000 | 36,620,000 | 8,040,000 | 66,330,000 | 27,920,000 | 16,750,000 | 35,330,000 | 26,250,000 | 102,710,000 | 208,960,000 | 427,108,334 | 427,108,334 | |||||||||||||||||||||||
| Mwamba Loan 2 | 13,500,000 | 6,200,000 | 16,500,000 | 65,028,450 | 0 | 101,228,450 | 2,700,000 | 2,900,000 | 8,250,000 | 5,200,000 | 19,050,000 | 2,350,000 | 15,500,000 | 29,640,000 | 15,600,000 | 37,190,000 | 100,280,000 | 220,558,450 | 220,558,450 | |||||||||||||||||||||||
| Mwamba Star | 11,300,000 | 21,150,000 | 17,460,000 | 40,000,000 | 0 | 89,910,000 | 11,450,000 | 2,500,000 | 44,870,000 | 13,240,000 | 72,060,000 | 0 | 10,650,000 | 7,850,000 | 11,070,000 | 0 | 29,570,000 | 59,140,000 | 59,140,000 | |||||||||||||||||||||||
| Total Ind Disbursements(Amounts) | 45,365,804 | 44,120,000 | 82,850,000 | 170,620,980 | 0 | 342,956,784 | 24,420,000 | 16,800,000 | 89,740,000 | 26,480,000 | 157,440,000 | 30,270,000 | 42,900,000 | 72,820,000 | 52,920,000 | 139,900,000 | 338,810,000 | 706,806,784 | 706,806,784 | |||||||||||||||||||||||
| BIASHARA LOANS | ||||||||||||||||||||||||||||||||||||||||||
| Disbursements(Nos) | ||||||||||||||||||||||||||||||||||||||||||
| Msingi | 4,129 | 3,553 | 4,407 | 3,767 | 0 | 15,856 | 4,670 | 3,238 | 6,194 | 3,524 | 17,626 | 3,206 | 7,364 | 8,473 | 5,114 | 6,585 | 30,742 | 64,224 | 64,224 | |||||||||||||||||||||||
| Uchumi | 1,073 | 187 | 362 | 995 | 0 | 2,617 | 402 | 172 | 227 | 706 | 1,507 | 695 | 908 | 2,459 | 1,238 | 1,958 | 7,258 | 11,382 | 11,382 | |||||||||||||||||||||||
| Mafanikio | 293 | 938 | 219 | 249 | 0 | 1,699 | 715 | 628 | 167 | 466 | 1,976 | 314 | 820 | 422 | 341 | 1,124 | 3,021 | 6,696 | 6,696 | |||||||||||||||||||||||
| Pepea | 90 | 24 | 82 | 89 | 0 | 285 | 22 | 32 | 0 | 26 | 80 | 0 | 30 | 47 | 108 | 180 | 365 | 730 | 730 | |||||||||||||||||||||||
| Biashara Star | 0 | 7 | 16 | 16 | 0 | 39 | 13 | 7 | 1 | 13 | 34 | 0 | 3 | 14 | 31 | 0 | 48 | 121 | 121 | |||||||||||||||||||||||
| Total Group Biashara Loans(Nos) | 5,585 | 4,709 | 5,086 | 5,116 | - | 20,496 | 5,822 | 4,077 | 6,589 | 4,735 | 21,223 | 4,215 | 9,125 | 11,415 | 6,832 | 9,847 | 41,434 | 83,153 | 83,153 | |||||||||||||||||||||||
| MWANGAZA LOANS | ||||||||||||||||||||||||||||||||||||||||||
| Mwangaza-Gold | 157 | 2 | 172 | 306 | 0 | 637 | 7 | 1 | 0 | 0 | 8 | 43 | 0 | 16 | 0 | 0 | 59 | 704 | 704 | |||||||||||||||||||||||
| Mwangaza-Silver | 87 | 13 | 66 | 341 | 0 | 507 | 68 | 0 | 0 | 0 | 68 | 21 | 78 | 50 | 0 | 127 | 276 | 851 | 851 | |||||||||||||||||||||||
| Mwangaza-Bronze | 70 | 9 | 40 | 661 | 0 | 780 | 36 | 2 | 0 | 0 | 38 | 2 | 71 | 61 | 0 | 67 | 201 | 1,019 | 1,019 | |||||||||||||||||||||||
| Mwangaza Star | 0 | 2 | 10 | 56 | 0 | 68 | 2 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 15 | 15 | 85 | 85 | |||||||||||||||||||||||
| Total Mwangaza Loans(Nos) | 314 | 26 | 288 | 1,364 | - | 1,992 | 113 | 3 | - | - | 116 | 66 | 149 | 127 | - | 209 | 551 | 2,659 | 2,659 | |||||||||||||||||||||||
| SPECIAL LOANS | ||||||||||||||||||||||||||||||||||||||||||
| Elimu | 222 | 224 | 212 | 349 | 0 | 1,007 | 450 | 158 | 694 | 279 | 1,581 | 258 | 366 | 1,186 | 371 | 830 | 3,011 | 5,599 | 5,599 | |||||||||||||||||||||||
| Tatua | 0 | 5 | 0 | 0 | 0 | 5 | 157 | 13 | 4 | 5 | 179 | 0 | 0 | 9 | 0 | 7 | 16 | 200 | 200 | |||||||||||||||||||||||
| Consumer | 1,464 | 1,112 | 1,359 | 1,368 | 0 | 5,303 | 845 | 1,804 | 2,337 | 744 | 5,730 | 367 | 1,271 | 3,916 | 1,374 | 2,482 | 9,410 | 20,443 | 20,443 | |||||||||||||||||||||||
| Afya Card | 0 | 0 | 89 | 0 | 0 | 89 | 121 | 146 | 1,248 | 0 | 1,515 | 0 | 0 | 911 | 0 | 0 | 911 | 2,515 | 2,515 | |||||||||||||||||||||||
| Start up Loans | 1,369 | 320 | 0 | 377 | 0 | 2,066 | 0 | 111 | 325 | 139 | 575 | 0 | 0 | 407 | 630 | 895 | 1,932 | 4,573 | 4,573 | |||||||||||||||||||||||
| Total Special Loans(Nos) | 3,055 | 1,661 | 1,660 | 2,094 | - | 8,470 | 1,573 | 2,232 | 4,608 | 1,167 | 9,580 | 625 | 1,637 | 6,429 | 2,375 | 4,214 | 15,280 | 33,330 | 33,330 | |||||||||||||||||||||||
| Total Group Disbursements(Nos) | 8,954 | 6,396 | 7,034 | 8,574 | - | 30,958 | 7,508 | 6,312 | 11,197 | 5,902 | 30,919 | 4,906 | 10,911 | 17,971 | 9,207 | 14,270 | 57,265 | 119,142 | 119,142 | |||||||||||||||||||||||
| INDIVIDUAL LOANS | ||||||||||||||||||||||||||||||||||||||||||
| Mwamba Loan 1 | 153 | 118 | 184 | 235 | 0 | 690 | 42 | 41 | 156 | 59 | 298 | 81 | 92 | 196 | 113 | 391 | 873 | 1,861 | 1,861 | |||||||||||||||||||||||
| Mwamba Loan 2 | 34 | 25 | 68 | 308 | 0 | 435 | 8 | 7 | 16 | 16 | 47 | 26 | 40 | 98 | 34 | 167 | 365 | 847 | 847 | |||||||||||||||||||||||
| Mwamba Star | 14 | 29 | 36 | 69 | 0 | 148 | 19 | 4 | 1 | 20 | 44 | 0 | 20 | 15 | 13 | 0 | 48 | 240 | 240 | |||||||||||||||||||||||
| Total Ind Disbursements(Nos) | 201 | 172 | 288 | 612 | 0 | 1,273 | 69 | 52 | 173 | 95 | 389 | 107 | 152 | 309 | 160 | 558 | 1,286 | 2,948 | 2,948 | |||||||||||||||||||||||