PART 2:
So, now that I have the nifty option to switch between expense profiles, I think there is some confusion between the FI tab and "Retirement Planner" tab.
When i set my Georgia Salary to 75000, the FI tab says I can retire in 11.57 years, and the retirement planner tab says, I'll have 1.8M by age 99.
However, If I increase my Georgia Salary from 75000 to 100000, the FI tab says i can retire in 8 year, but the retirement tab says i will run out of money when I'm 75
It seems like I need to tell the retirement planner to base it's numbers off my Withdraw Rate (=FI!C4) instead of percentage of annual income. Any ideas how to make these more synchronized?
I looked at cell (J45) but i don't understand how it's getting the value. =IFERROR(Calculations!I45,"")???
I appreciate any help you can offer. Here is the latest working spreadsheet.