From this site

One project, every trade

Each calculator adds its lines to a single estimate — consolidated BOM, schedule and cash-flow included.

Open My Project

Methodology

Loan Amortisation

The annuity formula behind every repayment figure, and why the zero-rate case needs its own branch.

The annuity payment

A repayment loan is an annuity: a fixed periodic payment that exactly retires the principal plus its accruing interest over the term. The payment is the principal times the periodic rate, divided by one minus the discount factor over the full number of periods.

Every part of the formula is doing something. The numerator is the interest on the whole principal for one period. The denominator scales that up to account for the principal being repaid gradually, so that later periods carry interest on a smaller balance.

M=Pr(1+r)n(1+r)n1
The payment equals principal times rate times one plus rate to the power n, divided by one plus rate to the power n minus one.
M
payment per period
P
principal
r
interest rate per period (annual rate ÷ 12 for monthly)
n
total number of payments

The zero-rate branch is not hypothetical

At r = 0 the formula divides by zero, and code that does not handle it returns NaN. This is not an edge case worth ignoring: interest-free finance is a real product, offered routinely on cars, furniture and home improvements.

The correct behaviour at zero is obvious once stated — the payment is simply the principal divided by the number of periods — and every calculator here branches to it explicitly rather than relying on floating-point luck near zero.

What amortisation does not tell you

The payment is arithmetic on the figures entered. It is not an affordability assessment, an offer, or advice. Lending decisions rest on income, expenditure, credit history and a stress-tested rate materially above the headline one, and a comfortable-looking payment at today's rate says nothing about whether a lender will agree to it.

Calculators that use this method

Basis

  • Standard annuity-immediate formula; identical to the PMT function in spreadsheet software.