Calculation guide
Monthly payments in arrears, nominal annual rate divided by twelve, no taxes or insurance.
Months = cost of points ÷ (old amortizing payment − new amortizing payment); unchanged term
Inputs
Outstanding loan balance
Example entry 120000 (in the selected currency). Minimum 0.01.
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 5 %. Allowed range 0 to 100.
Discount points (% of principal)
Example entry 1 %. 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 | 5% |
| Discount points (% of principal) | 1% |
| Result | Value |
|---|---|
| Payback period | 20.181689 months |
| Upfront points cost | 1,200 |
| Monthly payment savings | 59.45984 |
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 | Upfront points cost | 1,200 | 1,320 |
| Remaining term in months | 120 | 132 | Payback period | 20.181689 months | 19.898661 months |
| Annual nominal loan rate | 6% | 7% | Payback period | 20.181689 months | 9.95722 months |
| New annual nominal rate | 5% | 4% | Payback period | 20.181689 months | 10.229798 months |
| Discount points (% of principal) | 1% | 2% | Payback period | 20.181689 months | 40.363378 months |
