Question: Kindly solve the given question with the same tables structure Problem 11-19 Diversification (L03) Here are the returns on two stocks. January February March April
Kindly solve the given question with the same tables structure





Problem 11-19 Diversification (L03) Here are the returns on two stocks. January February March April May June July August Digital Cheese +14 -3 +5 +7 -4 +3 -2 -8 Executive Fruit +7 +1 +4 +13 +2 +5 -3 -2 Required: a-1. Calculate the variance and standard deviation of each stock. a-2. Which stock is riskier if held on its own? b. Now calculate the returns in each month of a portfolio that invests an equal amount each month in the two stocks. c. Is the variance more or less than halfway between the variance of the two individual stocks? Complete this question by entering your answers in the tabs below. Reg A1 Req A2 Reg B Reg C Calculate the variance and standard deviation of each stock. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Digital Cheese Retum Executive Fruit Return Variance % % Standard deviation Reg A1 Req A2 > Complete this question by entering your answers in the tabs below. Req A1 Reg A2 Reg B Reg C Which stock is riskier if held on its own? Which stock is riskier if held on its own? Reg A1 Req A2 Reg B ReqC Now calculate the returns in each month of a portfolio that invests an equal amount each month in the two stocks. (Negative amounts should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) Month Portfolio Return January February March April May June July August Complete this question by entering your answers in the tabs below. Req A1 Req A2 Req B Reg C Is the variance more or less than halfway between the variance of the two individual stocks? Is the variance more or less than halfway between the variance of the two individual stocks?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
