Pro Forma Underwriting Engine for Real Estate Development
Build institutional-grade real estate development pro formas with IRR, sensitivity analysis, and ...
What You Can Do
You can construct rigorous development pro formas that model complex project dynamics—construction budgets, phased timelines, pre-leasing velocity, financing structures, and market assumptions—then run sensitivity analysis to show how changes in rent, construction costs, or hold periods impact returns. This skill produces defensible investment theses suitable for LP presentations, lender submissions, and institutional review committees by capturing interdependencies that simple models miss.
Features
phase in hard costs, soft costs, and carrying costs aligned to construction schedules and pre-leasing milestones
model construction loans, permanent financing, mezzanine debt, and equity waterfall to assess leverage impacts on returns
automatically compute investor returns based on cash flows, exit assumptions, and capital structures
stress-test assumptions (rental rates, construction costs, lease-up rates, interest rates) to identify deal drivers and risks
underwrite multi-phase projects with staggered revenue recognition and cost schedules
model NOI, expense escalation, vacancy rates, and lease-up curves specific to property type and market
evaluate hold periods, stabilization timing, and cap-rate assumptions on sale value and investor returns
build realistic construction budget contingencies and cost escalation curves by trade
Example Output
Example 1: Apartment Development Pro Forma
- Project: 250-unit mixed-income multifamily, 24-month construction
- Output: 10-year cash flow projection showing Phase 1 lease-up (months 25–36), Phase 2 stabilization (year 3), permanent loan closing (month 28), IRR of 18.5% at 5.5% exit cap rate, 2.8x equity multiple
- Sensitivity Table: Shows IRR ranging from 14.2% to 22.1% as market rent assumptions vary ±10%
Example 2: Office Redevelopment Underwriting
- Project: Class B to Class A conversion, 18-month construction, $2.1M total costs
- Output: Construction loan drawdown schedule, debt service coverage ratio during stabilization (1.35x), financing structure (60% LTV construction, 55% permanent), pro forma NOI of $1.8M at year 5, 1.95x equity multiple
- Sensitivity Table: Risk matrix showing impact of 100–300 bps interest rate movement and 10–20% lease-up delays on returns
Example 3: Mixed-Use Phase Development
- Project: Retail + residential, 3 phases over 36 months
- Output: Blended IRR 16.8%, per-phase cash flow waterfall, retail lease-up curve vs. residential pre-leasing dynamics, construction loan interest capitalization, permanent financing refinance assumptions post-stabilization
What's Included
- SKILL.md instruction file: step-by-step framework for building development pro formas
- Pro Forma Template: Excel-ready cash flow model structure with construction timeline, hard/soft cost schedules, and financing integration
- Sensitivity Analysis Checklist: key variables to stress-test (rents, costs, rates, lease-up curves) and interpretation guidelines
- Debt Structure Worksheet: construction loan, permanent financing, mezzanine, and equity waterfall calculator
- Development Assumptions Framework: market-rent curves, expense escalation, vacancy assumptions, and lease-up velocity benchmarks by property type
Who It's For
- Real estate investment analysts — underwriting development deals for institutional investors, family offices, and REITs
- Development partners and sponsors — validating internal pro formas and preparing investment memos for equity partners
- Commercial real estate lenders — assessing feasibility, debt service capacity, and loan-to-value ratios on construction financing
- Private equity investors — evaluating development opportunities and comparing project returns across portfolios
- Asset and portfolio managers — stress-testing development pro formas and modeling exit scenarios under different market conditions
Best For
- Ground-up development underwriting — apartments, office, retail, mixed-use, industrial projects with 18–60 month timelines
- Major redevelopment and conversion analysis — repositioning Class B to Class A, adaptive reuse, and value-add rehab projects
- Phased project modeling — analyzing staggered revenue recognition, cost schedules, and returns across multiple release dates
- Construction financing and permanent loan structuring — debt service coverage, drawdown schedules, and refinancing assumptions
- Sensitivity and scenario analysis — stress-testing market assumptions, construction risks, and market timing on equity returns
- Institutional investment presentations — building defensible pro formas for LP meetings, lender submissions, and board reviews
You might also like
You can decompose complex investment theses into measurable components, stress-test narrative consistency against market scenarios, and identify logical gaps or metric blind spots before committing capital. This framework separates fundamental thesis soundness from market timing risk, helping you distinguish between theses that are broken versus theses that are correct but prematurely positioned.
by fission
You can rapidly assemble institutional-grade ESG and impact reports by integrating quantitative metrics, qualitative narratives, materiality assessments, and third-party validations across multiple frameworks (GRI, SASB, TCFD, ISSB, SDG). The skill reduces report production timelines from weeks to days while ensuring consistency, regulatory alignment, and stakeholder credibility—whether you're preparing standalone sustainability reports, due diligence data rooms, investor fact books, or fund impact disclosures.
by fission
You can rapidly value complex structured notes, convertibles, and equity-linked instruments by breaking them into vanilla bonds and embedded derivatives. The skill guides you through scenario analysis, sensitivity testing, and credit spread modeling to identify secondary market mispricings, calculate Greeks, and stress-test barrier knockouts or coupon adjustments. Output includes fair value estimates, comparable valuation matrices, and hedge recommendations defensible to traders and risk committees.
by fission
You can systematically evaluate real estate acquisition opportunities by inputting property financials, market data, and deal terms into a standardized framework. The skill analyzes cap rates, cash flow projections, market fundamentals, and risk factors to generate consistent, comparable metrics across multiple deals. This enables you to quickly identify investment-worthy opportunities versus deals that fail fundamental criteria, while documenting your investment thesis for compliance and portfolio tracking.
by fission
You'll architect backtesting systems that separate genuinely profitable strategies from curve-fitted fantasies. The skill guides you through modeling realistic market microstructure, accounting for transaction costs, detecting survivorship bias, and stress-testing strategies across regime changes. You'll implement walk-forward validation, out-of-sample testing, and Monte Carlo simulations to predict actual live performance and identify where backtest results diverge from real trading outcomes.
by fission
You can systematically analyze option fair value against market quotes, assess Greeks exposure across multi-leg strategies, evaluate implied volatility term structures and skew patterns, and determine optimal hedge ratios for underlying exposures. This skill bridges theoretical pricing models with actionable trading decisions by incorporating market microstructure, counterparty credit considerations, and execution feasibility into your analysis.
by fission
You can rapidly evaluate multiple financing structures for M&A, recapitalizations, and growth transactions by modeling different capital stack configurations and comparing them against recent comparable transaction benchmarks. The skill helps you assess debt capacity, analyze covenant headroom across downside scenarios, and stress-test leverage under EBITDA decline, capex disruption, and refinancing risk—enabling you to present optimized structures that balance cost of capital, covenant flexibility, and stakeholder requirements in client presentations and pitch books.
by fission
You can rapidly decompose multi-year financial statements to distinguish between legitimate business performance and accounting manipulation or one-time distortions. This skill helps you identify suspicious patterns in working capital trends, revenue recognition timing, asset impairment practices, and cash flow divergence from reported profits—enabling you to validate investment theses with forensic rigor and reduce the risk of catastrophic research errors.
by fission