The Definitive Guide to Underwriting Multifamily Acquisitions

1. Underwriting is the Foundation of Smart Multifamily Investing

Success in investing doesn’t come from buying good things, but from buying things well, and it’s essential to know the difference.

Buy well, not just good. Underwriting is the critical process of collecting and organizing financial information to project income, expenses, and investment returns. This "pro forma" guides all investment decisions, from purchase to refinance and sale, ensuring that the price paid for an asset aligns with target returns and risk tolerance. It prevents emotional decisions based solely on qualitative factors like location or condition, forcing a focus on the numbers.

Translate qualitative to quantitative. While factors like population growth, low crime, and strong comparables are important, underwriting translates these into a "bottom line" using appropriate pricing and risk models. This allows investors to compare diverse opportunities on equal footing, revealing the implied growth expectations and operational assumptions baked into market prices. The "best" markets don't always offer the best value; comprehensive underwriting uncovers where true value lies.

Set realistic targets. Target returns should not be developed in a vacuum but informed by market feedback obtained through underwriting numerous deals. Too high a target leads to no investments, while too low results in poor returns. Underwriting helps identify average prospective returns for various markets and investment types, enabling investors to position their targets realistically within the market cycle.

2. Passive Investors: Focus on Sponsor, Deal Structure, and Key Deal Metrics

If you’re quickly evaluating an investment, focus on the sponsor’s team and experience.

Sponsor's track record matters. For passive investors with limited time, a high-level evaluation focusing on three key areas is crucial. First, thoroughly vet the sponsor's team and experience, looking beyond just completed deals to understand their operational involvement and asset management capabilities. Request case studies comparing underwriting to actual results to discern if success stems from execution or market appreciation.

Aligning interests is paramount. Second, scrutinize the deal structure for alignment of interests, reasonable fees, and significant sponsor co-investment. A preferred return (especially an IRR hurdle) that prioritizes investor capital return is ideal. The sponsor's co-investment should be meaningful relative to their net worth, demonstrating genuine commitment. Be wary of hidden fees that can erode investor returns.

Key deal metrics reveal value. Third, assess the deal itself by examining critical inputs like rent growth, exit cap rate, and yield on cost. Request the sponsor's underwriting model to verify projections.

• Rent growth: Should be conservative (typically 2-3%).
• Exit cap rate: Should be 50-100bps above current market cap rates.
• Yield on cost: A robust metric (pro forma NOI / (purchase price + capex)) that is harder to manipulate than IRR, providing a clearer picture of value-add potential.

3. Accurate Data Entry Drives Reliable Projections: Income & Expenses

Garbage in, garbage out.

Foundation of the pro forma. The accuracy of your underwriting model hinges on meticulous data input for unit mix, operating income, and operating expenses. Start with the property's address, a trailing 12-month financial statement (T12), and a rent roll. These documents provide the historical baseline for projecting future performance. Market metrics like median household income, population growth, and crime rates offer crucial context for your assumptions.

Income line items. Carefully input current and projected (pro forma) rents from the unit mix, recognizing that pro forma rents are highly sensitive and drive stabilized Gross Potential Rent (GPR). Account for all income sources like RUBS (utility billbacks) and Other Income, while also factoring in income losses such as:

• Loss to Lease (difference between market and lease rents)
• Vacancy Rate (revenue lost from vacant units)
• Concessions/Non-Revenue units
• Bad Debt (uncollectable rent)

Expense line items. Similarly, detail all operating expenses from the T12, adjusting or reclassifying items for consistency. Key expenses include Payroll, Contract Services, Repairs & Maintenance, Turnover, Utilities, Administrative, Marketing, and Insurance. Crucially, always include a market-rate management fee and project property taxes based on reassessment upon sale, as these significantly impact Net Operating Income (NOI) and valuation. Replacement reserves should also be included "above the line" in NOI calculations for conservative valuation.

4. Validate Your Assumptions with Thorough Rental and Sales Comparables

Rent comp information can also be obtained from Google searches, Apartments.com, and paid apartment data services such as Yardi Matrix, CoStar, and ALN Apartment Data.

Justify rent increases. Rental comparables (rent comps) are essential, especially for value-add strategies aiming for higher market rents. Identify properties of similar vintage and post-renovation condition within a 1-3 mile radius. Beyond base rents, investigate additional charges like RUBS or washer/dryer fees to ensure true comparability. Calling properties directly ("mystery shopping") provides granular detail often missed in data reports.

Sanity check purchase and sale prices. Sales comparables (sales comps) serve as a vital sanity check for both your proposed purchase price and projected future exit price. For value-add deals, sales comps must support the significantly higher projected sale price, justifying the capital expenditures and increased cash flow. In competitive markets, finding direct comps for future exit prices can be challenging, but the goal remains to ensure feasibility.

Metrics for comparison. Compare sales using:

• Cap rates: Though difficult to obtain accurately due to varying NOI calculations and value-add strategies.
• Price per unit: A common metric, but adjust for unit size differences (e.g., studios vs. townhomes).
• Price per square foot: Accounts for unit size but misses other factors like number of kitchens.
  Consider the debt used in the sale and market conditions at the time of sale, as these can significantly impact reported values.

