s↗sokointel.

KENYAN TAX & HOUSEHOLD FINANCE / FREE TOOL

Map the repayment
before the move.

Inspect the monthly payment, full amortisation schedule, interest split, balance path, and effect of an extra payment.

Your working assumptions

The calculation runs on the server. Inputs are used for this response and are not stored in your browser or member profile.

YOUR WORKED SCENARIO

Minimum monthly repaymentKES 79,529.84
Monthly payment with the extra amountKES 79,529.84
Interest over the repayment pathKES 12,087,161.24
Months to repay240
Months saved by the extra payment0
Interest saved by the extra paymentKES 0.00

Follow the calculation.

MeasureCalculated result
Monthly rate used1.04%
Original scheduled term240 monthly payments
Balance after 60 monthsKES 6,452,609.62
Total repaid on this pathKES 19,087,161.24
Formulae used
\[ PMT = P \times \frac{i(1+i)^{n}}{(1+i)^{n}-1} \]

The standard payment amortises principal P over n monthly periods at monthly rate i.

\[ B_{k} = B_{k-1}(1+i) - PMT_{k} \]

Each month, interest is added to the opening balance and the payment reduces the balance.

The schedule assumes a constant nominal rate and equal monthly payments. Add insurance, valuation, legal, maintenance, tax, rate-reset and other housing costs to build the wider household budget.

Annual repayment schedule

The schedule applies the extra payment every month. The final row may be a smaller payment because it clears the remaining balance.

YearPaymentsInterestPrincipal repaidClosing balance
1KES 954358.06KES 870291.82KES 84066.25KES 6915933.75
2KES 954358.06KES 859160.10KES 95197.97KES 6820735.79
3KES 954358.06KES 846554.36KES 107803.70KES 6712932.08
4KES 954358.06KES 832279.42KES 122078.64KES 6590853.44
5KES 954358.06KES 816114.25KES 138243.82KES 6452609.62
6KES 954358.06KES 797808.55KES 156549.52KES 6296060.11
7KES 954358.06KES 777078.88KES 177279.18KES 6118780.92
8KES 954358.06KES 753604.27KES 200753.79KES 5918027.13
9KES 954358.06KES 727021.25KES 227336.82KES 5690690.31
10KES 954358.06KES 696918.20KES 257439.86KES 5433250.45
11KES 954358.06KES 662829.03KES 291529.03KES 5141721.43
12KES 954358.06KES 624225.91KES 330132.15KES 4811589.28
13KES 954358.06KES 580511.12KES 373846.94KES 4437742.34
14KES 954358.06KES 531007.79KES 423350.28KES 4014392.06
15KES 954358.06KES 474949.42KES 479408.65KES 3534983.41
16KES 954358.06KES 411468.02KES 542890.04KES 2992093.37
17KES 954358.06KES 339580.67KES 614777.40KES 2377315.97
18KES 954358.06KES 258174.27KES 696183.79KES 1681132.19
19KES 954358.06KES 165988.37KES 788369.69KES 892762.49
20KES 954358.06KES 61595.57KES 892762.49KES 0.00
First 12 monthly payments
MonthPaymentInterestPrincipalBalance
1KES 79529.84KES 72916.67KES 6613.17KES 6993386.83
2KES 79529.84KES 72847.78KES 6682.06KES 6986704.77
3KES 79529.84KES 72778.17KES 6751.66KES 6979953.11
4KES 79529.84KES 72707.84KES 6821.99KES 6973131.11
5KES 79529.84KES 72636.78KES 6893.06KES 6966238.06
6KES 79529.84KES 72564.98KES 6964.86KES 6959273.20
7KES 79529.84KES 72492.43KES 7037.41KES 6952235.79
8KES 79529.84KES 72419.12KES 7110.72KES 6945125.07
9KES 79529.84KES 72345.05KES 7184.79KES 6937940.29
10KES 79529.84KES 72270.21KES 7259.63KES 6930680.66
11KES 79529.84KES 72194.59KES 7335.25KES 6923345.41
12KES 79529.84KES 72118.18KES 7411.66KES 6915933.75
240KES 79529.84KES 819.90KES 78709.94KES 0.00

Take the research further.

Use the full article and companion resources to put this calculation into its wider business, household, or portfolio context. The workbook keeps the deeper scenario modelling, data record and audit trail.

Read the household-housing research →

KEEP EXPLORING / OPTIONAL EMAIL SERIES

Build a model
you can revisit.

Get research notes, updated reading paths, and useful modelling ideas.