Assignment $1$

a$.$ Suppose you plan on retirine $40$ years from now. After retiring, you believe you will live $20$ more

years and will require $$100,000$ per year. Let's assume for now that all your investing will be in a

mutual fund that returns $9\%$ annually. You also have no initial value in the account. What is the

annual imvestment required to meet retirement needs? Assume that your annual investment is made

at the end of year and the retirement spending $$100,000$ is needed at the beginning of each year

after retiring. Build a table that shows your account balance vear by year over your work and

retirement life, Graphically illustrate the account balance at the end of each year. $($Make a eraph of

the column "Year" and the column "End Balance", make sure you label the $x-$axis and $y-$axis and title

your graph so it can be understood by people without having to ask what it represents$).$

b$.$ Make a TWO$-$WAY data table to show the annual saving for your retirement plan $($assuming you

have $$0$ when you open your account$).$ The two changing variables are: return to your investment

before you retire and return to your investment after you retire. Ust possible returns to your

investment AFTER you retire in the ROW $($make the range between $4\%-9\%.$ Step value: $1\%).$ Ust

possible returns to your investment before you retire in a column $($range from $6\%-15\%.$ Step value:

$1\%).$ NOTE: Think $-$ what data needs to be referenced in the row and column inputs.