Sensitivity analysis for REIT models.
How to test cap rate, NOI growth, and interest-rate scenarios with Excel Data Tables — plus the iterative-calculation gotcha that breaks Data Tables in any REIT model with a cash-and-debt schedule. Free PDF + 4-minute video walkthrough.
What’s inside.
- Two-variable Data Tables — the cap rate × NOI growth grid that every REIT analyst eventually builds
- The iterative-calculation gotcha — why Data Tables silently break when iterative calc is enabled, and the workaround
- Interest-rate sensitivity — how to layer a rate shift on top of a cash-and-debt schedule without rebuilding the model
- Variable input ranges — choosing the cap rate ± bps and growth ± pp ranges that actually show meaningful spread
- The output to surface — what to display in the Data Table cell so the result is interpretable, not just “a number”
- Conditional formatting — the color gradient pattern senior modelers use to make sensitivity output legible at a glance
Get the PDF + video.
Enter your email. The PDF arrives immediately; the 4-minute video walkthrough is linked inside.
Companion to REIT Modeling — the self-paced REIT modeling course. Sensitivity analysis is not part of the core course curriculum; this guide is a standalone resource.