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'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 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.
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'll construct sophisticated DCF models that treat each clinical asset as a branching probability tree, weighting revenue contributions by phase-specific success rates (Phase I: 30%, Phase II: 33%, Phase III: 25-30%, FDA approval: 80-90%). This approach replaces deterministic sales projections with realistic scenario ranges, enabling you to value pre-revenue or early-revenue biotechs by their pipeline potential, regulatory trajectory, and time-to-market dynamics. The skill guides you through setting risk-adjusted discount rates (10-15% above pharma majors) and conducting sensitivity analyses that institutional investors expect.
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 design and execute comprehensive ESG screening across equity and fixed income universes using customizable criteria, weighted scoring models, and tiered filtering processes. The framework converts mission-driven sustainability objectives into defensible, repeatable, auditable screening methodologies that integrate both negative screens (exclusions) and positive screens (inclusions/preferences), eliminating unsuitable candidates and prioritizing those warranting further due diligence.
by fission
You can systematically analyze complex alternative fund portfolios by decomposing returns into alpha, beta, and fee components, then benchmark manager performance against peers. The skill processes manager letters, fund documents, and performance data to identify risk sources, flag operational red flags, and generate standardized due diligence matrices that support investment committee decisions across hedge funds, private equity, infrastructure, and real assets.
by fission