Real Estate Deal Analysis Framework for Acquisitions
Systematically evaluate real estate acquisitions with financial metrics and risk analysis
What You Can Do
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.
Features
calculates IRR, cash-on-cash returns, cap rates, debt service coverage ratio, and stress-tested pro forma scenarios
assesses supply/demand dynamics, rent growth trends, absorption rates, and competitive positioning by submarket
identifies and scores acquisition risks including financing, market, operational, tenant, and sponsor execution risks
generates standardized metrics across multiple properties and markets for objective side-by-side comparison
property-specific checklist covering title, environmental, structural, tenant quality, and lease documentation review items
structures analysis outputs with executive summary, key assumptions, sensitivity tables, and recommendation sections
models deal performance under downside scenarios (rent decline, higher cap rates, vacancy increases)
creates consistent records of investment thesis, decision rationale, and assumptions for portfolio monitoring
Example Output
Example 1: Office Building in Secondary Market
Key Metrics:
- Current Cap Rate: 5.2% | Stabilized Cap Rate: 6.1%
- Cash-on-Cash Return: 12.3% (Year 1) | 5-Year IRR: 14.7%
- Debt Service Coverage Ratio: 1.32x
- Investment Required: $8.5M equity (40% of purchase price)
Market Assessment: Submarket experiencing 2.1% annual rent growth, 88% occupied with 1.2 years of supply. Office sector headwinds justify 150bps rent growth discount vs. historical 3.2% trend.
Risk Score: 6.8/10 (Moderate Risk)
- Financing Risk: 4/10 (Fixed-rate CMBS available, rates 4.85%)
- Market Risk: 7/10 (Sector headwinds, 15% tenant concentration)
- Sponsor Risk: 5/10 (Experienced team, completed 12 similar deals)
- Recommendation: PROCEED to LOI — meets hurdle rates with acceptable risk profile if rent growth assumption validated.
Example 2: Industrial Warehouse, Core Market
Key Metrics:
- Current Cap Rate: 4.8% | Year 3 Cap Rate: 5.4%
- Cash-on-Cash Return: 8.2% (Year 1) | 5-Year IRR: 9.1%
- DSCR: 1.28x under stressed occupancy (92% vs. 96% pro forma)
Risk Score: 4.2/10 (Low-Moderate Risk) Industrial fundamentals strong (sub-3% vacancy, +3.5% rent growth), long-term tenant (7 years remaining on 10-year lease), triple-net structure protects against operational risk.
Recommendation: PROCEED with caution — returns below 10% hurdle rate; viable only if rent growth acceleration likely or portfolio requires core stabilized cash flow.
What's Included
- SKILL.md instruction file with complete deal analysis framework:
- Deal Analysis Template (Excel or Google Sheets) with pre-built financial model tabs:
- Risk Assessment Scorecard for standardized risk factor evaluation and scoring:
- Market Research Checklist: 35-point checklist for submarket and competitive analysis
- Due Diligence Tracker: document review checklist covering title, environmental, tenant, and structural items
- Investment Committee Presentation Outline: structured format with assumption summary, sensitivity analysis, and recommendation sections
Who It's For
- Real estate acquisition analysts evaluating 5-50 deals annually for investment funds or operating companies
- Investment committee members requiring standardized metrics and consistent decision documentation
- Portfolio managers comparing acquisition opportunities across different markets and asset classes
- Underwriters for institutional real estate sponsors evaluating acquisition pipeline
- Commercial mortgage brokers structuring deal packages with consistent financial metrics for lender submission
Best For
- Initial acquisition screening and comparative deal analysis
- Pro forma modeling and financial underwriting for institutional-grade deals
- Investment thesis documentation and go/no-go decision support
- Risk quantification and stress-testing before LOI or purchase contract execution
- Investment committee presentation preparation with standardized metrics and assumptions
You might also like
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 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 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.
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 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 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