RentalCalcs worksheet · Reviewed October 17, 2026. General investor research, not an agency form, approval or appraisal. Blank fields are for your records. This page does not save or transmit entries; print it when finished.
Read the complete worked example and limitations · Download example CSV
Download the complete worked monthly ledger. It starts at $5,000, reaches a $664 shortfall in month 5 and ends at $3,339. The $2,720 HAP receivable is collected in month 6 and is not deducted again as lost income. Timing is illustrative.
Opening cash + tenant cash + PHA cash − operating bills − debt − reserve funding/capital spending = closing available cash. Carry that balance forward. Keep collectible HAP in its own column, outside available cash. Do not count a reserve transfer and the same bill paid from it twice.
| Month | Opening cash | Tenant cash | PHA cash | Outgo / set aside | HAP still owed | Closing cash |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | ||||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 | ||||||
| 9 | ||||||
| 10 | ||||||
| 11 | ||||||
| 12 |
Scroll within the calendar or focus it and use arrow keys. These are blank record fields, not an automatic calculator; no entries are saved or transmitted.
| Item | Value |
|---|---|
| Gross annual rent | 19,800 |
| Normalized vacancy | 825 |
| Occupied tenant rent due | 3,335 |
| Tenant loss at 10 percent | 333.5 |
| Normalized HAP loss | 198 |
| Effective income | 18,443.5 |
| Management at 8 percent | 1,475.48 |
| Other operating costs | 5,500 |
| NOI before reserve | 11,468.02 |
| Replacement reserve | 1,500 |
| Annual principal and interest | 8,322.93 |
| Cash after reserve and debt | 1,645.09 |
| Stress effective income | 14,850 |
| Stress NOI | 8,162 |
| Stress cash | -1,660.93 |
Amounts are dollars unless the row names a percentage, count or term. The article states the complete method, source scope and rounding convention.