Financial Modeling in Google Sheets
Erin Buchanan
Professor
= Initial Withdrawal Cell
= Initial Withdrawal * (1 + Inflation) ^ (Year - 1)
= Fixed Income Beginning * Return on Fixed Income * (1 - Ordinary Tax Rate)
= Stock Holding Beginning * Return on Stocks
Year-End Stock Holding: = Stock Holding Beginning + Stock Return
Year-End Fixed Income Holding: = Fixed Income Beginning + Income After Tax
Total Year-End Balance: = Year-End Stock + Year-End Fixed Income
Financial Modeling in Google Sheets