Retirement planning in nominal dollars 2

Financial Modeling in Google Sheets

Erin Buchanan

Professor

Add annual withdrawal

= Initial Withdrawal Cell

Enter Annual Withdrawal

Financial Modeling in Google Sheets

Annual withdrawal with inflation

= Initial Withdrawal * (1 + Inflation) ^ (Year - 1)

Add Inflation Calculation

Financial Modeling in Google Sheets

How much money did you make?

= Fixed Income Beginning * Return on Fixed Income * (1 - Ordinary Tax Rate)

Income After Tax

Financial Modeling in Google Sheets

Making money part 2

= Stock Holding Beginning * Return on Stocks

Stock Return

Financial Modeling in Google Sheets

Add everything together

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

Year-End Totals

Financial Modeling in Google Sheets

Copy over formulas to finish

Drag to Fill

Financial Modeling in Google Sheets

Negative Values

Financial Modeling in Google Sheets

Adjust model parameters

Negative Values

Financial Modeling in Google Sheets

Increase initial balance

Twenty Increase

Forty Increase

First Increase is Negative

Second Increase is Positive

Financial Modeling in Google Sheets

Estimate your retirement!

Financial Modeling in Google Sheets

Preparing Video For Download...