{"product_id":"real-estate-mixed-use-multifamily-acquisition-proforma-copy","title":"Real Estate - Student Accommodation Acquisition Pro-forma","description":"\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003eA 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.\u003c\/p\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003e\u003cstrong\u003eModel Features:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"[li_\u0026amp;]:mb-0 [li_\u0026amp;]:mt-1 [li_\u0026amp;]:gap-1 [\u0026amp;:not(:last-child)_ul]:pb-1 [\u0026amp;:not(:last-child)_ol]:pb-1 list-disc flex flex-col gap-1 pl-8 mb-3\"\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eDynamic Cash Flow Analysis:\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eAcademic-Year Lease Logic:\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eRenovation Budget with Monthly Phasing:\u003c\/strong\u003e The model integrates a detailed renovation budget organised by category — common areas, room and bed space upgrades, FF\u0026amp;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.\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eDebt Financing Options:\u003c\/strong\u003e The model includes three fully customisable debt tranches, each modelled monthly with interest, amortisation, and payoff tracking:\n\u003cul class=\"[li_\u0026amp;]:mb-0 [li_\u0026amp;]:mt-1 [li_\u0026amp;]:gap-1 [\u0026amp;:not(:last-child)_ul]:pb-1 [\u0026amp;:not(:last-child)_ol]:pb-1 list-disc flex flex-col gap-1 pl-8 mb-3\"\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eSenior Bridge Loan:\u003c\/strong\u003e A floating-rate acquisition loan linked to a 120-month SOFR forward curve, with configurable spread, IO period, amortisation, LTV, LTC, and term.\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eMezzanine Loan:\u003c\/strong\u003e A subordinate loan sized against a capex LTC constraint, with separate cash pay and PIK rate inputs, offering flexible financing for the renovation phase.\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003ePermanent Refinance:\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eCapital Stack and Working Capital:\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eEquity Waterfall Analysis:\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eScenario Engine:\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eAutomated Model Checks:\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003e\u003cstrong\u003eInstructions for Use:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"[li_\u0026amp;]:mb-0 [li_\u0026amp;]:mt-1 [li_\u0026amp;]:gap-1 [\u0026amp;:not(:last-child)_ul]:pb-1 [\u0026amp;:not(:last-child)_ol]:pb-1 list-disc flex flex-col gap-1 pl-8 mb-3\"\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eData Entry:\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eSample Data:\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eInvestment Summary:\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eRenovation Budgeting:\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eDebt Configuration:\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eSOFR Curve:\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003cli class=\"whitespace-normal break-words pl-2\"\u003e\n\u003cstrong\u003eTime Frame:\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"font-claude-response-body break-words whitespace-normal leading-[1.7]\"\u003eBy 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.\u003c\/p\u003e","brand":"Bizz View","offers":[{"title":"Default Title","offer_id":51046938771762,"sku":null,"price":70.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0755\/2434\/2066\/files\/coverbizzview_48ab50bb-0aa2-4871-b610-87e289fa5858.png?v=1775609664","url":"https:\/\/bizz-view.com\/products\/real-estate-mixed-use-multifamily-acquisition-proforma-copy","provider":"Bizz View","version":"1.0","type":"link"}