Key Takeaways
- Project revenue by unit type with separate assumptions for market rent growth, renewal rate, and concessions.
- Each expense category requires its own growth rate—property taxes, insurance, and repairs each have distinct dynamics.
- Model CapEx using both annual reserves ($250-$500/unit) and specific major items timed to remaining useful life.
- Insurance escalation of 7-12% in recent years requires more conservative budgeting than historical norms.
The multi-year pro forma is the engine of every acquisition model. It projects revenue, expenses, NOI, debt service, and cash flow for each year of the holding period, incorporating growth assumptions and capital expenditure timing. This lesson teaches the detailed mechanics of building a year-by-year pro forma that links every output back to clearly defined assumptions.
Revenue Projection Mechanics
Revenue projection starts with the Year 1 validated revenue and applies growth assumptions forward. For multifamily, the most accurate approach projects each unit type separately: market rent per unit type, occupancy by unit type, and loss-to-lease (the difference between market rent and in-place rent for existing tenants). Revenue growth is driven by three factors: market rent growth (applied to new leases and renewals at market), lease renewal rate (the percentage of existing tenants who renew, typically at a discount to market), and concessions (free rent or move-in specials offered during lease-up). A more detailed model might project rent growth monthly or quarterly for the first two years, then annually thereafter.
Why it matters: Understanding this concept is essential for making informed investment decisions.
Expense Projection by Category
Each expense category should have its own growth assumption. Property taxes: in reassessment jurisdictions, model a step-up in Year 1 to the purchase-price-based assessment, then 2-3% annual growth. In non-reassessment jurisdictions, use the historical growth rate. Insurance: historically grew 3-5% annually, but has been escalating 7-12% in recent years due to increased natural disaster frequency. Budget conservatively at 5-8% until the market stabilizes. Repairs and maintenance: grow at 3-4% for inflation, but add step-ups for aging systems. Management fees: if a percentage of revenue, they automatically scale with revenue growth. Utilities: 3-5% annual growth, adjustable for energy efficiency improvements. Administrative costs: 2-3% growth for general inflation.
| Expense Category | Growth Assumption | Key Consideration |
|---|---|---|
| Property Taxes | 2-3% (post-reassessment) | Model Year 1 reassessment step-up |
| Insurance | 5-8% | Market hardening since 2020; get broker forecast |
| Repairs & Maintenance | 3-4% + age step-ups | Older buildings need higher escalation |
| Management Fees | Scales with revenue | Usually 8-10% of EGI |
| Utilities | 3-5% | Efficiency improvements can offset |
| Administrative | 2-3% | General inflation |
Expense growth assumptions by category
Why it matters: Understanding this concept is essential for making informed investment decisions.
Capital Expenditures and Replacement Reserves
Capital expenditures are not operating expenses but must be modeled in the cash flow projection. There are two approaches: the Reserve Method allocates a fixed amount per unit per year ($250-$500) into a replacement reserve, funded from cash flow. The Specific Item Method identifies major capital items, estimates their remaining useful life and replacement cost, and models them as lump-sum expenditures in the appropriate year. Professional models use both: reserves for routine replacements (appliances, carpet, paint) and specific items for major systems (roof at $8,000-$12,000 per unit, HVAC at $5,000-$8,000 per unit, parking lot at $3-$5 per square foot). Lenders typically require replacement reserves of $250-$350 per unit per year, escrowed monthly.
Why it matters: Understanding this concept is essential for making informed investment decisions.
Key Takeaways
- ✓Project revenue by unit type with separate assumptions for market rent growth, renewal rate, and concessions.
- ✓Each expense category requires its own growth rate—property taxes, insurance, and repairs each have distinct dynamics.
- ✓Model CapEx using both annual reserves ($250-$500/unit) and specific major items timed to remaining useful life.
- ✓Insurance escalation of 7-12% in recent years requires more conservative budgeting than historical norms.
Sources
- IREM — Income/Expense Analysis(2025-01-15)
- RSMeans/Gordian — Facilities Maintenance and Repair Cost Data(2025-01-15)
Common Mistakes to Avoid
Using identical growth rates for revenue and expenses
Consequence: Ignores the reality that insurance, taxes, and repairs often escalate faster than rents
Correction: Model expenses at 3-4% annual growth and revenue at 2-3% unless market data supports different assumptions
Omitting capital expenditure reserves from the model entirely
Consequence: Overstates free cash flow and fails to account for inevitable major replacements
Correction: Include $250-$500/unit/year in CapEx reserves, adjusted for property age and condition assessment findings
Test Your Knowledge
1.In a multi-year pro forma, what growth rate is applied to project future revenue?
2.Why should expense growth typically exceed revenue growth in conservative models?
3.What is the purpose of capital expenditure reserves in a financial model?