Question: Help, please Here are the returns on two stocks. Digital Executive Cheese Fruit January +14 +8 February -4 +2 March +6 +5 April +8 +12




Here are the returns on two stocks. Digital Executive Cheese Fruit January +14 +8 February -4 +2 March +6 +5 April +8 +12 May -5 +3 June +4 +6 July -3 -4 August --3 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 Reg A2 Reg B Reqc Calculate the variance and standard deviation of each stock. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Digital Cheese Retum 96 Executive Fruit Return 96 Variance Standard deviation 3 Regal Req A2 > Complete this question by entering your answers in the tabs below. Reg A1 Red A2 Req B Reqc Which stock is riskier if held on its own? Which stock is riskierit held on its own? ( Req A1 ReqB> Complete this question by entering your answers in the tabs below. Req A1 Reg A2 Reqa 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. Reg A1 Reg A2 Reg B ReqC 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
