Calculation guide
End-of-month payments and a fixed nominal annual rate divided by twelve. No fees or early settlement charges.
Each month balance := balance × (1+APR/1200) − payment; recast payment = PMT(recast balance,APR,remaining term).
Inputs
Principal outstanding
Example entry 100000 (in the selected currency).
Nominal annual interest rate
Example entry 6 %. Allowed range 0 to 100.
Payment
Example entry 300 (in the selected currency).
Months at reduced payment
Example entry 12. Allowed range 0 to 600. Use whole numbers.
Remaining months after recast
Example entry 240. Allowed range 1 to 600. Use whole numbers.
Worked example
| Input | Value |
|---|---|
| Principal outstanding | 100,000 |
| Nominal annual interest rate | 6% |
| Payment | 300 |
| Months at reduced payment | 12 |
| Remaining months after recast | 240 |
| Result | Value |
|---|---|
| Balance at recast | 102,467.112475 |
| Capitalized shortfall | 2,467.112475 |
| New monthly payment | 734.106218 |
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 | 100,000 | 110,000 | Balance at recast | 102,467.112475 | 113,083.890593 |
| Nominal annual interest rate | 6% | 7% | Balance at recast | 102,467.112475 | 103,511.232499 |
| Payment | 300 | 330 | Balance at recast | 102,467.112475 | 102,097.045603 |
| Months at reduced payment | 12 | 13 | Balance at recast | 102,467.112475 | 102,679.448037 |
| Remaining months after recast | 240 | 264 | New monthly payment | 734.106218 | 699.926665 |
