Real Estate Acquisition Underwriting
Analyze and underwrite real estate acquisitions with institutional-grade rigor.
What You Can Do
You can model acquisition deals, calculate key investment metrics, assess property valuations, and generate investment-grade underwriting summaries. Claude analyzes purchase price, operating expenses, market comparables, and risk factors to produce deal memos that support acquisition committees and lender requirements. You get institutional-quality financial analysis in minutes, not days.
Features
Automatically calculates cap rate, cash-on-cash return, IRR, NOI, debt service coverage ratio, and other standard metrics from property and financing data.
Evaluates subject property against comparable sales and rentals in the market, adjusting for location, condition, amenities, and time on market.
Applies income, sales comparison, and cost approaches to estimate fair market value and identify basis risk.
Identifies property-specific, market, financing, and execution risks with probability scores and mitigation strategies.
Produces executive summaries with key findings, investment thesis, red flags, and recommendation for internal stakeholders or lenders.
Tests how changes in assumptions (cap rate, rental income, expense growth, interest rates) impact returns and decision thresholds.
Models debt-to-value, loan-to-cost, debt service coverage under different financing scenarios and lender requirements.
Example Output
Example 1: Multifamily Property Underwriting
Property: 120-unit Class B apartment complex, $8.5M asking price
Key Metrics:
- Cap Rate: 6.2%
- Cash-on-Cash (Year 1): 7.1%
- Debt Service Coverage Ratio: 1.28x
- IRR (5-year hold): 12.3%
- Loan-to-Value: 75%
Recommendation: Proceed with offer. Market comps support $8.3-8.7M valuation. Financing terms favorable. Primary risk: occupancy decline if local employment contracts.
Example 2: Commercial Retail Space Deal Analysis
Property: 15,000 sq ft shopping center strip, $2.1M purchase price
Valuation Summary:
- Income Approach: $2.05M (8.1% cap rate)
- Market Approach: $2.08M (avg $140/sq ft)
- Basis Risk: -2% vs asking price ✓ acceptable
Issues Flagged:
- ⚠️ Anchor tenant lease expires in 2 years
- ⚠️ Property taxes rose 12% last cycle
- ✓ Strong foot traffic from adjacent development
Example 3: Value-Add Office Conversion
Sensitivity Table (IRR impact from key variables):
| Scenario | Rental Rate | Expense Growth | IRR |
|---|---|---|---|
| Base Case | $28/sq ft | 3% | 11.5% |
| Downside | $26/sq ft | 4% | 8.2% |
| Upside | $30/sq ft | 2% | 14.8% |
What's Included
- Financial Modeling Templates: Pre-built spreadsheet logic for residential, commercial, industrial, and mixed-use properties with industry-standard line items.
- Metric Calculation Engine: Automated formulas for IRR, cap rate, DSCR, cash-on-cash, equity multiple, and leverage metrics from raw property data.
- Comparable Analysis Framework: Step-by-step methodology to identify comparable properties, normalize adjustments, and triangulate fair market value.
- Risk Assessment Checklist: Comprehensive framework covering property condition, market cycle, financing, tenant quality, regulatory, and execution risks.
- Deal Memo Format: Professional templates for executive summary, investment highlights, financial analysis, risks, and recommendation sections.
- Example Analyses: Complete worked examples for multifamily, office, retail, and industrial acquisitions at different price points and hold strategies.
Who It's For
- Real Estate Investment Managers
- Acquisition Officers and Deal Leads
- Commercial Real Estate Analysts
- Private Equity / Real Estate Fund Managers
- Commercial Lenders and Credit Officers
Best For
- Rapid deal screening and go/no-go decisions
- Investment committee presentations and memos
- Lender credit memorandum preparation
- Comparative analysis of competing acquisition opportunities
- Sensitivity stress-testing under different market scenarios
You might also like
Transform raw feature analytics into clear, actionable insights by analyzing engagement patterns, identifying performance trends, and synthesizing recommendations. You can compare feature performance across segments, detect anomalies, and generate reports that guide product decisions with data-backed confidence. This skill automates the heavy lifting of analytics interpretation so you focus on strategy.
Use Claude to generate comprehensive technical documentation for APIs, services, and libraries while enforcing consistency across hundreds of pages. You can audit existing docs against your style guide and best practices, then restructure the navigation for better developer discoverability. This skill transforms documentation from a maintenance burden into a scalable, developer-first asset that stays current as your product evolves.
Transform raw market data into professional investment analyses and trend forecasts. This toolkit synthesizes comparable sales, market trends, and risk factors into structured opportunity evaluations using proven real estate investment frameworks. Generate investment-grade reports, identify high-potential markets, and make data-backed property acquisition decisions with confidence.
You provide Claude with your component requirements, design tokens, and accessibility needs, and it generates comprehensive, production-ready component specifications. The skill produces detailed documentation including prop tables, variant documentation, implementation examples, and accessibility guidelines—everything your design system needs to stay consistent and maintainable at scale.
This skill helps you structure and validate residential appraisal reports that meet USPAP (Uniform Standards of Professional Appraisal Practice) requirements. You can quickly organize comparable sales data, run valuation reconciliation, and document your analysis in a format ready for compliance review. It accelerates report generation while ensuring every section meets regulatory standards.
Increase bookings by 15-35% and revenue by 20-50% through AI-powered competitive pricing, seasonal demand forecasting, and listing optimization. Get exact nightly rate recommendations, identify content gaps costing you bookings, and predict occupancy patterns weeks in advance so you can price with confidence.
You get a comprehensive feasibility analysis that combines market demand research, regulatory constraint assessment, financial modeling, and timeline evaluation. The skill produces professional-grade reports quantifying opportunity cost, identifying regulatory barriers, projecting ROI scenarios, and highlighting key risks—giving you confidence to greenlight or pass on development opportunities. Use it to validate assumptions before land acquisition, secure financing, or present deals to stakeholders.
Create comprehensive metric definition frameworks that directly align your product metrics with business objectives and ensure consistent measurement practices across teams. You'll develop standardized metric definitions with clear calculation methodologies, success criteria, and governance structures that reduce measurement inconsistency. The result is a shared organizational language around metrics that enables confident data-driven decision making.