Provided in the following data file is the recent excess returns for the market portfolio and for
Question:
Provided in the following data file is the recent excess returns for the market portfolio and for 26 companies-one for every letter of the alphabet. Analyze PG stock using the CAPM style of analysis.
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 calculations, would this asset have been a good investment over the 2016-2021 period? Why or why not?
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 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?
Equity Asset Valuation
ISBN: 978-0470571439
2nd Edition
Authors: Jerald E. Pinto, Elaine Henry, Thomas R. Robinson, John D. Stowe, Abby Cohen