$1.$ Gina deposits $$210$ each month in a retirement plan with an APR of $6\mathrm{.}75\%$ compounded monthly. Use Excel to determine how much will she have in the account after $25$ years.

Express your answer rounded correctly to the nearest cent!

Answer $=$ $

$2.$ Rachel has an opportunity to save $$230$ per month at an APR of $5\mathrm{.}45\%$ in a $401$K plan through work. She plans to retire in $20$ years. The income taxes are at $25\%$ for her.

$(1)$ Use Excel's FV function to determine how much her investment will be worth when she retires based on her contributions.

$($Express your answer rounded correctly to the nearest cent!$)$

$

$(2)$ How much will Rachel have deposited into the account by the time she retires?

$($Express your answe$)$

$$55200\mathrm{.}00$ correct

$(3)$ How much more money will Rachel have earned than what her investment amount was by the time she retires?

$($Express your answer rounded correctly to the nearest cent!$)$

$

$3.$ Isabel decided to put $$285$ in her savings account at the end of every month for $10$ years. If the account has an APR of $6\mathrm{.}8\%$ compounded monthly, determine the following amounts she has at the end of $10$ years.

Express your answer rounded correctly to the nearest cent!

Use Excel to find the balance after $10$ years: $

How much did Isabel invest total over the $10$ years? Total Invested: $

How much more is in the account after $10$ years than what Isabel invested? $

$4.$ sabel has an opportunity to save $$320$ per month at an APR of $7\mathrm{.}2\%$ in a $401$K plan through work. She plans to retire in $30$ years. The income taxes are at $27\%$ for her.

$(1)$ How much will Isabel's monthly take$-$home pay decrease? Review your course materials for help with this calculation.

$($Express your answer rounded correctly to the nearest cent!$)$

$5.$ Carlos has an opportunity to save $$335$ per month at an APR of $8\mathrm{.}3\%$ in a $401$K plan through work. He plans to retire in $10$ years. Carlos's company offers a $10\%$ matching contribution

$(1)$ How much will Carlos have deposited into the account by the time he retires?

$($Express your answer rounded correctly to the nearest cent!$)$

$$40200\mathrm{.}00$ correct

$(2)$ If Carlos's company offers a $10\%$ matching contribution, use Excel's FV function to determine how much his investment will be worth when he retires.

$($Express your answer rounded correctly to the nearest cent!$)$

$