Question: 1) Using the historical information below and the formulas learned in class, calculate the Historical Average Return, Variance, Standard Deviation and Coefficient of Variation (CV)

1) Using the historical information below and the formulas learned in class, calculate the Historical Average Return, Variance, Standard Deviation and Coefficient of Variation (CV) for the following stock. Year 2020 2019 2018 2017 2016 Return XYZ 22% 16% -8% 4% 10% A) Average Return (XYZ) = B) Variance (XYZ) = sn C) Standard Deviation XYZ = D) CVX = E) With 68% certainty, return for XYZ will fall within what range? Return XYZ 2) Using the data emailed to you earlier titled FNCE 325 Homework Data Assignment i complete the following: In Excel, using the format given in class: A) Compute the Daily Average Returns (Reward) and Daily Standard Deviations (Risk) for SLAB, GM and LULU. B) Compute the Annualized Average Returns (Reward), Annualized Standard Deviations (Risk) and the Annualized Coefficient of Variation (CV) for SLAB, GM and LULU. C) Please fill in the Table below: SLAB GM LULU Daily Average Return Daily Standard Deviation Annualized Average Return Annualized Standard Deviation Annualized Coefficient of Variation
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
