Skip to main content

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 $3,900 $4,017 $4,400 $4,532 $4,668
Annual Rent $46,800 $48,204 $52,800 $54,384 $56,016
CFBT $2,100 $3,500 $7,500 $8,200 $8,900
RIDQ™ Total $42,500 $44,200 $48,800 $50,100 $51,500
= Override (user-entered value)
Italic = Cascaded from override

Before vs After Override

What happens when you override Monthly Rent from $4,138 to $4,400 at Year 3.

Base Calculation

Year 3 with 3% annual rent growth from $3,900/mo.

Monthly Rent $4,138
Annual Rent $49,656
CFBT $4,900
Year 5 CFBT (cascaded) $6,200

With Override

Year 3 rent manually set to $4,400/mo.

Monthly Rent $4,400
Annual Rent $52,800
CFBT $7,500
Year 5 CFBT (cascaded) $8,900

How Cascade Logic Works

1

You set an override — click any editable cell and enter a custom value. The cell turns yellow to show it's an override.

2

Override becomes the new base — all future years grow from the overridden value instead of the original calculated value.

3

Downstream metrics recalculate — changing rent affects NOI, which affects cash flow, which affects RIDQ™, ROIQ™, IRR, and more.

4

Clear to revert — remove the override to go back to the calculated value. Everything recalculates instantly.

What You Can Override

Property value & appreciation rate
Rent, other income & vacancy rate
Every expense: taxes, insurance, HOA, utilities, maintenance, management, CapEx
Mortgage rate, payment & extra principal
Tax rates, depreciation & commission
Equity, True Net Equity™ & reserves

60+ individual fields organized into 10 sections, all overridable per year.

Explore More Features

Dive deeper into what makes TWGREDAS™ the most complete deal analysis tool.

Included with All Apps

Property Database

30+ financial fields organized into 9 categories with auto-save and full change history.

Property Classification

Tag properties by investment strategy and property type. Filter and sort your entire portfolio.

Real-Time Calculations

27 key metrics across 5 categories computed instantly as you type, with clickable walkthroughs.

Portfolio Dashboard

Portfolio highlights, property cards, strategy and type breakdowns, overview charts, and cross-app features.

Included with Purchase of Deal Analyzer

Four-Stream Breakdown

See appreciation, cash flow, debt paydown, and tax benefits as both dollars (RIDQ™) and percentages (ROIQ™).

Analysis Dashboard

The TWGREDAS™ card, 6 input sections, and 9 interactive charts that update as you type.

Multi-Year Projections

Project all 80+ metrics across 40 years. See how returns compound and accelerate over time.

Override System

Click any cell to override its value. Changes cascade forward and recalculate all downstream metrics.

Amortization Schedule

480-month schedule with PMI tracking, extra principal modeling, and interactive balance charts.

Return Quadrants™

RIDQ™, ROIQ™, ROEQ™, and ROTNEQ™ with year navigation and reserve adjustments.

Yearly Summaries

All 40 years in one table: value, rent, cash flow, equity, RIDQ™, ROIQ™, cap rate, and IRR.

IRR Tables

Internal Rate of Return before and after taxes for every year from 1 to 40.

Model Any Scenario on Your Next Deal

Override rent bumps, expense changes, rate adjustments — and see how they cascade through 40 years.

View Pricing