Loan Amortization Schedule with CSV Export

Build a detailed amortization schedule with monthly principal and interest splits, model extra payments to see interest savings, and export the full table as a CSV file.

Other languages: ja | en | zh-CN | es | pt-BR | id | vi | ko | fr | de | it
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