Amortization calculator and monthly schedule

Generate a fixed-payment monthly amortization schedule: principal, interest and remaining debt. Export CSV. Fixed nominal rate, exact cents, adjusted final payment.

Your inputs stay herePUFFINMINT

Set your data

Loan principal (€)

Fixed annual nominal rate (%) · up to 4 decimals

Monthly payments (1–600)

Result

Enter your data and run the tool. Your result will appear here.

Principal and interest

See how much principal and interest you have paid by each month.

The values you enter stay on this page. Reloading or closing it clears them.

We count which tools are used most, without including entered values or file contents in the statistics. Privacy

How to use the tool

Fill in these fields: Loan principal (€), Fixed annual nominal rate (%) · up to 4 decimals, Monthly payments (1–600).
Select “Calculate” to obtain the result.
See how much principal and interest you have paid by each month.
Use the sliders in the calculator with a mouse, touch or the arrow keys. Use the calculator fields for precise values or values outside the sliders’ ranges.

Method and principles

Formula

C = A - I

K[m] = A[m] − I[m]; B[m] = B[m−1] − K[m]

Result details

Result details
Parameter	Value
Total repayment	€145,435.21
Total interest	€45,435.21
Actual payments	240

Practical example

Input

Loan principal (€): 100000
Fixed annual nominal rate (%) · up to 4 decimals: 4
Monthly payments (1–600): 240

Result

€605.98

Limits and checks

Limits and checks
Parameter	Value
Monthly payments (1–600)	≥ 1; ≤ 600

Sources and further reading

Banca d’Italia · TAEG