Hustle Fund Forecaster - Money254

	B	C	D	E	F	G
1
2					Fund Starting Balance	Ksh38,000
3					Interest Rate (Annual)	8%
4					Loan Tenure (Days)	360
5					Cycle Interest Rate	7.89%
6					Repayment Rate	75%
7
8	Cycle #	Weeks Post Launch	Fund Start	% of Fund Remaining	Cycle Gain (Interest)	Cycle Loss (Defaults)

9	1	0	Ksh38,000	100%	Ksh2,249	-Ksh9,500
10	2	51	Ksh30,749	81%	Ksh1,820	-Ksh7,687
11	3	103	Ksh24,881	65%	Ksh1,472	-Ksh6,220
12	4	154	Ksh20,133	53%	Ksh1,191	-Ksh5,033
13	5	206	Ksh16,291	43%	Ksh964	-Ksh4,073
14	6	257	Ksh13,183	35%	Ksh780	-Ksh3,296
15	7	309	Ksh10,667	28%	Ksh631	-Ksh2,667
16	8	360	Ksh8,632	23%	Ksh511	-Ksh2,158
17	9	411	Ksh6,985	18%	Ksh413	-Ksh1,746
18	10	463	Ksh5,652	15%	Ksh334	-Ksh1,413
19	11	514	Ksh4,573	12%	Ksh271	-Ksh1,143
20	12	566	Ksh3,701	10%	Ksh219	-Ksh925
21	13	617	Ksh2,994	8%	Ksh177	-Ksh749
22	14	669	Ksh2,423	6%	Ksh143	-Ksh606
23	15	720	Ksh1,961	5%	Ksh116	-Ksh490
24	16	771	Ksh1,587	4%	Ksh94	-Ksh397
25	17	823	Ksh1,284	3%	Ksh76	-Ksh321
26	18	874	Ksh1,039	3%	Ksh61	-Ksh260
27	19	926	Ksh841	2%	Ksh50	-Ksh210
28	20	977	Ksh680	2%	Ksh40	-Ksh170
29	21	1029	Ksh550	1%	Ksh33	-Ksh138
30	22	1080	Ksh445	1%	Ksh26	-Ksh111
31	23	1131	Ksh360	1%	Ksh21	-Ksh90
32	24	1183	Ksh292	1%	Ksh17	-Ksh73
33	25	1234	Ksh236	1%	Ksh14	-Ksh59
34	26	1286	Ksh191	1%	Ksh11	-Ksh48
35	27	1337	Ksh155	0%	Ksh9	-Ksh39
36	28	1389	Ksh125	0%	Ksh7	-Ksh31
37	29	1440	Ksh101	0%	Ksh6	-Ksh25
38	30	1491	Ksh82	0%	Ksh5	-Ksh20
39	31	1543	Ksh66	0%	Ksh4	-Ksh17
40	32	1594	Ksh54	0%	Ksh3	-Ksh13
41	33	1646	Ksh43	0%	Ksh3	-Ksh11
42	34	1697	Ksh35	0%	Ksh2	-Ksh9
43	35	1749	Ksh28	0%	Ksh2	-Ksh7
44	36	1800	Ksh23	0%	Ksh1	-Ksh6
45	37	1851	Ksh19	0%	Ksh1	-Ksh5
46	38	1903	Ksh15	0%	Ksh1	-Ksh4
47	39	1954	Ksh12	0%	Ksh1	-Ksh3
48	40	2006	Ksh10	0%	Ksh1	-Ksh2
49	41	2057	Ksh8	0%	Ksh0	-Ksh2
50	42	2109	Ksh6	0%	Ksh0	-Ksh2
51	43	2160	Ksh5	0%	Ksh0	-Ksh1
52	44	2211	Ksh4	0%	Ksh0	-Ksh1
53	45	2263	Ksh3	0%	Ksh0	-Ksh1
54	46	2314	Ksh3	0%	Ksh0	-Ksh1
55	47	2366	Ksh2	0%	Ksh0	-Ksh1
56	48	2417	Ksh2	0%	Ksh0	Ksh0
57	49	2469	Ksh1	0%	Ksh0	Ksh0
58	50	2520	Ksh1	0%	Ksh0	Ksh0
59	51	2571	Ksh1	0%	Ksh0	Ksh0
60	52	2623	Ksh1	0%	Ksh0	Ksh0
61	53	2674	Ksh1	0%	Ksh0	Ksh0
62	54	2726	Ksh1	0%	Ksh0	Ksh0
63	55	2777	Ksh0	0%	Ksh0	Ksh0
64	56	2829	Ksh0	0%	Ksh0	Ksh0
65	57	2880	Ksh0	0%	Ksh0	Ksh0
66	58	2931	Ksh0	0%	Ksh0	Ksh0
67	59	2983	Ksh0	0%	Ksh0	Ksh0
68	60	3034	Ksh0	0%	Ksh0	Ksh0
69	61	3086	Ksh0	0%	Ksh0	Ksh0
70	62	3137	Ksh0	0%	Ksh0	Ksh0
71	63	3189	Ksh0	0%	Ksh0	Ksh0
72	64	3240	Ksh0	0%	Ksh0	Ksh0
73	65	3291	Ksh0	0%	Ksh0	Ksh0
74	66	3343	Ksh0	0%	Ksh0	Ksh0
75	67	3394	Ksh0	0%	Ksh0	Ksh0
76	68	3446	Ksh0	0%	Ksh0	Ksh0
77	69	3497	Ksh0	0%	Ksh0	Ksh0
78	70	3549	Ksh0	0%	Ksh0	Ksh0
79	71	3600	Ksh0	0%	Ksh0	Ksh0
80	72	3651	Ksh0	0%	Ksh0	Ksh0
81	73	3703	Ksh0	0%	Ksh0	Ksh0
82	74	3754	Ksh0	0%	Ksh0	Ksh0
83	75	3806	Ksh0	0%	Ksh0	Ksh0
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100