Part 1: Using the data from 2016 through the end of 2021 (not using the 2022 observations), compute and report the following items for PG stock

1. average excess return 2. return volatility 3. Sharpe ratio 4. CAPM alpha & beta 5. CAPM R2 (R-squared) 6. Treynor ratio

Analysis: Based on the above calculations, would this asset have been a good investment over the 2016-2021 period? Why or why not?

Part 2: Compute the average excess market return for the first half of 2022. With that number in hand, and along with the beta that you computed in Part 1, please provide the expected excess stock return for PG for this period according to the CAPM, ?iE[RM ?Rf ]. Compare this number to the firm's actual average excess return for the first half of 2022. Did PG perform better or worse than expected?

Note: Please complete in Excel. I'm not sure how to do it in Excel.

\f26 1/31/2018 5.57 -5.43 27 2/28/2018 -3.65 -9.17 28 3/31/2018 -2.35 0.86 29 4/30/2018 0.28 -8.02 30 5/31/2018 2.65 1.01 31 6/30/2018 0.48 6.54 32 7/31/2018 3.19 4.4 33 8/31/2018 3.44 2.4 34 9/30/2018 0.06 0.19 35 10/31/2018 -7.68 7.31 36 11/30/2018 1.69 6.39 37 12/31/2018 -9.57 -2.94 38 1/31/2019 8.4 5.57 39 2/28/2019 3.4 1.98 40 3/31/2019 1.1 5.39 41 4/30/2019 3.97 2.85 42 5/31/2019 -6.94 -3.56 43 6/30/2019 6.93 6.37 44 7/31/2019 1.19 8.16 45 8/31/2019 -2.58 1.7 46 9/30/2019 1.43 3.27 47 10/31/2019 2.06 0.58 48 11/30/2019 3.87 -2.09 49 12/31/2019 2.77 2.19\f\f