Why do my pasted numbers break in Excel?

Excel reads numbers using your Windows region settings. A French or German Excel treats "1,234.56" as text because it expects "1.234,56". Switch this calculator to EU format and the copy/CSV output matches what your Excel expects.

Does it work for mortgages, car loans and personal loans?

Yes - the annuity formula is the same one banks use for any fixed-rate loan with equal monthly payments. Enter the amount, rate and term and you get the same payment your bank would quote (before fees and insurance).

Why is the total interest so high on long loans?

Early payments are mostly interest because the balance is still large. On a 30-year loan you can easily pay more in interest than the original amount - the table shows exactly how that evolves month by month.

Is my financial data sent anywhere?

No. The calculation runs entirely in your browser - nothing is transmitted, logged or stored.

Loan Calculator - Payment, Interest & Amortization Table

A loan calculator that respects your region's numbers

If you live in Germany, France or most of Europe, your Excel expects 1.234,56 and separates CSV columns with a semicolon. Most online calculators only speak the US format - so the moment you paste their numbers into a spreadsheet, everything breaks. This calculator lets you switch between EU and US formats, and both the on-screen numbers and the exports follow your choice.

How the monthly payment is calculated

The standard annuity formula: M = P × r / (1 - (1 + r)^-n), where P is the loan amount, r the monthly interest rate (annual rate / 12) and n the number of monthly payments. The amortization table then splits every payment into interest (balance × monthly rate) and principal (the rest), month by month, until the balance reaches zero.

Getting the numbers into Excel

Copy table for Excel copies the schedule as tab-separated values with your chosen decimal separator - paste it straight into Excel, Google Sheets or LibreOffice and the numbers stay numbers.
Download CSV uses your region's conventions: semicolon-separated with comma decimals in EU mode (what most European Excel installs expect), or comma-separated with dot decimals in US mode.

FAQ

Why do my pasted numbers break in Excel?: Excel reads numbers using your Windows region settings. A French or German Excel treats "1,234.56" as text because it expects "1.234,56". Switch this calculator to EU format and the copy/CSV output matches what your Excel expects.
Does this Loan Calculator work for mortgages, car loans and personal loans?: Yes - the annuity formula is the same one banks use for any fixed-rate loan with equal monthly payments. Enter the amount, rate and term and you get the same payment your bank would quote (before fees and insurance).
Why is the total interest so high on long loans?: Early payments are mostly interest because the balance is still large. On a 30-year loan you can easily pay more in interest than the original amount - the table shows exactly how that evolves month by month.
Is my financial data sent anywhere?: No. The calculation runs entirely in your browser - nothing is transmitted, logged or stored.

Loan Calculator with Amortization