Calculation guide
Monthly payments in arrears, nominal annual rate divided by twelve, no taxes or insurance.
Payment = balance × r ÷ (1 − (1+r)^−months); enter the reset rate after contractual caps
Inputs
Outstanding loan balance
Example entry 120000 (in the selected currency).
Remaining term in months
Example entry 120. Allowed range 1.0 to 1200.0. Use whole numbers.
Annual nominal loan rate
Example entry 6 %. Allowed range 0 to 100.
New annual nominal rate
Example entry 0 %. Allowed range 0 to 100.
Worked example
| Input | Value |
|---|---|
| Outstanding loan balance | 120,000 |
| Remaining term in months | 120 |
| Annual nominal loan rate | 6% |
| New annual nominal rate | 0% |
| Result | Value |
|---|---|
| Monthly payment | 1,000 |
| Original monthly payment | 1,332.246023 |
| Monthly payment change | -332.246023 |
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 |
|---|---|---|---|---|---|
| Outstanding loan balance | 120,000 | 132,000 | Monthly payment | 1,000 | 1,100 |
| Remaining term in months | 120 | 132 | Monthly payment | 1,000 | 909.090909 |
| Annual nominal loan rate | 6% | 7% | Original monthly payment | 1,332.246023 | 1,393.301751 |
| New annual nominal rate | 0% | 1% | Monthly payment | 1,000 | 1,051.249456 |
