Mortgage Amortization Schedule Calculator
Amortization Schedule
| Month | Beginning Balance | Interest | Principal | Extra Payment | Ending Balance |
|---|---|---|---|---|---|
| ▶ Year 1 | $240,000 | $15,521 | $2,683 | $0 | $237,317 |
| ▶ Year 2 | $237,317 | $15,341 | $2,862 | $0 | $234,455 |
| ▶ Year 3 | $234,455 | $15,150 | $3,054 | $0 | $231,401 |
| ▶ Year 4 | $231,401 | $14,945 | $3,258 | $0 | $228,143 |
| ▶ Year 5 | $228,143 | $14,727 | $3,477 | $0 | $224,666 |
| ▶ Year 6 | $224,666 | $14,494 | $3,709 | $0 | $220,957 |
| ▶ Year 7 | $220,957 | $14,246 | $3,958 | $0 | $216,999 |
| ▶ Year 8 | $216,999 | $13,981 | $4,223 | $0 | $212,776 |
| ▶ Year 9 | $212,776 | $13,698 | $4,506 | $0 | $208,270 |
| ▶ Year 10 | $208,270 | $13,396 | $4,808 | $0 | $203,463 |
| ▶ Year 11 | $203,463 | $13,074 | $5,130 | $0 | $198,333 |
| ▶ Year 12 | $198,333 | $12,731 | $5,473 | $0 | $192,860 |
| ▶ Year 13 | $192,860 | $12,364 | $5,840 | $0 | $187,021 |
| ▶ Year 14 | $187,021 | $11,973 | $6,231 | $0 | $180,790 |
| ▶ Year 15 | $180,790 | $11,556 | $6,648 | $0 | $174,142 |
| ▶ Year 16 | $174,142 | $11,110 | $7,093 | $0 | $167,049 |
| ▶ Year 17 | $167,049 | $10,635 | $7,568 | $0 | $159,481 |
| ▶ Year 18 | $159,481 | $10,128 | $8,075 | $0 | $151,405 |
| ▶ Year 19 | $151,405 | $9,588 | $8,616 | $0 | $142,790 |
| ▶ Year 20 | $142,790 | $9,011 | $9,193 | $0 | $133,597 |
| ▶ Year 21 | $133,597 | $8,395 | $9,809 | $0 | $123,788 |
| ▶ Year 22 | $123,788 | $7,738 | $10,465 | $0 | $113,323 |
| ▶ Year 23 | $113,323 | $7,037 | $11,166 | $0 | $102,156 |
| ▶ Year 24 | $102,156 | $6,289 | $11,914 | $0 | $90,242 |
| ▶ Year 25 | $90,242 | $5,491 | $12,712 | $0 | $77,530 |
| ▶ Year 26 | $77,530 | $4,640 | $13,563 | $0 | $63,967 |
| ▶ Year 27 | $63,967 | $3,732 | $14,472 | $0 | $49,495 |
| ▶ Year 28 | $49,495 | $2,763 | $15,441 | $0 | $34,054 |
| ▶ Year 29 | $34,054 | $1,728 | $16,475 | $0 | $17,579 |
| ▶ Year 30 | $17,579 | $625 | $17,579 | $0 | $0 |
How Does Mortgage Amortization Work?
Mortgage amortization is the process of repaying a loan through fixed monthly payments that gradually shift from interest-heavy to principal-heavy over the loan term. Amortization analysis is an important component of real estate investment analysis because it reveals how equity builds through mortgage paydown — one of the four pillars of real estate investment return. The standard amortization formula derives from the time value of money — each payment covers that month’s accrued interest first, with the remainder reducing principal. This schedule is calculated using the PMT function, which solves for the fixed payment that fully retires the debt over a specified number of periods at a given rate (Vertex42 amortization derivation, CFPB mortgage reference).
The Crossover Point
At current rates, the early years are overwhelmingly interest. On a $280,000 loan at 7%, month 1 allocates approximately $1,633 to interest and only $230 to principal. The crossover point — where principal exceeds interest in each payment — occurs around year 19-20. Before that crossover, you’ve paid the majority of the loan’s total interest. This front-loading is why selling or refinancing in the first 5-10 years is particularly costly from an equity-building perspective.
The Extra Payment Multiplier Effect
Extra payments bypass the amortization schedule entirely — every dollar goes directly to principal reduction. This creates a compounding savings effect: the reduced balance means less interest accrues in every subsequent month, which means more of each future regular payment goes to principal. On a $240,000 loan at 6.5%, adding $200/month saves over $115,000 in total interest and eliminates approximately 5.5 years of payments (HughCalc algorithm reference). The earlier you start extra payments, the greater the multiplier effect.
Refinancing Restarts the Clock
Refinancing creates a new amortization schedule from scratch. Even at a lower rate, you restart the interest-heavy early phase. An investor 8 years into a 30-year mortgage has already paid most of the interest — refinancing to a new 30-year term may actually increase total interest paid despite a lower rate. Always compare using our mortgage payment calculator to see the full PITI impact of refinancing scenarios. For investment properties, understanding amortization is critical to evaluating long-term equity buildup and DSCR qualification.
How to Use This Calculator
- Loan Amount — Enter the total borrowed amount (purchase price minus down payment). If refinancing, enter your current loan balance.
- Interest Rate — Enter the annual interest rate from your loan offer or current mortgage statement. Even small rate differences (0.25%) compound significantly over 30 years.
- Loan Term — Select 15 or 30 years. The calculator generates a complete month-by-month schedule for the full term. Try both to compare total interest paid.
- Extra Monthly Payment — Enter any additional principal payment you plan to make regularly. Start with $100-$200 to see the impact, then adjust upward.
- Start Year / Start Month — Set when your loan begins (or current month if analyzing an existing mortgage). This labels each row with calendar dates.
The calculator generates a complete month-by-month amortization table showing beginning balance, interest portion, principal portion, extra payments, and ending balance for every payment. The summary cards above the table show total monthly payment, total interest, and total amount paid over the loan life.
Worked Examples
Sophia — Standard 30-Year Mortgage in Atlanta, GA
Sophia just closed on a $350,000 home in Atlanta with 20% down, resulting in a $280,000 loan at 7%. She wants to see exactly how much of her first year’s payments go to interest versus principal — and is shocked to learn that in year 1, over 75% of each payment services interest.
Inputs
- Loan Amount
- $280,000
- Interest Rate
- 7.00%
- Loan Term (years)
- 30 years
- Extra Monthly Payment
- $0
- Start Year
- 2,026
- Start Month
- 1
Results
- Monthly Payment
- $1,863
- Total Interest Paid
- $390,625
- Total Amount Paid
- $670,625
- Loan Amount
- $280,000
Brandon — Extra Payments Strategy in Charlotte, NC
Brandon purchased a $300,000 townhome in Charlotte with a $240,000 loan at 6.5%. He’s committing an extra $200/month toward principal from day one. The amortization table shows his loan pays off approximately 5.5 years early, saving over $115,000 in interest. The summary totals shown assume the full 30-year term — scroll the table to see the actual early payoff row.
Inputs
- Loan Amount
- $240,000
- Interest Rate
- 6.50%
- Loan Term (years)
- 30 years
- Extra Monthly Payment
- $200
- Start Year
- 2,026
- Start Month
- 3
Results
- Monthly Payment
- $1,517
- Total Interest Paid
- $306,107
- Total Amount Paid
- $618,107
- Loan Amount
- $240,000
Yuki — 15-Year Term Comparison in Minneapolis, MN
Yuki is comparing a 15-year mortgage against the standard 30-year option on her $400,000 home purchase in Minneapolis ($320,000 loan after 20% down, 6% rate). The 15-year payment is significantly higher each month, but total interest is only $166,000 compared to over $370,000 on a 30-year — a 55% reduction in interest paid.
Inputs
- Loan Amount
- $320,000
- Interest Rate
- 6.00%
- Loan Term (years)
- 15 years
- Extra Monthly Payment
- $0
- Start Year
- 2,026
- Start Month
- 6
Results
- Monthly Payment
- $2,700
- Total Interest Paid
- $166,062
- Total Amount Paid
- $486,062
- Loan Amount
- $320,000
Derek — Refinancing Evaluation in Philadelphia, PA
Derek is 8 years into a 30-year mortgage on his Philadelphia rental property. The original $260,000 loan at 6.8% has a monthly payment of $1,695. He’s considering refinancing but uses this calculator to see how much interest he’s already paid versus what remains. The amortization table reveals that after 8 years, he’s paid over $130,000 in interest but reduced principal by only about $33,000 — illustrating the front-loading effect.
Inputs
- Loan Amount
- $260,000
- Interest Rate
- 6.80%
- Loan Term (years)
- 30 years
- Extra Monthly Payment
- $0
- Start Year
- 2,026
- Start Month
- 1
Results
- Monthly Payment
- $1,695
- Total Interest Paid
- $350,202
- Total Amount Paid
- $610,202
- Loan Amount
- $260,000
Get the Free Rental Analysis Template
Download our Excel spreadsheet to analyze your own properties. Works with any rental property — just enter your numbers.
Frequently Asked Questions
What is a mortgage amortization schedule? ▾
An amortization schedule is a table showing each monthly mortgage payment broken down into principal and interest portions. Early payments are mostly interest, while later payments shift toward principal. The schedule shows exactly when your loan balance reaches zero.
How does making extra payments affect my mortgage? ▾
Extra payments go directly toward reducing your principal balance. This reduces the total interest paid over the life of the loan and can shorten your payoff timeline. Even small extra monthly payments can save thousands in interest.
When does principal exceed interest in my mortgage payments? ▾
For a standard 30-year mortgage at typical rates, the crossover point where principal exceeds interest usually occurs around year 17-20. Lower interest rates move this crossover earlier, while higher rates push it later.
Is it better to get a 15-year or 30-year mortgage? ▾
A 15-year mortgage has higher monthly payments but saves dramatically on total interest — often 55-65% less than a 30-year loan. At 6% on $320,000, the 15-year total interest is about $166,000 vs $371,000 for 30 years. Choose 15-year if you can comfortably afford the higher payment; choose 30-year for cash flow flexibility.
How do biweekly payments affect amortization? ▾
Making biweekly payments (half the monthly amount every two weeks) results in 26 half-payments per year — equivalent to 13 full monthly payments instead of 12. This one extra payment per year can shave approximately 4-5 years off a 30-year mortgage and save tens of thousands in interest.
Does refinancing reset my amortization schedule? ▾
Yes. Refinancing creates a brand-new loan with a fresh amortization schedule. Even if you refinance to a lower rate, you restart the interest-heavy early years. If you're 8-10 years into your mortgage, you've already paid most of the interest — refinancing to a new 30-year term may increase total interest paid despite a lower rate.
How much does one extra payment per year save? ▾
On a $240,000 loan at 6.5% for 30 years, one extra monthly payment per year ($1,517) saves approximately $78,000 in total interest and pays off the loan about 5 years early. The savings come from reducing the principal balance that accrues daily interest.
For informational and educational purposes only. Not financial advice. Full disclaimer.