Institutional Multi-Phase Master-Plan Development Pro Forma Model

The Institutional Multi-Phase Master-Plan Development Pro Forma Model is an institutional-grade financial engine designed specifically for master-planned, multi-building real estate developments.

Underwriting multi-phase developments requires tracking overlapping construction curves, prorating shared infrastructure costs, sizing per-phase debt, and recycling capital from early building sales into later phases. This model automates all phase interactions into a unified executive dashboard.

Key Financial Features & Mechanics

• Phase-by-Phase Timing Engine: Independently schedule construction start dates, completion milestones, lease-up absorption, and disposition dates for each building in the master plan.
  

• Prorated Infrastructure & Land Cost Allocation: Automatically allocates shared land purchase costs, sitework, and horizontal infrastructure across individual building budgets on an RSF or land-area basis.
  

• Iterative Construction Draw Engine: Capitalizes construction interest per phase dynamically based on monthly expenditure curves.
  

• Building-Level Sell-Down & Capital Recycling: Tracks individual building dispositions and calculates net cash proceeds available for debt paydown or equity distributions.
  

• Blended JV Equity Waterfall: Consolidates multi-year phased cash flows into a 4-tier joint venture equity waterfall with preferred return hurdles and GP promote splits.
  

• Sensitivity & Scenario Analysis: Integrated matrix flex tables evaluating project IRR, sponsor margin, and equity multiples across cost overruns and exit cap shifts.
  
  

1. Fully Unlocked Excel Workbook (.xlsx): Zero password protection, no hidden VBA code, and completely transparent formulas.
   

2. Pre-Populated 1.675M RSF Baseline Master Plan: Includes a live 4-building industrial park sample deal ("Prairie Gateway Logistics Park", ~$89.9M cost, ~31.2% IRR baseline).
   

3. PDF Quick-Start User Guide (.pdf): Concise instructions explaining model flow, input tabs, land proration, and circular calculation setup.