Here are two trading companies; Capri Holdings, Facebook. Capri Holdings is the value stock (low beta, low p/e, low B/M, Low EPS growth rate, Low P/S) and Facebook is the growth stock (high beta, high p/e, high M/B, high EPS growth rate, high P/S). So high beta means a beta that is higher than the beta of the market, or 1. So high P/E ratio means a P/E ratio that is higher than the P/E of the market.

Below is a link with their monthly prices for the past five years.

• Capri Holdings

https://finance.yahoo.com/quote/CPRI/history?period1=1443744000&period2=1601596800&interval=1mo&filter=history&frequency=1mo

• Facebook

https://finance.yahoo.com/quote/FB/history?period1=1443744000&period2=1601596800&interval=1mo&filter=history&frequency=1mo

1. Estimate the average monthly return for each stock.
2. Estimate the standard deviation of monthly returns of each stock
3. Which stock has the highest and the lowest total risk? Highest and lowest Systematic risk?
4. Compare these two stocks (Risk-return trade-of).

Provide your answers in your discussion post and attach your Excel file where your estimations can be seen.