Amortization schedule calculator

Amortization Calculator with Loan Payment Table

Create a free amortization schedule with monthly payment, principal, interest, extra payment, balance, and payoff date. Print the amortization table or export the loan amortization schedule to Excel.

Full schedule Extra payments Excel export PDF print

Full payment table

Amortization schedule built for month-by-month review

This amortization calculator is focused on the payment table. It shows how each monthly payment moves through interest, principal, extra payment, and remaining balance until the loan is paid off. The final payment should adjust for rounding so the schedule ends with a clean zero balance.

Use it when you need a free amortization schedule, amortization worksheet, loan repayment schedule calculator, or loan amortization schedule Excel export for planning and comparison.

How it works

Three steps from balance to amortization table

Enter the loan balance

Add the current balance, annual rate, tenure, currency, interest method, and schedule start month.

Compare extra payments

Add an optional extra monthly payment to see interest saved, payoff months saved, and the updated balance path.

Export the full table

Print a clean PDF report or export an Excel workbook with summary, assumptions, notes, and every amortization row.

Inputs and outputs

What the amortization calculator includes

Starting balance	The loan balance used as the first principal amount in the amortization schedule.
Monthly payment	The estimated payment needed to amortize the loan over the selected tenure and interest rate.
Principal and interest split	Each row shows how much of the payment goes to principal and how much goes to interest.
Extra payments	Optional extra payments reduce the balance faster and can lower total interest.
Full schedule export	PDF and Excel reports include the complete amortization table, summary, input assumptions, payoff date, planning notes, and rounding-safe final balance handling.

Always check lender rules for prepayment, escrow, insurance, compounding, fees, and rounding before relying on an amortization schedule.

Amortization table calculator

An amortization table shows every payment in a loan: payment number, date, principal paid, interest paid, extra payment, and ending balance. This amortization table calculator helps you see the loan cost month by month.

Schedule with extra payments

Use the amortization calculator with extra payments to compare an original loan amortization schedule against an early payoff plan. The schedule shows interest saved and how many months can be removed from the loan.

Printable and Excel amortization schedule

Generate a free amortization schedule online, print it as a PDF, or export a loan amortization schedule Excel file. It works as an amortization worksheet, loan repayment schedule calculator, and amortized loan payment calculator.

FAQ

Amortization Calculator FAQs

What is loan amortization?+

Loan amortization is the process of paying down a loan through scheduled payments. Each payment usually includes interest plus a portion that reduces the principal balance.

How does an amortization schedule work?+

An amortization schedule lists each payment period and shows payment amount, principal, interest, extra payment, and remaining balance. Early payments often include more interest, while later payments include more principal.

What do extra payments do in an amortization schedule?+

Extra payments reduce principal faster. That can shorten the payoff timeline and reduce total interest, depending on the lender's rules.

Can I download the amortization schedule as Excel?+

Yes. Use the Export Excel button to download a workbook with summary and schedule sheets. If the Excel library is blocked, the tool exports a CSV file instead.

Is amortization the same as depreciation?+

No. Loan amortization is about repayment of debt over time. Depreciation is about the declining value of an asset. This tool is for loan repayment planning.

Loan · Payment