Mortgage recast after principal curtailment · Calculation guide

Compare the unchanged-term mortgage payment before and after a lump-sum curtailment.

Calculation guide

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

New payment = PMT(principal−curtailment,APR,months); reduction = old payment − new payment.

Inputs

Principal outstanding

Example entry 200000 (in the selected currency).

Lump-sum principal payment

Example entry 30000 (in the selected currency).

Nominal annual interest rate

Example entry 5 %. Allowed range 0 to 100.

Months remaining

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

Worked example

InputValue
Principal outstanding200,000
Lump-sum principal payment30,000
Nominal annual interest rate5%
Months remaining240
ResultValue
New monthly payment1,121.924757
Previous monthly payment1,319.911478
Monthly payment reduction197.986722

Calculation steps

New monthly payment = payment((Principal outstanding − Lump-sum principal payment), Nominal annual interest rate, Months remaining)

payment((200,000 − 30,000), 5, 240) = 1,121.924757

Previous monthly payment = payment(Principal outstanding, Nominal annual interest rate, Months remaining)

payment(200,000, 5, 240) = 1,319.911478

Monthly payment reduction = (Previous monthly payment − New monthly payment)

(1,319.911478 − 1,121.924757) = 197.986722

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Principal outstanding200,000220,000New monthly payment1,121.9247571,253.915905
Lump-sum principal payment30,00033,000New monthly payment1,121.9247571,102.126084
Nominal annual interest rate5%6%New monthly payment1,121.9247571,217.932799
Months remaining240264New monthly payment1,121.9247571,062.977283
Mortgage recast after principal curtailment →

Sources