The Override System
Click any editable cell in the 40-year projection table to override the calculated value. Your change cascades forward through all subsequent months, recalculating every downstream metric automatically.
How the Override System Works
The most sophisticated modeling capability available in any real estate analysis tool.
| Field | M25 | M26 | M27 | M28 | M29 | M30 |
|---|---|---|---|---|---|---|
| Income | ||||||
| Rent | $2,334 | $2,334 | $2,500 | $2,500 | $2,500 | $2,500 |
| Other Income | $0 | $0 | $0 | $0 | $0 | $0 |
| Expenses | ||||||
| Vacancy | $117 | $117 | $125 | $125 | $125 | $125 |
| Property Taxes | $250 | $250 | $300 | $300 | $300 | $300 |
| Cash Flow | ||||||
| NOI | $1,380 | $1,380 | $1,488 | $1,488 | $1,488 | $1,488 |
| CFBT | $459 | $459 | $567 | $567 | $567 | $567 |
Override Any Editable Cell
The override table shows all 480 months (40 years), 12 at a time. Navigate between years and click any editable cell to set your own value.
Click any editable cell to enter a custom value. Press Enter to save or Escape to cancel. The cell highlights amber to show it's been overridden.
When you override Month 27's rent, that new value cascades forward to all subsequent months. No need to change each one individually. The override becomes the new base value going forward.
Computed fields (marked with an indigo left border) recalculate automatically. Change rent in Month 27, and NOI, cash flow, RIDQ™, and every other downstream metric updates instantly.
Clear any overridden cell to revert it (and all cascaded months after it) back to the original calculated value.
Track Actual Monthly Numbers
The override system isn't just for modeling — it's also for tracking reality.
Record What Actually Happened
As each month passes, override the projected values with your actual numbers. Did your tenant pay $4,100 instead of the projected $3,900? Click the rent cell for that month and enter $4,100.
- Track actual rent collected vs. projected
- Record real expense amounts as they occur
- See how reality compares to your projections
- Maintain a month-by-month history of your deal
Sophisticated Scenario Modeling
Model specific events that no other spreadsheet can handle. Want to see what happens if you raise rent by $200 in Year 3? If property taxes jump 15% in Year 5? If you do a renovation in Year 7?
- Model rent bumps at specific months
- Test tax increase scenarios
- Model renovation cost impact on future cash flow
- See how one change ripples through all 80+ metrics
Not Available in Other Spreadsheets
The ability to override individual cells at the month level, with automatic cascade and full downstream recalculation, is unique to TWGREDAS™. Most analysis tools only let you change assumptions at the top level. Here, you can be as granular as you want — change one field in one month and see exactly how it affects everything.
What Can You Override?
The override table is organized into sections. Here's what you can control.
Property Value
- Property Value
- Appreciation Rate
Income
- Rent
- Other Income
- Gross Potential Income
- Vacancy Rate
- Vacancy Loss
- Effective Gross Income
Expenses
- Property Taxes
- Insurance
- HOA
- Utilities
- Maintenance
- Management
- CapEx
- Other Expenses
NOI & Cash Flow
- NOI
- Debt Service
- CFBT
- True Cash Flow™
Mortgage
- Interest Rate
- Extra Principal
- PMI
Equity & Sale
- Equity
- True Net Equity™
- ROI if Sold
See What You've Changed
Quickly view all your overrides in one place, or reset everything to start fresh.
Override List View
A dedicated page lists every override you've set, grouped by year. See the section, field name, month number, and value for each override at a glance.
- Grouped by year for easy navigation
- Delete individual overrides with one click
- Total count badge shows how many you've set
Show Overrides Only
Toggle the "Show overrides only" filter on the override table to hide all non-overridden cells. Instantly see only the months and fields where you've made changes.
- Quick visual of all customizations
- Reset all overrides at once if needed
- Sparkline charts show 40-year trends per field
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.
Scenario Modeling
Model rent bumps, tax increases, renovations, or any scenario with month-level granularity.
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, Track Every Month
The override system gives you month-level control over your entire 40-year projection. No other analysis tool offers this level of granularity.