How to Evaluate Real Estate Deals: Underwriting Framework, Key Metrics & Checklist
What to model first
– Gross potential rent: Start with achievable market rent by unit type and adjust for concessions. Use recent comparable listings and lease-up trends rather than asking rents.
– Vacancy and credit loss: Apply a conservative vacancy rate based on market history and property condition.
Factor in turnover costs and vacancy duration for multifamily or short-term rental models.
– Operating expenses: Break out line items — property management, utilities, maintenance, insurance, property taxes, and capital reserves. Benchmark against similar assets in the submarket to avoid underestimating hidden costs.
– Net operating income (NOI): NOI = Effective gross income − operating expenses. This is the core profitability metric before financing.
Key metrics to calculate
– Cap rate: NOI divided by purchase price. Use the cap rate primarily as a valuation cross-check versus comps and as a shorthand for market return expectations.
– Cash-on-cash return: Annual pre-tax cash flow divided by initial equity. Useful for evaluating short-term cash yield, especially on leveraged deals.
– Debt Service Coverage Ratio (DSCR): NOI divided by annual debt service. Lenders typically require a DSCR above a threshold; stress-test for tighter covenants.
– Loan-to-value (LTV): Loan amount divided by purchase price. Higher LTV increases risk and sensitivity to market shifts.
– Internal Rate of Return (IRR) and Net Present Value (NPV): Model multiple hold periods and exit assumptions to estimate long-term returns. Use conservative exit cap rates and account for selling costs.
Underwriting best practices
– Use three scenarios: base, conservative (downside), and optimistic (upside). Change rent growth, vacancy, and cap rate at exit to see effects on returns.
– Sensitivity analysis: Build a tornado or matrix showing which variables (rent growth, cap rate compression/expansion, financing rate) most affect returns.
Prioritize mitigating the biggest risks.
– Include capital expenditures: Differentiate between routine maintenance and near-term large capital items like roof, HVAC, or re-skinning. Create a capital reserve schedule.
– Tax and depreciation effects: Incorporate tax advantages such as depreciation, interest deductibility, and cost segregation where applicable. Run after-tax IRR if tax impacts change investment decisions.
Market and asset-level indicators
– Submarket fundamentals: Track employment growth, household formation, new supply pipeline, and transit or amenity expansions that influence demand.
– Rent-to-income ratio and affordability: Strong rent growth can be constrained by local income trends; ensure rent increases are supportable.
– Comparable sales and leasing activity: Use recent comps for valuation and lease comparables for rent assumptions. Adjust for quality, class, and micro-location differences.
Common pitfalls to avoid
– Overreliance on pro forma rents without supporting market evidence.
– Ignoring capex needs and deferred maintenance in purchase price negotiations.
– Failing to stress-test financing under rising interest rates or tighter lending standards.
– Not planning an exit strategy that aligns with market liquidity for the asset class.
Practical checklist before bidding
– Verify third-party financials and rent rolls
– Inspect property and obtain detailed repair estimates
– Confirm zoning, rent control, or regulatory constraints
– Reconcile seller-provided performance against market comps
– Run conservative downside scenarios and lender stress cases
A structured investment analysis reduces surprises and clarifies which assumptions drive value. Focus on objective market data, conservative underwriting, and scenario planning to make decisions that balance upside potential with downside protection.