Answered step by step
Verified Expert Solution
Question
1 Approved Answer
WMT SPY Date Adj Close Adj Close 5/1/2011 43.4721 110.6702 6/1/2011 42.1114 108.2665 7/1/2011 41.77064 106.6267 8/1/2011 42.15102 100.7648 9/1/2011 41.4263 93.28702 10/1/2011 45.27356 104.0044
WMT | SPY | |
Date | Adj Close | Adj Close |
5/1/2011 | 43.4721 | 110.6702 |
6/1/2011 | 42.1114 | 108.2665 |
7/1/2011 | 41.77064 | 106.6267 |
8/1/2011 | 42.15102 | 100.7648 |
9/1/2011 | 41.4263 | 93.28702 |
10/1/2011 | 45.27356 | 104.0044 |
11/1/2011 | 47.01365 | 103.5817 |
12/1/2011 | 47.70008 | 104.0044 |
1/1/2012 | 49.28323 | 109.5177 |
2/1/2012 | 47.45198 | 114.2714 |
3/1/2012 | 49.15472 | 117.4321 |
4/1/2012 | 47.63213 | 117.1594 |
5/1/2012 | 53.21925 | 110.1233 |
6/1/2012 | 56.75518 | 114.0015 |
7/1/2012 | 60.58934 | 115.9478 |
8/1/2012 | 59.09961 | 118.8525 |
9/1/2012 | 60.40139 | 121.2186 |
10/1/2012 | 61.3999 | 119.6479 |
11/1/2012 | 58.94454 | 120.325 |
12/1/2012 | 55.84265 | 120.5451 |
1/1/2013 | 57.56805 | 127.6146 |
2/1/2013 | 58.25113 | 129.2428 |
3/1/2013 | 61.58425 | 133.5563 |
4/1/2013 | 64.37531 | 136.7276 |
5/1/2013 | 61.98984 | 139.9558 |
6/1/2013 | 62.07 | 137.3613 |
7/1/2013 | 64.94478 | 145.2241 |
8/1/2013 | 60.81179 | 140.8685 |
9/1/2013 | 62.00261 | 144.6215 |
10/1/2013 | 64.34151 | 152.0561 |
11/1/2013 | 67.91279 | 156.5626 |
12/1/2013 | 65.96789 | 159.7544 |
1/1/2014 | 62.97065 | 154.9601 |
2/1/2014 | 62.98752 | 162.0132 |
3/1/2014 | 64.44623 | 162.6394 |
4/1/2014 | 67.64558 | 164.4928 |
5/1/2014 | 65.15057 | 168.3101 |
6/1/2014 | 64.10228 | 170.9657 |
7/1/2014 | 62.82998 | 169.4764 |
8/1/2014 | 64.46946 | 176.1646 |
9/1/2014 | 65.72793 | 172.9259 |
10/1/2014 | 65.55605 | 177.8258 |
11/1/2014 | 75.24288 | 182.711 |
12/1/2014 | 73.81607 | 181.2472 |
1/1/2015 | 73.45057 | 176.8477 |
2/1/2015 | 72.54302 | 186.7874 |
3/1/2015 | 71.09093 | 183.0367 |
4/1/2015 | 67.86597 | 185.6617 |
5/1/2015 | 64.57918 | 188.0486 |
6/1/2015 | 62.06422 | 183.3372 |
7/1/2015 | 62.983 | 188.3905 |
8/1/2015 | 56.63919 | 176.9082 |
9/1/2015 | 57.12285 | 171.5025 |
10/1/2015 | 50.42739 | 187.0579 |
11/1/2015 | 51.83696 | 187.7417 |
12/1/2015 | 54.00417 | 183.4055 |
1/1/2016 | 58.95163 | 175.3115 |
2/1/2016 | 58.93385 | 175.1667 |
3/1/2016 | 60.84384 | 185.9902 |
4/1/2016 | 59.84447 | 187.6863 |
5/1/2016 | 63.34367 | 190.8791 |
6/1/2016 | 65.82678 | 190.5517 |
7/1/2016 | 65.7817 | 198.5284 |
8/1/2016 | 64.40244 | 198.7662 |
9/1/2016 | 65.46051 | 197.7786 |
10/1/2016 | 63.55442 | 195.3315 |
11/1/2016 | 63.92658 | 202.5272 |
12/1/2016 | 62.73753 | 205.422 |
1/1/2017 | 61.01085 | 210.3304 |
2/1/2017 | 64.84116 | 218.5946 |
3/1/2017 | 65.89245 | 217.9198 |
4/1/2017 | 69.23168 | 221.0403 |
5/1/2017 | 72.3811 | 224.1599 |
6/1/2017 | 70.15851 | 224.4941 |
7/1/2017 | 74.15405 | 230.2257 |
8/1/2017 | 72.37414 | 230.8974 |
9/1/2017 | 72.89468 | 234.3866 |
10/1/2017 | 81.44911 | 241.1003 |
11/1/2017 | 90.70322 | 248.4698 |
12/1/2017 | 92.12118 | 250.2043 |
1/1/2018 | 99.96831 | 265.6566 |
2/1/2018 | 84.41039 | 255.9972 |
3/1/2018 | 83.4351 | 247.987 |
4/1/2018 | 83.45141 | 250.267 |
5/1/2018 | 77.86659 | 256.3507 |
6/1/2018 | 81.30956 | 256.6725 |
7/1/2018 | 84.70813 | 267.3765 |
8/1/2018 | 91.00214 | 275.9111 |
9/1/2018 | 89.66876 | 276.3008 |
10/1/2018 | 95.75107 | 258.3716 |
11/1/2018 | 93.23986 | 263.1642 |
12/1/2018 | 88.94309 | 238.5996 |
1/1/2019 | 92.00137 | 259.2081 |
2/1/2019 | 95.03513 | 267.6105 |
3/1/2019 | 93.63345 | 271.2596 |
4/1/2019 | 99.26256 | 283.5849 |
5/1/2019 | 97.91126 | 265.5004 |
6/1/2019 | 107.213 | 282.6011 |
7/1/2019 | 107.1062 | 288.2692 |
8/1/2019 | 110.8712 | 283.4425 |
9/1/2019 | 115.7269 | 287.6295 |
10/1/2019 | 114.3423 | 295.3451 |
11/1/2019 | 116.1267 | 306.036 |
12/1/2019 | 115.8829 | 313.3873 |
1/1/2020 | 112.1419 | 314.8009 |
2/1/2020 | 105.4716 | 289.8794 |
3/1/2020 | 111.2898 | 252.1988 |
4/1/2020 | 119.584 | 285.8952 |
5/1/2020 | 122.0533 | 299.5168 |
6/1/2020 | 118.361 | 303.493 |
7/1/2020 | 127.867 | 322.7805 |
8/1/2020 | 137.205 | 345.3096 |
9/1/2020 | 138.8208 | 331.0547 |
10/1/2020 | 137.6699 | 324.0925 |
11/1/2020 | 151.6006 | 359.3463 |
12/1/2020 | 143.0278 | 371.0777 |
1/1/2021 | 139.9059 | 368.8619 |
2/1/2021 | 129.3798 | 379.1183 |
3/1/2021 | 135.2652 | 395.0362 |
4/1/2021 | 139.63 | 420.06 |
What is Walmarts beta for these 10 years?
**NOTE** (the risk-free rate in this problem is equal to ZERO)
**Please answer accurate to two decimales i.e. 0.045
What is the firm-specific variance for Walmart over this period?
**Please answer accurately to four decimals i.e. 0.0045
What is Walmart's firm-specific (residual) return for May 2012? (The date is 5/1/12).
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