← Finance & money

Loan amortization schedule (with CSV export)

Build an amortization schedule with principal, interest, and balance per payment. Model extra payments and export the table as CSV.

Other languages ja | en | zh-CN | zh-TW | zh-HK | es | es-419 | es-MX | pt-BR | pt-PT | id | vi | ko | fr | de | it | ru-RU | hi-IN | ar | bn-BD | ur-PK | tr-TR | th-TH | pl-PL | fil-PH | ms-MY | fa-IR | nl-NL | uk-UA | he-IL | cs-CZ
Leave blank to omit extra principal payments.

Enter loan details to view the monthly payment, payoff date, and totals.

Amortization table

# Date Payment Principal Interest Balance

FAQ

How do you build an amortization schedule?

Interest equals balance × APR ÷ 12. Principal equals payment − interest. Extra payments apply directly to principal, reducing the balance faster.

What does the CSV include?

The CSV lists payment number, year-month, payment amount, principal, interest, and remaining balance so you can analyze the loan in your spreadsheet.

Can I model extra monthly payments?

Yes. Enter an extra payment amount to apply it toward principal each month and see the new payoff date and total interest.

Related calculators