lev-os Building Real Estate Pro Formas
Constructs property pro forma models with rent roll analysis, expense projections, and cash flow forecasting.
When To Use
- Underwriting an acquisition or disposition of income-producing property
- Modeling a development or value-add repositioning from ground-up or renovation budget through stabilization
- Preparing annual asset-management budgets or reforecasts for an existing portfolio asset
- Evaluating refinancing scenarios by stress-testing debt service coverage
- Supporting REIT-level NAV or FFO/AFFO analysis that rolls up individual property cash flows
Inputs To Gather
- Rent roll: Unit-level or tenant-level detail — tenant name, suite/unit, SF or unit count, lease start/end, base rent (per SF or per unit), escalation schedule, renewal probability, free-rent or abatement periods
- Market data: Comparable rents, vacancy rates, absorption trends, and cap rate benchmarks for the submarket [VERIFY — source CoStar, CBRE, or local broker comps]
- Operating expenses: Historical T-12 or T-3 actuals broken out by line item (property taxes, insurance, utilities, R&M, management fees, payroll, G&A, contract services)
- Capital expenditure plan: Near-term capex reserves, tenant improvement allowances (TI), leasing commissions (LC), and any deferred maintenance or renovation budget
- Financing terms: Loan amount or LTV, interest rate (fixed/floating), amortization period, IO period, term, prepayment provisions, debt covenants (DSCR floors, LTV caps)
- Hold period and exit assumptions: Projected hold (typically 5–10 years), exit cap rate, disposition costs (brokerage, transfer tax)
- Tax and entity structure: Property tax assessment schedule, depreciation method (27.5 yr residential / 39 yr commercial), any tax abatement or PILOT [VERIFY — jurisdiction-specific]
Workflow
Build the revenue module
- Lay out each lease on a unit-by-unit or tenant-by-tenant basis across the projection period
- Apply contractual escalations (fixed bumps, CPI-linked, or percentage rent)
- Model lease expirations: assign renewal probability and downtime assumptions; re-lease at projected market rent
- Calculate gross potential rent (GPR), then deduct vacancy and credit loss (typically 3–10% depending on asset class and market) [VERIFY — market-specific vacancy]
- Add ancillary income: parking, laundry, storage, expense recoveries (CAM/NNN reimbursements), percentage rent overages
Build the expense module
- Start from the T-12 actuals; inflate each line item at an appropriate growth rate (general inflation for most; separate escalator for property taxes and insurance)
- Management fee: typically 3–5% of EGI for institutional assets [VERIFY — per management agreement]
- Replacement reserves: $150–$300/unit for multifamily or $0.15–$0.30/SF for commercial [VERIFY — lender/investor requirements]
- Net operating income (NOI) = Effective Gross Income minus total operating expenses
Build the capital and TI/LC module
- Schedule tenant improvement allowances and leasing commissions at each lease rollover
- Include any renovation or repositioning capex phased by quarter or year
- Separate "above-the-line" capex (capitalized into basis) from operating expense repairs
Build the financing module
- Model debt service: monthly P&I during amortizing periods, IO payments during interest-only periods
- Calculate DSCR (NOI / annual debt service) each year; flag any year where DSCR falls below covenant threshold (commonly 1.20–1.25x)
- If floating-rate, show base-case rate path plus stressed scenarios (+100 bps, +200 bps)
Calculate return metrics
- Unlevered cash flow = NOI minus capex/TI/LC
- Levered cash flow = Unlevered cash flow minus debt service
- Exit value = forward NOI / exit cap rate, less disposition costs
- Equity waterfall: preferred return, catch-up, and promote splits if applicable
- Compute IRR, equity multiple, cash-on-cash yield, and average annual return for both unlevered and levered scenarios
Run sensitivity and scenario analysis
- Sensitivity table on exit cap rate vs. rent growth (or vacancy)
- Downside scenario: higher vacancy, slower rent growth, cap rate expansion
- Upside scenario: faster lease-up, above-market escalations, cap rate compression
- Break-even analysis: identify occupancy or rent level at which DSCR = 1.0x or IRR = 0%
Output
- Summary page: Property name, address, asset class, SF/units, acquisition price, going-in cap rate, stabilized yield, target IRR/equity multiple
- Annual cash flow projection (typically 5–10 year hold): GPR, vacancy, EGI, operating expenses by category, NOI, capex/TI/LC, unlevered cash flow, debt service, levered cash flow
- Return metrics table: Unlevered IRR, levered IRR, equity multiple, cash-on-cash by year, peak equity outstanding
- Sensitivity matrix: Two-variable table (e.g., exit cap rate x rent growth) showing IRR and equity multiple at each intersection
- Key assumptions schedule: Clearly list every assumption — growth rates, vacancy, cap rates, financing terms, TI/LC per SF — with source or basis noted
- Footnotes and flags: Mark any assumption lacking market support with [VERIFY]; note where historical data was extrapolated
Quality Checks
- NOI sanity check: Compare modeled NOI margin to submarket benchmarks; multifamily typically 55–70%, office 60–75% of EGI [VERIFY — asset class and market]
- Cap rate cross-check: Going-in cap rate should align with recent comparable transactions; flag divergence >25 bps
- DSCR covenant compliance: Confirm no year breaches the lender's minimum DSCR; if it does, note the shortfall and potential cash sweep or reserve trigger
- Rent growth reasonableness: Projected rent escalation should not materially exceed historical submarket CAGR without explicit justification
- Expense ratio consistency: Total opex as % of EGI should be stable year-over-year absent a known structural change
- IRR back-check: Reverse-engineer the exit price implied by the target IRR; confirm it implies a realistic exit cap rate
- Unit economics: Per-unit or per-SF revenue and expense figures should fall within market ranges; outliers need annotation
- Circular reference check: Ensure no unresolved circularity between debt sizing, equity, and return calculations