Please Use Excel For This Question!!! Thanks

Please Use Excel For This Question!!! Thanks

Please Use Excel For This Question!!! Thanks

2. Suppose a(t) = 0.015 (t 2)3 + 0.35 t + 1.12. Calculate values of a(t) 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 a(t) values to 3 decimal points and round the interest rates to 2 decimal points in percentage form. (4 + 3 = 7 marks)

2. Suppose alt) = 0.015 (t 2)3 +0.35 t + 1.12. Calculate values of a(t) and the effective rate of interest, i, 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 + 3 = 7 marks) 2. Suppose alt) = 0.015 (t 2)3 +0.35 t + 1.12. Calculate values of a(t) and the effective rate of interest, i, 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 + 3 = 7 marks)