Mortgage amortization schedule calculator
The calculator opens on the monthly schedule of an example loan. Enter your own loan to see every payment, then download the table as a CSV.
Enter a home price and an interest rate to see your monthly payment.
Where your payment goes
| Part of the payment | Per month |
|---|
Above the baseline conforming loan limit
How it’s calculated
- Formula
payment = L × r ÷ (1 − (1 + r)−n)- Where
- L is the loan amount, r is the interest rate per month (annual rate ÷ 12), and n is the number of monthly payments.
- With your numbers
—
Amortization schedule
An estimate, not a loan offer
Your lender’s figures can differ. Property tax, insurance, PMI, and fees vary by home, lender, and place. This is general information, not financial or tax advice.Official figures used
PMI. You can ask your servicer to cancel private mortgage insurance when your balance is scheduled to reach 80% of the original value of your home, and the servicer must end it automatically at 78%, as long as you are current on payments. This calculator ends PMI when the balance, including your extra payments, reaches 78% of the home price.
Verified on October 8, 2026. Source: Consumer Financial Protection Bureau (CFPB), when can I remove PMI from my loan.
Conforming loan limit. For 2026, the baseline limit for a one-unit home is $832,750. In high-cost areas it is higher, up to $1,249,125.
Verified on October 8, 2026. Source: Federal Housing Finance Agency (FHFA), 2026 conforming loan limit values.
How to use it
- Enter the home price and your down payment, as a percent or in dollars.
- Enter the interest rate from your lender’s quote and choose a 30, 20, 15, or 10 year term.
- Add property tax, home insurance, HOA dues, and a PMI rate if your down payment is under 20%.
- Add extra payments, monthly, yearly, or one time, to see the interest you save and the new payoff date.
- Read the monthly breakdown and the amortization schedule, then download it as a CSV or copy a link.
Frequently asked questions
What is an amortization schedule?
It is a table of every loan payment showing how much goes to interest, how much to principal, and the balance left afterward.
Why is so much of the early payment interest?
Interest is charged on the balance, which is at its highest at the start. In the example, $1,733.33 of the $2,022.62 first payment is interest.
Can I download the schedule?
Yes. The Download CSV button saves the monthly schedule, including extra payments and PMI, as a file you can open in Excel or Google Sheets.
An amortization schedule for a $400,000 home
An amortization schedule lists every payment and splits it into interest and principal. This example is a $320,000 loan (20% down on $400,000) at 6.5% for 30 years, with a payment of $2,022.62. The 6.5% rate is an example, not today’s rate. Enter your own in the mortgage calculator.
Selected years of the schedule
| Year | Principal paid | Interest paid | Interest so far | Balance at year end |
|---|---|---|---|---|
| Year 1 | $3,577 | $20,695 | $20,695 | $316,423 |
| Year 5 | $4,636 | $19,636 | $100,912 | $299,555 |
| Year 10 | $6,410 | $17,861 | $193,998 | $271,284 |
| Year 15 | $8,864 | $15,407 | $276,260 | $232,189 |
| Year 20 | $12,257 | $12,014 | $343,557 | $178,129 |
| Year 25 | $16,949 | $7,322 | $390,159 | $103,373 |
| Year 30 | $23,438 | $833 | $408,142 | $0 |
The first payment
Payment 1 sends $1,733.33 to interest and only $289.28 to principal. Principal first exceeds interest in payment 233, in year 20, when the balance is down to $186,388.
Read it by year or by month
The calculator shows the schedule by year or by month, and downloads the monthly version as a CSV file you can open in a spreadsheet. Add extra payments and the schedule shortens: the last row moves earlier and the interest column shrinks.
Updated on October 8, 2026