Question: Here are the returns on two stocks. Digital Cheese -17 Executive Fruit +7 +4 January February March April May June July August o w w




Here are the returns on two stocks. Digital Cheese -17 Executive Fruit +7 +4 January February March April May June July August o w w his w 33 Required: 2-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. Req A1 Reg A2 ReqB ReqC Calculate the variance and standard deviation of each stock. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Variance Standard deviation Digital Cheese Retum 53.64% 2.877 25 Executive Fruit Return 27.56% 5.25 Reg A1 Req A2 > Complete this question by entering your answers in the tabs below. Reg A1 Reg A2 ReqB Reqc Which stock is riskier if held on its own? Which stock is riskier if held on its own? Executive Fruit Complete this question by entering your answers in the tabs below. Reg A1 Reg 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 January February March April May June July August Portfolio Return 76.56 14.06 1.56 60.06 14.06 0.56 7.56 68.06 Complete this question by entering your answers in the tabs below. Req A1 Reg A2 Reg 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
