Computer Questions - Use a spreadsheet to answer the following questions (see helpful hints to get you started on Excel for part of question 7) 8. To get an idea just how powerful compound interest is compared to simple interest, calculate the accumulated value of a $5000 deposit after 0.10,0.50, 0.80, 1, 3, 6, 12, 20, 30, 40 and 50 years using rates of interest of 4%, 7% and 10%. For each interest rate, do SIX calculations: one assuming simple interest, and four assuming compound interest rates of i, (2), {{4) and {(12), along with calculating the difference between the accumulated values under compound interest at and under simple interest (just the vs. simple interest, not the lm), etc) (9 marks) 9. Suppose a(t) = 0.0015 (t-3)4 +0.042 (t - 2)3 + 1.2145. Calculate values of alt) and the effective rate of interest, it for integer values of t from 0 to 50 (no need for an effective rate at t=0). Then graph the values of the effective rates of interest (see Excel graphing helpful hints). Round the alt) values to 3 decimal points and round the interest rates to 2 decimal points in percentage form. (4 + 2 = 6 marks) S Total = 70 marks