Analyzing Multifamily Investments

Analyzing Multifamily Investments

Structures multifamily property analysis with rent comps, expense benchmarking, and value-add assessment for apartment communities ranging from garden-style to mid-rise and high-rise assets.

When To Use

• Underwriting an acquisition of an apartment property (5+ units)
• Benchmarking in-place rents against market comps to identify upside
• Evaluating a value-add business plan (unit renovations, amenity upgrades, operational improvements)
• Preparing an investment memo or IC package for a multifamily deal
• Comparing competing multifamily opportunities within a market or submarket

Inputs To Gather

• Property details: unit count, unit mix (studio/1BR/2BR/3BR), net rentable SF, year built, renovation history
• Rent roll: current in-place rents by unit type, lease expiration schedule, vacancy and concession detail
• T-12 operating statement: trailing 12-month income and expenses line by line
• Rent comps: 3–5 comparable properties with asking rents, concessions, occupancy, and amenity sets
• Capital expenditure history: recent and planned capex, deferred maintenance items
• Market data: submarket vacancy, absorption trends, new supply pipeline, rent growth forecasts
• Acquisition terms: purchase price, financing assumptions (LTV, rate, term, IO period), hold period

Workflow

1. Validate the rent roll and T-12

   • Reconcile rent roll totals to the T-12 gross potential rent
   • Flag any month-to-month leases, employee/model units, or below-market legacy leases
   • Identify lease expiration clustering that creates rollover risk

2. Build the rent comp analysis

   • Map each comp by distance, vintage, unit size, and amenity tier
   • Calculate effective rent PSF for each unit type at subject and comps
   • Determine loss-to-lease (in-place vs. market) and gain-to-lease where applicable
   • Note concession levels and whether comps are stabilized or in lease-up

3. Benchmark operating expenses

   • Express each expense line as cost per unit and cost PSF
   • Compare against market benchmarks: taxes [VERIFY against county assessor records], insurance, payroll, R&M, utilities, management fee
   • Flag any lines that deviate >15% from benchmarks and note whether the variance is structural or correctable
   • Assess real estate tax reassessment risk at the projected acquisition price [VERIFY local reassessment triggers]

4. Underwrite the stabilized pro forma

   • Project gross potential rent using market rents from comp analysis
   • Apply market vacancy (typically 5–7% for stabilized Class B/C; adjust for submarket) [VERIFY submarket norms]
   • Layer in other income: pet rent, parking, RUBS/utility reimbursement, late fees, application fees
   • Apply underwritten expenses with appropriate inflation factors
   • Calculate Net Operating Income (NOI)

5. Evaluate the value-add business plan (if applicable)

   • Define renovation scope and per-unit cost (interior: $8K–$25K light-to-heavy; exterior/common area budget)
   • Estimate rent premium achievable per unit type post-renovation, supported by comp data
   • Model renovation pace (units/month) and temporary vacancy during turns
   • Calculate return on cost for the renovation program: incremental NOI ÷ total capex
   • Target return on cost typically >15% for institutional value-add [VERIFY sponsor's threshold]

6. Run return metrics

   • Calculate going-in cap rate, stabilized cap rate, and exit cap rate assumption
   • Model levered and unlevered IRR over the hold period
   • Compute equity multiple, average annual cash-on-cash return, and peak equity requirement
   • Sensitivity test: vary exit cap rate (±25–50 bps), rent growth (±100 bps), and renovation premium (±$25–$50/unit)

7. Assess risk factors

   • New supply: identify competing projects under construction or in planning within a 1–3 mile radius
   • Regulatory risk: rent control/stabilization exposure, inclusionary zoning requirements [VERIFY local ordinances]
   • Concentration risk: tenant employer base, single-industry dependency
   • Physical risk: deferred maintenance, environmental issues (asbestos, mold), flood zone status
   • Capital markets risk: refinancing exposure given rate environment

Output

Deliver a structured investment analysis containing:

• Executive summary: property overview, key thesis, and go/no-go recommendation with supporting rationale
• Rent comp matrix: table of subject vs. comps with effective rent PSF by unit type, occupancy, and concessions
• Expense benchmarking table: T-12 actuals vs. underwritten vs. market benchmarks per unit and PSF
• Pro forma summary: 5–10 year cash flow projection showing revenue, expenses, NOI, debt service, and levered cash flow
• Value-add schedule (if applicable): renovation timeline, cost, rent premium, and return on cost
• Returns summary: going-in cap rate, stabilized yield, IRR (levered/unlevered), equity multiple, cash-on-cash
• Sensitivity tables: IRR and equity multiple across exit cap rate and rent growth scenarios
• Risk register: ranked list of material risks with probability assessment and mitigation strategies

Quality Checks

• In-place rents reconcile between rent roll and T-12; any discrepancies are explained
• Rent comps are genuinely comparable (similar vintage, unit size ±10%, same submarket tier)
• Expense underwriting does not simply adopt seller's numbers — each line is independently justified
• Tax reassessment is modeled at the acquisition price unless a credible basis for appeal exists [VERIFY]
• Value-add rent premiums are supported by renovated comps, not aspirational projections
• IRR calculations account for all capital outflows including capex reserves and renovation spend
• Sensitivity ranges are wide enough to capture realistic downside (minimum ±50 bps on exit cap, ±1% on rent growth)
• All market data sources and vintage dates are cited; stale data (>6 months) is flagged