Student Housing Model - PBSA Beds, Rent, NOI, DSCR & Equity Multiple (Excel)

Description
Underwrite purpose-built student accommodation with confidence. The Student Housing Model is an institutional-grade Excel model built to a rigorous value framework used by professional investors and advisors. It builds beds, occupancy, rent, operating costs, NOI, senior debt with DSCR and an equity multiple, in a clean, formula-driven workbook you can open and use in minutes. It is fully documented and auditable, ready to drop into a data room or an investment committee pack.


Every model is scenario-driven (a single switch flexes Base, Upside and Downside), reorganised where relevant into NOPLAT, invested capital and ROIC so you can see the return on capital against the cost of capital and the economic profit created, and independently verified through a live Checks dashboard that reads MODEL OK with zero formula errors. An executive dashboard summarises the headline results and charts at a glance, so the story is clear before anyone opens a single formula.


What you get: a protected, formula-driven Excel workbook (no macros), a scenario manager, the full model build, a Sources and Audit tab, a live Checks dashboard, an executive dashboard, and a plain-English documentation guide. Single-seat commercial licence. Default inputs are illustrative and ready to replace with your own numbers. No fluff, no locked black boxes: clear structure, honest assumptions, and a model you can defend in front of an investor, lender or board.