All reference tables

Reference

Loan Prepayment Savings Tables

What a rupee paid early is actually worth — across interest rates, remaining tenures, and the point in the loan you pay it. On a long dear loan the same ₹1 lakh avoids more than ₹20 lakh of interest; on a short cheap one, less than it cost. Computed on a stated loan, not quoted.

Computed on₹50 lakh · 8.5% · 20 years

The same money is not worth the same thing

Prepaying a loan always saves interest. What almost nobody has a feel for is how much the amount saved varies — not by a little, but by more than twenty times, for the identical sum of money.

Three things move it. A dearer loan saves more, because the interest avoided is charged at a higher rate. A longer remaining tenure saves more, because the avoided interest would have gone on accruing for longer. And — the one people most reliably underestimate — paying earlier saves far more than paying later. On a twenty-year loan, ₹1 lakh in the first year is worth over seven times the same ₹1 lakh in year fifteen.

None of this is a reason to prepay or not to. It is the size of the prize, which is the thing you need before deciding anything.

Interest avoided per rupee prepaid

Read your rate down the side and the years remaining across the top. A figure of 4× means every ₹1 lakh prepaid avoids ₹4 lakh of interest over the life of the loan.

Return per rupee, ₹50 lakh loan, ₹1 lakh prepaid in year 1
Rate5years left10years left15years left20years left25years left30years left
6%0.27×0.70×1.29×2.06×3.08×4.43×
7%0.32×0.86×1.62×2.67×4.13×6.13×
8.5%0.40×1.12×2.21×3.82×6.19×9.60×
10%0.49×1.42×2.93×5.31×8.99×14.51×
12%0.61×1.88×4.12×7.95×14.23×23.94×
14%0.74×2.43×5.66×11.56×21.65×37.26×
Figures scale roughly rather than exactly to other loans: prepaying a large share of what you owe ends the loan sooner and the saving stops accruing, so the return per rupee falls. On this loan ₹50,000 returns 3.92× where ₹5 lakh returns 3.21×.

When you pay it matters more than you think

The same ₹1 lakh, on the same loan, paid at different points. Nothing about the money changes — only how long the balance it retires would otherwise have been charged interest on.

₹1 lakh prepaid at different points in a ₹50 lakh, 8.5%, 20-year loan
Paid in yearReturnInterest savedMonths off
13.82×382,26511
33.10×309,5339
52.48×247,5148
101.30×129,7115
150.51×51,3533
180.18×17,7122
Late prepayment still saves; it simply saves less. There is no point at which paying down a loan costs you interest.

Paying a little more every month

The other way to prepay, and the one most people can actually do. A small amount added to every instalment compounds into a large amount of avoided interest, because each addition retires principal that would otherwise have been charged on for years.

Extra added to every instalment, ₹50 lakh, 8.5%, 20-year loan
Extra₹/monthMonths offInterest savedTotal extra paid₹ lakh
1,00013359,6552.3
2,50030808,7365.3
5,000531,389,2509.4
10,000852,178,72115.5
20,0001243,067,12023.2
Total extra is what you actually pay in over the shortened life of the loan — compare it against the interest saved beside it.

Do this with a tool

Share
WhatsAppXin