Instruction: You are a portfolio investment analyst at Goldman Sachs. Your investment unit manages two equity portfolios - one portfolio, named P1, consists of two stock assets (Apple (AAPL) and Microsoft (Ticker: MSFT)) and the other portfolio, named P2, consists of five stocks (Disney(Ticker:DIS), Boeing(Ticker:BA), Amazon (Ticker:AMZN), Tesla(Ticker:TSLA), Netflix (Ticker:NFLX)). Now you are asked to compute two portfolio returns and risk measures. To do this, first download monthly stock prices from Dec.2009 to Dec. 2018 from Bloomberg and compute monthly stock returns from Jan. 2010 to Dec. 2018.1 Problem 1. Compute the respective average, standard deviation, and covariance of monthly stock returns.2 Problem 2. Make two covariance matrices using two portfolio components. Note that you have to make a completed form of a matrix as below.3 Ep1 = 1 I OAPL = 0 AAPL,AAPL O AAPL,MSFT = OMSFT,AAPL OMSFT, AAPL = 0 AAPL,MSFT OM SFT = OMSFT,MSFT ODIS, AMZN 2 OBIS ODIS,BA ODIS,TLSA ODIS,NFLX OBA, DI , AMZN OBA,TLSA OBA,NFLX EP2 = | OAMZN,DIS CAMZN.BA CMZN OAMZN.TLSA OAMZN.NFLX OTLSA,DIS OTLSA,BA OTLSA, AMZN OILSA OTLSA,,NFLX KONFLX.DIS ONFLX.BA ONFLX.AMZN ONFLX,TLSA OFLX 2 Instruction: You are a portfolio investment analyst at Goldman Sachs. Your investment unit manages two equity portfolios - one portfolio, named P1, consists of two stock assets (Apple (AAPL) and Microsoft (Ticker: MSFT)) and the other portfolio, named P2, consists of five stocks (Disney(Ticker:DIS), Boeing(Ticker:BA), Amazon (Ticker:AMZN), Tesla(Ticker:TSLA), Netflix (Ticker:NFLX)). Now you are asked to compute two portfolio returns and risk measures. To do this, first download monthly stock prices from Dec.2009 to Dec. 2018 from Bloomberg and compute monthly stock returns from Jan. 2010 to Dec. 2018.1 Problem 1. Compute the respective average, standard deviation, and covariance of monthly stock returns.2 Problem 2. Make two covariance matrices using two portfolio components. Note that you have to make a completed form of a matrix as below.3 Ep1 = 1 I OAPL = 0 AAPL,AAPL O AAPL,MSFT = OMSFT,AAPL OMSFT, AAPL = 0 AAPL,MSFT OM SFT = OMSFT,MSFT ODIS, AMZN 2 OBIS ODIS,BA ODIS,TLSA ODIS,NFLX OBA, DI , AMZN OBA,TLSA OBA,NFLX EP2 = | OAMZN,DIS CAMZN.BA CMZN OAMZN.TLSA OAMZN.NFLX OTLSA,DIS OTLSA,BA OTLSA, AMZN OILSA OTLSA,,NFLX KONFLX.DIS ONFLX.BA ONFLX.AMZN ONFLX,TLSA OFLX 2