...I'd like a spreadsheet that could tell me what we need to do retire within 10 years.
It appears you are looking for something to help you analyze
- Current and projected income, including
- Salary & Wages
- Other Income (e.g., rental)
- Social Security
- Pension
- Current and projected spending, both pre- and post-retirement, including
- Taxes
- Living expenses
- "Specials," e.g. college, other major investments (house, car, etc.)
- Investments
- Investment performance (including "likely" and "reasonable worst case")
- Etc.
In other words, a complete financial view that allows you to explore various "what if we do ___?" and "what if ____ happens to us?" scenarios.
Before going much further...is the above at all close to what you seek?