Key Takeaways
- Performance attribution decomposes total return into income (38%), appreciation (47%), and leverage effect (15%).
- Variance analysis (actual vs. underwritten) identifies where assumptions were accurate, conservative, or optimistic.
- Market vs. manager analysis separates beta (market movement) from alpha (manager skill) in total returns.
- Post-investment analysis improves future underwriting—insurance escalation in this case should be 10-12%, not 5%.
After acquiring a property, the financial model transitions from a decision tool to a performance measurement tool. Performance attribution decomposes actual returns into their component sources—income return, appreciation return, and leverage effect—and compares them to the original underwriting to identify where assumptions were accurate, conservative, or optimistic. This case study demonstrates full performance attribution on a 40-unit property after a 3-year hold.
The Performance Attribution Framework
Performance attribution decomposes total return into four components. Income Return: the cash flow yield from operations (NOI minus debt service, divided by equity). Appreciation Return: the change in property value over the holding period, driven by NOI growth and cap rate movement. Leverage Effect: the incremental return generated by using debt financing—positive when asset returns exceed the cost of debt, negative when they fall below. Market vs. Manager: separating returns attributable to market movement (beta) from returns attributable to manager skill (alpha)—did you outperform because the market went up, or because you executed a superior strategy? Each component should be calculated both in absolute terms (dollars) and relative terms (contribution to overall IRR).
Case Study: 40-Unit Post-Disposition Attribution
Property: 40-unit apartment complex acquired for $4,000,000 with $1,000,000 equity. Held for 3 years, sold for $5,200,000. Total equity distributions: $1,720,000 (cumulative BTCF of $300,000 + net sale proceeds of $1,420,000). Equity multiple: 1.72x. Actual IRR: 21.8%. Attribution breakdown: Income return contributed 8.3% to IRR (stable, predictable cash flow averaging $100K/year BTCF). Appreciation contributed 10.2% (property value increased 30% due to NOI growth of 18% and cap rate compression of 40bps). Leverage effect contributed 3.3% (3x leverage amplified the positive asset-level returns). Manager alpha: actual IRR exceeded the NCREIF NPI benchmark by 5.2%, attributable to successful lease-up of vacant units and utility expense reduction through LED lighting and smart thermostats.
| Return Component | Contribution to IRR | % of Total | Source |
|---|---|---|---|
| Income Return | 8.3% | 38% | Operating cash flow from stabilized property |
| Appreciation | 10.2% | 47% | NOI growth (18%) + cap rate compression (40bps) |
| Leverage Effect | 3.3% | 15% | 3x leverage amplifying positive asset returns |
| Total IRR | 21.8% | 100% | Sum of components |
40-Unit performance attribution: 3-year hold
Variance Analysis: Actual vs. Underwritten
Comparing actual performance to original underwriting reveals where assumptions were accurate and where they missed. Revenue: actual EGI averaged 4% above underwriting due to stronger-than-expected rent growth (3.5% actual vs. 2.5% underwritten). Expenses: actual OpEx was 6% above underwriting due to insurance premium increases of 12%/year (vs. 5% underwritten) and higher-than-expected turnover costs. NOI: net effect was 2% above underwriting—revenue overperformance partially offset by expense underperformance. Exit: actual sale price was 8% above underwriting due to cap rate compression that was not modeled (market cap rates dropped 40bps during the hold period). This variance analysis feeds into improved underwriting for future deals—for example, you now know to budget 10-12% insurance escalation rather than 5%.
Watch Out For
Attributing all outperformance to manager skill without isolating market effects
Overconfidence in management ability when returns were primarily driven by market tailwinds
Fix: Benchmark returns against NCREIF NPI or ODCE index to isolate alpha from beta
Not performing variance analysis post-disposition
Missing the opportunity to calibrate future underwriting assumptions based on actual performance data
Fix: Conduct formal variance analysis for every disposition, building an institutional learning feedback loop
Key Takeaways
- ✓Performance attribution decomposes total return into income (38%), appreciation (47%), and leverage effect (15%).
- ✓Variance analysis (actual vs. underwritten) identifies where assumptions were accurate, conservative, or optimistic.
- ✓Market vs. manager analysis separates beta (market movement) from alpha (manager skill) in total returns.
- ✓Post-investment analysis improves future underwriting—insurance escalation in this case should be 10-12%, not 5%.
Sources
Common Mistakes to Avoid
Attributing all outperformance to manager skill without isolating market effects
Consequence: Overconfidence in management ability when returns were primarily driven by market tailwinds
Correction: Benchmark returns against NCREIF NPI or ODCE index to isolate alpha from beta
Not performing variance analysis post-disposition
Consequence: Missing the opportunity to calibrate future underwriting assumptions based on actual performance data
Correction: Conduct formal variance analysis for every disposition, building an institutional learning feedback loop
"Advanced Modeling: Development Pro Formas, Funds & Attribution" is a Pro track
Upgrade to access all lessons in this track and the entire curriculum.
Immediate access to the rest of this content
1,746+ structured curriculum lessons
All 33+ real estate calculators
Metro-level data across 50+ regions
Test Your Knowledge
1.What does performance attribution decompose?
2.What is variance analysis in post-investment review?
3.How does alpha differ from beta in real estate performance attribution?