Student Housing & Co-Living by the Bed: Unit Mix, Rent per Bed, Academic-Year Leases, Pre-Leasing Pace, Summer Income & NOI per Bed

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn a fictional residence's unit mix into beds, rent per unit and the weekly rent when every bed is let, and compare the bed-weighted average rent with a simple average.
• Measure one block's occupancy twice – by bed and by unit – count the fully let units, and put a weekly price on the empty beds.
• Turn ten fictional tenancies into last nights, tenancy rent, instalment due dates with EDATE and the empty nights before the next academic year with DAYS.
• Track eight weeks of pre-leasing for next year: share of beds signed, the gap to the target curve in whole beds, a projection on last year's pattern and the beds per week needed to reach the final target.
• Forecast eight summer weeks of short stays in the beds that 44-week tenants leave empty: occupied room-nights, room revenue, cleaning per stay, commission and the net summer income.
• Add up what the all-in rent includes per bed and week, the net rent and the all-in share by room type, the annual all-in cost of the residence, and what a fictional energy price rise does to the 6-bed clusters.
• Estimate how many beds turn each summer and mid-year, the make-ready cost, the rent lost while mid-year rooms are re-let and the annual turnover cost per bed.
• Bring the residence together: effective gross income, operating costs with a management fee, NOI, NOI per bed and yield on cost, a rent-and-occupancy sensitivity grid and a chart of the cost lines.