Use EXCEL format to solve above (a) (b) questions. (method: EXCEL)

Detail workings needed. Thank you.

WWE Company has decided to install a new networked computer system. Initial discussions with the preferred supplier have indicated that the company faces the following two basic options. Option 1: WWE can purchase the system outright for an initial sum of RM45,000. This sum includes a maintenance contract from supplier for the first 12 months. At the end of first year and at the end of each subsequent year, WWE can purchase an annual maintenance contract for RM2,500. At the end of five years, the system will be obsolete and will have a scrap value of RM1,000. Option 2: Alternatively, WWE can lease the system from the computer suppliers. WWE will pay RM12,000 now and a further RM12,000 per annum at the end of each subsequent year. The second lease payment will be due at the end of the first year (to pay for the system through Year 2) and so on. At the end of the fifth year, the system will be scrapped, but its scrap value will go to the supplier not to WWE. The leasing fee also includes maintenance. (a) Tabulate the company's cash flows of Option 1 and Option 2 over 5 years. (6 marks) (b) Based on your answers in (a), calculate the relevant net present values for each option by discounting the cash flows at 10%. (12 marks)