How we calculate
This is how HomeLoanPlanner calculates your monthly payment and amortization schedule using the French system.
The formula step by step
- We subtract the down payment from the home price:
P = price − down payment - 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$2,000,000 home with 20% down.
The loan is at 10% a year over 20 years; we add the monthly costs and run the inverse budget calculation:
01 · Loan
US$1,600,000.00
P = US$2,000,000 − US$400,00002 · Monthly rate and term
0.833333% · 240
i = 10 / 100 / 12; n = 20 × 1203 · Fixed monthly payment
US$15,440.35
A = P × i / (1 − (1 + i)^−240); i = 0 → A = P / n04 · Principal
US$2,107.01
capital = A + extra − interés; interés = saldo × i05 · Monthly total with US$1,500 of other costs
US$16,940.35
total = payment + other costs06 · Maximum payment with income of US$40,000 at 30%
US$12,000.00
A = US$40,000 × 30 / 10007 · Maximum loan
US$1,243,495.42
P = A × (1 − (1 + i)^−n) / i; i = 0 → P = A × n08 · Maximum home price with 20% down
US$1,554,369.28
precio = P / (1 − 20 / 100)Additional costs
Add insurance, property tax and maintenance under Other monthly costs. Fees, appraisal and closing costs are not included. The interest rate stays fixed.
Every calculation is checked against hand-solved cases before it is published.