Key Takeaways
- On a $450,000 mortgage at 7.25%, total interest paid over 30 years reaches $664,813. That exceeds the original loan by 47.7%.
- Skipping even one extra principal payment of $500 in month one costs more than $1,200 in future interest over a 30-year term.
- Calculate each month's interest charge as the periodic rate multiplied by the remaining balance, then subtract from your fixed payment to find principal reduction.
- Tool: Run your full amortization schedule in seconds →
Get Pre-Approved TodaySPONSORED
Lock your rate before it moves. Rocket Mortgage pre-approval takes under 10 minutes.
What an Amortization Schedule Actually Shows
An amortization schedule is a complete payment-by-payment table for a loan. Each row shows four things: the payment number, the interest portion of that payment, the principal portion, and the remaining loan balance.
The schedule is not decorative. It is the only document that shows how a lender applies your money each month. Banks disclose the monthly payment prominently. They do not headline the fact that payment 1 on a typical 30-year mortgage sends roughly 82 cents of every dollar straight to interest.
That ratio shifts slowly over time. By payment 300, the split reverses. Understanding the progression is not academic. It determines the financial logic behind refinancing, prepayment, and the true cost of carrying a mortgage for the full term.
The Core Formula
The fixed monthly payment on a fully amortizing mortgage comes from one equation. Let P equal the principal, r equal the monthly interest rate, and n equal the total number of payments.
Monthly Payment = P × [r(1 + r)^n] / [(1 + r)^n - 1]
The monthly rate r is the annual rate divided by 12. A 7.25% annual rate produces a monthly rate of 0.604167%.
Once you have the fixed monthly payment, every subsequent row in the schedule follows two steps.
Step 1: Multiply the current outstanding balance by the monthly rate. The result is that month's interest charge.
Step 2: Subtract the interest charge from the fixed monthly payment. The remainder reduces principal.
The new balance equals the prior balance minus that principal reduction. Repeat 359 more times for a 30-year loan.
Worked Example 1: A $450,000 Loan at 7.25%
Loan details:
- Principal: $450,000
- Annual rate: 7.25%
- Monthly rate: 0.604167%
- Term: 360 months (30 years)
Calculate the fixed monthly payment:
Payment = 450,000 × [0.00604167 × (1.00604167)^360] / [(1.00604167)^360 - 1]
(1.00604167)^360 = 8.7991 (approximately)
Payment = 450,000 × [0.00604167 × 8.7991] / [8.7991 - 1]
Payment = 450,000 × [0.053163] / [7.7991]
Payment = 450,000 × 0.006816
Fixed monthly payment: $3,067.34
Month 1 breakdown:
- Interest: $450,000 × 0.00604167 = $2,718.75
- Principal: $3,067.34 - $2,718.75 = $348.59
- Remaining balance: $450,000 - $348.59 = $449,651.41
Month 2 breakdown:
- Interest: $449,651.41 × 0.00604167 = $2,716.64
- Principal: $3,067.34 - $2,716.64 = $350.70
- Remaining balance: $449,651.41 - $350.70 = $449,300.71
The principal portion grows by roughly $2.11 from month 1 to month 2. That modest acceleration is why the schedule takes decades to tip in the borrower's favor.
Total cost at full term:
- Total paid: $3,067.34 × 360 = $1,104,242.40
- Total interest: $1,104,242.40 - $450,000 = $654,242.40
Where Most Borrowers Misread the Schedule
The Interest-Heavy Front End Is Not a Design Flaw
Borrowers sometimes assume lender-friendly front-loading is intentional manipulation. It is not. It is pure mathematics. The outstanding balance is highest at origination, so the interest charge is highest. The formula applies equally and mechanically.
The implication is significant. Selling or refinancing in the first seven years means paying substantial interest relative to equity built. A borrower who buys a $450,000 home with this loan, pays for five years, and then sells has paid $162,862.80 in total mortgage payments. Of that, approximately $134,100 went to interest. Principal reduction: roughly $28,763. That is not a contractual penalty. It is a predictable mathematical outcome.
The Crossover Point Arrives Later Than Borrowers Expect
The payment where principal first exceeds interest on a 30-year, 7.25% loan arrives around month 253. That is 21 years and one month into the loan. Before that crossover, the majority of every payment services interest. Most borrowers never see this stated explicitly in the materials they receive at closing.
Worked Example 2: The Impact of One Extra Payment per Year
Same loan: $450,000 at 7.25%, 30-year term, $3,067.34 monthly payment.
The borrower adds one additional monthly payment per year, applied entirely to principal. One extra payment equals $3,067.34. Applied at the end of year 1 as a lump-sum principal reduction:
New balance after year 1 standard payments: approximately $446,181. After the extra $3,067.34 payment: approximately $443,114.
That $3,067.34 removes itself from the compounding base. Every subsequent month, interest accrues on a smaller balance. The cumulative effect over the remaining term:
- Loan payoff: accelerates by approximately 4 years and 3 months
- Total interest saved: approximately $64,700
The math reinforces a direct principle: early principal reduction saves disproportionately more than late principal reduction. A $3,000 extra payment in year 2 saves far more total interest than the same payment in year 25, because it removes a larger compounding base for a longer period.
How Rate Changes Alter the Schedule Dramatically
Rate is the single most powerful variable in the amortization formula. Consider the same $450,000 principal at three different rates.
| Rate | Monthly Payment | Total Interest |
|---|---|---|
| 5.75% | $2,627.01 | $496,723.60 |
| 7.25% | $3,067.34 | $654,242.40 |
| 8.50% | $3,460.47 | $795,769.20 |
Moving from 5.75% to 7.25% costs $157,518.80 in additional interest over 30 years. That figure rarely appears in the rate comparison conversation at origination. The monthly payment difference of $440.33 seems manageable. The 30-year cumulative difference does not.
This is why rate decisions carry long-term weight that month-to-month budget comparisons obscure. The amortization schedule makes the full cost visible.
Adjustable-Rate Mortgages and Schedule Complexity
A fixed-rate amortization schedule is calculable on day one. Adjustable-rate mortgages (ARMs) add a variable that makes full-term projections conditional.
For an ARM, the schedule recalculates at each adjustment period. The lender applies the new rate to the remaining balance and the remaining term. The monthly payment resets. The interest portion of each payment changes accordingly.
Borrowers modeling ARM scenarios should calculate multiple schedules. One at the initial rate, one at the rate cap floor, one at the lifetime maximum. The difference between a 6.50% initial ARM rate and a 10.50% lifetime cap on a $450,000 loan is a monthly payment swing of approximately $1,038. Knowing where the schedule lands under each scenario is the minimum standard of diligence before signing.
How to Build the Schedule Yourself
Building a complete schedule in a spreadsheet requires four columns and one formula carried down 360 rows.
Column A: Payment number (1 through 360).
Column B: Interest charge. Formula: prior balance × monthly rate. For row 1, prior balance equals the loan amount.
Column C: Principal reduction. Formula: fixed payment minus column B.
Column D: Remaining balance. Formula: prior balance minus column C.
The fixed payment appears once at the top of the sheet and is referenced absolutely. The monthly rate is the annual rate divided by 12, also entered once.
Building this manually takes about 20 minutes and produces a complete picture. It also allows scenario testing. Change the rate or add an extra payment amount and every downstream row updates automatically.
The limitation of a manual spreadsheet is version control. Each scenario requires a separate file or tab. Comparing three refinancing options or five prepayment strategies across a shared base case adds complexity quickly.
Using the Schedule to Make Specific Decisions
The amortization schedule answers several questions directly.
Should you refinance? Calculate the remaining interest under the current loan. Calculate total interest under the proposed new loan, including closing costs added to principal. The difference is the true savings. Divide by monthly payment reduction to find the break-even month.
How much equity do you have? The remaining balance column on any row is the exact mortgage balance at that point. Subtract from current market value to find equity. No estimate required.
Is an extra payment worth it? Remove any amount from a specific row's balance and recalculate from that row forward. The total interest saved is the direct value of that payment.
When does PMI fall off? Private mortgage insurance typically cancels at 80% loan-to-value. The schedule shows the exact payment number where the remaining balance hits 80% of the original appraised value.
The CalcMoney mortgage calculator generates a full amortization schedule for any loan in seconds. Enter your loan amount, rate, and term. The schedule populates instantly, with total interest, the crossover month, and row-by-row balance data.
Run your complete amortization schedule →You Might Also Like
- 15-Year vs 30-Year Mortgage: The Exact Dollar Difference on a $400,000 Loan
- The Total Cost of a 30-Year Mortgage Is Not the Purchase Price
- ARM vs Fixed Rate Break-Even: The Exact Calculation Most Borrowers Skip
The numbers above are not hypothetical. They are your numbers once you enter your loan terms. The schedule does not change what you owe. It shows you exactly what you owe, month by month, for the full life of the loan.
Put These Numbers to Work
Open a Fidelity brokerage account. $0 commissions, no account minimums, fractional shares available.
Run the Numbers →Related Guides
Free Tools
Run the actual numbers
Stop estimating. Plug in your numbers and get a precise answer in seconds. Free, no signup required.
Open Free Calculators