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 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 map individual holdings against multiple thematic investment frameworks simultaneously, generating transparency-rich alignment scores that reveal true thematic exposure. Unlike traditional ESG screening, this skill identifies positive exposure to specific trends and solutions, helping you track portfolio concentration within thematic segments, detect misaligned holdings, and quantify drift from stated investment mandates with measurable impact metrics.
by fission
You can conduct rigorous competitive positioning analysis for SaaS companies by mapping competitors across pricing architecture, target buyer personas, feature differentiation, go-to-market efficiency, and retention dynamics. This skill transforms raw competitive data into structured frameworks that identify sustainable competitive advantages, market share vulnerabilities, and valuation implications—helping you differentiate your research thesis from consensus and reduce confirmation bias in your coverage.
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 systematically evaluate corporate bond issuers by synthesizing quantitative metrics (leverage ratios, cash flow coverage, liquidity), qualitative factors (management quality, competitive positioning, covenant protections), and market signals (credit spreads, relative value) into a cohesive credit opinion. This framework enables you to construct ratings that withstand peer review, document credit theses for investment committees, and respond to market events with quantified analytical support.
by fission
You can ingest multi-property portfolio data and generate comprehensive financial diagnostics, including performance metrics, peer benchmarking, concentration risk analysis, and stress-test scenarios across economic conditions. Claude systematizes the analysis of 10-500+ heterogeneous assets (varying property types, leverage, lease structures, and markets) to identify underperformers, quantify rebalancing impact, and deliver executive summaries with specific buy/sell/hold recommendations backed by financial modeling.
by fission
You can systematically decompose portfolio returns to isolate alpha (manager skill) from beta (passive market exposure) and identify which specific positions, sectors, or factor exposures drove performance. The skill enables rigorous performance attribution across multiple timeframes, generates risk-adjusted performance metrics (Information Ratio, Sharpe ratio, CAPM alpha), and produces institutional-grade client reporting with statistical rigor to support manager evaluation and capital allocation decisions.
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