Design an Excel financial model that can help to answer the following parts (part 1).

5 marks will be allocated for the presentation and clarity of your model (e.g., if there are clear headings, clear arrangement for input cells, appropriate use of colors, have some degree of flexibility, generate warning messages for wrong user inputs, etc.).

Part 1 (8 marks)

Suppose you receive $850 at the end of each year for the next four years. a. (2 marks) If the interest rate is 6% per annum (interest paid annually), what is the present value of these cash flows? b. (2 marks) What is the future value in four years of the present value you computed in part (a)? c. (2 marks) Assume that no withdrawals are made from the savings account until the end of the fourth year. What is the interest component? d. (2 marks) Compute the effective 4 years rate (total interest over 4 years). Hint: EFFECT function is not appropriate for this part as it is often used to compute an effective annual interest rate from a nominal interest rate.