Student Housing & Co-Living by the Bed: Unit Mix, Rent per Bed, Academic-Year Leases, Pre-Leasing Pace, Summer Income & NOI per Bed
Run a fictional student residence or co-living building bed by bed: unit mix, rent per bed vs per unit, academic-year tenancies, pre-leasing against target, summer short stays, all-inclusive utilities, turnover and NOI per bed, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you run a fictional 314-bed student residence in Excel, bed by bed. You turn the unit mix of studios, twins and clusters into beds, rent per unit and a bed-weighted average rent, and compare bed occupancy with fully let units using SUMPRODUCT. You build 44- and 51-week tenancy calendars with EDATE and DAYS, track pre-leasing against the prior year and a target curve, and forecast summer short-stay income with cleaning and commission. You price the all-inclusive services per bed, estimate turnover and make-ready costs, then calculate NOI, NOI per bed and yield on cost with a sensitivity grid and a chart.
Lessons
- Unit Mix: Studios, Twins and Clusters, Beds and Rent per Bed Pro
- Bed vs Unit Occupancy: Occupied Beds, Fully Let Units and Empty-Bed Rent Pro
- Academic-Year Tenancies: 44- and 51-Week Contracts, Instalments & Summer Gaps Pro
- Pre-Leasing Pace: Beds Signed vs Prior Year and the Target Curve Pro
- Summer Income: Short Stays in the Gap Weeks Pro
- All-Inclusive Rents: Utilities, Internet & Cleaning per Bed and the Margin Left Pro
- Turnover: Make-Ready Cost per Bed, Days to Re-Let & Annual Turnover Cost Pro
- NOI per Bed & Yield on Cost: Income, Costs, Sensitivity and the Chart Pro