Fixed principal versus fixed instalment schedule · Calculation guide

Compare overall interest and the range of payments on two amortization methods.

Calculation guide

End-of-month payments and a fixed nominal annual rate divided by twelve. No fees or early settlement charges.

Equal principal = P/n; total interest = P × r × (n+1)/2; level instalment = PMT(P,APR,n).

Inputs

Principal outstanding

Example entry 120000 (in the selected currency).

Nominal annual interest rate

Example entry 6 %. Allowed range 0 to 100.

Months remaining

Example entry 120. Allowed range 1 to 600. Use whole numbers.

Worked example

InputValue
Principal outstanding120,000
Nominal annual interest rate6%
Months remaining120
ResultValue
Interest saved with equal principal3,569.522796
First monthly payment1,600
Final monthly payment1,005
Level instalment1,332.246023

Calculation steps

Interest saved with equal principal = (((payment(Principal outstanding, Nominal annual interest rate, Months remaining) × Months remaining) − Principal outstanding) − ((((Principal outstanding × Nominal annual interest rate) ÷ 1,200) × (Months remaining + 1)) ÷ 2))

(((payment(120,000, 6, 120) × 120) − 120,000) − ((((120,000 × 6) ÷ 1,200) × (120 + 1)) ÷ 2)) = 3,569.522796

First monthly payment = ((Principal outstanding ÷ Months remaining) + ((Principal outstanding × Nominal annual interest rate) ÷ 1,200))

((120,000 ÷ 120) + ((120,000 × 6) ÷ 1,200)) = 1,600

Final monthly payment = ((Principal outstanding ÷ Months remaining) × (1 + (Nominal annual interest rate ÷ 1,200)))

((120,000 ÷ 120) × (1 + (6 ÷ 1,200))) = 1,005

Level instalment = payment(Principal outstanding, Nominal annual interest rate, Months remaining)

payment(120,000, 6, 120) = 1,332.246023

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Principal outstanding120,000132,000Interest saved with equal principal3,569.5227963,926.475076
Nominal annual interest rate6%7%Interest saved with equal principal3,569.5227964,846.210075
Months remaining120132Interest saved with equal principal3,569.5227964,313.828489
Fixed principal versus fixed instalment schedule →

Sources