How to Use
- 1.
Enter the loan amount or principal balance.
- 2.
Enter the annual interest rate and select the payment frequency.
- 3.
Add the loan term in years and months, then choose the start date.
- 4.
Select the compounding option used for the estimate.
- 5.
Add an optional extra payment or balloon payment if your loan includes one.
- 6.
Review payment amount, total interest, total amount paid, principal vs interest chart, and the amortization schedule table.
- 7.
Download the full schedule as a CSV file for Excel or Google Sheets.
Features
Loan payment calculation
Monthly, weekly, and yearly payment frequencies
Monthly, daily, and annual compounding options
Principal and interest breakdown for every payment
Remaining balance after each payment
Extra payment and prepayment support
Balloon payment option
Principal vs interest summary chart
Full amortization table
CSV export for spreadsheet use
Multiple currency display options
Copyable loan summary
Frequently Asked Questions
What is an amortization schedule?+
An amortization schedule is a table that shows every loan payment, including the payment date, payment amount, principal paid, interest paid, and remaining balance.
How does this amortization calculator work?+
It converts the annual interest rate into a payment-period rate, calculates the regular payment, then builds a schedule showing principal, interest, and balance after each payment.
Can I use this as a mortgage amortization calculator?+
Yes. Enter the mortgage amount, rate, term, start date, and monthly frequency to estimate a mortgage payment schedule.
Does the calculator support extra payments?+
Yes. Enter an extra payment amount and the schedule recalculates to show faster payoff and the updated interest total.
What is a balloon payment?+
A balloon payment is a larger final payment due at the end of the loan. The calculator treats the entered balloon amount as the planned final balance.
Can I download the amortization table?+
Yes. Use the Download CSV button to export the full schedule. CSV files can be opened in Excel, Google Sheets, Numbers, and other spreadsheet tools.
Why is the lender schedule different from this estimate?+
Lenders may use different compounding, rounding, payment dates, fees, escrow charges, variable rates, or day-count rules. Use this calculator as a planning estimate.
Is this calculator financial advice?+
No. It is an educational loan planning tool only. Confirm official numbers with your lender or a qualified financial professional.
About this tool
Free Amortization Schedule Calculator
Use the free WebToolsEdge Amortization Schedule Calculator to estimate a loan payment and build a payment-by-payment amortization table. Enter the loan amount, annual interest rate, loan term, start date, payment frequency, compounding option, and optional extra payment to see how each payment is split between principal and interest. A loan amortization schedule is useful because a single payment number does not show the full cost of borrowing. Early in many loans, a larger share of each payment goes toward interest. Later, as the balance falls, more of each payment goes toward principal. This calculator shows the payment number, payment date, total payment, principal paid, interest paid, and remaining balance after every scheduled payment. The tool supports monthly, weekly, and yearly payment schedules, making it useful as a mortgage amortization calculator, car loan amortization calculator, personal loan schedule calculator, business loan payment table, or general loan repayment planner. You can also compare monthly compounding, daily compounding, and annual compounding assumptions. Extra payments can make a major difference. Add an extra amount per payment period to see whether the loan could be paid off earlier and how the total interest changes. The calculator also includes a balloon payment field for loans where a planned final balance is paid at the end. For reporting, the full amortization schedule can be downloaded as a CSV file that opens in Excel, Google Sheets, Numbers, and most spreadsheet apps. Pair this calculator with the EMI Calculator for a quick monthly payment estimate, the Credit Card Payoff Calculator for revolving debt planning, the Debt-to-Income Ratio Calculator for affordability checks, and the Rent vs Buy Calculator when comparing home ownership costs. This amortization calculator is for educational planning only. Real lenders may use different rounding rules, fees, day-count conventions, escrow charges, taxes, variable rates, payment dates, and contract terms. Review official lender documents before making financial decisions.
Planning a vehicle purchase? Compare trade-in, flat or reducing rates, and car-specific fees with the Car Loan Calculator. Planning a home purchase? Calculate upfront cash, PMI, and affordability first with the Down Payment Calculator. If you only need a quick fixed monthly installment, start with the EMI Calculator. For credit card balances, the Credit Card Payoff Calculator is better suited to revolving debt. You can also check affordability with the Debt-to-Income Ratio Calculator or compare home decisions with the Rent vs Buy Calculator.