Calculation guide
Same principal and remaining term. Simple monthly payment recovery excludes differences in principal repaid and time value. No break-even when the extended quote is not cheaper.
Inputs
Principal outstanding
Example entry 200000 (in the selected currency). Minimum 0.01.
Locked annual rate
Example entry 5 %. Allowed range 0 to 100.
Alternative annual rate
Example entry 5.5 %. Allowed range 0 to 100.
Months remaining
Example entry 240. Allowed range 1 to 600. Use whole numbers.
Contract fee
Example entry 600 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Principal outstanding | 200,000 |
| Locked annual rate | 5% |
| Alternative annual rate | 5.5% |
| Months remaining | 240 |
| Contract fee | 600 |
| Result | Value |
|---|---|
| Payment-savings recovery period | 10.740535 months |
| Monthly payment reduction | 55.863137 |
Calculation steps
Payment-savings recovery period = (Contract fee ÷ (payment(Principal outstanding, Alternative annual rate, Months remaining) − payment(Principal outstanding, Locked annual rate, Months remaining)))
(600 ÷ (payment(200,000, 5.5, 240) − payment(200,000, 5, 240))) = 10.740535 months
Monthly payment reduction = (payment(Principal outstanding, Alternative annual rate, Months remaining) − payment(Principal outstanding, Locked annual rate, Months remaining))
(payment(200,000, 5.5, 240) − payment(200,000, 5, 240)) = 55.863137
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 | 200,000 | 220,000 | Payment-savings recovery period | 10.740535 months | 9.764123 months |
| Locked annual rate | 5% | 4% | Payment-savings recovery period | 10.740535 months | 3.662692 months |
| Alternative annual rate | 5.5% | 6.5% | Payment-savings recovery period | 10.740535 months | 3.503961 months |
| Months remaining | 240 | 264 | Payment-savings recovery period | 10.740535 months | 10.501129 months |
| Contract fee | 600 | 660 | Payment-savings recovery period | 10.740535 months | 11.814589 months |
