Strategic Analysis Case Study

miller31
CVSStockData.xlsx
Home>Business & Finance homework help>Management homework help>Strategic Analysis Case Study

CVS Stock Price Data

Date Open High Low Close Adj Close Volume
1/10/19 66.019997 66.279999 64.559998 65.550003 63.383896 15503500
1/11/19 65.18 65.82 64.360001 65.809998 63.635296 11396300
1/14/19 65.379997 65.779999 64.900002 65.339996 63.180824 9276000
1/15/19 64.68 64.82 63.139999 63.740002 61.633705 15501500
1/16/19 63.810001 64.5 63.669998 63.919998 61.807755 13551200
1/17/19 63.970001 64.089996 63.27 63.369999 61.275925 12599200
1/18/19 64.650002 65.550003 64.300003 65.519997 63.354881 15600000
1/22/19 65.389999 65.769997 64.599998 64.919998 62.774712 8492600
1/23/19 65.300003 66.32 64.900002 66.110001 63.925388 9101400
1/24/19 65.5 65.629997 64.559998 64.980003 63.311569 7039900
1/25/19 65.57 65.809998 65.139999 65.449997 63.769493 8625700
1/28/19 65.110001 65.260002 63.580002 65.239998 63.564888 8642000
1/29/19 65.459999 66.150002 65.18 65.540001 63.857185 7293600
1/30/19 66.290001 66.660004 65.769997 65.959999 64.266396 7340600
1/31/19 65.949997 66.410004 65.550003 65.550003 63.866932 10883200
2/1/19 64.5 65.720001 62.880001 65.220001 63.545399 16742500
2/4/19 65.25 65.919998 64.870003 65.910004 64.21769 7151900
2/5/19 66.239998 66.379997 65.389999 65.669998 63.983845 6763900
2/6/19 65.440002 66.290001 65.360001 66.029999 64.33461 6494600
2/7/19 65.970001 66.129997 64.949997 65.75 64.06179 6306600
2/8/19 65.489998 65.699997 64.360001 65.010002 63.340797 7754000
2/11/19 65.349998 65.730003 65.010002 65.099998 63.428482 9654800
2/12/19 65.440002 67.400002 65.300003 67.010002 65.289436 7868000
2/13/19 67.330002 68.160004 67.129997 67.790001 66.049416 9738200
2/14/19 67.459999 68.160004 66.769997 67.690002 65.951981 6988200
2/15/19 68.260002 69.870003 67.849998 69.529999 67.744736 10245400
2/19/19 70.209999 70.32 69.279999 69.879997 68.085747 13091900
2/20/19 63.669998 65.190002 63.299999 64.220001 62.571079 43365600
2/21/19 64.029999 64.150002 61.959999 62.349998 60.749088 26490600
2/22/19 62.139999 62.349998 61.169998 61.950001 60.359364 20182900
2/25/19 62.119999 62.290001 61.200001 61.23 59.657848 12853900
2/26/19 61.25 61.580002 60.59 60.68 59.121971 12273600
2/27/19 60.43 60.490002 58.459999 58.5 56.997944 20986500
2/28/19 58.540001 58.790001 57.560001 57.830002 56.34515 17121000
3/1/19 58.150002 58.740002 58.060001 58.130001 56.637444 14432800
3/4/19 58.369999 58.549999 55.799999 55.959999 54.523159 17836000
3/5/19 56.150002 56.200001 54.369999 54.959999 53.54884 27776100
3/6/19 54.740002 55.009998 54 54 52.613487 15876800
3/7/19 54.139999 54.34 52.169998 52.360001 51.015598 23030200
3/8/19 52.060001 53.099998 51.93 52.93 51.570961 21748300
3/11/19 53.099998 53.889999 52.310001 53.75 52.369907 14770200
3/12/19 54.02 54.93 53.720001 54.650002 53.246799 16681400
3/13/19 55.610001 56.919998 55.310001 56.57 55.1175 22936500
3/14/19 56.950001 57.41 55.669998 55.880001 54.445217 15216100
3/15/19 55.919998 56.189999 55.27 55.599998 54.172401 24262200
3/18/19 55.610001 56.919998 55.560001 56.669998 55.214931 12752900
3/19/19 56.700001 57.540001 56.48 57.09 55.624149 12367400
3/20/19 56.82 56.900002 55.810001 56.16 54.718029 11405800
3/21/19 56.07 57.610001 55.779999 57.400002 55.926193 10452700
3/22/19 57.110001 57.279999 55.919998 56.040001 54.601112 10204200
3/25/19 55.799999 56.130001 54.400002 54.950001 53.539097 12968600
3/26/19 55.380001 56.169998 55.080002 55.389999 53.967796 11730900
3/27/19 53.939999 54.43 52.830002 54.049999 52.662205 21327300
3/28/19 54.18 54.599998 53.25 53.360001 51.989922 11564900
3/29/19 53.549999 53.970001 53.290001 53.93 52.545284 11361500
4/1/19 54.16 54.34 53.450001 54.189999 52.798607 10790100
4/2/19 52.68 52.919998 51.77 52.130001 50.791504 22104400
4/3/19 52.419998 53.07 52.32 52.790001 51.434559 17437400
4/4/19 52.880001 53.459999 52.799999 53.400002 52.028893 11058000
4/5/19 53.610001 54.200001 53.509998 54.060001 52.671951 10002100
4/8/19 53.959999 54.490002 53.740002 54.150002 52.75964 8374100
4/9/19 54.099998 54.330002 53.450001 53.720001 52.340679 9275800
4/10/19 53.700001 53.889999 53.040001 53.869999 52.486824 11853400
4/11/19 53.98 54.369999 52.470001 52.689999 51.337124 11354700
4/12/19 52.950001 53.290001 52.580002 52.810001 51.454044 10024700
4/15/19 53.720001 54.599998 53.5 54.220001 52.827839 17590400
4/16/19 54.73 54.830002 53.34 53.900002 52.516056 12943200
4/17/19 53.98 54.150002 52 52.540001 51.190975 22106000
4/18/19 52.439999 53.16 52.259998 52.630001 51.278667 15930600
4/22/19 52.43 52.759998 52.18 52.43 51.573765 9122500
4/23/19 52.5 53.669998 52.099998 52.959999 52.095108 14102400
4/24/19 52.990002 53.110001 52.560001 52.93 52.065601 9599200
4/25/19 52.810001 53.689999 52.610001 53.23 52.360699 8503000
4/26/19 53.23 53.619999 52.93 53.529999 52.6558 9084500
4/29/19 53.150002 54.439999 52.66 53.990002 53.108292 9731200
4/30/19 54.630001 54.889999 53.450001 54.380001 53.49192 13911200
5/1/19 56.849998 57.75 56.209999 57.330002 56.393745 26243000
5/2/19 57.209999 57.369999 55.57 56.73 55.803539 14489700
5/3/19 57.009998 57.34 56.029999 56.66 55.734684 11035600
5/6/19 55.970001 56.619999 55.41 56.599998 55.675663 10689500
5/7/19 56.349998 56.48 54.919998 55.349998 54.446075 9586900
5/8/19 55.360001 56.119999 54.880001 55.740002 54.829708 8841200
5/9/19 55.099998 55.650002 54.630001 55.349998 54.446075 9255700
5/10/19 55.299999 55.619999 54.240002 55.16 54.259178 9397100
5/13/19 54.299999 54.450001 53.299999 53.82 52.941067 11183800
5/14/19 53.849998 54.23 52.939999 52.970001 52.10495 10772900
5/15/19 52.709999 53.07 51.880001 52.790001 51.927887 11618000
5/16/19 52.900002 53.209999 52.150002 52.299999 51.445885 11823600
5/17/19 52.009998 53.200001 51.720001 52.880001 52.016415 8046700
5/20/19 52.849998 53.599998 52.700001 53 52.134457 8083900
5/21/19 53.32 53.689999 52.849998 53.52 52.645966 8163200
5/22/19 53.43 53.82 52.82 53.709999 52.832859 7919800
5/23/19 53.27 53.290001 52.34 52.790001 51.927887 9388900
5/24/19 52.880001 53.169998 52.59 53.07 52.203312 5681200
5/28/19 53.119999 53.240002 52.580002 52.700001 51.839355 12493000
5/29/19 52.459999 52.950001 52.119999 52.52 51.662296 9578200
5/30/19 52.639999 52.959999 52.290001 52.75 51.888538 6789100
5/31/19 52.27 52.720001 52.040001 52.369999 51.514744 8089300
6/3/19 52.540001 53.700001 52.459999 53.389999 52.518085 8920500
6/4/19 54.43 55.75 54.25 54.619999 53.727997 12754300
6/5/19 55 55.049999 53.02 53.169998 52.301678 12128800
6/6/19 53.139999 54.610001 53.02 54.110001 53.22633 10043000
6/7/19 54.27 54.619999 53.810001 53.919998 53.039429 7826000
6/10/19 54.330002 55.529999 54.299999 55.029999 54.131302 8007800
6/11/19 54.43 55.09 53.790001 53.970001 53.088615 8774300
6/12/19 53.849998 54.029999 53.040001 53.66 52.783676 9404900
6/13/19 53.869999 54.639999 53.709999 54.59 53.69849 5250700
6/14/19 54.650002 54.68 54.049999 54.169998 53.285343 4680700
6/17/19 54.23 54.700001 53.93 54.540001 53.649307 5008800
6/18/19 54.830002 55.34 54.540001 54.66 53.767345 7156800
6/19/19 54.860001 55.380001 54.669998 54.889999 53.993587 6212900
6/20/19 54.889999 55.080002 53.279999 53.869999 52.990246 13254500
6/21/19 53.799999 54.02 53.23 53.650002 52.773842 12482100
6/24/19 53.709999 53.75 52.759998 53.139999 52.272171 9144900
6/25/19 53.25 53.790001 52.889999 53.68 52.803352 7865700
6/26/19 53.740002 54.130001 53.279999 53.700001 52.823025 6655200
6/27/19 54.029999 55 53.939999 54.740002 53.846043 7476000
6/28/19 54.830002 55.240002 54.349998 54.490002 53.600124 9336900
7/1/19 55.099998 55.990002 54.650002 54.93 54.032936 7991100
7/2/19 54.869999 55.009998 54.119999 54.799999 53.90506 4960200
7/3/19 55.009998 55.84 55 55.200001 54.298527 4117800
7/5/19 55.240002 56.110001 55.110001 55.57 54.662483 4264200
7/8/19 55.380001 55.450001 54.759998 55.310001 54.406731 5936900
7/9/19 55.049999 55.369999 54.66 54.830002 53.93457 5757900
7/10/19 55 55.5 54.650002 55.380001 54.47559 5056800
7/11/19 59.369999 60.130001 57.52 57.970001 57.023293 29037100
7/12/19 57.900002 58.48 57.34 57.549999 56.610149 10089400
7/15/19 57.759998 57.790001 57.040001 57.439999 56.501942 5883400
7/16/19 57.369999 57.5 56.869999 57.380001 56.442924 5063000
7/17/19 57.330002 57.369999 56.009998 56.23 55.311707 7678600
7/18/19 56.07 56.68 55.470001 56.5 55.577297 6066200
7/19/19 56.700001 56.82 55.939999 55.939999 55.026443 5480900
7/22/19 56.080002 56.16 55.259998 55.48 54.573956 5717300
7/23/19 55.41 56.400002 55.049999 56.27 55.351055 6973400
7/24/19 55.900002 56.09 54.970001 55.990002 55.569405 6774800
7/25/19 55.68 55.900002 55.049999 55.439999 55.023533 5526200
7/26/19 55.540001 56 55.349998 55.540001 55.122784 4753300
7/29/19 55.470001 56.52 55.450001 56.259998 55.837372 4951600
7/30/19 55.91 56.59 55.540001 56.529999 56.105343 5016900
7/31/19 56.599998 56.599998 55.400002 55.869999 55.450302 8473100
8/1/19 55.799999 56.91 55.360001 55.369999 54.954056 11847900
8/2/19 55.43 55.84 55.009998 55.709999 55.291504 6673300
8/5/19 55.049999 55.950001 54.060001 54.509998 54.100517 9492300
8/6/19 54.599998 54.700001 53 54.09 53.683674 12803400
8/7/19 56.27 58.279999 56.009998 58.119999 57.683399 22891700
8/8/19 58.720001 59.52 58.5 59.040001 58.596489 14892100
8/9/19 58.939999 59.5 58.490002 59.290001 58.844612 6694500
8/12/19 59.049999 59.259998 58.560001 58.75 58.308666 5126700
8/13/19 58.700001 59.970001 58.48 59.849998 59.400402 8243200
8/14/19 59.330002 59.490002 58.459999 58.560001 58.120098 10561400
8/15/19 58.799999 59.150002 57.919998 58.84 58.397991 10751100
8/16/19 59.279999 60.549999 59.119999 60.279999 59.827175 9643600
8/19/19 60.810001 61.549999 60.599998 61.389999 60.928837 10072100
8/20/19 61.240002 61.869999 61.07 61.560001 61.097561 8961400
8/21/19 62.18 62.580002 61.599998 61.650002 61.186886 9595600
8/22/19 61.91 62.169998 61.099998 62.049999 61.583878 6401900
8/23/19 61.360001 62.119999 60.029999 60.240002 59.787476 9353100
8/26/19 60.799999 60.990002 60.279999 60.759998 60.303566 4849400
8/27/19 61.209999 61.310001 59.119999 59.189999 58.745361 7700600
8/28/19 59.060001 59.580002 58.619999 59.48 59.033184 7817200
8/29/19 60.119999 60.599998 59.849998 60.150002 59.698154 6784000
8/30/19 60.669998 61.150002 60.259998 60.919998 60.462364 6310300
9/3/19 60.439999 60.830002 59.689999 60.689999 60.234093 5379400
9/4/19 61.189999 61.799999 61 61.66 61.196808 5700600
9/5/19 63.009998 63.34 62.380001 62.759998 62.288544 7892700
9/6/19 62.740002 62.970001 62.009998 62.23 61.762527 7124800
9/9/19 62.540001 63.860001 62.509998 63.68 63.201633 8623700
9/10/19 63.75 64.120003 62.799999 63.599998 63.122234 10239200
9/11/19 63.48 64.010002 63.290001 63.990002 63.509308 7314800
9/12/19 64.940002 65.25 63.639999 63.900002 63.419983 8816700
9/13/19 64.099998 64.720001 63.16 64.059998 63.578777 6184500
9/16/19 63.299999 63.849998 63.18 63.43 62.95351 4408700
9/17/19 63.5 63.75 63.150002 63.48 63.003136 4652500
9/18/19 63.220001 63.540001 62.740002 63.259998 62.784786 4747100
9/19/19 63.450001 64.029999 63.279999 63.630001 63.152012 4543600
9/20/19 64.18 64.690002 64.010002 64.300003 63.816978 10375300
9/23/19 63.93 64.32 63.099998 63.349998 62.874111 7360100
9/24/19 63.549999 64.190002 62.669998 62.93 62.457268 6519500
9/25/19 62.650002 63.369999 62.470001 62.59 62.119823 5207200
9/26/19 62.68 62.779999 60.950001 61.59 61.127335 7455800
9/27/19 61.939999 62.5 61.580002 62.080002 61.613655 4938900
9/30/19 62.110001 63.439999 61.77 63.07 62.596214 6383400
10/1/19 63.200001 63.560001 61.759998 62.349998 61.881622 5996600
10/2/19 61.98 62.099998 60.959999 61.5 61.03801 6398400
10/3/19 61.509998 61.779999 60.369999 61.220001 60.760113 5800100
10/4/19 61.150002 62.32 61.130001 62.240002 61.772453 4677400
10/7/19 62.130001 62.549999 61.73 61.990002 61.52433 4465500
10/8/19 61.48 61.619999 60.139999 60.380001 59.926426 6950500
10/9/19 60.860001 61.34 60.610001 60.799999 60.343269 5214900
10/10/19 60.900002 62.5 60.849998 62.139999 61.673203 6729200
10/11/19 62.799999 63.610001 62.77 62.939999 62.46719 6278700
10/14/19 62.77 63.25 62.43 62.990002 62.516819 2934800
10/15/19 63.48 64.970001 63.48 64.830002 64.342995 8209600
10/16/19 65 65.790001 64.760002 65.410004 64.91864 7343500
10/17/19 65.559998 66.580002 65.309998 66.5 66.00045 8402500
10/18/19 66.32 66.459999 65.730003 66.160004 65.66301 6249500
10/21/19 66.629997 66.779999 65.610001 65.699997 65.206459 6820700
10/22/19 65.879997 66.919998 65.730003 66.559998 66.059998 6293100
10/23/19 66.040001 66.309998 65.32 65.599998 65.599998 4683800
10/24/19 65.599998 65.889999 64.470001 64.839996 64.839996 5562300
10/25/19 64.639999 65.610001 64.379997 65.099998 65.099998 5068200
10/28/19 65.449997 66.540001 65.349998 65.879997 65.879997 7015500
10/29/19 65.690002 66.099998 64.949997 65.889999 65.889999 6505900
10/30/19 66.150002 67.330002 65.849998 67.050003 67.050003 8032000
10/31/19 66.800003 67.099998 65.720001 66.389999 66.389999 6138500
11/1/19 66.860001 67.589996 66.709999 67.239998 67.239998 6793300
11/4/19 67.970001 68.410004 67.480003 68.040001 68.040001 8822200
11/5/19 68.25 68.650002 67.129997 67.32 67.32 15587500
11/6/19 69.43 70.940002 69.300003 70.93 70.93 22382100
11/7/19 71.940002 72.089996 71.18 71.779999 71.779999 11695900
11/8/19 71.800003 72.980003 71.57 72.470001 72.470001 9245700
11/11/19 71.980003 72.75 71.57 71.730003 71.730003 5057600
11/12/19 71.550003 72.470001 71 72.349998 72.349998 5030400
11/13/19 71.830002 73.290001 71.709999 72.82 72.82 5112000
11/14/19 72.769997 73.25 72.629997 72.940002 72.940002 4032700
11/15/19 73.339996 74.389999 72.980003 74.290001 74.290001 8767100
11/18/19 74.150002 75.129997 74.110001 75.099998 75.099998 8463700
11/19/19 75.279999 75.470001 74.459999 75.349998 75.349998 6923900
11/20/19 75.25 75.489998 74.339996 74.919998 74.919998 6958100
11/21/19 74.870003 75.279999 74.160004 74.940002 74.940002 4339000
11/22/19 75.279999 75.699997 75.089996 75.309998 75.309998 5402100
11/25/19 75.5 77.029999 75.5 76.580002 76.580002 8807100
11/26/19 76.760002 76.790001 74.639999 74.940002 74.940002 10128300
11/27/19 75.099998 75.559998 74.629997 75.040001 75.040001 7823800
11/29/19 74.690002 75.400002 74.43 75.269997 75.269997 4463600
12/2/19 75.220001 75.910004 75.010002 75.550003 75.550003 5264500
12/3/19 74.389999 74.790001 73.599998 74.709999 74.709999 6381600
12/4/19 75.25 75.440002 74.900002 75 75 4958400
12/5/19 75.059998 75.080002 73.889999 74.480003 74.480003 4900300
12/6/19 75.080002 75.75 75 75.360001 75.360001 5103400
12/9/19 75.029999 75.489998 74.889999 74.989998 74.989998 4812600
12/10/19 75 75.050003 72.639999 73.18 73.18 10942900
12/11/19 73.07 73.75 72.839996 73.349998 73.349998 7192500
12/12/19 73.629997 74.529999 73.379997 74.260002 74.260002 4774400
12/13/19 74.220001 74.540001 73.580002 73.589996 73.589996 3902500
12/16/19 74.25 75.010002 73.940002 74.400002 74.400002 5511800
12/17/19 74.389999 74.440002 72.809998 73.349998 73.349998 7901200
12/18/19 72.940002 73.599998 72.650002 73.279999 73.279999 7132700
12/19/19 73.949997 74.279999 73.650002 74.099998 74.099998 6583900
12/20/19 75 75 74.110001 74.580002 74.580002 8571700
12/23/19 74.540001 74.949997 74.32 74.379997 74.379997 3882500
12/24/19 74.529999 74.779999 74.360001 74.510002 74.510002 1315400
12/26/19 74.699997 74.760002 74.139999 74.480003 74.480003 2801100
12/27/19 74.510002 74.610001 74.040001 74.400002 74.400002 3543500
12/30/19 74.269997 74.529999 73.610001 73.699997 73.699997 3450800
12/31/19 73.559998 74.370003 73.419998 74.290001 74.290001 4531900
1/2/20 74.650002 74.699997 73.529999 74.160004 74.160004 5022700
1/3/20 73.220001 74.059998 73.07 73.57 73.57 4453000
1/6/20 73.120003 73.940002 73.059998 73.860001 73.860001 4620700
1/7/20 73.610001 73.669998 72.660004 73.580002 73.580002 6172300
1/8/20 72.5 73.089996 71.599998 72.660004 72.660004 8311200
1/9/20 73 73.260002 72.669998 72.860001 72.860001 5426200