Real Estate Development Underwriting Framework
Analyze real estate development projects for financial viability and investment decision-making
What You Can Do
You can structure comprehensive development underwriting analyses that evaluate project feasibility, construction risks, market absorption, and financial returns. The skill helps you organize complex variables across multiple development scenarios, stress-test assumptions, and produce clear investment recommendations backed by rigorous financial modeling—transforming incomplete project information into actionable investment decisions.
Features
Example Output
Example 1: Mixed-Use Development Analysis
- Project: 250-unit residential + 15,000 SF retail on downtown infill
- Total Development Cost: $87.5M | Land: $12M | Construction: $65M | Soft Costs: $10.5M
- Projected Stabilization Year 3 | NOI: $4.2M at 5.5% cap rate
- Unleveraged IRR: 14.2% | Levered IRR (65% LTV): 18.7%
- Key Risks: Entitlement timeline (6 months risk), retail absorption (assumes 90% leased pre-delivery)
- Recommendation: Proceed with approval contingent on lease commitments for 60% retail
Example 2: Adaptive Reuse Comparison
- Scenario A (Residential): 80 units, $42M TDC, 12.3% IRR
- Scenario B (Mixed-Use): 60 units + 8,000 SF office, $45M TDC, 14.8% IRR
- Sensitivity: 10% construction cost overrun reduces IRR by 2.1% in Scenario A vs. 1.4% in Scenario B
- Conclusion: Scenario B offers better risk-adjusted returns despite higher basis
What's Included
- SKILL.md instruction file with development underwriting framework and risk assessment methodology:
- Pro forma template for phased development cash flows with construction and ramp periods:
- Financial analysis checklist covering assumptions, comparable benchmarking, and scenario modeling:
- Risk assessment framework for entitlement, construction, market, and execution risks:
- Deal summary template for investment memos and committee presentations:
Who It's For
- Real estate development analysts evaluating ground-up and value-add projects
- Investment committee members assessing development deal recommendations
- Development company CFOs and financial planners modeling project returns
- Real estate fund managers comparing multiple development opportunities
- Project managers seeking financial viability validation before execution
Best For
- Ground-up residential, mixed-use, industrial, and office developments
- Adaptive reuse and renovation projects with significant scope changes
- Comparative analysis across multiple development scenarios and sites
- IRR and equity multiple projections for leveraged development deals
- Project feasibility studies and investment committee presentations
- Sensitivity analysis and stress-testing of key development assumptions
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