Loan Amortization Schedule — Excel Calculator with Extra Payments
Bottom Line
A loan amortization schedule in Excel that calculates your monthly payment, shows every payment's principal and interest split, and reveals how much interest extra payments save you.
Tool Overview
- Format: Excel and Google Sheets
- Best For: Mortgages, car loans, student loans, personal loans
- Price: $4.99
A loan amortization schedule shows exactly how each payment splits between principal and interest. Free online calculators give you a table but no extra payment feature. Bank calculators don't let you see interest saved from paying extra.
Two numbers that matter: how much interest extra payments save you, and how many months they shave off your loan.
Loan Amortization Schedule — Excel Calculator with Extra Payments is the solution. Enter your loan amount, rate, and term once. The PMT function calculates your monthly payment. The amortization table auto-generates for up to 360 months. Add recurring or one-time extra payments to see interest saved and your new payoff date instantly.
Key Features
- Full amortization table with PMT, principal, interest, and balance for each payment
- Extra payment support — recurring monthly and one-time lump sum
- Comparison tab showing interest saved and months saved with extra payments
- Charts: principal vs interest area chart, balance trajectory line chart
- Up to 360-month horizon for 30-year mortgages
Get Instant Access
Instant download. Secure payment. Fix-or-replace guarantee.
What's Inside
Five tabs for inputs, calculations, and visual output. All formulas unlocked and visible. Zero macros — works in Excel, Google Sheets, and LibreOffice.
- Loan Summary: Inputs (loan amount, rate, term, start date, extra payments) → outputs (monthly payment via PMT, total interest, payoff date, interest saved)
- Amortization Schedule: Payment #, Date, Scheduled Payment, Extra Payment, Total Payment, Principal, Interest, Balance, Cumulative Interest — auto-generated for full term
- Comparison: Side-by-side with extra payments vs without — interest saved, months saved, years saved, payoff date comparison
- Charts: Principal vs interest area chart, balance trajectory line chart — auto-updating
- Instructions: Step-by-step guide, formula explanations, compatibility notes
How to Use This Tool
- Download — After purchase, you'll receive a download link via email instantly.
- Open — Double-click the .xlsx file to open in Excel, Google Sheets, or LibreOffice Calc.
- Enter loan details — On the Loan Summary tab, fill in the yellow cells: loan amount, interest rate, term, start date, and any extra payments.
- Review results — The amortization schedule, comparison, and charts update automatically.
- Compare scenarios — Adjust extra payments to see how much interest you save and how many months you knock off.
What This Tool Does NOT Do
- It does not track multiple loans simultaneously — one loan per file.
- It does not connect to your bank or import transactions.
- It does not calculate adjustable-rate mortgages (ARMs) — fixed rate only.
- It does not account for PMI, property taxes, or insurance — principal and interest only.
- It does not calculate biweekly payment schedules — monthly payments only.
✓ All formulas unlocked and visible. Zero macros. Compatible with Excel 2016+, Google Sheets, and LibreOffice Calc.
How do I calculate my loan amortization schedule?
A: Enter your loan amount, annual interest rate, loan term, and start date on the Loan Summary tab. The PMT function calculates your monthly payment, and the Amortization Schedule tab generates every payment with principal, interest, and remaining balance.
If your tool doesn't work as described, we'll fix it or replace it free.