AAMS1773 QUANTITATIVE STUDIES Question 4 The average marks obtained by the first-year diploma students in an Advanced Excel short course for the past three trimester years as shown below: Year Semester Second Third 2018 2019 First 65 70 72 85 61 69 78 80 78 75 79 2020 2021 (4 marks) (1) Compute the moving average trend, (ii) Calculate the average seasonal variations using additive model (ii) Forecast the average mark for the first semester of the year 2022. (6 marks) (3 marks) b) The following table shows the two different portions of saving from a couple. Saving (RM) Interest rate per year Duration 3500 2.2% 2 years 20XXO 2.5% 6 months (1) If the interest rate for the saving of RM3500 is based on simple interest while the interest rate for the RM2000 is compounded monthly calculate the total interest earned. (3 marks) (ii) After six months of the saving an additional RM150 monthly saving is saved to RM2000 for the next two years, find the total interest eamed at the end of the investment period (4 marks) c) A new investor is considering investing in the Real Estate Investment Trust (REIT) with the following cash flow Year REIT investment Cash Inflow Cash Outflow 0 RM20000 RM15000 RM8000 RM12000 RM1000 RM8000 RM5000 If the cost of capital is 15% per annum, advise the investor on the course of action (5 marks) [Total: 25 marks 1