SACCO Loan & Eligibility Planner. Enter your own figures, review the method and download a local financial report.
Workspace
Regular repaymentKSh 24,006.44
Review the cash you receive, interest, fees and the full repayment schedule.
Net proceeds after fees
KSh 495,000.00
Total loan payments
KSh 576,154.60
Interest paid
KSh 76,154.60
Fees deducted upfront
KSh 5,000.00
Total borrowing cost
KSh 81,154.60
Effective annual borrowing cost
16.1%
Repayment periods
24
Scenario borrowing limit
KSh 600,000.00
Separate ongoing monthly savings
KSh 2,000.00
Financial comparison
Outstanding balance
Select a point for its value.
Tap a point or use Tab to read its value. Exact values are also in the tables.
Amortisation schedule
Amortisation schedule
Period
Payment KSh
Principal KSh
Interest KSh
Balance KSh
1
24,006.44
18,173.11
5,833.33
481,826.89
2
24,006.44
18,385.13
5,621.31
463,441.76
3
24,006.44
18,599.62
5,406.82
444,842.14
4
24,006.44
18,816.62
5,189.82
426,025.52
5
24,006.44
19,036.14
4,970.30
406,989.38
6
24,006.44
19,258.23
4,748.21
387,731.15
7
24,006.44
19,482.91
4,523.53
368,248.24
8
24,006.44
19,710.21
4,296.23
348,538.03
9
24,006.44
19,940.16
4,066.28
328,597.87
10
24,006.44
20,172.80
3,833.64
308,425.07
11
24,006.44
20,408.15
3,598.29
288,016.92
12
24,006.44
20,646.24
3,360.20
267,370.68
13
24,006.44
20,887.12
3,119.32
246,483.56
14
24,006.44
21,130.80
2,875.64
225,352.76
15
24,006.44
21,377.32
2,629.12
203,975.44
16
24,006.44
21,626.73
2,379.71
182,348.71
17
24,006.44
21,879.04
2,127.40
160,469.67
18
24,006.44
22,134.29
1,872.15
138,335.38
19
24,006.44
22,392.53
1,613.91
115,942.85
20
24,006.44
22,653.77
1,352.67
93,289.08
21
24,006.44
22,918.07
1,088.37
70,371.01
22
24,006.44
23,185.44
821.00
47,185.57
23
24,006.44
23,455.94
550.50
23,729.63
24
24,006.48
23,729.63
276.85
0.00
1–24 of 24
Method, assumptions & sources
Nominal annual rate divided by repayments per year. Payments and interest round to cents, with the final payment adjusted to clear the balance. Effective annual cost is the IRR of actual repayments versus net proceeds, annualised for the selected frequency.
Upfront fees are deducted from proceeds, so they are not added again to instalments. Flat-rate extra repayments need contract-specific rebate terms and are not inferred. Actual lenders may use different dates, day counts and fees.
Requested amount is within the entered deposit multiple. This is not an approval. Share eligibility, guarantors, deductions and actual SACCO policy must be confirmed separately.
More schedules, imports and original worksheet options
The original worksheet retains its documented methods, inputs and export options. Figures are not transferred automatically.
Results ready
Files and inputs stay on your device. Use Reset to clear this workspace.
Useful to know
Which assumptions are used in the result?
The calculation uses the values and options entered in the workspace. Financial scenarios do not insert current market rates, taxes or lender offers. The method and tool limits are shown so you can assess whether they fit your task.
Where are my files and inputs processed?
This tool processes your entries on your device. It does not upload them or save them in an account. Downloads remain on your device; Reset clears the current tool workspace.
Rate this tool
Tell others how well SACCO Loan & Eligibility Planner worked for you. No account needed.