Real Estate Investment Analysis: Underwriting Guide to NOI, Cap Rates & Cash Flow
Begin with reliable inputs
– Rent and occupancy: Use actual rent rolls when available, otherwise derive market rents from comparable properties and broker listings.
Assume conservative vacancy and credit loss to avoid optimistic cash flow projections.
– Operating expenses: Track line-by-line—property taxes, insurance, utilities, maintenance, property management, reserves for replacement. Compare expense ratios to comps in the submarket, not just the metro.
– Capital expenditures (CapEx): Budget for deferred maintenance and cyclical items (roofs, HVAC). Treat CapEx separately from routine operating expenses.
Core metrics to calculate
– Net Operating Income (NOI): Effective Gross Income minus operating expenses. NOI is the foundation for value-based metrics.
– Capitalization Rate (Cap Rate): NOI divided by purchase price.
Use cap rates from recent comparable sales in the same property type and submarket to validate price assumptions.
– Cash-on-Cash Return: Annual pre-tax cash flow divided by initial equity invested.
Useful for quick comparisons among deals.
– Debt Service Coverage Ratio (DSCR): NOI divided by annual debt service; lenders use DSCR thresholds to gauge loanability.
– Loan-to-Value (LTV): Loan amount divided by property value—keeps leverage and risk in view.
– Internal Rate of Return (IRR) and Equity Multiple: IRR measures investment return over time accounting for timing of cash flows; equity multiple shows total cash returned per dollar invested. Use a realistic hold period and include a reasonable exit cap rate in terminal value assumptions.
Stress-test with scenarios
Build three scenarios: conservative, base, and optimistic. Vary vacancy, rent growth, expense inflation, and exit cap rate.
Sensitivity analysis helps identify which variables move returns most—often rent growth, exit cap rate, and financing cost. Run a break-even analysis to find the occupancy or rent level where cash flow turns negative or debt service coverage falls below lender requirements.
Value drivers and market indicators
Focus on supply and demand fundamentals in the micro-market: job growth, household formation, rental inventory, new construction deliveries, and zoning changes. Track absorption rates and recent sales to see whether cap rates are compressing or expanding. Neighborhood-level trends—transit access, school quality, and planned infrastructure—can materially affect upside.
Tax and liquidity considerations
Factor in tax impacts: depreciation shields, capital gains implications, and 1031 exchange possibilities (when available in your jurisdiction). Also consider liquidity: some assets are harder to exit quickly without price concessions.
Practical workflow and tools
Start with a standardized underwriting spreadsheet: income, expenses, debt schedule, cash flows, and return metrics. Supplement with market research platforms, MLS data, and conversations with local brokers. For complex deals, run a Monte Carlo or probability-based sensitivity analysis to visualize downside distributions.
Risk management and due diligence
Perform physical inspections, verify leases, obtain historical financials, and confirm zoning compliance. Stress the exit scenario—what happens if cap rates widen or rents stagnate? Conservatively modeling downside preserves capital and positions you to act when markets reprice.
A disciplined, metric-driven approach turns gut instincts into repeatable investment outcomes. By focusing on NOI, leverage, cashflow sensitivity, and local market fundamentals, you’ll be better prepared to evaluate opportunities and manage risk across different market cycles.