PBSA Financial Modelling in Excel
This course teaches participants how to confidently build, analyse, and stress‑test financial models for Purpose-Built Student Accommodation (PBSA). You’ll learn how PBSA assets generate value, how income and costs behave differently from other real estate types, and how to correctly model cash flows, debt, and investment returns. The training also highlights common modelling mistakes unique to PBSA and shows how to avoid them
Across two days, the course covers both foundational and advanced skills: from understanding PBSA as an asset class and constructing a basic cash flow model, to analysing revenue drivers, operating costs, development risk, lender covenants, and feasibility metrics. Real case studies reinforce how to evaluate stabilised assets and development opportunities using IRR, NPV, sensitivities, and scenario analysis.
On this course you will:
- Build and interrogate PBSA financial models with confidence
- Understand how PBSA value is created, protected, and destroyed
- Correctly model income, costs, debt, and cash flow timing specific to student housing
- Avoid common modelling and underwriting pitfalls unique to PBSA
Who is this course for?
- Real Estate Investment & Finance Professionals
- Investment analysts, associates, and managers Fund managers and investment committee members
- Portfolio managers evaluating PBSA allocations
- PBSA operators needing to understand financial drivers
- Graduates or career switchers entering real estate modelling
Course Outline
Foundations of PBSA Investment & Cash Flow Modelling
Introduction to PBSA as an Asset Class
- What makes PBSA distinct within real estate
- PBSA vs traditional commercial real estate vs residential
- Operating business vs financial yield asset
- Overview of UK market structure and typical deal types (core, core-plus, value-add, development)
How PBSA Creates Value
Sources of return in PBSA:
- Income growth
- Operational optimisation
- Exit pricing
- Why PBSA returns differ from offices, logistics, and PRS
- Case examples of value creation and value destruction
Financial Mathematics & Time Value of Money (Applied)
- Discounting and compounding in real estate models
- IRR vs NPV: when each metric matters
- Equity multiple vs cash-on-cash returns
- Common interpretation mistakes
Building a Basic PBSA Cash Flow Model
- Model architecture and Excel best practice
Setting up:
- Rental income
- Operating costs
- Net Operating Income (NOI)
- Cash flow to equity
- Annual vs monthly modelling trade-offs
Key Performance Metrics in Practice
- IRR, NPV, Equity Multiple, Cash-on-Cash
- How leverage affects each metric
- Why IRR alone is misleading in PBSA
- Introduction to downside and sensitivity thinking
Modelling Debt & Lender Constraints
- Common PBSA financing structures
- Interest-only vs amortising loans
- DSCR, LTV, and covenant mechanics
Case Study — Stabilised PBSA Cash Flow
Advanced PBSA Modelling: Income, Risk, and Real-World Complexity
PBSA Income Architecture: What Actually Drives Revenue
- Deconstructing PBSA revenue: Rent × beds × occupancy × pricing × voids
- Unit mix economics: Studios vs en-suites vs shared
- Demand security: Nomination, Master leases, University partnerships
PBSA Cost Modelling: From Flat %s to Operational Reality
- Fixed vs semi-fixed vs variable costs in PBSA
- Staffing models and scale effects
- Utilities and inflation pass-through
- Maintenance vs lifecycle capex
- Cost timing mismatches vs revenue timing
Straight-Lining Revenue: Accounting Logic vs Commercial Reality
- Why straight-lining exists (IFRS / UK GAAP perspective)
- Daily accrual
- Weekly accrual
- Term-based smoothing
- Balance sheet
Rent Collection Models in UK PBSA
PBSA Development Modelling: Risk, Timing, and Optionality
- PBSA development lifecycle
- Land
- Construction
- Lease-up
- Stabilisation
- Cost risk
Appraisal & Feasibility Techniques
- Residual land value analysis
- Sensitivity and scenario analysis
- Break-even rent and yield analysis
- Decision thresholds for go/no-go investment committees
Integrated Case Study — PBSA Development & Operation
Course Details
Number of days: Two days
Delivery: In-Person
Course type: Financial Modelling
Course level:
Recommended Pre-requisite: Real Estate Analyst
Upcoming Dates
- 7th & 8th May 2026
Course Schedule: Public Course Dates
Price Per Person
In-Person
- Course Delivery
- Course Manual
- Course Files
- CPD Accredited Certificate
- Online Learning Resources
- Financial Modelling Proficiency Badge
Are you currently studying?
How to Book
Course Bookings:
Jacob Noble
[email protected]
Course Delivery & Administration:
Emma Wilson
[email protected]
