$3.$ Sue has $$10,000$ to invest for four years. She intends to reinvest the interest at the end of each year so the funds will accumulate for a holiday at the end of the four years. Using an Excel workbook, show the following calculations:

a$)$ Construct a table to calculate the principal plus interest at the end of each of the four years $$ Yr$1,$ Yr$2,$ Yr$3,$ Yr$4,$ if the money is invested at $8\%$ per annum and calculated on a simple interest basis.

b$)$ Construct a table to calculate the principal plus interest at the end of each of the four years $$ Yr$1,$ Yr$2,$ Yr$3,$ Yr$4,$ if the money is invested at $8\%$ per annum and calculated on a compound interest basis and compounded annually.

c$)$ Explain why she has a higher closing balance if she chooses the compound interest method.