How we calculate
This is how LoanSchedule calculates your monthly payment and amortization schedule using the French system.
The formula step by step
- We convert annual rate r to monthly rate i:
i = r / 100 / 12 - We calculate fixed payment A for amount P over n months:
A = P × i / (1 − (1 + i)^−n)If the rate is 0, the payment is simply P / n. - Each month, interest is calculated on the balance:
interest = balance × i - Principal reduces the debt. With extra payment E, without exceeding the balance:
principal = A + E − interestnew balance = balance − principal - The schedule stops when the balance reaches zero. Extra payments can finish it before n months, and the last payment can be smaller.
Worked example
A US$100,000 loan at 12% a year over 24 months.
At the end, we compare it with paying US$1,000 extra each month:
01 · Monthly rate
1%
i = 12 / 100 / 1202 · Fixed monthly payment
US$4,707.35
A = US$100,000 × i / (1 − (1 + i)^−24)03 · First month's interest
US$1,000.00
US$100,000 × 0.0104 · Principal
US$3,707.35
US$4,707.35 − US$1,000.0005 · Balance
US$96,292.65
US$100,000 − US$3,707.3506 · With US$1,000 extra a month
20 months · US$10,495.85 interest
principal = A + extra − interestWhat it leaves out
The calculation does not include fees, insurance, taxes or rate changes. It is an informational estimate with a fixed monthly payment and fixed rate.
Every calculation is checked against hand-solved cases before it is published.