Multifamily Underwriting & Investment Analysis
Analyze multifamily investments with institutional-grade underwriting and portfolio metrics
What You Can Do
Perform comprehensive financial analysis on multifamily acquisitions, from pro forma development to underwriting memoranda. Generate sensitivity analyses, cash flow projections, and investment metrics (IRR, CoC, NOI) that help you evaluate deal quality and portfolio performance. Create institutional-grade reports with rent rolls, expense breakdowns, and risk assessments for due diligence, lender presentations, or investor pitch decks.
Features
Build 5–10 year projections with revenue assumptions, operating expenses, capital expenditures, and NOI trending to forecast property cash flow performance.
Calculate IRR, cash-on-cash return, equity multiple, cap rate, debt service coverage ratio, and cash flow metrics to quantify deal returns.
Model impact of rate changes, occupancy shifts, and expense variations on returns with data tables showing how returns move with assumption changes.
Organize tenant data, project lease renewals, analyze unit type distribution, and identify pricing power and lease expiration risk.
Evaluate loan structures, refinancing options, prepayment penalties, and financing impact on DSCR and after-tax returns.
Identify key financial risks, stress test assumptions against market downturns, and model recession and occupancy loss scenarios.
Compare property metrics against market comps, peer portfolios, and investor return targets to assess deal merit.
Export professional underwriting memos with executive summaries, charts, tables, and lender-ready presentation formats.
Example Output
5-Year Pro Forma Summary
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|
| Potential Gross Income | $2,450,000 | $2,546,250 | $2,646,516 | $2,750,956 |
| Operating Expenses | $735,000 | $763,875 | $794,829 | $827,102 |
| NOI | $1,485,000 | $1,548,316 | $1,614,653 | $1,684,149 |
Key Investment Metrics
- Cap Rate: 4.95% (Year 1)
- Cash-on-Cash Return: 12.3% (Year 1)
- IRR: 18.7% (5-year hold)
- Equity Multiple: 2.15x
- DSCR: 1.24x
Sensitivity Analysis: IRR by Rent Growth & Occupancy
| Occupancy | 0% Growth | 2% Growth | 3% Growth |
|---|---|---|---|
| 92% | 15.2% | 16.8% | 17.9% |
| 95% | 16.4% | 18.7% | 19.8% |
| 98% | 17.6% | 20.1% | 21.4% |
What's Included
- Acquisition Analysis Framework: Standardized model for evaluating new deals with all key assumptions, valuation methods, and investment return scenarios.
- Cash Flow Projection Engine: Build detailed 5–10 year operating models with revenue escalation, expense management, and CapEx scheduling.
- Underwriting Metrics Suite: Complete set of investment performance calculations including IRR, cash-on-cash, equity multiple, cap rate, and DSCR.
- Sensitivity & Scenario Tools: Model impact of market shifts, rate changes, occupancy loss, and expense volatility on returns with dynamic tables.
- Rent Roll & Tenant Analysis: Track unit types, lease expirations by quarter, renewal economics, and below-market rent identification.
- Professional Report Templates: Pre-formatted underwriting memos, executive summaries, and lender packages ready for investment committee or bank presentations.
Who It's For
- Commercial Real Estate Investors
- Asset Managers & Portfolio Analysts
- Acquisition Managers & Deal Underwriters
- Multifamily Developers
- Lenders, Loan Servicers & Credit Analysts
Best For
- Pre-acquisition due diligence and deal underwriting
- Investment committee packages and lender presentations
- Portfolio performance tracking and quarterly reporting
- Refinance and disposition scenario modeling
- Investor pitch materials and LP fund performance analysis
You might also like
You can rapidly map your security controls to major regulatory frameworks (SOC 2, ISO 27001, GDPR, HIPAA, PCI-DSS), automatically identify compliance gaps, and generate audit-ready evidence packages. The skill analyzes your control inventory against framework requirements, flags missing or inadequate controls, and produces structured documentation that accelerates compliance reviews and audit preparation.
by nakano1122
You can systematically identify performance bottlenecks in your frontend application across React, Vue, and Angular frameworks. This skill analyzes your codebase for common anti-patterns, runtime behavior, and bundle metrics to pinpoint the slowest components and queries. You'll receive a data-driven optimization roadmap prioritized by impact and implementation effort, complete with specific code examples and effort estimates your team can execute immediately.
by nakano1122
Create comprehensive, multi-buyer auction marketing briefs that position commercial properties strategically for competitive bidding. The skill analyzes property characteristics, identifies institutional and individual buyer segments, and recommends reserve prices backed by market data and buyer psychology insights. You get ready-to-deploy marketing strategies, buyer persona briefs, and competitive positioning reports tailored to your specific property and timeline.
by nakano1122
Claude systematically analyzes production incidents to identify root causes, contributing factors, and systemic vulnerabilities in your infrastructure. You'll receive structured postmortems that guide your team through incident timelines, pinpoint what actually failed, and prioritize infrastructure improvements that prevent recurrence. The skill also detects patterns across your incident history—revealing repeated failures that point to deeper architectural weaknesses.
by nakano1122
You get immediate structured incident assessment and response coordination. Claude analyzes incident severity, impact scope, and escalation requirements—then generates decision trees, stakeholder communication templates, and post-incident review guides. This skill accelerates your response from triage through resolution to after-action review.
by nakano1122
You conduct systematic architecture reviews that identify technical risks, quantify their business impact, and prioritize technical debt for remediation. The framework generates risk matrices, compliance gap analyses, and actionable roadmaps with effort estimates—ideal for due diligence, modernization planning, or governance decision-making. You produce executive summaries that translate technical findings into business language for stakeholder alignment.
by nakano1122
You get a structured decision-making framework tailored to scale-ups navigating rapid growth. Claude helps you evaluate technical architecture choices, plan team scaling with hiring rubrics, prioritize technical debt against velocity demands, and craft engineering strategy communications for leadership. The framework balances short-term velocity with long-term maintainability.
by nakano1122
You can conduct comprehensive architecture reviews that systematically evaluate your platform's design decisions, infrastructure choices, and technical debt. This framework helps you identify performance bottlenecks, scalability constraints, cost inefficiencies, and technology risks—then generates actionable improvement roadmaps prioritized by impact and effort.
by nakano1122