Calculation guide
Hold the entered nominal rate and minimum payment constant until the first cap crossing. Evaluation stops at the selected horizon. Zero trigger months means no crossing.
Cap = original principal × cap%; evaluate month-end balance after interest and payment against cap.
Inputs
Original principal for cap
Example entry 100000 (in the selected currency). Minimum 0.01.
Principal outstanding
Example entry 100000 (in the selected currency).
Nominal annual interest rate
Example entry 12 %. Allowed range 0 to 100.
Payment
Example entry 500 (in the selected currency).
Balance cap percentage
Example entry 105 %. Allowed range 100 to 300.
Projection horizon in months
Example entry 60. Allowed range 1 to 600. Use whole numbers.
Worked example
| Input | Value |
|---|---|
| Original principal for cap | 100,000 |
| Principal outstanding | 100,000 |
| Nominal annual interest rate | 12% |
| Payment | 500 |
| Balance cap percentage | 105% |
| Projection horizon in months | 60 |
| Result | Value |
|---|---|
| First crossing month, zero if none | 10 months |
| Contractual balance cap | 105,000 |
| Balance at crossing or horizon | 105,231.106271 |
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 |
|---|---|---|---|---|---|
| Original principal for cap | 100,000 | 110,000 | First crossing month, zero if none | 10 months | 28 months |
| Principal outstanding | 100,000 | 90,000 | First crossing month, zero if none | 10 months | 33 months |
| Nominal annual interest rate | 12% | 13% | First crossing month, zero if none | 10 months | 9 months |
| Payment | 500 | 550 | First crossing month, zero if none | 10 months | 11 months |
| Balance cap percentage | 105% | 116% | First crossing month, zero if none | 10 months | 28 months |
| Projection horizon in months | 60 | 1 | First crossing month, zero if none | 10 months | 0 months |
