How Loan Calculator works
This loan calculator with extra payments takes four numbers: the amount borrowed, the annual interest rate, the term in years and an optional extra monthly payment. It returns the monthly payment, total interest, total repaid and a year-by-year table of principal paid, interest paid and remaining balance. With the default 250,000 at 6.5% over 25 years the payment is 1,688.02 and the interest comes to 256,405.37, slightly more than the sum borrowed. Add 200 a month and the loan clears in 19 years 6 months, saving roughly 64,927.88 in interest. It assumes a fixed rate, monthly payments and interest charged monthly on the reducing balance. Results are plain numbers with no currency symbol, so they read the same in dollars, pounds, euros or rupees.
What an extra monthly payment saves: three example loans
Each row is the note the tool shows under the Repayment summary for that Extra monthly payment. Rates and terms are examples, not offers.
| Loan | Standard payment | Extra per month | Paid off in | Interest saved |
|---|---|---|---|---|
| 20,000 at 7% over 5 years | 396.02 | 50 | 4 years 5 months | 508.42 |
| 20,000 at 7% over 5 years | 396.02 | 100 | 3 years 11 months | 893.72 |
| 25,000 at 7.5% over 5 years | 500.95 | 100 | 4 years 1 month | 1,013.61 |
| 250,000 at 6.5% over 25 years | 1,688.02 | 100 | 21 years 11 months | 37,671.20 |
| 250,000 at 6.5% over 25 years | 1,688.02 | 200 | 19 years 6 months | 64,927.88 |
| 250,000 at 6.5% over 25 years | 1,688.02 | 500 | 14 years 11 months | 115,668.35 |
| 300,000 at 6.5% over 30 years | 1,896.20 | 100 | 26 years 0 months | 60,994.79 |
| 300,000 at 6.5% over 30 years | 1,896.20 | 200 | 23 years 1 month | 103,448.79 |
| 300,000 at 6.5% over 30 years | 1,896.20 | 500 | 17 years 6 months | 179,759.08 |
The extra amount is assumed to be paid every month from the first payment until the loan is cleared. The last payment is cut to whatever balance is left, and the payoff time counts that final part payment as a full month.
Monthly payment per 1,000 borrowed, by rate and term
Multiply by the thousands you are borrowing for a quick estimate. For 18,000 over 5 years at 8%, 18 × 20.28 is about 365 a month.
| Rate | 3 years | 5 years | 10 years | 15 years | 20 years | 25 years | 30 years |
|---|---|---|---|---|---|---|---|
| 3% | 29.08 | 17.97 | 9.66 | 6.91 | 5.55 | 4.74 | 4.22 |
| 4% | 29.52 | 18.42 | 10.12 | 7.40 | 6.06 | 5.28 | 4.77 |
| 5% | 29.97 | 18.87 | 10.61 | 7.91 | 6.60 | 5.85 | 5.37 |
| 6% | 30.42 | 19.33 | 11.10 | 8.44 | 7.16 | 6.44 | 6.00 |
| 7% | 30.88 | 19.80 | 11.61 | 8.99 | 7.75 | 7.07 | 6.65 |
| 8% | 31.34 | 20.28 | 12.13 | 9.56 | 8.36 | 7.72 | 7.34 |
| 10% | 32.27 | 21.25 | 13.22 | 10.75 | 9.65 | 9.09 | 8.78 |
| 12% | 33.21 | 22.24 | 14.35 | 12.00 | 11.01 | 10.53 | 10.29 |
Figures are the tool's Monthly payment for an Amount borrowed of 1,000. Scaling up by multiplication can differ from the exact result by a small rounding amount.
Worked examples: same loan, different term
A longer term lowers the payment and raises the total cost. These are the tool's results for 250,000 at 6.5%.
15-year term
Amount borrowed 250000, Annual interest rate 6.5, Term in years 15, Extra monthly payment 0
Monthly payment 2,177.77. Total interest 141,998.31. Total repaid 391,998.31. Cost per borrowed unit 1.57.
20-year term
Amount borrowed 250000, Annual interest rate 6.5, Term in years 20, Extra monthly payment 0
Monthly payment 1,863.93. Total interest 197,343.88. Total repaid 447,343.88. Cost per borrowed unit 1.79.
25-year term
Amount borrowed 250000, Annual interest rate 6.5, Term in years 25, Extra monthly payment 0
Monthly payment 1,688.02. Total interest 256,405.37. Total repaid 506,405.37. Cost per borrowed unit 2.03.
In the Yearly breakdown, year 1 pays 4,127.75 of principal and 16,128.47 of interest. Principal does not overtake interest until year 15.
30-year term
Amount borrowed 250000, Annual interest rate 6.5, Term in years 30, Extra monthly payment 0
Monthly payment 1,580.17. Total interest 318,861.22. Total repaid 568,861.22. Cost per borrowed unit 2.28.
Going from 15 to 30 years cuts the payment by 597.60 a month and adds 176,862.91 of interest.
Loan payment formula and how each payment is split
M = P × r ÷ (1 − (1 + r)^−n)
M is the monthly payment, P the amount borrowed, r the monthly rate (annual rate ÷ 12 ÷ 100) and n the number of payments (years × 12). Each month, interest = balance × r, the rest of the payment is principal, and the balance falls by that principal. For 10,000 at 8% over 3 years, r is 0.006667 and n is 36, giving 313.36 a month. The first month's interest is 10,000 × 0.006667 = 66.67, so 246.69 goes to principal. Over the three years the Yearly breakdown shows interest of 689.00, 434.08 and 158.00, which matches the Total interest of 1,281.09 apart from a 0.01 rounding difference.
How to read the results when you enter an extra payment
Monthly payment shows the standard payment plus your extra amount, so 1,688.02 becomes 1,888.02 when you add 200. That is what leaves your account each month.
Total interest, Total repaid, Cost per borrowed unit and the Yearly breakdown table all stay on the original schedule with no overpayment. They are the baseline. The note underneath the summary is where the overpayment result appears: the new payoff time and the interest saved compared with that baseline. To get the interest you would pay with the extra, subtract the saving from Total interest: 256,405.37 − 64,927.88 = 191,477.49 in the default example.
Cost per borrowed unit is Total repaid divided by Amount borrowed. A value of 2.03 means every 1,000 borrowed is repaid as about 2,030. It folds rate and term into one number, which makes two offers with different terms easy to compare.
What this calculator does not include
- Fees. Arrangement, origination and valuation fees are not added, so compare the APR on real offers as well as the rate.
- Variable rates. One rate is applied for the whole term. For a rate that will change, run the remaining balance again at the new rate.
- Lump sums and yearly overpayments. Only a fixed extra amount every month is modelled.
- Early repayment charges. Some lenders cap penalty-free overpayments, often as a percentage of the balance per year. Check your agreement first.
- Taxes, insurance and other escrow items that some mortgage payments bundle in.
- Fortnightly or weekly payment schedules. Payments are monthly.
Step by step
- 1
Type the loan balance into Amount borrowed, leaving out any deposit or down payment you are paying in cash.
- 2
Enter the Annual interest rate as a percentage, for example 6.5.
- 3
Set the Term in years. The box is set for 1 to 50, and a part year such as 2.5 is treated as 30 monthly payments.
- 4
Leave Extra monthly payment at 0 for the standard figures, or enter the amount you could add each month.
- 5
Read the Repayment summary, the note showing the new payoff time and interest saved, and the Yearly breakdown table.