TTKTheTextKit

Extra Payment Calculator

Enter your loan balance, interest rate and the years left, then add an extra amount for every month and, if you like, a one-time lump sum today. The calculator shows the interest you would save, how much sooner the loan is repaid, your new monthly payment and a year-by-year table of the balance with and without the extra. It works for mortgages, car loans and personal loans with a fixed rate. Everything runs in your browser.

Interest saved
79,800.51
Total interest 151,875.87 instead of 231,676.38
Time saved
9 years
Paid off in 21 years instead of 30 years
New monthly payment
1,399.10
Regular payment 1,199.10
End of yearBalance, regularBalance, with extra
1197,543.98195,076.86
2194,936.47189,850.08
3192,168.14184,300.92
4189,229.06178,409.50
5186,108.71172,154.71
6182,795.91165,514.13
7179,278.77158,463.99
8175,544.71150,979.00
9171,580.34143,032.36
10167,371.45134,595.58
11162,902.97125,638.44
12158,158.88116,128.85
13153,122.19106,032.72
14147,774.8595,313.89
15142,097.6983,933.95
16136,070.3871,852.11
17129,671.3159,025.09
18122,877.5745,406.93
19115,664.8130,948.84
20108,007.1715,598.99
2199,877.230.00
2291,245.860.00
2382,082.120.00
2472,353.170.00
2562,024.170.00
2651,058.100.00
2739,415.670.00
2827,055.160.00
2913,932.270.00
300.000.00

The regular payment comes from the standard loan formula, payment = balance x r / (1 - (1 + r) to the power of minus n), with r the monthly rate and n the number of months. The extra amount is added to every payment and goes straight to the balance, so each month less interest is charged. The last payment is trimmed to what is still owed. This assumes a fixed rate, payments at the end of each month and no prepayment fee. Check with your lender that extra payments are applied to principal and not held for the next due date. Everything is worked out in your browser.

Related Tools

[5 suggestions]

About the Extra Payment Calculator

A fixed-rate loan has a regular payment worked out from the balance, the monthly rate and the number of months: payment = balance x r / (1 - (1 + r) to the power of minus n), where r is the yearly rate divided by 12. Each month part of the payment covers the interest on the balance and the rest reduces it. When you pay extra, all of the extra reduces the balance, so next month's interest is smaller and more of the regular payment goes to principal. That compounding effect is why a small extra amount saves so much. For a 200,000 loan at 6% over 30 years the regular payment is 1,199.10 and the total interest is 231,676.38. Adding 200 a month pays the loan off in 21 years, which is 9 years sooner, and cuts the interest by about 79,800. A one-time lump sum of 20,000 at the start saves about 77,800 and shortens the loan by 6 years and 9 months. The model assumes a fixed rate, monthly payments at the end of each month and no prepayment penalty. Ask your lender whether extra payments are applied to the principal straight away.

How much interest do extra payments save?▾

It depends on the balance, the rate and the term. On a 200,000 loan at 6% for 30 years, an extra 200 a month saves about 79,800 in interest and takes 9 years off the loan.

Is it better to pay extra every month or one lump sum?▾

The earlier the extra money reduces the balance, the more interest it saves. A lump sum now saves more than the same total spread over many years, but regular extras are easier for most budgets.

Do extra payments lower my monthly payment?▾

Not on a standard loan. The regular payment stays the same and the loan ends sooner. You would need to ask your lender to recast or refinance the loan to lower the payment.

Should I pay extra or invest the money?▾

Paying extra gives a guaranteed return equal to your loan rate. Investing might return more or less, with risk. The right choice depends on your rate, your goals and your other debts, so this tool only shows the effect of the extra payment.

Is my data uploaded?▾

No. The calculation runs in your browser and nothing you enter is sent anywhere.