How to Underwrite Real Estate Deals: NOI, Cap Rates, IRR & Due Diligence
Start with clear investment objectives
Define target returns, acceptable risk, hold period, and liquidity needs before running numbers.
Objectives guide choices between core, core-plus, value-add, and opportunistic strategies and determine acceptable leverage, location criteria, and tenant mix.
Core financial metrics to master
– Net Operating Income (NOI): Gross scheduled income minus vacancy losses and operating expenses. NOI is the basis for most valuation and underwriting models.
– Capitalization Rate (Cap Rate): NOI divided by purchase price. Cap rate provides a quick market-derived yield and a way to compare properties.
– Cash-on-Cash Return: Annual pre-tax cash flow divided by the equity invested.
Useful for investors focused on cash yield.
– Internal Rate of Return (IRR): Discount rate that sets the net present value of cash flows to zero. IRR reflects time value of money and is critical for multi-year projects with interim cash flows.
– Debt Service Coverage Ratio (DSCR): NOI divided by annual debt service. Lenders use DSCR to assess borrowing capacity and repayment risk.
Practical underwriting tips
– Use conservative revenue assumptions: stress rent growth and factor realistic vacancy rates based on comparable properties and local market cycles.
– Separate capital expenditures from operating expenses. Reserve for replacements (roof, HVAC, appliances) should be a line item outside day-to-day operations.
– Build multiple scenarios: best case, base case, and downside case. Sensitivity analysis on rent, occupancy, interest rates, and exit cap rate reveals which variables most affect returns.
– Account for transaction costs and carrying costs: closing fees, legal, financing fees, and holding costs during lease-up or renovation can materially affect equity returns.
Market and location analysis
Fundamentals drive long-term performance.
Evaluate job growth, tenant demand, new supply pipeline, and demographic trends such as household formation and income growth. Walk the submarket to validate neighborhood quality, transportation access, and amenities that support rent premiums.
Due diligence checklist
– Financial: rent roll, historical P&L, utility bills, service contracts
– Physical: inspection reports, environmental assessments, deferred maintenance estimates
– Legal: title review, zoning, leases, tenant estoppels, pending litigation
– Market: comparable rents, recent sales, absorption rates
Leverage, tax, and exit considerations
Leverage amplifies returns but increases sensitivity to interest rate changes. Model scenarios with different loan terms and stress test for higher rates.
Factor tax impacts, depreciation, and potential deferral strategies for capital gains. Define an exit strategy and probable sale assumptions; exit cap rate is often the largest sensitivity in IRR models.
Technology and data tools
Modern investors leverage data platforms, public records, and geospatial tools to pull comparable sales, rent trends, and zoning overlays.
Property management software and vacancy-tracking tools improve operating forecasts and highlight performance gaps early.
Risk management and portfolio context
View each underwriting in the context of portfolio diversification, liquidity needs, and investor time horizon.
Smaller markets may offer higher yields but less liquidity. Value-add plays require construction and leasing expertise; core assets trade on stability and lower volatility.
Applying disciplined analysis helps turn gut feel into measurable outcomes. Prioritize conservative assumptions, robust sensitivity testing, and thorough due diligence to make investment decisions that align with your objectives and risk tolerance.