Escrow monthly deposit and shortage recovery · Calculation guide

Combine expected escrow bills and a quoted shortage repayment schedule.

Calculation guide

Enter actual annual bills and the servicer’s stated shortage and recovery term. Excludes cushion analysis or legal limits.

Base = (annual tax + insurance + other escrow bills)/12; temporary monthly = base + shortage/recovery months.

Inputs

Annual property taxes

Example entry 3600 (in the selected currency).

Annual insurance

Example entry 1200 (in the selected currency).

Other annual escrow bills

Example entry 0 (in the selected currency).

Stated escrow shortage

Example entry 600 (in the selected currency).

Shortage recovery months

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

Worked example

InputValue
Annual property taxes3,600
Annual insurance1,200
Other annual escrow bills0
Stated escrow shortage600
Shortage recovery months12
ResultValue
Monthly deposit during recovery450
Ongoing base deposit400
Monthly shortage payment50

Calculation steps

Monthly deposit during recovery = ((((Annual property taxes + Annual insurance) + Other annual escrow bills) ÷ 12) + (Stated escrow shortage ÷ Shortage recovery months))

((((3,600 + 1,200) + 0) ÷ 12) + (600 ÷ 12)) = 450

Ongoing base deposit = (((Annual property taxes + Annual insurance) + Other annual escrow bills) ÷ 12)

(((3,600 + 1,200) + 0) ÷ 12) = 400

Monthly shortage payment = (Stated escrow shortage ÷ Shortage recovery months)

(600 ÷ 12) = 50

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Annual property taxes3,6003,960Monthly deposit during recovery450480
Annual insurance1,2001,320Monthly deposit during recovery450460
Other annual escrow bills01Monthly deposit during recovery450450.083333
Stated escrow shortage600660Monthly deposit during recovery450455
Shortage recovery months1213Monthly deposit during recovery450446.153846
Escrow monthly deposit and shortage recovery →

Sources