In the first problem, we will make deposits at the end of the year. In cell A$7,$ type in your formula to continue the time from $1$ to $30$ and fill down the formula. In B$6,$ type in your beginning balance of $$0.$ You should get $"-"$ as your answer since this is the spreadsheet's way of saying $"0".$ In cell C$6,$ type in your interest formula using an interest rate of $3\mathrm{.}00\%($Note: remember NOT to locate A$6$ for time$).$ You should have gotten $"-"$ for your interest $($Note: $"-"$ means zero$).$ In cell D$6$ type in your deposit of $$1000.$ Now go to E$6,$ and type in your ending balance formula.

In this problem, we will now make deposits at the beginning of the year. The only columns we will need to interchange are the interest and deposit columns. Time and ending balance formula's stay the same. Do not change your beginning balance of $$0\mathrm{.}00.$ In cell C$5,$ change interest to deposit, and in cell D$5$ change deposit to interest. In cell C$6$ type in your deposit of $$1800\mathrm{.}00.$ Now go to D$6$ and type in your interest formula using an interest rate of $8\mathrm{.}00\%($Note: remember NOT to use A$6$ for time and to do remember to include both the beginning balance and deposit when figuring your interest$).$ You should have gotten $ $144\mathrm{.}00$ for your interest. Now go to E$6,$ and type in your ending balance formula.

What is the answer in cell E$6?$

$($b$)$Carry over your ending balance for year $1$ over to the beginning balance for years $2.$ Now fill down your formula's for each of the columns. The ending balance in the account after $15$ years should be $$52783\mathrm{.}71$

What is your total amount in the account after $30$ years?

What is the total amount of deposits made in the account during the $30$ years?

What is the total amount of interest earned on the account during the $30$ years?