AGENT SKILL

analyzing-multifamily-investments

Structures multifamily property analysis with rent comps, expense benchmarking, and value-add assessment. Use when analyzing apartment investments, comparing rent levels, or evaluating value-add opportunities.

License 许可
Apache-2.0
最近更新
2026-11-09
Stars
★ 0
Forks
0

01 前言 Front Matter

name
analyzing-multifamily-investments
tags
[ "analysis", "real-estate-finance", "investment" ]
source
https://github.com/CaseMark/skills
license
Apache-2.0
language
en
metadata
{ "author": "casemark", "skill_modes": [ "Analysis" ], "document_types": [ "Analysis Report" ], "practice_areas": [ "Real Estate Finance", "REIT Analysis", "Property Investment" ] }
description
Structures multifamily property analysis with rent comps, expense benchmarking, and value-add assessment. Use when analyzing apartment investments, comparing rent levels, or evaluating value-add opportunities.
imported_at
2026-09-20
source_path
skills/finance/analyzing-multifamily-investments/SKILL.md
source_repository
CaseMark/skills

03 SKILL.md 正文

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

04 同仓库更多 Skills