Loan amortization schedule (Excel)
Every payment of a loan or mortgage split into interest and principal, with optional extra payments; download as Excel or CSV.
Input
How to use this tool
- Enter your values or choose a local file. Replace the example data with your own.
- Review options, units and assumptions, then run the tool.
- Check the result before copying or downloading it. Keep an original copy of important files.
Method & assumptions
Every payment of a loan or mortgage split into interest and principal, with optional extra payments; download as Excel or CSV.
payment = P × r ÷ (1 − (1 + r)^−n), r = rate ÷ 12 (monthly compounding)Worked example
Currency: USD Loan amount: 250,000 Interest rate %: 6.5 Term (years): 30 Extra payment per month: 0 Download as: Excel workbook (.xlsx) → Monthly payment: USD 1,580.17 → Total interest: USD 318,861.22 → Paid off in: 360 months
Limits & important notes
Basic release. Review the result before relying on it. File limits, supported cases and processing requirements are shown above.
Content updated:
Privacy & Free to use
Are my inputs stored?
Your inputs stay in this tab. We do not receive your files, pasted text or calculation values.
Is this tool free?
Yes. No signup or payment is required.
Useful next steps
Monthly budget planner with Excel download
Plan income, bills, spending and savings by category, check the 50/30/20 split and download an editable Excel budget with live formulas.
Budget & debt12-month budget spreadsheet generator (Excel)
Create a ready-to-use Excel workbook: a 12-month budget, a transaction log and a plan-versus-actual summary, all with working formulas.
Budget & debtDebt snowball & avalanche calculator (Excel plan)
Enter up to five debts and an extra monthly amount to see your debt-free date, total interest, payoff order and a month-by-month Excel plan.
Budget & debt