Loan Amortization

Loan amortization converts borrowed principal, annual rate, term and payment frequency into a regular payment, then helps test repayment pressure. It also shows how much interest will be paid and how the remaining balance falls over time. This view is essential for comparing a shorter term, a comfortable payment and total credit cost.

Formula used

Payment = P × r / (1 - (1 + r)^-n)

The payment uses the amortization formula: payment = principal × r × (1 + r)^n ÷ ((1 + r)^n − 1). Here, r is the rate per period and n is the total number of payments. If the rate is zero, the principal is simply divided by the number of payments.

Worked example and result reading

Situation

Example matching the default values: €200,000 borrowed over 20 years at 4%, with monthly payments. The payment is about €1,212, total repaid is about €290,871, including about €90,871 in interest.

Interpretation

A lower payment is not automatically better. It can come from a longer term, making the budget easier but often increasing interest paid. The amortization table shows when the principal actually falls.

Detailed calculation guide

Regular payment

The model spreads repayment across the whole term. With a fixed rate, the payment stays stable while its composition gradually changes.

Interest at the beginning

Interest is calculated on the remaining balance. At the start, that balance is almost the full loan, so the interest share is larger.

Principal repayment

As payments continue, the balance decreases. A larger share of each payment then repays principal, accelerating the fall in debt.

Loan term

A short term requires a higher payment but limits cost. A long term lowers the periodic payment and lets more interest accumulate.

Comparing offers

Do not compare the nominal rate alone. Check payment, total cost, insurance, fees and repayment flexibility.

Safety margin

Before signing, test a slightly higher payment or lower income. The loan should remain manageable under stress.

Key takeaways

  • Each regular payment covers both interest and principal.
  • Interest is higher early because the remaining balance is still high.
  • Extending the term reduces the payment but often raises total cost.
  • The amortization table should be read with actual fees and insurance.

Decision checklist

  • Borrowed principal excludes fees already paid separately.
  • The annual rate matches the nominal rate in the offer being reviewed.
  • Payment frequency matches the contract.
  • Insurance and guarantees are compared outside the formula.
  • Total cost is reviewed together with the payment.

Result checks before use

Compare total cost and payment

For a financial decision, do not keep only the payment, return or final amount. Check total cost, fees, duration, possible inflation and available cash flow to understand what the result really implies. This extra context makes the estimate easier to compare with a quote, statement or long-term plan.

Test an adverse scenario

Increase the rate, lower the expected return or add fees to see how resilient the result is. If a small change removes the safety margin, treat the number as a fragile assumption rather than a secured target. Keep the cautious case visible before committing money.

Separate estimate from contract

An online finance calculation helps prepare comparisons, but it does not replace a bank offer, statement, tax document or contract. Before acting, reconcile the result with official documents and rules that apply to your situation.

Document the assumptions

Keep the entered values, date, currency, rate, term and fees included or excluded. This record makes the simulation repeatable and explains why two similar outputs can lead to different decisions.

Amortization excerpt with default values

€200,000 loan over 20 years at 4%, monthly payments.

YearRemaining balanceCumulative interestPrincipal repaid
1€193,335€7,879€6,665
10€119,706€65,141€80,294
20€0€90,871€200,000

Scenarios to compare

Shorter payoff

Higher payment, lower total cost if the budget supports it.

Long term

More accessible payment, but higher cumulative interest.

Higher-rate affordability

Payment and total cost rise quickly on large amounts, which tests whether repayment pressure remains acceptable.

Early repayment

Review possible fees and timing before deciding.

Common mistakes to avoid

  • Comparing only the payment.
  • Forgetting borrower insurance.
  • Confusing nominal rate with APR.
  • Ignoring application or guarantee fees.
  • Borrowing at the limit without keeping accessible savings.

What to know before using the result

This simulation is educational and is not a credit offer or personalized financial advice. A lender may add insurance, application fees, guarantees, penalties, early repayment rules and approval criteria specific to the borrower.

Frequently asked questions

Why is interest high at the start?

Because it is calculated on a remaining balance that is still large.

Is a longer term bad?

Not always. It can protect monthly cash flow, but it often increases total cost.

Does the calculation include insurance?

No, unless you add it separately in your comparison. The tool models principal amortization with the entered rate.

How is this different from APR?

Amortization calculates payment and interest. APR aims to express global annual cost including mandatory costs and fees.

Related calculators