5. Evaluate Beyond IRR: Prioritize Yield on Cost for Value-Add Deals

The cleanest solution to these issues and the simplest yet most robust return metric is something called return on cost, or yield on cost.

IRR's limitations. While Internal Rate of Return (IRR) is a universal measure, it can be subjective and sensitive to manipulation, especially with growth and exit assumptions. Cash on cash yield is more reliable as it focuses on annual cash flow but ignores the crucial future sale component. Cap rates, while simple, ignore financing and can be misleading due to various calculation methods.

Yield on Cost: The robust metric. Yield on Cost (or Return on Cost) is a superior metric for value-add investments. It calculates pro forma NOI (without growth assumptions) divided by the total cost (purchase price + capital expenditures), independent of capital structure. This provides the clearest picture of whether an investment has true value-add potential, showing if you can "build" cash flows for a higher cap rate than the market rate for already stabilized assets.

Targeting a spread. A strong value-add deal should aim for a Yield on Cost 100-200 basis points above market cap rates for stabilized, comparable product. This spread compensates for the time and execution risk involved in stabilization. Additionally, compare your yield to the amortized debt constant (principal and interest payments as a percentage of principal) to ensure sufficient cash flow, especially when interest-only periods expire.

6. Stress Test Investments with Sensitivity Analyses to Mitigate Risk

Never forget the 6-foot-tall man who drowned crossing the stream that was 5 feet deep on average.

Prepare for the unexpected. Sensitivity analyses are crucial for understanding an investment's resilience to adverse scenarios, addressing both loan default and loan maturity risks. The most common stress test is breakeven occupancy, which determines the economic occupancy rate needed to cover all operating expenses and debt service. This provides a strong indication of the property's ability to meet liabilities in a downturn.

Refinance/Exit Test is paramount. The refinance/exit test is arguably the most important, forecasting the loan's unpaid principal balance and property valuation at maturity. This test projects if a new loan could be large enough to pay off the existing debt without requiring additional equity. It involves:

• Operational Shock: Decreasing effective gross income (revenue).
• Capital Markets Shock: Increasing market interest rates and cap rates (reducing valuation).
• Both Shock: A combination of both, representing a realistic worst-case scenario.
  This analysis is particularly vital for bridge loans with shorter maturities and higher leverage, revealing potential capital shortfalls.

Two-way tables and cash flow proportion. Two-way sensitivity tables illustrate how changes in key metrics (e.g., rent growth vs. exit cap rate, hold period vs. stabilization time) affect investor IRR. Additionally, analyze the percentage of total returns attributed to cash flow versus appreciation. A higher proportion from cash flow (e.g., 50-60% for 5-10 year holds) indicates a more conservative deal, as cash flow is generally more predictable than capital appreciation.

7. Scrutinize Partnership Structures for True Alignment and Hidden Fees

The truest alignment of interest is GP co-investment. Cash (co-invested) is king.

Traditional promote structures. Most multifamily deals feature an acquisition fee (1-2% of purchase price), an ongoing asset management fee (1-2% of effective gross income), and a promote (carried interest) structure, typically subordinate to a preferred return (6-10%). While sponsors claim "aligned interests," these structures can create conflicts, especially when sponsors prioritize quicker sales to realize capital gains and maximize their promote share.

Preferred return nuances. Understand how preferred returns are calculated: cumulative and compounding is best, meaning missed payments accrue interest. Be wary of "no pref, lower promote" structures, which often result in worse investor economics and higher risk. Also, watch for sponsors who "over-raise" equity to pay preferred returns, as this dilutes investor returns and negates the pref's alignment power.

Beware of hidden fees. Beyond standard fees, look for "hidden fees" that erode returns. Loan guarantee fees on non-recourse debt are a red flag, as are charges for travel or hourly rates that should be covered by the asset management fee. Always ask sponsors what costs are covered by the asset management fee. The strongest alignment of interest remains significant cash co-invested by the sponsor on the same terms as limited partners, demonstrating genuine commitment.

8. Build Your Own Underwriting Model for Deepest Understanding

The process of creating your own model forces you to learn every calculation and step in the process and better understand how each assumption works with the others in the model.

Intimate knowledge is power. Building your own underwriting model from scratch is invaluable for both learning and practical application. This hands-on process compels you to understand every calculation and the interplay between assumptions, fostering a deep, intuitive grasp of the investment's mechanics. While models vary, knowing the intricacies of your own ensures you trust its outputs.

Learn from existing models. Start by downloading and experimenting with various models to observe different styles, formats, and common calculation methods. Underwrite the same deal across multiple models to see how minor differences can substantially alter projected returns. This exposure helps you identify best practices and areas for improvement.

Iterative refinement. Once familiar with existing models, begin dissecting and reassembling them, incorporating the best aspects into your own evolving model. Ensure your model performs monthly pro forma calculations for accuracy, as annual calculations can be oversimplified. Consistency in your model's structure and line items across different deals is paramount for accurate, like-for-like comparisons.