Student Housing Development ModelFree Financial Model Download

Name: Student Housing Development Model
Brand: Finamodel
Availability: InStock

Model student housing development including lease-up risk, operating margins, and exit valuation so you see the true development return, not pro forma day-one value. Covers land cost through stabilized NOI and exit cap rate sensitivity.

Download Get a custom model

Free download. No sign-up required.

About this model

Model student housing development including lease-up risk, operating margins, and exit valuation so you see the true development return, not pro forma day-one value. The model spans 2-year construction and 10-year operating hold. Revenue is all rental income: academic lets (44 weeks per year at 90-98% occupancy) and summer lets (8 weeks at 55-65% of academic rent, 60% occupancy). Revenue grows 3-5% annually. Operating expenses (29% of gross revenue at stabilisation) include management fee (5%), utilities (7%, split fixed/variable), maintenance, insurance, business rates, and staffing.

Development cost is £85,000/bed (land, construction, fees, contingency) plus capitalised interest (£1.1M on a £17.5M debt draw over 2 years). Debt is senior (55% LTV, 6.5%, 25-year amortisation). The model calculates NOI yield-on-cost (NOI Y3 / total development cost) and compares to exit cap rate (5.25%) to show development spread—the return for bearing construction and lease-up risk. DSCR is typically 1.25-1.45x in stabilised years; Yield on Cost targets 14-18% equity IRR for institutional sponsors. Checks ensure bed count sums (322 en-suite + 28 studio = 350), utilities scale correctly with occupancy, and exit value uses forward NOI (Year 11 annualised NOI / cap rate).

Essential for student housing developers, pension fund allocators (e.g., CPPIB, GIC), and REITs evaluating regional UK acquisition vs development. Includes utility cost inflation and weekly vs monthly rent payment cycles.

income_statement.xlsx

Recolor to your brand.
Formatted to IB standards.

Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with blue inputs, black formulas, and green cross-sheet links.

Brand-ready
Institutional grade
Fully auditable

What's included

Land acquisition and development costs
Construction period and carrying cost
Lease-up assumptions and occupancy ramp curve
Rental rate assumptions by bed type and location
Stabilized NOI and exit valuation scenarios

Lease-up timing and dynamics

Realistic lease-up curves show the 12-24 month ramp from 30% to 90%+ stabilized occupancy, which is where most development return risk actually sits.

Bed type and density optimization

2, 3, and 4-bed units are modeled separately so you can optimize density and revenue per bed across the unit mix.

Exit valuation and cap rate sensitivity

Stabilized cap rate, exit multiple, and equity return are all shown under different stabilization assumptions so you can see how much the exit depends on lease-up execution.

Frequently asked

What is stabilized occupancy for student housing?+

Stabilized occupancy is typically 85-95% depending on supply competition and university size. Reaching stabilization generally takes 12-24 months from opening.

What are typical student housing rents per bed?+

Rents range from $500 to $1,500 per month per bed depending on location and amenities. Premium off-campus housing commands 15-25% premiums over basic options.

What cap rate should I use for student housing?+

Stabilized student housing yields 4-7% cap rates depending on location and university stability. University-dependent demand commands lower cap rates due to revenue predictability.

How does construction period financing affect returns?+

Carrying costs during the construction period and lease-up phase are a meaningful drag on equity returns. The model sizes construction loans, permanent debt, and required reserves explicitly.

Who uses student housing development models?+

Developers, real estate equity sponsors, lenders sizing construction and permanent debt, and investors underwriting development risk all use this type of model.