$*$PLEASE ATTACH EXCEL DOCUMENT$*$

Assignment: Retirement Planning Model

Open Excel and look for the Retirement Planer Template. You may have to search for this template

using the search box at the top of the page. I would like you to recreate a simplified version of this

model. First don't worry about the "uncertainty" part of this model $-$ just build the basic model, which

will generate the table of cash flows shown at the bottom of the model and the chart at the top of the

page. I think this should be straight forward except that the table length will have to update to deal

with both i$)$ different retirement ages and ii$)$ years in retirement. This slightly more complicated than

the Amortization Table problem we looked at in class since each calculation will depend on which of

three time buckets you are in i$)$ working phase of life cycle, ii$)$ retirement phase of life cycle and iii$)$ uh $-$

post retirement $($that is to say, "dead"$).$

Notes: We are not trying to replicate the techniques used in the template $($Multiple sheets and named

formulas$).$ Your model should be on one sheet and use if statements to allow for an adjusting table

length. You should never hide sheets on any assignment.

In addition to a completed, tested, well formatted and well documented model, the Basic outputs that

I will be looking for:

A well formatted chart showing

a$.$ Savings Account balance $($use a scatter chart type to show this series$)$

b$.$ Savings deposited into the account. $($use a column chart type to show this series$)$

c$.$ Withdrawals from the account. $($again use a column chart but with a different color$)$

d$.$ A dynamic chart title similar to the one in the template.

A well formatted table, similar to the one in the Excel Template.