Real Estate Acquisition Deal Underwriting
Underwrite real estate acquisitions with financial models, comps analysis & risk assessment
What You Can Do
You can rapidly evaluate potential real estate acquisitions by synthesizing financial data, market comparables, and risk factors into a structured underwriting analysis. This skill guides you through building defensible pro forma models, calculating investment returns, stress-testing assumptions, and comparing opportunities using standardized metrics—enabling you to present clear investment theses to underwriting committees and partners.
Features
Build 5-10 year financial projections with revenue, expense, and capital assumptions tailored to property type
Research and normalize market comps to establish fair market value and support pricing decisions
Compute IRR, equity multiple, cash-on-cash return, and cap rate to benchmark against investment criteria
Stress test assumptions (occupancy, rent growth, expense inflation, cap rate compression) to quantify downside risk
Generate executive summaries and investment committee materials that communicate valuation logic and key assumptions
Systematically surface deal-breaking risks (market, tenant, operational, regulatory) early in evaluation
Score and rank multiple deals against standardized criteria to prioritize pipeline activity
Example Output
Example 1: Class B Multifamily Pro Forma
- 150-unit acquisition at $18M purchase price
- 5-year hold model with 3% annual rent growth, 92% stabilized occupancy
- Year 1 NOI: $1.44M | Levered equity IRR: 18.2% | Equity multiple: 1.8x
- Downside scenario (2% rent growth, 88% occupancy): IRR drops to 12.4%
Example 2: Comparable Analysis Summary
- 8 recent comps analyzed; subject property valued at $22.50/sf vs. comp average $23.15/sf
- Market rent for Class B units: $1,650/mo.; subject at $1,600 shows 3% below-market opportunity
- Cap rate on comps: 5.2–5.8%; deal cap rate: 6.1% (above-market pricing risk identified)
Example 3: Risk Assessment
- Key risks ranked: tenant concentration (30% of NOI), interest rate refinance risk, below-market rent roll opportunity
- Recommended mitigants: lease diversification plan, floating rate hedging, rent growth acceleration timeline
What's Included
- SKILL.md: Core underwriting framework and structured workflow
- Pro forma template: Excel-ready revenue, expense, and capital model for multifamily, office, industrial, or retail
- Comparable analysis worksheet: Property attributes, rent/price per sf, cap rates, and valuation reconciliation
- Risk assessment checklist: Market, tenant, operational, and financial risk categories with mitigation strategies
- Investment committee summary template: Executive overview, valuation rationale, return assumptions, and risk disclosure
Who It's For
- Real Estate Investment Analysts evaluating acquisition opportunities and building underwriting memoranda
- Commercial Real Estate Investors comparing multiple deals to prioritize capital deployment
- Asset Management teams stress-testing assumptions and preparing investor reporting
- Development and Acquisitions Managers presenting deals to underwriting committees
- Debt/Equity Investors performing due diligence on third-party acquisition packages
Best For
- Multifamily, office, industrial, and retail acquisition underwriting
- Pro forma modeling with 5-10 year hold assumptions and return sensitivity analysis
- Market comparable research and valuation reconciliation
- Scenario modeling and risk identification for deal prioritization
- Investment committee materials and partner memos communicating investment thesis
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