please provide steps and method

Company Name Closing Price (Share Value) as on 31st December, 2015 2016 2017 2018 2014 2.0450 1.8150 2.3420 2.3800 2.7450 1 Galaxy 2 Diamond Foods 3 New Airlines 2.1530 2.5700 3.9800 2.0500 3.8500 1.6450 1.8230 1.9990 3.9800 2.2760 4 gas 2.7250 1.9810 1.9090 2.9320 1.9280 2.5900 1.8900 2.4520 2.6950 3.5800 1.6150 1.4790 2.8210 2.8050 2.9350 2.8500 2.2050 2.5090 2.9111 1.4200 5 Future telecom 6 Imperial 7 Royal Cements 8 Pearson Technology 9 Continental Hotels 10 United Utilities 3.4690 3.8500 3.8650 3.9000 3.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) = 8 % Risk Free Rate (rf) = 5% Hypothetical Value to the nearest place taken for academic purpose only 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 2014 to 2018 Make a table / graph of all the companies in terms of averages and standard deviation and based on that given highest rank to highest average (retums) and highest rank to lowest strandard deviation (risk) PART B 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 - (117,1/7...1/7) average yearly returns, return variances and standard deviations, Make a table / graph of all the companies in terms of averages and standard deviation and based on that given highest rank to highest average (returns) and highest rank to lowest strandard deviation (risk) 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) Company Name Closing Price (Share Value) as on 31st December, 2015 2016 2017 2018 2014 2.0450 1.8150 2.3420 2.3800 2.7450 1 Galaxy 2 Diamond Foods 3 New Airlines 2.1530 2.5700 3.9800 2.0500 3.8500 1.6450 1.8230 1.9990 3.9800 2.2760 4 gas 2.7250 1.9810 1.9090 2.9320 1.9280 2.5900 1.8900 2.4520 2.6950 3.5800 1.6150 1.4790 2.8210 2.8050 2.9350 2.8500 2.2050 2.5090 2.9111 1.4200 5 Future telecom 6 Imperial 7 Royal Cements 8 Pearson Technology 9 Continental Hotels 10 United Utilities 3.4690 3.8500 3.8650 3.9000 3.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) = 8 % Risk Free Rate (rf) = 5% Hypothetical Value to the nearest place taken for academic purpose only 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 2014 to 2018 Make a table / graph of all the companies in terms of averages and standard deviation and based on that given highest rank to highest average (retums) and highest rank to lowest strandard deviation (risk) PART B 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 - (117,1/7...1/7) average yearly returns, return variances and standard deviations, Make a table / graph of all the companies in terms of averages and standard deviation and based on that given highest rank to highest average (returns) and highest rank to lowest strandard deviation (risk) 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)