Year-by-year amortization schedule
| Year | Interest | Principal paid | Insurance | Remaining balance |
|---|
| Year | Interest | Principal paid | Insurance | Remaining balance |
|---|
This calculator estimates a fixed-rate amortizing loan, whether it is a mortgage, a car loan or a personal loan. It answers the two questions everyone asks before borrowing: "How much will I pay each month?" and "How long will it take to repay if I pay a set amount every month?". In both cases it shows the total cost of the loan, the total interest and a year-by-year amortization schedule, so you can compare scenarios before talking to a lender or a broker.
The calculator uses the standard formula for a loan with equal monthly payments. The monthly rate is the annual rate divided by 12: i = annual rate ÷ 12.
Payment = P × i ÷ (1 − (1 + i)−n)
Term n = −ln(1 − P × i ÷ M) ÷ ln(1 + i)
where P is the amount borrowed, n the number of monthly payments and M the monthly payment. At a 0% rate, the payment is simply P ÷ n. In "loan term" mode the last payment is smaller than the others, and the total cost shown takes this into account.
Example: borrowing 150,000 at 3.5% over 240 months gives a monthly payment of about 869.94, a total cost of 208,785 and 58,785 of interest. Paying 900 a month at the same rate cuts the term to 229 months (19 years and 1 month) and the interest to about 55,700.
Each payment first covers the month's interest, calculated on the remaining balance; the rest pays down the principal. Early in the loan the balance is high, so interest takes a large share of every payment. In the example above, the first year costs about 5,170 of interest for 5,270 of principal repaid; the last year, less than 200 of interest for more than 10,200 of principal. That is why extra payments save far more interest early in a loan than near the end.
No. The payment covers principal and interest, plus mortgage insurance if you enter a rate. Property taxes, homeowners insurance and HOA fees often paid through an escrow account come on top.
If the payment is lower than or equal to the first month's interest (P × i), the balance never goes down and the loan can never be repaid. Increase the payment or reduce the amount borrowed.
The nominal annual interest rate quoted by the lender, without fees. Enter mortgage insurance separately in the "Insurance and income" panel.
Not directly: it assumes the same rate for the whole term. To estimate an ARM after its fixed period, run a second simulation with the remaining balance from the amortization schedule, the new rate and the remaining term.
No, it is an estimate for information only. Only the Loan Estimate and closing documents from your lender are binding.
📖 Read our article: Mortgage: 7 Ways to Lower the Cost of Your Loan
With your consent, cookies may be used to show ads (Google AdSense). You can accept or refuse; you can change your choice at any time. Learn more