The World's Greatest Real Estate Deal Analysis Spreadsheet App™
Born from the legendary spreadsheet that real estate investors couldn't stop sharing — now rebuilt as a full-blown app. See all four return streams — appreciation, cash flow, debt paydown, and tax benefits — projected across 40 years with per-cell overrides, 480-month amortization, IRR, and 9 interactive charts.
Appreciation
$15,000
Cash Flow
$2,437
Debt Paydown
$4,191
Tax Benefits
$3,491
Total RIDQ™
$25,120/yr
40
Year Projections
80+
Metrics Per Year
4
Return Quadrants™
9
Interactive Charts
Most investors only track cash flow — they miss 75% of their return.
Cash flow gets all the attention, but it's only one of four ways real estate builds wealth. If you're making decisions based on cash flow alone, you're missing the appreciation, principal paydown, and tax benefits that often dwarf your rental income.
See the complete picture with all four return streams.
The Return in Dollars Quadrant™
Year 1 analysis of a $500,000 property — 25% down, 6.5% rate, $3,900/mo rent.
Appreciation
$15,000
Cash Flow
$2,437
Debt Paydown
$4,191
Tax Benefits
$3,491
Total
$25,120
© 2026 Return in Dollars Quadrant™ from Real Estate Financial Planner LLC
Four Streams of Real Estate Return
Property value growth. At 3% on a $500K property, that's $15,000 in Year 1 alone.
Net rental income after all expenses and mortgage payments.
Principal reduction your tenants pay for you — $4,191 in Year 1.
Depreciation-based cash flow from your income tax savings.
Return Quadrant™ Over 10 Years
See how all four return streams compound over time.
Property value increase over time.
Net income after expenses & mortgage.
Principal reduction tenants pay for you.
Depreciation-based tax savings.
See How Returns Compound Over 40 Years
Key metrics at years 1, 5, 10, 20, and 30 — all from a single $500K property.
| Metric | Year 1 | Year 5 | Year 10 | Year 20 | Year 30 |
|---|---|---|---|---|---|
| Property Value | $515,000 | $579,637 | $671,958 | $903,056 | $1,213,631 |
| Total Equity | $144,191 | $228,596 | $354,048 | $694,311 | $1,213,631 |
| RIDQ™ Total | $25,120 | $32,119 | $42,423 | $69,863 | $107,143 |
| ROIQ™ Total | 17.32% | 22.15% | 29.26% | 48.18% | 73.89% |
| Cash Flow (CFBT) | $2,437 | $6,313 | $11,849 | $25,706 | $44,328 |
| Loan Balance | $370,809 | $351,041 | $317,910 | $208,745 | $0 |
How It Works
Three steps to a complete 40-year analysis.
Enter Your Property Details
Enter purchase price, mortgage details, rent, and expenses — or select an existing property from your account.
Run the Analysis Engine
TWGREDAS™ computes 80+ metrics per year across 40 years, builds amortization, calculates IRR, and generates Return Quadrants™.
Explore 40 Years of Returns
Browse projections, override any cell, compare scenarios, and explore 9 interactive charts.
Explore 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.
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.
See All Four Return Streams on Any Deal
Run the complete TWGREDAS™ analysis — 40-year projections, Return Quadrants™, amortization, IRR, and more.