Question: Compute the annualized average volatility and annualized average return for the stock in excel. pls show the calculation. Data: Months date price volume return Share
Compute the annualized average volatility and annualized average return for the stock in excel. pls show the calculation.
Data:

Months date price volume return Share outstanding 1 1/29/2016 62.24000168 1735493-0.072836928 582234 2 2/29/2016 67.69999695 1281537| 0.087724857 582322 3 3/31/2016 76.54000092 14200151 0.130576134| 582322 4 4/29/2016| 77.72000122 1217809 0.025476879 583892 5 5/31/2016 72.51000214 1121518] -0.067035496 583892 6 6/30/2016| 75.80999756 1060871] 0.045510899| 583892 7 7/29/2016 82.76000214 1038857) 0.101833597| 583892 8 8/31/2016 81.94999695 745406 -0.009787399 584231 9 9/30/2016 88.76999664 992173] 0.083221473 584231 10 10/31/2016 83.45999908 1055574 -0.051143378 584231 11 11/30/2016 95.55999756 1210447] 0.144979611 585073 12 12/30/2016 92.73999786 888398 -0.029510252 585073 13 1/31/2017] 95.66000366 941043 0.039788719 585073 14 2/28/2017| 96.66000366| 851079 0.01045369 586486 15 3/31/2017| 92.76000214 1424344 -0.040347625 586486 16 4/28/2017| 102.2600021 1116129 0.110715821 589157 17 5/31/2017 105.4300003 1039277 0.030999394 589090 18 6/30/2017 107.4599991 1050877 0.01925447 589090 19 7/31/2017| 113.9499969 8682221 0.06765306 590973 20 8/31/2017| 117.4899979 6652291 0.031066267 590973 21 9/29/2017| 124.7099991 641371 0.06145205 590973 22 10/31/2017 135.8000031 9252591 0.095180854 590973 23 11/30/2017 141.1499939 611220 0.039396103 594934 24 12/29/2017 157.5800018 747223 0.116401054 594934 25 1/31/2018 162.7799988 1348971 0.037948959 594934 26 2/28/2018 154.6300049 1268759 -0.05006754 597626 27 3/29/2018 147.3800049 1253015 -0.046886113 597626 28 4/30/2018 144.3600006 1182373 -0.015198834 597950 29 5/31/2018 151.9100037 916214 0.052299827 597905 30 6/29/2018 135.6699982 9067371 -0.106905438 31 7/31/2018| 143.8000031 985777| 0.066263765 597905 32 8/31/2018] 138.8500061 960986 -0.034422789 594325 33 9/28/2018 152.4900055 806492 0.098235495 594325 34 10/31/2018 121.3199997 1818563 -0.19876717 590107 35 11/30/2018 135.6699982 1264152 0.118282214 590107 36 12/31/2018 127.0699997 1104776 -0.063389093 590107 37 1/31/2019 133.1600037 1192819 0.054694295| 590107 38 2/28/2019 137.3399963 789580 0.031390753 575543 39 3/29/2019 135.4900055 811098 -0.013470153 575543 40 4/30/2019 139.4199982 838954 0.035353106 571876 41 5/31/2019 119.8099976 1079066 -0.140654147 571876 42 6/28/2019 136.2899933 800602 0.137551084 571876 43 7/31/2019 131.6699982| 903708 -0.026340857 571876 44 8/30/2019 119 892818 -0.096225396| 562589 45 9/30/2019 126.3099976 801601 0.061428551 562589 46 10/31/2019 137.8000031 1004839| 0.099121258 552658 47 11/29/2019 144.7299957 638287] 0.050290223 552658 48 12/31/2019 147.6799927 551493 0.020382762 552658 49 1/31/2020 131.3500061 6452151 -0.103602298 552658 50 2/28/2020 124.2399979 734189 -0.054130245 550083 51 3/31/2020 116.0400009 1576641 -0.066001266 550083 52 4/30/2020 116.3799973 1165673| 0.011806242 541239 53 5/29/2020 120.1299973 8477251 0.032222033 541239 54 6/30/2020 126.5 8415601 0.053025912 541239 55 7/31/2020 132.8800049 669587 0.058577113 541239 56 8/31/2020 142.3099976 574089 0.070966229 541507 57 9/30/2020 149.1499939 748559 0.048064061 541507 58 10/30/2020 157.0500031 757494 0.059872676 541507 59 11/30/2020 173.5899963 672845 0.105316736 543258 60 12/31/2020 182.0200043 578967 0.04856275 543258 597905
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
