Calculation guide
Enter actual annual bills and the servicer’s stated shortage and recovery term. Excludes cushion analysis or legal limits.
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
| Input | Value |
|---|---|
| Annual property taxes | 3,600 |
| Annual insurance | 1,200 |
| Other annual escrow bills | 0 |
| Stated escrow shortage | 600 |
| Shortage recovery months | 12 |
| Result | Value |
|---|---|
| Monthly deposit during recovery | 450 |
| Ongoing base deposit | 400 |
| Monthly shortage payment | 50 |
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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Annual property taxes | 3,600 | 3,960 | Monthly deposit during recovery | 450 | 480 |
| Annual insurance | 1,200 | 1,320 | Monthly deposit during recovery | 450 | 460 |
| Other annual escrow bills | 0 | 1 | Monthly deposit during recovery | 450 | 450.083333 |
| Stated escrow shortage | 600 | 660 | Monthly deposit during recovery | 450 | 455 |
| Shortage recovery months | 12 | 13 | Monthly deposit during recovery | 450 | 446.153846 |
