← การเงิน & เงิน

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.

ภาษาอื่น ๆ 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.

เครื่องคำนวณที่เกี่ยวข้อง