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