I need it as soon as possible the submission is very soon please.
Closing Price (Share Value) as on 31st December, 2016 2017 2018 2019 2020 4 Company Name 1 Sweets of Oman 2 Oman Refreshments 3 AS Saffa Foods Muscat Gases Oman Oil Omantel 7 Financial Services 8 Al Omaniya Financial Services Oman Cements 10 Shell Oman LOOOO 1.0450 0.8150 1.3420 1.3800 1.7450 1.1530 1.5700 2.9800 3.0500 2.8500 1.5450 1.6230 1.0990 3.7800 1.2760 2.2250 1.8810 1.3090 2.4320 1.3280 2.5200 1.8700 2.4820 2.6050 2.5800 2.6150 1.4790 1.8210 1.8050 1.9350 2.4500 1.2050 1.5090 2.4111 0.4200 2.4690 2.4500 0.8650 1.9000 0.8500 2.0890 1.8320 1.2450 1.2240 1.0280 3.6900 2.7930 2.7930 2.7500 2.3400 Assume: Market Returns (Rm) = 9% Risk Free Rate (rf) = 4% Hypothetical Value to the nearest place taken for academic purpose only Task 1 1) Calculate for each stock Average yearly return, (for all 10 companies) - arithmetic mean ONLY Its return variance and; (for all 10 companies) Standard deviations throughout the period (for all 10 companies) Comment and analyze on the results calculated above based on the ranking which stock is having the highest yearly returns and standard deviations of individual stocks from 2016 to 2020 (3 marks for calculations + 2 marks for analysis and comments) 2) Construct three types of portfolios of equal weights Assuming that each stock has equal weight in the portfolio, calculate Portfolio A any combination of any three companies, (1/3, 1/3, 1/3 - weights x returns) & (weights x standard deviation) Portfolio B any combination of any five companies, and (1/5, 1/5, 1/5, 1/5, 1/5 - (weights x returns) & (weights x standard deviation) Portfolio C any combination of any 7 companies -(1/7, 1/7...1/7) average yearly returns, return variances and standard deviations, Comment and analyze based on the rankings which portfolio has the maximum returns and which portfolio is having the minimum standard deviation. Give the reasons (Economic reasons)