Payment-option ARM balance cap · Calculation guide

Find the first month a reduced ARM payment takes the loan to its balance cap.

Calculation guide

Hold the entered nominal rate and minimum payment constant until the first cap crossing. Evaluation stops at the selected horizon. Zero trigger months means no crossing.

Cap = original principal × cap%; evaluate month-end balance after interest and payment against cap.

Inputs

Original principal for cap

Example entry 100000 (in the selected currency). Minimum 0.01.

Principal outstanding

Example entry 100000 (in the selected currency).

Nominal annual interest rate

Example entry 12 %. Allowed range 0 to 100.

Payment

Example entry 500 (in the selected currency).

Balance cap percentage

Example entry 105 %. Allowed range 100 to 300.

Projection horizon in months

Example entry 60. Allowed range 1 to 600. Use whole numbers.

Worked example

InputValue
Original principal for cap100,000
Principal outstanding100,000
Nominal annual interest rate12%
Payment500
Balance cap percentage105%
Projection horizon in months60
ResultValue
First crossing month, zero if none10 months
Contractual balance cap105,000
Balance at crossing or horizon105,231.106271

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Original principal for cap100,000110,000First crossing month, zero if none10 months28 months
Principal outstanding100,00090,000First crossing month, zero if none10 months33 months
Nominal annual interest rate12%13%First crossing month, zero if none10 months9 months
Payment500550First crossing month, zero if none10 months11 months
Balance cap percentage105%116%First crossing month, zero if none10 months28 months
Projection horizon in months601First crossing month, zero if none10 months0 months
Payment-option ARM balance cap →

Sources