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
| Input | Value |
|---|---|
| Principal outstanding | 300,000 |
| Nominal annual interest rate | 6% |
| Months remaining | 360 |
Temporary payment tiers
| Tier months | Effective borrower rate |
|---|---|
| 12 | 4% |
| 12 | 5% |
| Result | Value |
|---|---|
| Total subsidy deposit | 6,655.108746 |
| Full contractual monthly payment | 1,798.651575 |
| Borrower payment in first tier | 1,432.245886 |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Principal outstanding | 300,000 | 330,000 | Total subsidy deposit | 6,655.108746 | 7,320.61962 |
| Nominal annual interest rate | 6% | 7% | Total subsidy deposit | 6,655.108746 | 11,389.250588 |
| Months remaining | 360 | 396 | Total subsidy deposit | 6,655.108746 | 6,831.915345 |
| Tier months (row 1) | 12 | 13 | Total subsidy deposit | 6,655.108746 | 7,021.514435 |
| Effective borrower rate (row 1) | 4% | 5% | Total subsidy deposit | 6,655.108746 | 4,516.480954 |
