Scenario Modeling
Override any cell in the 40-year projection table. Changes cascade forward automatically and recalculate all downstream metrics in real time.
Click Any Cell to Override
Yellow cells are overrides. They become the new base, and all future years cascade from the override.
| Metric | Year 1 | Year 2 | Year 3 * | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Monthly Rent | $2,200 | $2,266 | $2,500 | $2,575 | $2,652 |
| Annual Rent | $26,400 | $27,192 | $30,000 | $30,900 | $31,827 |
| CFBT | $2,856 | $3,194 | $5,748 | $6,140 | $6,548 |
| RIDQ™ Total | $21,650 | $22,380 | $25,200 | $25,980 | $26,790 |
Before vs After Override
What happens when you override Monthly Rent from $2,334 to $2,500 at Year 3.
Base Calculation
Year 3 with 3% annual rent growth from $2,200/mo.
With Override
Year 3 rent manually set to $2,500/mo.
How Cascade Logic Works
You set an override — click any editable cell and enter a custom value. The cell turns yellow to show it's an override.
Override becomes the new base — all future years grow from the overridden value instead of the original calculated value.
Downstream metrics recalculate — changing rent affects NOI, which affects cash flow, which affects RIDQ™, ROIQ™, IRR, and more.
Clear to revert — remove the override to go back to the calculated value. Everything recalculates instantly.
What You Can Override
60+ individual fields organized into 10 sections, all overridable per year.
Model Any Scenario on Your Next Deal
Override rent bumps, expense changes, rate adjustments — and see how they cascade through 40 years.