Real Estate - Student Accommodation Acquisition Pro-forma (Excel XLSX)

BENEFITS OF THIS EXCEL DOCUMENT

1. This Excel template is an intuitive and comprehensive solution tailored for evaluating the financial viability of Student Accommodation investments

REAL ESTATE EXCEL DESCRIPTION

Real Estate - Student Accommodation Acquisition Pro-forma is an Excel template (XLSX) available for immediate download upon purchase.

A dynamic, institutional-grade Excel proforma built specifically for Purpose-Built Student Accommodation (PBSA) acquisitions, value-add repositioning, and structured equity deals. The model runs monthly and annual projections across a ten-year hold period, covering everything from day-one acquisition through renovation, lease-up, debt structuring, and exit – all driven from a single Input sheet.

Model Features:

•  Dynamic Cash Flow Analysis: The model delivers both monthly and annual cash flow projections, enabling users to assess acquisition feasibility, track the impact of renovation and lease-up, and project operational performance across a ten-year hold. Key investment metrics – including unlevered IRR, levered IRR, equity multiple, and cash-on-cash return – are presented for every exit year from Year 1 to Year 10, giving investors a complete picture of the deal at any point in the hold period.

•  Academic-Year Lease Logic: Unlike generic multifamily models, this proforma incorporates PBSA-specific lease mechanics, including an August roll flag, lease-year indexing, and bed-level rent schedules by room type – Cluster Standard, Cluster Premium, Ensuite, and Studio. Occupancy ramps from an initial level to stabilised occupancy over a configurable lease-up period, with preleasing targets and lease downtime assumptions built in.

-Renovation Budget with Monthly Phasing: The model integrates a detailed renovation budget organised by category – common areas, room and bed space upgrades, FF&E, and other works. Users define a total capex amount, start month, and end month for each category, and the model automatically distributes the spend on a monthly basis, feeding directly into the cash flow and debt sizing calculations.

•  Debt Financing Options: The model includes three fully customisable debt tranches, each modelled monthly with interest, amortisation, and payoff tracking:
•  Senior Bridge Loan: A floating-rate acquisition loan linked to a 120-month SOFR forward curve, with configurable spread, IO period, amortisation, LTV, LTC, and term.
•  Mezzanine Loan: A subordinate loan sized against a capex LTC constraint, with separate cash pay and PIK rate inputs, offering flexible financing for the renovation phase.
•  Permanent Refinance: A fixed or floating rate term loan that replaces the bridge at a configurable refi month, automatically sized against LTV, DSCR, and debt yield constraints simultaneously, with the binding constraint flagged in the model.

•  Capital Stack and Working Capital: The model follows industry-standard capital stack sequencing – equity first, then mezzanine, then senior debt. Users can establish a working capital reserve at acquisition and set a minimum balance and distribution month, ensuring sufficient liquidity through the initial ownership and renovation phase.

•  Equity Waterfall Analysis: A fully configurable LP/GP equity waterfall distributes cash flows across three promote tiers, with separate preferred return hurdles and GP/LP split percentages at each tier. Monthly accrual, annual roll-up, and exit distribution are all automatically reconciled, and the model confirms that every tier is cleared by exit.

•  Scenario Engine: Three scenarios – Base, Weak, and a custom case – are toggled from a single cell on the Input sheet. Rent growth factor, physical vacancy delta, exit cap rate delta, and initial occupancy are all scenario-driven, enabling instant downside sensitivity without rebuilding the model.

•  Automated Model Checks: Twelve live integrity checks verify that sources equal uses at close, all three loans are paid off by exit, monthly cash flows reconcile to annual totals, and all waterfall tiers are cleared. Any inconsistency displays an ERROR flag, ensuring the model is investment-committee-ready before it is shared.

Instructions for Use:

•  Data Entry: Input data only into cells with blue text on the Input sheet. Black text indicates formula cells that should not be altered. The model is fully formula-driven – no macros or add-ins are required.

•  Sample Data: The template is pre-populated with a sample PBSA deal for demonstration purposes. Replace all blue-cell inputs with actual property data before analysing a specific acquisition.

•  Investment Summary: The Summary sheet provides a full deal snapshot, including sources and uses, property details, a hold/sell return matrix, cash-on-cash by year, and an IC Snapshot panel covering going-in yield, stabilised yield on cost, exit gross value, exit price per bed, peak debt, and peak LTC.

•  Renovation Budgeting: Allocate capex across categories on the Reno Budget sheet, defining a total amount, start month, and end month for each line item. Ensure the grand total reconciles to the All-In Capex input on the Input sheet – the Checks sheet will flag any discrepancy.

•  Debt Configuration: Set up each loan tranche in the Financing section of the Input sheet. Enable or disable the mezzanine and permanent refinance independently. The model sizes the permanent loan automatically and displays which constraint – LTV, DSCR, or debt yield – is binding.

•  SOFR Curve: Update the SOFR sheet with your own 120-month rate forecast if desired. Month 0 corresponds to the acquisition date. The senior bridge loan references this table automatically by month index.

•  Time Frame: The model supports a maximum hold period of 120 months (ten years), with monthly granularity throughout. The Summary sheet presents return profiles for every exit year regardless of the configured hold period.

By combining PBSA-specific lease logic, a three-tranche debt stack, a tiered LP/GP waterfall, and a single-sheet input architecture, this financial model gives investors, analysts, and advisors everything needed to underwrite, stress-test, and present a student accommodation deal with institutional precision.

Source: Best Practices in Real Estate, Integrated Financial Model Excel: Real Estate - Student Accommodation Acquisition Pro-forma Excel (XLSX) Spreadsheet, Jair Almeida