In: Finance
Using CVS Health as the company, for the remaining items in this
section you will analyze the Year-Over-Year returns using the last
5 years of monthly stock prices . In your spreadsheet, calculate
the Year-Over-Year (YoY) return for each month. (Please submit this
worksheet in Excel with your written paper.) The calculation for
this is:
(month - same month prior year) / (same month prior year)
What were the highest and lowest YoY returns during this period?
Calculate the mean or average of these YoY returns from your sample.
Calculate the standard deviation of the YoY returns. (In Excel, use the STDEV function.)
Data:
Date | Open | High | Low | Close | Adj Close | Volume |
4/1/2013 | null | null | null | null | null | null |
5/1/2013 | 58.97 | 60.7 | 57.2 | 57.580002 | 52.867352 | 116793800 |
6/1/2013 | 57.76 | 60.34 | 55.66 | 57.18 | 52.500076 | 100908400 |
7/1/2013 | 57.72 | 62.36 | 57.32 | 61.490002 | 56.457325 | 77412600 |
8/1/2013 | 62.01 | 62.22 | 57.07 | 58.049999 | 53.496353 | 109197700 |
9/1/2013 | 58.44 | 61.33 | 56.67 | 56.75 | 52.298328 | 110503300 |
######## | 56.76 | 62.91 | 56.32 | 62.259998 | 57.37611 | 143629500 |
######## | 62.42 | 67.64 | 61.93 | 66.959999 | 61.943008 | 100208600 |
######## | 67.1 | 71.99 | 65.45 | 71.57 | 66.207596 | 110859300 |
1/1/2014 | 71.16 | 71.37 | 66.07 | 67.720001 | 62.646069 | 119291500 |
2/1/2014 | 67.52 | 73.62 | 64.95 | 73.139999 | 67.934837 | 125294600 |
3/1/2014 | 72.59 | 76.36 | 72.05 | 74.860001 | 69.532433 | 117059100 |
4/1/2014 | 74.56 | 76 | 72.37 | 72.720001 | 67.544716 | 116832300 |
5/1/2014 | 72.44 | 78.49 | 72.43 | 78.32 | 73.01786 | 91921800 |
6/1/2014 | 78.36 | 79.43 | 74.64 | 75.370003 | 70.267578 | 79743700 |
7/1/2014 | 75.89 | 79.21 | 75.42 | 76.360001 | 71.190552 | 67772600 |
8/1/2014 | 76.2 | 79.82 | 74.69 | 79.449997 | 74.336761 | 77040300 |
9/1/2014 | 79.47 | 82.57 | 79.22 | 79.589996 | 74.467728 | 80179600 |
######## | 79.45 | 87.16 | 77.4 | 85.809998 | 80.287437 | 123864700 |
######## | 86.03 | 92 | 83.61 | 91.360001 | 85.76873 | 75256400 |
######## | 91.42 | 98.62 | 88.95 | 96.309998 | 90.415779 | 100036000 |
1/1/2015 | 96.52 | 101.59 | 93.68 | 98.160004 | 92.152557 | 97903300 |
2/1/2015 | 98.34 | 104.52 | 97.06 | 103.870003 | 97.860008 | 89111000 |
3/1/2015 | 104.1 | 105.46 | 101.5 | 103.209999 | 97.238174 | 95022700 |
4/1/2015 | 102.66 | 104.45 | 99.01 | 99.290001 | 93.544998 | 100712300 |
5/1/2015 | 100.93 | 104.93 | 97.87 | 102.379997 | 96.79026 | 80918600 |
6/1/2015 | 102.9 | 106.88 | 99.14 | 104.879997 | 99.15377 | 97978200 |
7/1/2015 | 105.75 | 113.65 | 103.63 | 112.470001 | 106.329376 | 83710300 |
8/1/2015 | 113.17 | 113.58 | 81.37 | 102.400002 | 97.115463 | 117145300 |
9/1/2015 | 100.64 | 103.59 | 94.54 | 96.480003 | 91.500969 | 100678100 |
######## | 96.49 | 106 | 95.03 | 98.779999 | 93.682266 | 129349800 |
######## | 99.45 | 101.08 | 90.1 | 94.089996 | 89.537056 | 111659900 |
######## | 94.67 | 99.6 | 92.37 | 97.769997 | 93.038971 | 116258600 |
1/1/2016 | 96.17 | 97.15 | 92.35 | 96.589996 | 91.916077 | 106620800 |
2/1/2016 | 95.89 | 98.79 | 86.5 | 97.169998 | 92.883278 | 117548700 |
3/1/2016 | 98.16 | 104.4 | 97.58 | 103.730003 | 99.1539 | 89196000 |
4/1/2016 | 103.36 | 105 | 99.87 | 100.5 | 96.066383 | 75248300 |
5/1/2016 | 100.5 | 106.67 | 96.2 | 96.449997 | 92.575333 | 113171800 |
6/1/2016 | 96.46 | 98.67 | 91.75 | 95.739998 | 91.893852 | 128156800 |
7/1/2016 | 95.88 | 98.24 | 92.16 | 92.720001 | 88.995186 | 84627700 |
8/1/2016 | 92.58 | 98.66 | 92.25 | 93.400002 | 90.042908 | 107299600 |
9/1/2016 | 93.56 | 94.2 | 88.1 | 88.989998 | 85.791412 | 116749900 |
######## | 88.79 | 88.92 | 82.55 | 84.099998 | 81.077179 | 134064600 |
######## | 84.34 | 84.89 | 69.3 | 76.889999 | 74.49276 | 239272800 |
######## | 76.62 | 81.24 | 76.11 | 78.910004 | 76.449791 | 156408500 |
1/1/2017 | 79.58 | 84.72 | 77.03 | 78.809998 | 76.352898 | 139682500 |
2/1/2017 | 78.65 | 81.86 | 74.05 | 80.580002 | 78.539711 | 145409900 |
3/1/2017 | 81.1 | 81.69 | 77.57 | 78.5 | 76.512383 | 145650700 |
4/1/2017 | 78.38 | 82.9 | 76.56 | 82.440002 | 80.352623 | 119158300 |
5/1/2017 | 82.44 | 83.3 | 75.69 | 76.830002 | 75.366234 | 145781900 |
6/1/2017 | 76.84 | 82.15 | 75.46 | 80.459999 | 78.927078 | 152652900 |
7/1/2017 | 80.77 | 81.34 | 76.48 | 79.93 | 78.407173 | 91104200 |
8/1/2017 | 79.9 | 80.3 | 74.59 | 77.339996 | 76.359863 | 112499800 |
9/1/2017 | 77.54 | 84 | 77.3 | 81.32 | 80.289429 | 104104400 |
######## | 81.35 | 81.61 | 68.01 | 68.529999 | 67.661514 | 209664500 |
######## | 68.82 | 77.79 | 66.45 | 76.599998 | 76.126869 | 177501500 |
######## | 75.62 | 76.59 | 69.52 | 72.5 | 72.052193 | 221043800 |
1/1/2018 | 73.06 | 83.88 | 72.87 | 78.690002 | 78.203964 | 183092200 |
2/1/2018 | 78.3 | 79.2 | 67.31 | 67.730003 | 67.730003 | 177533800 |
3/1/2018 | 67.7 | 69.56 | 60.14 | 62.209999 | 62.209999 | 177442500 |
4/1/2018 | 62.06 | 64.99 | 60.45 | 64.279999 | 64.279999 | 25938500 |
Date | Open | High | Low | Close | Adj Close | Volume | YOY |
4/1/2013 | null | null | null | null | null | null | |
5/1/2013 | 58.97 | 60.7 | 57.2 | 57.58 | 52.86735 | 116793800 | |
6/1/2013 | 57.76 | 60.34 | 55.66 | 57.18 | 52.50008 | 100908400 | |
7/1/2013 | 57.72 | 62.36 | 57.32 | 61.49 | 56.45733 | 77412600 | |
8/1/2013 | 62.01 | 62.22 | 57.07 | 58.05 | 53.49635 | 109197700 | |
9/1/2013 | 58.44 | 61.33 | 56.67 | 56.75 | 52.29833 | 110503300 | |
######## | 56.76 | 62.91 | 56.32 | 62.26 | 57.37611 | 143629500 | |
######## | 62.42 | 67.64 | 61.93 | 66.96 | 61.94301 | 100208600 | |
######## | 67.1 | 71.99 | 65.45 | 71.57 | 66.2076 | 110859300 | |
1/1/2014 | 71.16 | 71.37 | 66.07 | 67.72 | 62.64607 | 119291500 | |
2/1/2014 | 67.52 | 73.62 | 64.95 | 73.14 | 67.93484 | 125294600 | |
3/1/2014 | 72.59 | 76.36 | 72.05 | 74.86 | 69.53243 | 117059100 | |
4/1/2014 | 74.56 | 76 | 72.37 | 72.72 | 67.54472 | 116832300 | |
5/1/2014 | 72.44 | 78.49 | 72.43 | 78.32 | 73.01786 | 91921800 | 36.02% |
6/1/2014 | 78.36 | 79.43 | 74.64 | 75.37 | 70.26758 | 79743700 | 31.81% |
7/1/2014 | 75.89 | 79.21 | 75.42 | 76.36 | 71.19055 | 67772600 | 24.18% |
8/1/2014 | 76.2 | 79.82 | 74.69 | 79.45 | 74.33676 | 77040300 | 36.86% |
9/1/2014 | 79.47 | 82.57 | 79.22 | 79.59 | 74.46773 | 80179600 | 40.25% |
######## | 79.45 | 87.16 | 77.4 | 85.81 | 80.28744 | 123864700 | 37.83% |
######## | 86.03 | 92 | 83.61 | 91.36 | 85.76873 | 75256400 | 36.44% |
######## | 91.42 | 98.62 | 88.95 | 96.31 | 90.41578 | 100036000 | 34.57% |
1/1/2015 | 96.52 | 101.59 | 93.68 | 98.16 | 92.15256 | 97903300 | 44.95% |
2/1/2015 | 98.34 | 104.52 | 97.06 | 103.87 | 97.86001 | 89111000 | 42.02% |
3/1/2015 | 104.1 | 105.46 | 101.5 | 103.21 | 97.23817 | 95022700 | 37.87% |
4/1/2015 | 102.66 | 104.45 | 99.01 | 99.29 | 93.545 | 100712300 | 36.54% |
5/1/2015 | 100.93 | 104.93 | 97.87 | 102.38 | 96.79026 | 80918600 | 30.72% |
6/1/2015 | 102.9 | 106.88 | 99.14 | 104.88 | 99.15377 | 97978200 | 39.15% |
7/1/2015 | 105.75 | 113.65 | 103.63 | 112.47 | 106.3294 | 83710300 | 47.29% |
8/1/2015 | 113.17 | 113.58 | 81.37 | 102.4 | 97.11546 | 117145300 | 28.89% |
9/1/2015 | 100.64 | 103.59 | 94.54 | 96.48 | 91.50097 | 100678100 | 21.22% |
######## | 96.49 | 106 | 95.03 | 98.78 | 93.68227 | 129349800 | 15.11% |
######## | 99.45 | 101.08 | 90.1 | 94.09 | 89.53706 | 111659900 | 2.99% |
######## | 94.67 | 99.6 | 92.37 | 97.77 | 93.03897 | 116258600 | 1.52% |
1/1/2016 | 96.17 | 97.15 | 92.35 | 96.59 | 91.91608 | 106620800 | -1.60% |
2/1/2016 | 95.89 | 98.79 | 86.5 | 97.17 | 92.88328 | 117548700 | -6.45% |
3/1/2016 | 98.16 | 104.4 | 97.58 | 103.73 | 99.1539 | 89196000 | 0.50% |
4/1/2016 | 103.36 | 105 | 99.87 | 100.5 | 96.06638 | 75248300 | 1.22% |
5/1/2016 | 100.5 | 106.67 | 96.2 | 96.45 | 92.57533 | 113171800 | -5.79% |
6/1/2016 | 96.46 | 98.67 | 91.75 | 95.74 | 91.89385 | 128156800 | -8.71% |
7/1/2016 | 95.88 | 98.24 | 92.16 | 92.72 | 88.99519 | 84627700 | -17.56% |
8/1/2016 | 92.58 | 98.66 | 92.25 | 93.4 | 90.04291 | 107299600 | -8.79% |
9/1/2016 | 93.56 | 94.2 | 88.1 | 88.99 | 85.79141 | 116749900 | -7.76% |
######## | 88.79 | 88.92 | 82.55 | 84.1 | 81.07718 | 134064600 | -14.86% |
######## | 84.34 | 84.89 | 69.3 | 76.89 | 74.49276 | 239272800 | -18.28% |
######## | 76.62 | 81.24 | 76.11 | 78.91 | 76.44979 | 156408500 | -19.29% |
1/1/2017 | 79.58 | 84.72 | 77.03 | 78.81 | 76.3529 | 139682500 | -18.41% |
2/1/2017 | 78.65 | 81.86 | 74.05 | 80.58 | 78.53971 | 145409900 | -17.07% |
3/1/2017 | 81.1 | 81.69 | 77.57 | 78.5 | 76.51238 | 145650700 | -24.32% |
4/1/2017 | 78.38 | 82.9 | 76.56 | 82.44 | 80.35262 | 119158300 | -17.97% |
5/1/2017 | 82.44 | 83.3 | 75.69 | 76.83 | 75.36623 | 145781900 | -20.34% |
6/1/2017 | 76.84 | 82.15 | 75.46 | 80.46 | 78.92708 | 152652900 | -15.96% |
7/1/2017 | 80.77 | 81.34 | 76.48 | 79.93 | 78.40717 | 91104200 | -13.79% |
8/1/2017 | 79.9 | 80.3 | 74.59 | 77.34 | 76.35986 | 112499800 | -17.19% |
9/1/2017 | 77.54 | 84 | 77.3 | 81.32 | 80.28943 | 104104400 | -8.62% |
######## | 81.35 | 81.61 | 68.01 | 68.53 | 67.66151 | 209664500 | -18.51% |
######## | 68.82 | 77.79 | 66.45 | 76.6 | 76.12687 | 177501500 | -0.38% |
######## | 75.62 | 76.59 | 69.52 | 72.5 | 72.05219 | 221043800 | -8.12% |
1/1/2018 | 73.06 | 83.88 | 72.87 | 78.69 | 78.20396 | 183092200 | -0.15% |
2/1/2018 | 78.3 | 79.2 | 67.31 | 67.73 | 67.73 | 177533800 | -15.95% |
3/1/2018 | 67.7 | 69.56 | 60.14 | 62.21 | 62.21 | 177442500 | -20.75% |
4/1/2018 | 62.06 | 64.99 | 60.45 | 64.28 | 64.28 | 25938500 | -22.03% |
Highest | 47.29% | ||||||
Lowest | -24.32% | ||||||
Average | 4.60% | ||||||
Std dev | 23.66% |