Lesson
The theory β Loan Payment Calculator
An amortising loan is repaid by a constant payment, but what that payment does changes every month: part settles the interest accrued since the last one, and whatever is left reduces the debt. Because the debt shrinks, next monthβs interest is smaller and more of the same payment goes to principal.
What each symbol means
r- the monthly rate, not the annual one. The box asks for 6.2% a year; the formula uses
0.0051667, which is0.062 / 12. n- the number of payments. Five years of monthly payments is
n = 60. M- the payment itself β the one number held constant,
485.65here.
Where the formula comes from
- Ask what the lender needs: the present value of all your future payments must equal the sum lent today. A payment
Marriving k months from now is worthM/(1+r)know. - So
P = M/(1+r) + M/(1+r)Β² + β― + M/(1+r)nβ a geometric series again, with ratio1/(1+r). Summing it givesP = MΒ·(1 β (1+r)βn) / r. - Solve for
Mand tidy by multiplying top and bottom by(1+r)n:M = PΒ·r(1+r)n / ((1+r)n β 1). That is the formula above, and it is the annuity formula run backwards β a loan is a savings plan seen from the other side.
- Assumes
- A fixed rate, equal payments, and interest compounding at exactly the payment frequency. Nothing here models fees, insurance, an early repayment, or a rate that moves.
- Breaks when
- It also quietly refutes something you have probably been told. βEarly payments are almost all interestβ is true of a 30-year mortgage, not of loans in general β in month 1 of this 5-year loan, principal (
356.48) already exceeds interest (129.17) nearly three to one. The claim is about the ratio of rate to term, not about loans as such.
Practice
Check yourself
Predict the answer first, then use the controls above to find out. Reveal only after you have committed to a guess β that is what makes it practice.
-
Press the mortgage preset β 420,000 at 5.8% over 30 years. Month 1 sends
2,030.00of the2,464.36payment straight to interest. Before you open the schedule: which year is it before the principal share overtakes the interest share?Show answer
Year 19, and the note under the chart says so outright. Row 218 of the schedule is where it happens β1,236.68of principal against1,227.68of interest, with254,003.03still owed. Nineteen of the thirty years pass before the payment is doing more repaying than renting. Change nothing but the term and the crossing moves: the 5-year default is already past it in month 1. -
Same mortgage. Set Term in years to
15. The monthly payment has to rise β predict what the total interest does.Show answer
It more than halves,4.672 Γ 10β΅down to2.098 Γ 10β΅, and the interest share of everything paid falls from52.658%to33.314%. The payment only went from2464.4to3499, about 42% more. You are not being charged a different rate; you are being charged for half as long, on a balance that falls twice as fast. -
Back to 30 years, and open the schedule. You are exactly halfway through the term β month 180, fifteen years of payments made. How much of the 420,000 is still owed?
Show answer
295,809.96: seven tenths of it. Fifteen years of payments have removed under a third of the debt, while the Cum. Interest column has already reached319,395.26. The balance does not drop below half until month 250, five sixths of the way through the term. Question 1 dated the front-loading; this prices it.
Problem solved in full
-
The monthly payment for borrowing 25 000 at 6.2% over 5 years 5 steps
Borrow 25 000 at 6.2% over 5 years. Derive the monthly payment from scratch, then find what doubling the term does to the total cost.
-
A loan is a promise to make n equal payments. Its value today is the sum of those payments discounted back, and that sum is a geometric series β which is the only mathematics in the whole of consumer finance.
-
Collapse the series and invert it for the payment. The monthly rate is the annual rate divided by twelve, and the term is in months, not years β the commonest error in this calculation is mixing the two units.
-
Substitute. The calculator above prints exactly this figure, and it does so by evaluating this expression rather than by iterating a schedule.
-
Total paid is just payment times count, and whatever exceeds the principal is interest. The tool prints both, along with the interest share of 14.204%.
-
Now double the term to ten years, which halves the payment β almost. Run the same formula again.
Answer
485.65 a month. Doubling the term drops the payment to 280.07 β not to 242.83, because you also owe interest for twice as long β and the interest more than doubles, from 4139 to 8608. This is the shape of every "lower monthly payment" offer: the payment falls by 42% and the cost rises by 108%. The series is where that asymmetry lives, and it is visible in the formula before any number is put in.
-
Learning path
Money over time
References (1)
- The amortisation schedule the lesson derives, and how the split moves month to month: S. Garrett, "Loan Repayment Schedules," in Introduction to the Mathematics of Finance, 2nd ed., 79β93. Butterworth-Heinemann, 2013.