Amortization schedule calculator

Free Amortization Schedule Calculator

Use this free amortization schedule calculator to create a monthly loan amortization schedule with principal, interest, extra payments, remaining balance, payoff date, and a yearly summary. Export the amortization table to Excel or print a PDF report in seconds.

Monthly table Yearly summary Extra payments Excel export

Loan payment schedule

Monthly loan amortization schedule with a yearly summary

A loan amortization schedule shows how each scheduled payment is divided between interest and principal. Early rows usually carry more interest because the balance is higher. Later rows shift more of the payment toward principal as the balance falls.

This amortization table calculator works for standard fixed-rate, fully amortizing loans. Use it as a loan payment schedule calculator, monthly amortization schedule, yearly amortization schedule, mortgage amortization schedule, or free amortization schedule with extra payments.

How it works

How to generate an amortization schedule

Enter loan details

Add loan amount, annual interest rate, loan term, currency, and schedule start month.

Add extra payments

Test optional monthly extra principal and a one-time extra payment in a selected month.

Review and export

Read the monthly amortization table, scan the yearly summary, print PDF, or export Excel.

Table columns

How to read an amortization table

Month and date	Shows the payment number and estimated payment month based on the schedule start date.
Payment	The scheduled principal-and-interest payment plus any extra principal applied in that row.
Principal	The part of the payment that reduces the loan balance.
Interest	The cost for that month based on the annual rate and remaining balance.
Extra payment	Optional monthly extra or one-time lump-sum principal payment applied to reduce the balance faster.
Remaining balance	The unpaid loan balance after scheduled principal and extra principal are applied.

Monthly vs yearly

Monthly amortization schedule vs yearly amortization schedule

Detailed view

Monthly amortization schedule

Use monthly rows when you need exact payment-by-payment detail, a payoff date, or an export that mirrors a lender-style loan amortization schedule.

Fast review

Yearly amortization schedule

Use the yearly summary to see annual principal, interest, extra payments, and ending balance without scanning hundreds of rows.

Spreadsheet planning

Loan amortization schedule Excel export

Download the full schedule and yearly summary for spreadsheet review. If the Excel library is blocked, the page exports a CSV report instead.

Worked example

Extra payment examples in an amortization schedule

Example: $250,000 at 6.5% for 30 years	Payoff time	Total interest	What changes
No extra payment	360 months	$318,861.22	Original monthly payment is about $1,580.17.
$100 extra monthly	304 months	$260,001.34	The balance falls faster and interest drops by about $58,859.89.
$250 extra monthly	250 months	$206,265.25	The payoff timeline is much shorter, but monthly cash flow needs are higher.

Examples assume a standard fixed-rate, fully amortizing loan with monthly interest. Actual lender schedules can differ because of APR, fees, day-count rules, payment dates, rounding, and prepayment rules.

Principal and interest schedule

The principal and interest schedule is the heart of amortization. It explains why the same monthly payment can reduce the balance slowly at first and faster later.

Amortization schedule with extra payments

Extra payments are modeled as additional principal. Confirm with your lender that extra money is applied to principal and review any prepayment terms before relying on estimated savings. The CFPB explains that some loans can include a prepayment penalty.

Download amortization schedule PDF or Excel

Use PDF print for a clean report or Excel export for a spreadsheet version of the full monthly amortization schedule, yearly summary, assumptions, and notes.

FAQ

Amortization Schedule Calculator FAQs

What is an amortization schedule?+

An amortization schedule is a payment table showing how each loan payment is split between principal and interest and how the remaining balance changes over time.

How is an amortization schedule calculated?+

For a standard fixed-rate loan, the calculator estimates a scheduled monthly payment, then recalculates interest each month from the remaining balance and applies the rest to principal.

Can I use this as a mortgage amortization schedule?+

Yes, for the principal-and-interest loan schedule. Use the mortgage calculator when you also need property tax, homeowners insurance, PMI, or HOA fees.

Does the amortization schedule include extra payments?+

Yes. Add monthly extra principal, a one-time extra payment, or both to estimate interest savings and earlier payoff timing.

Can I export the amortization schedule to Excel?+

Yes. The export includes summary, inputs, full monthly schedule, yearly summary, and notes. If Excel export is blocked, the calculator downloads a CSV report.

EMI · 9 min read