Problem $1$

$\backslash$table$[[500\mathrm{.}00],[0\mathrm{.}1],[0\mathrm{.}05],[35],[25],[12]]$

How much money do you plan to save each period?

Expected return on your savings before retirement $($this is an EAR$)$

Expected return on your savings during retirement $($this is an EAR$)$

Years until your retirement

Years you plan to be in retirement $($how long your money needs to last$)$

How frequently do you save money each year? Annually $(1),$ quarterly $(4),$ or monthly $(12$ times each year$)?$

Problem $2$

Problem $3$

Problem $4$

Problem $5$

Problem $6$

Problem $7$

Problem $8$

Problem $9$

Expected return on your savings during retirement $($this is an APR$)$

Expected return on your savings before retirement $($this is an APR$)$

Amount you'll have in your account at retirement based on the amount you save each period $($answer should be about $$1,699,396).$

Amount you could spend each period during your retirement

How much money do you currently have in savings?

Amount you'll have in your account at retirement based on the amount you save each period plus the amount already in savings Amount you could spend each period during your retirement $($answer should be about $$17,948).$

$15n+n^{-1}$

How much money would you like to receive in each period in retirement $($e$.$g$.,$ if periods are monthly, what monthly income do you want in retirement$)?$ How much money will you need to have at retirement based on the amount above in cell C$2$O and the years you plan to be in retirement? $($answer should b Given your current savings, how much money would you need to save, starting today, to hit that target?