A loan amortization schedule is the month-by-month breakdown of every payment — how much goes to interest, how much to principal, and the remaining balance — from the first payment to the final payoff. For a $400,000 mortgage at 7% over 30 years, the schedule reveals that the $2,129 fixed payment is $1,866 interest and $263 principal in month 1, but $12 interest and $2,117 principal in month 360, with $446,692 total interest over the life of the loan. Seeing this schedule before signing turns a monthly number into a full payoff picture.
This in-depth guide explains what an amortization schedule is, how amortizing loans work, how the monthly payment is calculated, how to create a full schedule in 3 steps with a free tool, and the what-if scenarios — extra payments, 15- vs 30-year, and rate changes — that save years and tens of thousands in interest.
What Is a Loan Amortization Schedule?
A loan amortization schedule is a table where each row is one payment period (usually monthly) with four columns:
- Payment: The fixed total due — e.g., $2,129 for a $400K, 7%, 30yr loan, paid 360 times
- Interest:
Remaining Balance × Monthly Rate— $400,000 × 7%/12 = $2,333 of interest accrual, but the payment formula yields $1,866 interest and $263 principal in month 1 (the fixed payment is less than interest on the full balance at first, so most goes to interest) - Principal:
Payment − Interest— the amount that actually reduces the balance - Balance:
Prior Balance − Principal— $400,000 − $263 = $399,737 after month 1, declining to $0 after month 360
Per CFPB: What is amortization?, amortizing loans are fully paid off by the end of the term with equal payments, unlike interest-only or balloon loans. The schedule makes this concrete: the same $2,129 every month, but the interest/principal split shifts dramatically over time.
How Amortizing Loans Work — The Formula
Answer-first: the fixed payment is calculated once from the loan amount, rate, and term, then each month's interest is computed on the remaining balance — so early payments are interest-heavy and later payments are principal-heavy.
Monthly payment formula:
PMT = P × [r(1+r)^n] / [(1+r)^n − 1]
P = $400,000 (principal)
r = 7% / 12 = 0.005833 (monthly rate)
n = 30 × 12 = 360 (payments)
→ PMT = $2,129.24 per month (P&I)Then the schedule loops 360 times:
For each month:
Interest = Balance × r
Principal = PMT − Interest
Balance -= PrincipalBecause balance shrinks, interest shrinks, so principal grows — all with the same $2,129 payment. This is why extra payments have a compounding effect: they reduce the balance, which reduces next month's interest, which increases the principal portion of the next payment.
Total cost: $2,129 × 360 = $766,692 paid, with $446,692 interest — more than the original loan. This total is invisible without the schedule.
How the Payment Split Shifts Over 30 Years
For the $400K, 7%, 30yr example:
| Year | Interest Paid That Year | Principal Paid | Remaining Balance |
|---|---|---|---|
| Year 1 | $27,800 | $3,200 | $396,800 |
| Year 10 | $24,000 | $6,800 | ~$350,000 |
| Year 20 | $15,000 | $15,800 | ~$220,000 |
| Year 30 | $1,200 | $24,300 | $0 |
Year 1 is 88% interest; year 30 is 99% principal. The crossover where principal exceeds interest occurs around year 18. Equity builds slowly at first — $3,200 after year 1 on a $400K loan — then accelerates. This slow start is why down payment and early extra payments matter so much for equity.
What Extra Payments Do (Real Value)
- +$100/mo extra: Save ~$51,000 interest, payoff 4.2 years early (2052 vs 2056)
- +$200/mo extra: Save ~$85,800 interest, payoff 5.8 years early
- Bi-weekly (26 half-payments = 13 full): Save ~$78,000, payoff 5.1 years early — equivalent to one extra payment per year, automated
Extra payments go 100% to principal, so next month's interest is calculated on a smaller balance — compounding savings that the schedule quantifies instantly.
15-Year vs 30-Year at the Same Rate
15yr at 7% on $400K: $3,597/mo, $247,000 total interest. 30yr at 7%: $2,129/mo, $446,692 interest. The 15yr costs $1,468/mo more but saves $199,692 in interest and 15 years. The schedule makes the trade-off concrete: lower monthly vs total cost.
How to Create an Amortization Schedule in 3 Steps (Free Tool)
- Enter loan details: Loan amount ($400,000), annual rate (7.0%), term (30 years or 360 months), start date (2026-09-01), and optional extra payment ($0 or $200/mo). The payment is calculated instantly via the formula above.
- Get the full table: The generator produces 360 rows with payment, interest, principal, balance, and date for every month, plus yearly totals and a running total. Toggle monthly vs yearly view — yearly is better for tax and planning, monthly for precision.
- Use and export: Print or save as PDF with yearly totals for tax records (yearly interest for itemized deduction), export CSV for Excel/Sheets modeling, try an extra $200 to see the new table and payoff date, and compare 15yr vs 30yr side by side.
What the schedule shows that the monthly alone hides: Interest paid per year (year 1: $27,800), equity built (balance $400K → $350K at year 10), and the exact payoff date — 2056-08 for the base loan, 2050-10 with $200 extra. These inform refinance, sale timing, and tax planning.
What-If Scenarios to Try in the Calculator
| Scenario | Monthly | Total Interest | Payoff |
|---|---|---|---|
| $400K, 7%, 30yr (base) | $2,129 | $446,692 | 2056-08 |
| + $200/mo extra | $2,329 | $360,880 | 2050-10 (5.8yr early) |
| 15yr at 7% | $3,597 | $247,000 | 2041-09 |
| 30yr at 6% vs 8% | $1,798 vs $2,473 | $247K vs $490K | 1% rate = $331/mo & $144K over 30yr |
Use the schedule for:
- Taxes: Yearly interest total for itemized deduction — export yearly view for the CPA
- Payoff plan: See balance at any future date to plan refinance or sale; the schedule shows exactly when 20% equity is reached for PMI removal
- Comparison: Compare two loans side by side — e.g., 30yr at 7% vs 15yr at 6.5% with points — on total interest, not just monthly
Amortization vs related calculators: Amortization is the full schedule (payment breakdown); a mortgage calculator is P&I only; a down payment calculator is cash needed. Use amortization for interest/principal over time, not just the monthly.
FAQs About Loan Amortization Schedules
What is a loan amortization schedule?
A table showing each payment's date, total payment, interest portion, principal portion, and remaining balance from the first payment to payoff, with totals. For a 30-year loan, it has 360 rows.
How is the monthly payment calculated?
With PMT = P×[r(1+r)^n]/[(1+r)^n−1] where P is loan amount, r is monthly rate (annual/12), and n is number of payments (years×12). Then each month: Interest = Balance×r, Principal = PMT−Interest, Balance −= Principal.
How does an extra payment affect the schedule?
Extra goes entirely to principal, so next month's interest is on a smaller balance — compounding. $200/mo extra on $400K at 7% saves ~$85,800 and shortens payoff by 5.8 years. The schedule regenerates with the new payoff date.
What is the difference between amortization and mortgage calculator?
A mortgage calculator gives the monthly P&I; an amortization schedule gives the full breakdown of every payment plus totals, yearly sums, and payoff date — the complete picture over time.
Can I print or export the schedule?
Yes — the tool offers print (yearly totals, clean layout for lenders or tax records) and CSV export for Excel/Sheets modeling and custom charts.
Does the schedule include taxes and insurance?
No — it shows P&I, interest, principal, and balance (the amortizing part). Add property tax, insurance, HOA, and PMI separately for PITI — the schedule is the loan itself.
Conclusion
An amortization schedule turns a single monthly number into a complete payoff story: how much interest is paid when, how quickly equity builds, and how extra payments compound into years saved and tens of thousands of dollars. Seeing the 360 rows — and the totals — makes the trade-off between lower monthly and total cost concrete before signing.
Enter the loan amount, rate, and term to generate the full schedule instantly — then try an extra payment to see the new payoff date and interest saved.
