Student housing financial model: occupancy and costs

A student housing financial model connects beds, occupancy, rent, and operating costs by property and month. Start with the actual lease calendar, then calculate occupied bed-months and the cost of serving those residents. Keep rental revenue and cash collections in separate schedules.

Start with beds and contract dates

Export the property rent roll, lease schedule, rent charges and credits, general ledger, and operating budget. Keep property ID, bed ID, contract dates, monthly rent, concessions, move-in status, and accounting month. Use consistent property IDs so revenue and expenses can be compared without merging unrelated buildings.

Define the denominator first. Physical capacity, rent-ready capacity, signed leases, and residents in place are different measures. If beds are unavailable for repairs, show both physical beds and unavailable beds rather than silently removing the vacancy from the report.

The academic calendar matters, but the contract controls the revenue periods. For example, NC State describes academic-year agreements without summer rent. That is evidence for checking contract duration, not an assumption that every private operator uses those terms.

Summer business needs its own schedule. NC State's summer housing information sets out separate summer sessions and eligibility. A professional manager should likewise document which beds can be sold, to whom, and for which dates. The daily capacity approach in a hotel financial model serves a different operating calendar.

Build a property operating worksheet

Use one row per property and month in the working file. For readability, this example groups identical months into three periods for one illustrative US property. Occupancy stays constant within each period, rent is earned monthly, and all rent is collected; concessions, bad debt, other income, and corporate allocations are zero in this simplified case.

Put the following inputs in columns A through F, with the first data row in row 2:

The operating-cost assumptions are inputs, not industry benchmarks:

Fixed costs include the assumed property staffing, insurance, property taxes, and base maintenance budget. Variable costs represent occupancy-related utilities and resident services. Turnover expense is an additional operating cost assigned to the fall period; do not also include it in the fixed-cost input.

Add occupied bed-months in G, rental revenue in H, variable cost in I, fixed cost in J, and operating surplus in K. Enter these spreadsheet formulas and fill down through row 4:

G2 =B2*C2*D2
H2 =G2*E2
I2 =G2*$N$2
J2 =B2*$N$3
K2 =H2-I2-J2-F2

For an actual lease register, calculate the billable period for each bed from its contract rather than rounding partial months to full occupancy. Add separately identified concessions and uncollectible amounts before comparing recognized rental revenue with the ledger.

Work the budget and prove the total

Occupied bed-months = Available beds × Occupancy × Months

Rental revenue = Occupied bed-months × Monthly rent per occupied bed

Operating surplus = Rental revenue minus variable costs, fixed costs, and turnover expense

The assumptions produce:

Fall occupied bed-months are 200 × 95% × 4 = 760. Multiplying by $1,000 gives $760,000 in rent. Subtracting $91,200, $100,000, and $30,000 leaves $538,800.

Available bed-months total 200 × (4 + 5 + 3) = 2,400. Annual occupancy is 1,900 / 2,400 = 79.2%, rounded to one decimal place. Weight by available bed-months instead of averaging the three occupancy percentages.

The proof is $1,852,000 minus $228,000 minus $300,000 minus $30,000 = $1,294,000. Also check =SUM(K2:K4)-(SUM(H2:H4)-SUM(I2:J4)-SUM(F2:F4)), which must return zero. This operating surplus excludes debt service, depreciation, income taxes, and capital purchases; it is not ending cash.

Change one assumption, then compare actuals

Reduce only spring occupancy from 90% to 85%. Occupied bed-months fall by 200 × 5% × 5 = 50. Rental revenue falls by 50 × $1,000 = $50,000; variable costs fall by 50 × $120 = $6,000. Fixed and turnover costs stay unchanged.

Annual operating surplus therefore falls by $44,000 to $1,250,000. This isolates the occupancy effect. Changing rent and maintenance spending at the same time would require a separate explanation for each movement.

For monthly reporting, compare the approved occupancy and rent assumptions with rent-roll actuals, then reconcile charges and credits to rental revenue. Reconcile property expenses to the ledger using the same account mapping. Use a cash flow forecast for collections and payments, and AI for FP&A for the wider process of explaining computed plan-to-actual differences.

Where it goes wrong

• Units mixed with beds. Apartment counts multiplied by per-bed rent understate capacity and revenue.
• Preleases treated as current residents. Future contracts inflate current occupancy or rent before their service periods begin.
• Summer filled automatically. Annualizing an academic-year rate invents revenue unless the contracts support it.
• Turnover counted twice. A separate make-ready budget duplicates expenses already included in maintenance.
• Revenue confused with cash. Advance payments and late collections move cash in different months from earned rent.

Compare your property files in Covirage

Bring your prepared property budget, occupancy schedule, and actual rent and expense export in a file or Google Sheet. Covirage maps the columns, and its tools compute and check the revenue, costs, and differences; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own property records.

See FP&A reporting for the supporting finance workflow.