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 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
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 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 can systematically evaluate consumer companies' competitive defensibility, pricing sustainability, and vulnerability to disruption. This skill helps you differentiate between companies with durable moats and those facing margin compression, translating qualitative competitive assessments into investable theses that support valuation spreads and sector rotation decisions.
by fission
You'll create structured screening matrices with weighted criteria, threshold rules, and exclusion logic that systematically evaluate companies against your fund's ESG thesis. Build transparent decision trees that handle conflicting metrics, materiality variations, and geographic nuances—enabling you to evaluate 100+ candidates consistently while maintaining defensible audit trails for stakeholders, LPs, and regulators.
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