Loan Amortization Calculator
Calculate loan payments and generate a complete amortization schedule. See principal, interest, and balance for each payment.
Generate a complete loan amortization schedule showing exactly how each payment is split between principal and interest. Perfect for mortgages, car loans, and personal loans. See the total interest you'll pay over the life of the loan and understand how extra payments can save you money.
How to Use This Tool
- Enter the loan amount (principal)
- Input the annual interest rate
- Specify the loan term in years
- Choose your payment frequency (monthly, bi-weekly, etc.)
- View or download the complete amortization schedule
Common Use Cases
- •Planning mortgage payments and total cost
- •Comparing different loan terms (15 vs 30 years)
- •Understanding interest vs principal breakdown
- •Calculating impact of extra payments
- •Refinancing analysis and comparison
Benefits of This Tool
Loan Details
Additional amount per payment
Frequently Asked Questions
Learn the Excel Formulas
=PMT(rate, nper, pv, [fv], [type])
=IPMT(rate, per, nper, pv, [fv], [type])
=PPMT(rate, per, nper, pv, [fv], [type])
=FV(rate, nper, pmt, [pv], [type])
=PV(rate, nper, pmt, [fv], [type])
=NPER(rate, pmt, pv, [fv], [type])
=RATE(nper, pmt, pv, [fv], [type], [guess])
Related Tools
NPV & IRR Calculator
Calculate Net Present Value (NPV) and Internal Rate of Return (IRR) for investment analysis. Free online financial calculator.
CAGR Calculator
Calculate Compound Annual Growth Rate (CAGR) for investments, revenue, or any metric. Free online growth rate calculator with projections.
This was one task. ElyxAI handles hundreds.
The AI agent that works directly in Excel. Describe what you want, it executes.