Instructions

The following are the general tasks that you must perform during this try$-$it:

Examine the formula in cell $B7.$

Insert a new worksheet and rename it My Investment Plan.

Enter the following data into the new worksheet:

a$.$ Enter Annual interest rate in cell A$1$ and $1\mathrm{.}5\%$ in cell B$1.$

b$.$ Enter Total to reach in $A2$ and $2000$ in cell $B2.$

C$.$ Enter Present value in A$3$ and $500$ in cell B$3.$

d$.$ Enter Monthly investment in cell A$4$ and $-50$ in cell B$4.$

e$.$ Enter Length of Investment in cell A$5.$

Create a formula in cell $B5$ that calculates the length of the investment by using the data in cells B$1,$ B$2,$ B$3,$ and B$4$ with the payment due at the end of each month.

Save the file as the same filename plus your initials.