Negative amortization and recast payment · Calculation guide

Project an interest shortfall and the payment required at recast.

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

InputValue
Principal outstanding100,000
Nominal annual interest rate6%
Payment300
Months at reduced payment12
Remaining months after recast240
ResultValue
Balance at recast102,467.112475
Capitalized shortfall2,467.112475
New monthly payment734.106218

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Principal outstanding100,000110,000Balance at recast102,467.112475113,083.890593
Nominal annual interest rate6%7%Balance at recast102,467.112475103,511.232499
Payment300330Balance at recast102,467.112475102,097.045603
Months at reduced payment1213Balance at recast102,467.112475102,679.448037
Remaining months after recast240264New monthly payment734.106218699.926665
Negative amortization and recast payment →

Sources