ccalculate all returns, percent part,and all red part
View + O 10 13 14 15 16 17 18 19 20 37 38 39 40 41 42 43 44 45 46 47 48 49 50 54 59 60 61 62 64 65 66 67 68 69 SUM 65% Zoom A Sheet1 DATE 2018-08-01 2018-09-01 2018-10-01 2018-11-01 2018-12-01 2019-01-01 2019-02-01 2019-03-01 2019-04-01 2019-05-01 2019-06-01 2019-07-01 2019-08-01 2019-09-01 2019-10-01 2019-11-01 2019-12-01 2020-01-01 2020-02-01 2020-03-01 2020-04-01 2020-05-01 2020-06-01 2020-07-01 2020-08-01 2020-09-01 2020-10-01 2020-11-01 2020-12-01 2021-01-01 2021-02-01 2021-03-01 2021-04-01 2021-05-01 2021-06-01 2021-07-01 2021-08-01 2021-09-01 2021-10-01 2021-11-01 2021-12-01 2022-01-01 2022-02-01 2022-03-01 2022-04-01 2022-05-01 2022-06-01 B 33.76 31.36 32.57 Closing Price S&P/TSX Imperial oil limited (USD) 31.66 31.01 24.91 28 28 26.99 27.46 28.96 26.87 27.96 27.05 24.12 26.04 24.68 24.80 26.50 23.72 22.15 10.86 15.58 15.62 16.18 15.63 16.37 11.92 13.14 17.79 19.09 19.20 22.21 24 20 29.47 33.54 31.06 27.51 C Imperial oil imited 26.39 31.82 34.49 33.78 36.19 42.00 45.38 48.13 50.19 55.35 Sheet2 Standard Deviation S&P/TSX Index Returns Standard Deviation Company Returns Correlation of TSX and Company Returns Beta Risk-Free Rate Market Risk Premium Expected Rate of Return GRAPH 28.05 29.10 28.08 26.82 22.87 25.73 24.46 24,72 26.40 24.27 25.27 15.03 25.02 22.41 23.78 22.87 23.15 24,34 21.92 20.30 10.43 15.10 14.37 14.97 14.72 15.47 11.26 12.49 16.51 18.11 18.28 21.10 23.23 28.04 31.96 29.44 26.69 25.73 30.77 33.30 32.52 35.48 4048 44.36 47.80 49.90 55.18 46.88 SD AVERAGE P SD Corr Beta D S&P/TSX rm -rf Add Category Sheet3 Returns, percent E Imperial all imiter Date Formula FINAL REMARK: Before you submit the file, please delete all notes in red color of this template. Finally, please "Print Preview your document and save it so that it can be printed in a clear and easy to follow format. This is important because when you save your assignment as a pdf file it will be saved as if it were printed. Note that you may have to reformat some of the columns so that it fits nicely on a page or pages MIN Pivot Table F G Source for S&P/TSK Index Price Data: Yahoo finance canada Source for Company Price Data: Yahoo finance canada Formula for returns: r-(p2-p1/p1 H Sample return calculation Source Calculation || MAX + Insert P E A o Table Chart Text Shape Media COUNTA 178 @ Comment 59 Collaborate Format Organize Ov V View + O 10 13 14 15 16 17 18 19 20 37 38 39 40 41 42 43 44 45 46 47 48 49 50 54 59 60 61 62 64 65 66 67 68 69 SUM 65% Zoom A Sheet1 DATE 2018-08-01 2018-09-01 2018-10-01 2018-11-01 2018-12-01 2019-01-01 2019-02-01 2019-03-01 2019-04-01 2019-05-01 2019-06-01 2019-07-01 2019-08-01 2019-09-01 2019-10-01 2019-11-01 2019-12-01 2020-01-01 2020-02-01 2020-03-01 2020-04-01 2020-05-01 2020-06-01 2020-07-01 2020-08-01 2020-09-01 2020-10-01 2020-11-01 2020-12-01 2021-01-01 2021-02-01 2021-03-01 2021-04-01 2021-05-01 2021-06-01 2021-07-01 2021-08-01 2021-09-01 2021-10-01 2021-11-01 2021-12-01 2022-01-01 2022-02-01 2022-03-01 2022-04-01 2022-05-01 2022-06-01 B 33.76 31.36 32.57 Closing Price S&P/TSX Imperial oil limited (USD) 31.66 31.01 24.91 28 28 26.99 27.46 28.96 26.87 27.96 27.05 24.12 26.04 24.68 24.80 26.50 23.72 22.15 10.86 15.58 15.62 16.18 15.63 16.37 11.92 13.14 17.79 19.09 19.20 22.21 24 20 29.47 33.54 31.06 27.51 C Imperial oil imited 26.39 31.82 34.49 33.78 36.19 42.00 45.38 48.13 50.19 55.35 Sheet2 Standard Deviation S&P/TSX Index Returns Standard Deviation Company Returns Correlation of TSX and Company Returns Beta Risk-Free Rate Market Risk Premium Expected Rate of Return GRAPH 28.05 29.10 28.08 26.82 22.87 25.73 24.46 24,72 26.40 24.27 25.27 15.03 25.02 22.41 23.78 22.87 23.15 24,34 21.92 20.30 10.43 15.10 14.37 14.97 14.72 15.47 11.26 12.49 16.51 18.11 18.28 21.10 23.23 28.04 31.96 29.44 26.69 25.73 30.77 33.30 32.52 35.48 4048 44.36 47.80 49.90 55.18 46.88 SD AVERAGE P SD Corr Beta D S&P/TSX rm -rf Add Category Sheet3 Returns, percent E Imperial all imiter Date Formula FINAL REMARK: Before you submit the file, please delete all notes in red color of this template. Finally, please "Print Preview your document and save it so that it can be printed in a clear and easy to follow format. This is important because when you save your assignment as a pdf file it will be saved as if it were printed. Note that you may have to reformat some of the columns so that it fits nicely on a page or pages MIN Pivot Table F G Source for S&P/TSK Index Price Data: Yahoo finance canada Source for Company Price Data: Yahoo finance canada Formula for returns: r-(p2-p1/p1 H Sample return calculation Source Calculation || MAX + Insert P E A o Table Chart Text Shape Media COUNTA 178 @ Comment 59 Collaborate Format Organize Ov V
