The below data shows the price share for a company.. Could you please help me in answering the following?

1. Calculate the Expected rate of return

2. Calculate the variance and standard deviation

3. Calculate the sharp ratio

Transcribed Image Text:

Date 11/28/2019 12/31/2019 1/30/2020 2/27/2020 3/31/2020 4/30/2020 5/31/2020 6/30/2020 7/28/2020 8/31/2020 9/30/2020 10/29/2020 11/30/2020 DIVIDENDS Annonced Date 12/15/2021 12/15/2020 12/9/2019 Open 49.95 50.1 47.55 46.1 45.75 48.8 52 53.3 54 55.2 53.4 53 54.8 Due Date 4/12/2022 4/13/2021 4/5/2020 High 49.95 50.1 47.6 46.45 48.75 49.25 52 53.4 54 55.2 53.5 53.1 55.9 Distribution Date 4/20/2022 4/21/2021 4/13/2020 Low 49 49.4 47.2 45.6 45.75 48.55 50 51.6 53.5 53.7 52.8 51.6 54.5 Distribution Way Account Transfer Account Transfer Account Transfer Close 49.25 49.5 47.5 45.8 47 -- 49.1 50.4 51.8 53.6 53.7 52.9 51.6 55.9 Amount 1 1 0.85 Change % Change -0.6 -0.6 0 -0.15 1.25 0.35 1.35 -1.2 -0.4 -1.5 -0.2 -1.9 1.1 -1.2 -1.2 0 -0.33 2.73 0.72 2.75 -2.26 -0.74 -2.72 -0.38 -3.55 2.01 18,571,035.85 32,268,208.60 45,712,395.65 29,337,471.50 Volume Trade ($) Volume Trade (SAR) 245,720 12,131,250.15 460,222 22,830,994.00 391,954 702,610 964,771 601,544 573,194 1,146,218 189,524 1,076,298 676,012 828,105 1,600,691 29,192,140.00 59,851,747.90 10,174,248.40 58,513,388.80 35,856,814.70 43,365,090.60 88,767,937.80 NO. Of Trades 595 1,363 596 934 2,868 1,061 2,126 3,214 782 1,946 2,006 1,544 3,052 Date 11/28/2019 12/31/2019 1/30/2020 2/27/2020 3/31/2020 4/30/2020 5/31/2020 6/30/2020 7/28/2020 8/31/2020 9/30/2020 10/29/2020 11/30/2020 DIVIDENDS Annonced Date 12/15/2021 12/15/2020 12/9/2019 Open 49.95 50.1 47.55 46.1 45.75 48.8 52 53.3 54 55.2 53.4 53 54.8 Due Date 4/12/2022 4/13/2021 4/5/2020 High 49.95 50.1 47.6 46.45 48.75 49.25 52 53.4 54 55.2 53.5 53.1 55.9 Distribution Date 4/20/2022 4/21/2021 4/13/2020 Low 49 49.4 47.2 45.6 45.75 48.55 50 51.6 53.5 53.7 52.8 51.6 54.5 Distribution Way Account Transfer Account Transfer Account Transfer Close 49.25 49.5 47.5 45.8 47 -- 49.1 50.4 51.8 53.6 53.7 52.9 51.6 55.9 Amount 1 1 0.85 Change % Change -0.6 -0.6 0 -0.15 1.25 0.35 1.35 -1.2 -0.4 -1.5 -0.2 -1.9 1.1 -1.2 -1.2 0 -0.33 2.73 0.72 2.75 -2.26 -0.74 -2.72 -0.38 -3.55 2.01 18,571,035.85 32,268,208.60 45,712,395.65 29,337,471.50 Volume Trade ($) Volume Trade (SAR) 245,720 12,131,250.15 460,222 22,830,994.00 391,954 702,610 964,771 601,544 573,194 1,146,218 189,524 1,076,298 676,012 828,105 1,600,691 29,192,140.00 59,851,747.90 10,174,248.40 58,513,388.80 35,856,814.70 43,365,090.60 88,767,937.80 NO. Of Trades 595 1,363 596 934 2,868 1,061 2,126 3,214 782 1,946 2,006 1,544 3,052