Key Takeaways
- Development models require monthly draw schedules—construction interest carry is often 10-15% of total budget.
- Fund fees switch base from committed to invested capital, and waterfall style (European vs. American) significantly affects GP/LP economics.
- Monte Carlo provides probability-of-achievement metrics unavailable from scenario analysis.
- Post-disposition variance analysis is the highest-value learning tool for improving future underwriting.
This lesson consolidates the advanced modeling techniques from Track 3: development modeling, fund-level analysis, Monte Carlo implementation, tax-impact modeling, and performance attribution. Test your mastery with the review questions below.
Advanced Modeling Recap
Development models track hard costs (60-70%), soft costs (15-25%), and financing costs (10-15%) with monthly draw schedules to calculate construction interest carry. Fund-level models aggregate property cash flows, apply management fees (on committed capital during investment period, invested capital during harvest), and calculate carried interest using European or American-style waterfalls. Monte Carlo simulation uses probability distributions (Normal, Triangular, Uniform) for uncertain variables and runs 1,000+ iterations to produce outcome distributions and probability-of-achievement metrics.
Performance Attribution Recap
Performance attribution decomposes returns into income, appreciation, and leverage components. Variance analysis compares actual performance to underwritten projections, identifying assumption accuracy. Market vs. manager analysis separates beta from alpha using NCREIF or ODCE benchmarks. Post-disposition analysis creates a feedback loop that improves future underwriting accuracy. Tax-impact modeling reveals how depreciation, cost segregation, and 1031 exchanges affect after-tax investor returns.
Watch Out For
Applying single-asset underwriting models to development or fund-level projections without structural modifications
The model fails to capture draw schedules, interest reserves, promote waterfalls, or multi-asset correlation effects
Fix: Use purpose-built templates: development models need construction draw schedules and interest carry; fund models need waterfall logic and portfolio aggregation
Running sensitivity analysis on only one variable at a time instead of testing correlated scenarios
A recession typically hits vacancy, rent growth, and exit cap rates simultaneously—single-variable tests miss the combined impact
Fix: Build scenario matrices that stress correlated variables together (e.g., recession = +200bps vacancy, -2% rent growth, +50bps exit cap)
Key Takeaways
- ✓Development models require monthly draw schedules—construction interest carry is often 10-15% of total budget.
- ✓Fund fees switch base from committed to invested capital, and waterfall style (European vs. American) significantly affects GP/LP economics.
- ✓Monte Carlo provides probability-of-achievement metrics unavailable from scenario analysis.
- ✓Post-disposition variance analysis is the highest-value learning tool for improving future underwriting.
Sources
- CBRE — Cap Rate Survey(2025-01-15)
- NCREIF — Property Index and Return Benchmarks(2025-01-15)
- FHFA — House Price Index(2025-01-15)
- Zillow Research — ZHVI and ZORI Data(2025-01-15)
Common Mistakes to Avoid
Applying single-asset underwriting models to development or fund-level projections without structural modifications
Consequence: The model fails to capture draw schedules, interest reserves, promote waterfalls, or multi-asset correlation effects
Correction: Use purpose-built templates: development models need construction draw schedules and interest carry; fund models need waterfall logic and portfolio aggregation
Running sensitivity analysis on only one variable at a time instead of testing correlated scenarios
Consequence: A recession typically hits vacancy, rent growth, and exit cap rates simultaneously—single-variable tests miss the combined impact
Correction: Build scenario matrices that stress correlated variables together (e.g., recession = +200bps vacancy, -2% rent growth, +50bps exit cap)
"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.During a fund's investment period, management fees are typically calculated on what base?
2.What distribution type is best for modeling exit cap rates in Monte Carlo simulation?
3.In performance attribution, what does "alpha" represent?