RentalCalcs · Original decision worksheet

Collection and vacancy worksheet

Record one consistent annual budget, then test the actual vacancy months. Fill locally and print or save as PDF. Nothing is submitted or automatically saved.

Read the complete worked guide

Worked example

The hypothetical fourplex needs 83.4% of $67,200 potential rent after its $2,400 capital contribution. At 90% collections it leaves $4,105.44; at 75% it loses $5,168.16 annually.

1. Establish the income basis

Unit rents, lease periods, concessions and evidence/datePotential annual rent before vacancy and credit lossActual collections, occupied units and unpaid balancesOther income and whether it survives the modeled vacancy

2. Separate the costs

Fixed operating costs and evidence/dateManagement percentage, minimum fees and leasing chargesLoan balance, payment, rate/reset and annual debt serviceCapital contribution; replacements due and available reserve

3. Test the cash calendar

Collection share needed with and without the reserveWhich unit is empty, for how long, and how much rent is lost?Lower rent plus credit loss, extra repairs and turnover costsCash due by month, accessible reserves and unresolved assumptions

Calculation notes

With no other income: required collection share = (fixed operating costs + annual debt + chosen annual capital contribution) / [potential rent × (1 − variable cost share)]. Do not also deduct the same vacancy loss as an expense. Physical occupancy is a separate unit count.

Reviewed October 14, 2026. Original RentalCalcs educational worksheet. Numbers are hypothetical, not property estimates or a lender commitment. OCC commercial real estate lending handbook; lender definitions can differ.