Answered step by step
Verified Expert Solution
Question
1 Approved Answer
XOM JPM SBUX Date Close Adj Close Date Close Adj Close Date Close Adj Close 5/1/2018 81.24 62.62186 5/1/2018 107.01 92.11655 5/1/2018 56.67 51.20496 6/1/2018
XOM | JPM | SBUX | ||||||||
Date | Close | Adj Close | Date | Close | Adj Close | Date | Close | Adj Close | ||
5/1/2018 | 81.24 | 62.62186 | 5/1/2018 | 107.01 | 92.11655 | 5/1/2018 | 56.67 | 51.20496 | ||
6/1/2018 | 82.73 | 64.41676 | 6/1/2018 | 104.2 | 89.69765 | 6/1/2018 | 48.85 | 44.36992 | ||
7/1/2018 | 81.51 | 63.46682 | 7/1/2018 | 114.95 | 98.95148 | 7/1/2018 | 52.39 | 47.58527 | ||
8/1/2018 | 80.17 | 62.42345 | 8/1/2018 | 114.58 | 99.16897 | 8/1/2018 | 53.45 | 48.54805 | ||
9/1/2018 | 85.02 | 66.88265 | 9/1/2018 | 112.84 | 97.66303 | 9/1/2018 | 56.84 | 51.98657 | ||
10/1/2018 | 79.68 | 62.68185 | 10/1/2018 | 109.02 | 94.3568 | 10/1/2018 | 58.27 | 53.29448 | ||
11/1/2018 | 79.5 | 62.54025 | 11/1/2018 | 111.19 | 96.90885 | 11/1/2018 | 66.72 | 61.02295 | ||
12/1/2018 | 68.19 | 54.1868 | 12/1/2018 | 97.62 | 85.08176 | 12/1/2018 | 64.4 | 59.21728 | ||
1/1/2019 | 73.28 | 58.23154 | 1/1/2019 | 103.5 | 90.20654 | 1/1/2019 | 68.14 | 62.65631 | ||
2/1/2019 | 79.03 | 62.80074 | 2/1/2019 | 104.36 | 91.69474 | 2/1/2019 | 70.26 | 64.60571 | ||
3/1/2019 | 80.8 | 64.9201 | 3/1/2019 | 101.23 | 88.9446 | 3/1/2019 | 74.34 | 68.7141 | ||
4/1/2019 | 80.28 | 64.5023 | 4/1/2019 | 116.05 | 101.966 | 4/1/2019 | 77.68 | 71.80135 | ||
5/1/2019 | 70.77 | 56.86133 | 5/1/2019 | 105.96 | 93.81295 | 5/1/2019 | 76.06 | 70.30393 | ||
6/1/2019 | 76.63 | 62.27539 | 6/1/2019 | 111.8 | 98.98346 | 6/1/2019 | 83.83 | 77.84539 | ||
7/1/2019 | 74.36 | 60.43061 | 7/1/2019 | 116 | 102.702 | 7/1/2019 | 94.69 | 87.93009 | ||
8/1/2019 | 68.48 | 55.65207 | 8/1/2019 | 109.86 | 97.95446 | 8/1/2019 | 96.56 | 89.6666 | ||
9/1/2019 | 70.61 | 58.09657 | 9/1/2019 | 117.69 | 104.9359 | 9/1/2019 | 88.42 | 82.41893 | ||
10/1/2019 | 67.57 | 55.59532 | 10/1/2019 | 124.92 | 111.3824 | 10/1/2019 | 84.56 | 78.82091 | ||
11/1/2019 | 68.13 | 56.05607 | 11/1/2019 | 131.76 | 118.4223 | 11/1/2019 | 85.43 | 79.63185 | ||
12/1/2019 | 69.78 | 58.10606 | 12/1/2019 | 139.4 | 125.2889 | 12/1/2019 | 87.92 | 82.36252 | ||
1/1/2020 | 62.12 | 51.72754 | 1/1/2020 | 132.36 | 118.9615 | 1/1/2020 | 84.83 | 79.46783 | ||
2/1/2020 | 51.44 | 42.83428 | 2/1/2020 | 116.11 | 105.0264 | 2/1/2020 | 78.43 | 73.4724 | ||
3/1/2020 | 37.97 | 32.07167 | 3/1/2020 | 90.03 | 81.43596 | 3/1/2020 | 65.74 | 61.87154 | ||
4/1/2020 | 46.47 | 39.25127 | 4/1/2020 | 95.76 | 86.619 | 4/1/2020 | 76.73 | 72.21486 | ||
5/1/2020 | 45.47 | 38.40662 | 5/1/2020 | 97.31 | 88.93569 | 5/1/2020 | 77.99 | 73.4007 | ||
6/1/2020 | 44.72 | 38.50552 | 6/1/2020 | 94.06 | 85.96538 | 6/1/2020 | 73.59 | 69.65103 | ||
7/1/2020 | 42.08 | 36.23238 | 7/1/2020 | 96.64 | 88.32336 | 7/1/2020 | 76.53 | 72.43366 | ||
8/1/2020 | 39.94 | 34.38976 | 8/1/2020 | 100.19 | 92.46014 | 8/1/2020 | 84.47 | 79.94868 | ||
9/1/2020 | 34.33 | 30.1425 | 9/1/2020 | 96.27 | 88.84256 | 9/1/2020 | 85.92 | 81.76342 | ||
10/1/2020 | 32.62 | 28.64108 | 10/1/2020 | 98.04 | 90.47601 | 10/1/2020 | 86.96 | 82.75312 | ||
11/1/2020 | 38.13 | 33.47899 | 11/1/2020 | 117.88 | 109.7948 | 11/1/2020 | 98.02 | 93.27806 | ||
12/1/2020 | 41.22 | 37.06526 | 12/1/2020 | 127.07 | 118.3544 | 12/1/2020 | 106.98 | 102.2847 | ||
1/1/2021 | 44.84 | 40.32038 | 1/1/2021 | 128.67 | 119.8447 | 1/1/2021 | 96.81 | 92.56102 | ||
2/1/2021 | 54.37 | 48.88981 | 2/1/2021 | 147.17 | 138.063 | 2/1/2021 | 108.03 | 103.2886 | ||
3/1/2021 | 55.83 | 51.0552 | 3/1/2021 | 152.23 | 142.8099 | 3/1/2021 | 109.27 | 104.9189 | ||
4/1/2021 | 57.24 | 52.34462 | 4/1/2021 | 153.81 | 144.2921 | 4/1/2021 | 114.49 | 109.9311 | ||
5/1/2021 | 58.37 | 53.37797 | 5/1/2021 | 164.24 | 154.9841 | 5/1/2021 | 113.88 | 109.3454 | ||
6/1/2021 | 63.08 | 58.52552 | 6/1/2021 | 155.54 | 146.7744 | 6/1/2021 | 111.81 | 107.7849 | ||
7/1/2021 | 57.57 | 53.41335 | 7/1/2021 | 151.78 | 143.2263 | 7/1/2021 | 121.43 | 117.0586 | ||
8/1/2021 | 54.52 | 50.58356 | 8/1/2021 | 159.95 | 151.8057 | 8/1/2021 | 117.49 | 113.2605 | ||
9/1/2021 | 58.82 | 55.3991 | 9/1/2021 | 163.69 | 155.3553 | 9/1/2021 | 110.31 | 106.7517 | ||
10/1/2021 | 64.47 | 60.7205 | 10/1/2021 | 169.89 | 161.2396 | 10/1/2021 | 106.07 | 102.6485 | ||
11/1/2021 | 59.84 | 56.35978 | 11/1/2021 | 158.83 | 151.6511 | 11/1/2021 | 109.64 | 106.1033 | ||
12/1/2021 | 61.19 | 58.40578 | 12/1/2021 | 158.35 | 151.1928 | 12/1/2021 | 116.97 | 113.6849 | ||
1/1/2022 | 75.96 | 72.50373 | 1/1/2022 | 148.6 | 141.8835 | 1/1/2022 | 98.32 | 95.55872 | ||
2/1/2022 | 78.42 | 74.85179 | 2/1/2022 | 141.8 | 136.2024 | 2/1/2022 | 91.79 | 89.2121 | ||
3/1/2022 | 82.59 | 79.70598 | 3/1/2022 | 136.32 | 130.9387 | 3/1/2022 | 90.97 | 88.86343 | ||
4/1/2022 | 85.25 | 82.2731 | 4/1/2022 | 119.36 | 114.6482 | 4/1/2022 | 74.64 | 72.91158 | ||
5/1/2022 | 96 | 92.64771 | 5/1/2022 | 132.23 | 127.9516 | 5/1/2022 | 78.5 | 76.68219 | ||
6/1/2022 | 85.64 | 83.49608 | 6/1/2022 | 112.61 | 108.9664 | 6/1/2022 | 76.39 | 75.14662 | ||
7/1/2022 | 96.93 | 94.50344 | 7/1/2022 | 115.36 | 111.6274 | 7/1/2022 | 84.78 | 83.40006 | ||
8/1/2022 | 95.59 | 93.19698 | 8/1/2022 | 113.73 | 111.0237 | 8/1/2022 | 84.07 | 82.70162 | ||
9/1/2022 | 87.31 | 85.95136 | 9/1/2022 | 104.5 | 102.0133 | 9/1/2022 | 84.26 | 83.3608 | ||
10/1/2022 | 110.81 | 109.0857 | 10/1/2022 | 125.88 | 122.8845 | 10/1/2022 | 86.59 | 85.66594 | ||
11/1/2022 | 111.34 | 109.6074 | 11/1/2022 | 138.18 | 136.0987 | 11/1/2022 | 102.2 | 101.1094 | ||
12/1/2022 | 110.3 | 109.4577 | 12/1/2022 | 134.1 | 132.0802 | 12/1/2022 | 99.2 | 98.7054 | ||
1/1/2023 | 116.01 | 115.1241 | 1/1/2023 | 139.96 | 137.8519 | 1/1/2023 | 109.14 | 108.5958 | ||
2/1/2023 | 109.91 | 109.0707 | 2/1/2023 | 143.35 | 142.2337 | 2/1/2023 | 102.09 | 101.581 | ||
3/1/2023 | 109.66 | 109.66 | 3/1/2023 | 130.31 | 129.2953 | 3/1/2023 | 104.13 | 104.13 | ||
4/1/2023 | 116.05 | 116.05 | 4/1/2023 | 138.73 | 137.6497 | 4/1/2023 | 107.47 | 107.47 | ||
4/14/2023 | 116.05 | 116.05 | 4/14/2023 | 138.73 | 138.73 | 4/14/2023 | 107.47 | 107.47 |
Please show answer in excel for JPM, XOM, SBUX
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started