Calculation $3$

As part of your retirement savings plan, you've determined that you need to have $$300,000$ in

$15$ years to be on track.

If you invest $$1150$ per month, what rate of return do you need to achieve this goal?

Enter your formula in cell A$9.$

Calculation $4$

Your friend Sally has a different savings plan for retirement. She determined that she needs to

save $$350,000$ in $15$ years to be on track.

If Sally invests $$14,000$ per year, what rate of return does she need to achieve her goal?

Enter your formula in cell A$12.$

Calculation $5$

You have a savings plan to invest $$2,000$ per month. You expect the rate of return to be $5\mathrm{.}5\%.$

After $20$ years how much will be in your savings?

Enter your formula in cell A$15.$