Temporary mortgage rate buydown subsidy · Calculation guide

Estimate the subsidy required for each discounted payment period.

Calculation guide

Contract principal, term and note rate remain unchanged. Each subsidized payment is computed from original principal and full term at its effective rate. Enter consecutive subsidized months only.

Total subsidy = Σ months in tier × [PMT(P,note rate,N) − PMT(P,reduced rate,N)].

Inputs

Principal outstanding

Example entry 300000 (in the selected currency). Minimum 0.01.

Nominal annual interest rate

Example entry 6 %. Allowed range 0 to 100.

Months remaining

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

Tier months

Example entry 12. Allowed range 1 to 360. Use whole numbers.

Effective borrower rate

Example entry 4 %. Allowed range 0 to 100.

Worked example

InputValue
Principal outstanding300,000
Nominal annual interest rate6%
Months remaining360

Temporary payment tiers

Tier monthsEffective borrower rate
124%
125%
ResultValue
Total subsidy deposit6,655.108746
Full contractual monthly payment1,798.651575
Borrower payment in first tier1,432.245886

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Principal outstanding300,000330,000Total subsidy deposit6,655.1087467,320.61962
Nominal annual interest rate6%7%Total subsidy deposit6,655.10874611,389.250588
Months remaining360396Total subsidy deposit6,655.1087466,831.915345
Tier months (row 1)1213Total subsidy deposit6,655.1087467,021.514435
Effective borrower rate (row 1)4%5%Total subsidy deposit6,655.1087464,516.480954
Temporary mortgage rate buydown subsidy →

Sources