Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 21, 2024

A. What percentage of Walmart's Total Return Risk is non-systematic, firm-specific risk for the most recent 36 month regression you performed in estimating Beta? (round

A. What percentage of Walmart's Total Return Risk is non-systematic, firm-specific risk for the most recent 36 month regression you performed in estimating Beta? (round to the nearest tenth of a percent. State this in the following form: 23.02% would be written as 23.02 below)

B. The estimated Walmart Beta for the most recent 36 months would be computed as: (round to the nearest .01)

Dividend 0.53 0.53 0.53 0.52 0.52 0.52 0.52 Month Count 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Date Close Sep-2019 118.68 Aug-2019 114.26 Jul-2019 110.38 Jun-2019 110.49 May-2019 101.44 Apr-2019 102.84 Mar-2019 97.53 Feb-2019 98.99 Jan-2019 95.83 Dec-2018 93.15 Nov-2018 97.65 Oct-2018 100.28 Sep-2018 93.91 Aug-2018 95.86 Jul-2018 89.23 Jun-2018 85.65 May-2018 82.54 Apr-2018 88.46 Mar-2018 88.97 Feb-2018 90.01 Jan-2018 106.60 Dec-2017 98.75 Nov-2017 97.23 Oct-2017 87.31 Sep-2017 78.14 Aug-2017 78.07 Jul-2017 79.99 Jun-2017 75.68 May-2017 78.60 Apr-2017 75.18 Mar-2017 72.08 Feb-2017 70.93 Jan-2017 66.74 Dec-2016 69.12 Nov-2016 70.43 Oct-2016 70.02 Sep-2016 72.12 Aug-2016 71.44 Jul-2016 72.97 Jun-2016 73.02 Monthly Return- WMT 0.0387 0.0400 (0.0010) 0.0892 (0.0085) 0.0544 (0.0094) 0.0330 0.0288 (0.0408) (0.0262) 0.0678 (0.0203) 0.0801 0.0418 0.0377 (0.0610) (0.0057) (0.0058) (0.1556) 0.0795 0.0209 0.1136 0.1174 0.0009 (0.0176) 0.0570 (0.0372) 0.0523 0.0430 0.0234 0.0628 (0.0344) (0.0115) 0.0059 (0.0291) 0.0095 (0.0141) (0.0007) 0.0316 Monthly MRP 0.0155 (0.0197) 0.0112 0.0670 (0.0680) 0.0370 0.0156 0.0273 0.0763 (0.0943) 0.0151 (0.0721) 0.0017 0.0278 0.0336 0.0024 0.0191 0.0003 (0.0294) (0.0415) 0.0539 0.0322 0.0016 0.0200 0.0172 (0.0016) 0.0171 0.0027 0.0093 0.0069 (0.0027) 0.0349 0.0156 0.0158 0.0321 (0.0212) (0.0029) (0.0028) 0.0341 (0.0008) Monthly Return- SP500 0.0172 (0.0181) 0.0131 0.0689 (0.0658) 0.0393 0.0179 0.0297 0.0787 (0.0918) 0.0179 (0.0694) 0.0043 0.0303 0.0360 0.0048 0.0216 0.0027 (0.0269) (0.0389) 0.0562 0.0343 0.0037 0.0222 0.0193 0.0005 0.0193 0.0048 0.0116 0.0091 (0.0004) 0.0372 0.0179 0.0182 0.0342 (0.0194) (0.0012) (0.0012) 0.0356 0.0009 Monthly Return-Rf 20yr 0.00164 0.00159 0.00197 0.00197 0.00219 0.00230 0.00233 0.00239 0.00241 0.00248 0.00273 0.00273 0.00257 0.00248 0.00245 0.00248 0.00254 0.00247 0.00248 0.00252 0.00228 0.00217 0.00217 0.00221 0.00211 0.00213 0.00221 0.00212 0.00225 0.00223 0.00236 0.00230 0.00229 0.00237 0.00212 0.00181 0.00168 0.00158 0.00152 0.00168 0.51 0.51 0.51 0.51 0.5 0.5 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 May-2016 Apr-2016 Mar-2016 Feb-2016 Jan-2016 Dec-2015 Nov-2015 Oct-2015 Sep-2015 Aug-2015 Jul-2015 Jun-2015 May-2015 Apr-2015 Mar-2015 Feb-2015 Jan-2015 Dec-2014 Nov-2014 Oct-2014 Sep-2014 Aug-2014 Jul-2014 Jun-2014 May-2014 Apr-2014 Mar-2014 Feb-2014 Jan-2014 Dec-2013 Nov-2013 Oct-2013 Sep-2013 Aug-2013 Jul-2013 Jun-2013 May-2013 Apr-2013 Mar-2013 Feb-2013 Jan-2013 Dec-2012 Nov-2012 70.78 66.87 68.49 66.34 66.36 61.30 58.84 57.24 64.84 64.73 71.98 70.93 74.27 78.05 82.25 83.93 84.98 85.88 87.54 76.27 76.47 75.50 73.58 75.07 76.77 79.71 76.43 74.70 74.68 78.69 81.01 76.75 73.96 72.98 77.94 74.49 74.84 77.72 74.83 70.78 69.95 68.23 72.02 0.5 0.0659 (0.0237) 0.5 0.0399 (0.0003) 0.0825 0.49 0.0501 0.0280 (0.1172) 0.0017 0.49 (0.0939) 0.0148 (0.0450) 0.49 (0.0422) (0.0511) 0.49 (0.0142) (0.0124) (0.0105) 0.48 (0.0135) 0.1478 (0.0026) 0.0128 0.48 0.0326 (0.0198) (0.0221) 0.48 (0.0309) 0.0429 0.48 0.0296 0.0003 (0.0510) 0.47 (0.0228) 0.0555 0.0377 0.0134 0.47 (0.0576) 0.0463 (0.0047) 0.47 (0.0310) 0.0386 0.47 0.0639 0.0119 0.0252 0.398 (0.0471) (0.0400) 0.0135 0.0009 0.0641 (0.0060) (0.0528) (0.0197) (0.0017) 0.0809 (0.0286) (0.0647) 0.0174 (0.0234) 0.0082 0.0066 (0.0194) 0.0529 (0.0329) (0.0063) 0.0222 0.0209 (0.0180) 0.0352 (0.0176) 0.0164 0.0184 0.0035 0.0041 0.0403 (0.0385) 0.0205 0.0251 0.0418 0.0268 (0.0342) 0.0467 (0.0176) 0.0185 0.0160 0.0337 0.0087 0.0482 0.0050 0.0009 0.0153 0.0027 0.0660 (0.0041) (0.0507) (0.0175) 0.0005 0.0830 (0.0264) (0.0626) 0.0197 (0.0210) 0.0105 0.0085 (0.0174) 0.0549 (0.0310) (0.0042) 0.0245 0.0232 (0.0155) 0.0377 (0.0151) 0.0191 0.0210 0.0062 0.0069 0.0431 (0.0356) 0.0236 0.0280 0.0446 0.0297 (0.0313) 0.0495 (0.0150) 0.0208 0.0181 0.0360 0.0111 0.0504 0.0071 0.0028 0.00185 0.00184 0.00190 0.00183 0.00208 0.00218 0.00224 0.00208 0.00218 0.00213 0.00231 0.00238 0.00224 0.00194 0.00201 0.00195 0.00183 0.00213 0.00230 0.00231 0.00251 0.00245 0.00256 0.00263 0.00260 0.00273 0.00279 0.00282 0.00293 0.00303 0.00292 0.00282 0.00294 0.00291 0.00276 0.00256 0.00228 0.00213 0.00232 0.00232 0.00223 0.00206 0.00199 83 84 85 86 87 88 89 90 91 92 93 94 95 Nov-2012 Oct-2012 Sep-2012 Aug-2012 Jul-2012 Jun-2012 May-2012 Apr-2012 Mar-2012 Feb-2012 Jan-2012 Dec-2011 Nov-2011 Oct-2011 72.02 75.02 73.80 72.60 74.43 69.72 65.82 58.91 61.20 59.08 61.36 59.76 58.90 56.72 (0.0400) 0.0165 0.0165 0.398 (0.0192) 0.0676 0.0593 0.398 0.1241 (0.0374) 0.398 0.0426 (0.0372) 0.0268 0.365 0.0208 0.0384 0.0009 (0.0219) 0.0222 0.0178 0.0107 0.0376 (0.0648) (0.0098) 0.0289 0.0383 0.0413 0.0063 (0.0023) 0.0028 0.00199 (0.0198) 0.00209 0.0242 0.00208 0.0198 0.00200 0.0126 0.00185 0.0396 0.00193 (0.0627) 0.00211 (0.0075) 0.00235 0.0313 0.00245 0.0406 0.00229 0.0436 0.00225 0.0085 0.00223 0.00227 Dividend 0.53 0.53 0.53 0.52 0.52 0.52 0.52 Month Count 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Date Close Sep-2019 118.68 Aug-2019 114.26 Jul-2019 110.38 Jun-2019 110.49 May-2019 101.44 Apr-2019 102.84 Mar-2019 97.53 Feb-2019 98.99 Jan-2019 95.83 Dec-2018 93.15 Nov-2018 97.65 Oct-2018 100.28 Sep-2018 93.91 Aug-2018 95.86 Jul-2018 89.23 Jun-2018 85.65 May-2018 82.54 Apr-2018 88.46 Mar-2018 88.97 Feb-2018 90.01 Jan-2018 106.60 Dec-2017 98.75 Nov-2017 97.23 Oct-2017 87.31 Sep-2017 78.14 Aug-2017 78.07 Jul-2017 79.99 Jun-2017 75.68 May-2017 78.60 Apr-2017 75.18 Mar-2017 72.08 Feb-2017 70.93 Jan-2017 66.74 Dec-2016 69.12 Nov-2016 70.43 Oct-2016 70.02 Sep-2016 72.12 Aug-2016 71.44 Jul-2016 72.97 Jun-2016 73.02 Monthly Return- WMT 0.0387 0.0400 (0.0010) 0.0892 (0.0085) 0.0544 (0.0094) 0.0330 0.0288 (0.0408) (0.0262) 0.0678 (0.0203) 0.0801 0.0418 0.0377 (0.0610) (0.0057) (0.0058) (0.1556) 0.0795 0.0209 0.1136 0.1174 0.0009 (0.0176) 0.0570 (0.0372) 0.0523 0.0430 0.0234 0.0628 (0.0344) (0.0115) 0.0059 (0.0291) 0.0095 (0.0141) (0.0007) 0.0316 Monthly MRP 0.0155 (0.0197) 0.0112 0.0670 (0.0680) 0.0370 0.0156 0.0273 0.0763 (0.0943) 0.0151 (0.0721) 0.0017 0.0278 0.0336 0.0024 0.0191 0.0003 (0.0294) (0.0415) 0.0539 0.0322 0.0016 0.0200 0.0172 (0.0016) 0.0171 0.0027 0.0093 0.0069 (0.0027) 0.0349 0.0156 0.0158 0.0321 (0.0212) (0.0029) (0.0028) 0.0341 (0.0008) Monthly Return- SP500 0.0172 (0.0181) 0.0131 0.0689 (0.0658) 0.0393 0.0179 0.0297 0.0787 (0.0918) 0.0179 (0.0694) 0.0043 0.0303 0.0360 0.0048 0.0216 0.0027 (0.0269) (0.0389) 0.0562 0.0343 0.0037 0.0222 0.0193 0.0005 0.0193 0.0048 0.0116 0.0091 (0.0004) 0.0372 0.0179 0.0182 0.0342 (0.0194) (0.0012) (0.0012) 0.0356 0.0009 Monthly Return-Rf 20yr 0.00164 0.00159 0.00197 0.00197 0.00219 0.00230 0.00233 0.00239 0.00241 0.00248 0.00273 0.00273 0.00257 0.00248 0.00245 0.00248 0.00254 0.00247 0.00248 0.00252 0.00228 0.00217 0.00217 0.00221 0.00211 0.00213 0.00221 0.00212 0.00225 0.00223 0.00236 0.00230 0.00229 0.00237 0.00212 0.00181 0.00168 0.00158 0.00152 0.00168 0.51 0.51 0.51 0.51 0.5 0.5 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 May-2016 Apr-2016 Mar-2016 Feb-2016 Jan-2016 Dec-2015 Nov-2015 Oct-2015 Sep-2015 Aug-2015 Jul-2015 Jun-2015 May-2015 Apr-2015 Mar-2015 Feb-2015 Jan-2015 Dec-2014 Nov-2014 Oct-2014 Sep-2014 Aug-2014 Jul-2014 Jun-2014 May-2014 Apr-2014 Mar-2014 Feb-2014 Jan-2014 Dec-2013 Nov-2013 Oct-2013 Sep-2013 Aug-2013 Jul-2013 Jun-2013 May-2013 Apr-2013 Mar-2013 Feb-2013 Jan-2013 Dec-2012 Nov-2012 70.78 66.87 68.49 66.34 66.36 61.30 58.84 57.24 64.84 64.73 71.98 70.93 74.27 78.05 82.25 83.93 84.98 85.88 87.54 76.27 76.47 75.50 73.58 75.07 76.77 79.71 76.43 74.70 74.68 78.69 81.01 76.75 73.96 72.98 77.94 74.49 74.84 77.72 74.83 70.78 69.95 68.23 72.02 0.5 0.0659 (0.0237) 0.5 0.0399 (0.0003) 0.0825 0.49 0.0501 0.0280 (0.1172) 0.0017 0.49 (0.0939) 0.0148 (0.0450) 0.49 (0.0422) (0.0511) 0.49 (0.0142) (0.0124) (0.0105) 0.48 (0.0135) 0.1478 (0.0026) 0.0128 0.48 0.0326 (0.0198) (0.0221) 0.48 (0.0309) 0.0429 0.48 0.0296 0.0003 (0.0510) 0.47 (0.0228) 0.0555 0.0377 0.0134 0.47 (0.0576) 0.0463 (0.0047) 0.47 (0.0310) 0.0386 0.47 0.0639 0.0119 0.0252 0.398 (0.0471) (0.0400) 0.0135 0.0009 0.0641 (0.0060) (0.0528) (0.0197) (0.0017) 0.0809 (0.0286) (0.0647) 0.0174 (0.0234) 0.0082 0.0066 (0.0194) 0.0529 (0.0329) (0.0063) 0.0222 0.0209 (0.0180) 0.0352 (0.0176) 0.0164 0.0184 0.0035 0.0041 0.0403 (0.0385) 0.0205 0.0251 0.0418 0.0268 (0.0342) 0.0467 (0.0176) 0.0185 0.0160 0.0337 0.0087 0.0482 0.0050 0.0009 0.0153 0.0027 0.0660 (0.0041) (0.0507) (0.0175) 0.0005 0.0830 (0.0264) (0.0626) 0.0197 (0.0210) 0.0105 0.0085 (0.0174) 0.0549 (0.0310) (0.0042) 0.0245 0.0232 (0.0155) 0.0377 (0.0151) 0.0191 0.0210 0.0062 0.0069 0.0431 (0.0356) 0.0236 0.0280 0.0446 0.0297 (0.0313) 0.0495 (0.0150) 0.0208 0.0181 0.0360 0.0111 0.0504 0.0071 0.0028 0.00185 0.00184 0.00190 0.00183 0.00208 0.00218 0.00224 0.00208 0.00218 0.00213 0.00231 0.00238 0.00224 0.00194 0.00201 0.00195 0.00183 0.00213 0.00230 0.00231 0.00251 0.00245 0.00256 0.00263 0.00260 0.00273 0.00279 0.00282 0.00293 0.00303 0.00292 0.00282 0.00294 0.00291 0.00276 0.00256 0.00228 0.00213 0.00232 0.00232 0.00223 0.00206 0.00199 83 84 85 86 87 88 89 90 91 92 93 94 95 Nov-2012 Oct-2012 Sep-2012 Aug-2012 Jul-2012 Jun-2012 May-2012 Apr-2012 Mar-2012 Feb-2012 Jan-2012 Dec-2011 Nov-2011 Oct-2011 72.02 75.02 73.80 72.60 74.43 69.72 65.82 58.91 61.20 59.08 61.36 59.76 58.90 56.72 (0.0400) 0.0165 0.0165 0.398 (0.0192) 0.0676 0.0593 0.398 0.1241 (0.0374) 0.398 0.0426 (0.0372) 0.0268 0.365 0.0208 0.0384 0.0009 (0.0219) 0.0222 0.0178 0.0107 0.0376 (0.0648) (0.0098) 0.0289 0.0383 0.0413 0.0063 (0.0023) 0.0028 0.00199 (0.0198) 0.00209 0.0242 0.00208 0.0198 0.00200 0.0126 0.00185 0.0396 0.00193 (0.0627) 0.00211 (0.0075) 0.00235 0.0313 0.00245 0.0406 0.00229 0.0436 0.00225 0.0085 0.00223 0.00227

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

Recommended Textbook for

Personal Finance

Authors: Jack Kapoor, Les Dlabay, Robert Hughes

4th Edition

0256147175, 978-0256147179

More Books

Students also viewed these Finance questions

Question

★★★★★

The accounting records of Ripken Electric, Inc., reveal the following: Requirements 1. Compute cash flows from operating activities by the direct method. 2. Evaluate the operating cash flow of Ripken...

Answered: 1 week ago

Question

★★★★★

Reconstruct Table 9.1 for when Victor Video is watching a 4 Mbps video, Facebook Frank is looking at a new 100 Kbyte image every 20 seconds, and Martha Music is listening to 200 kbps audio stream....

Answered: 1 week ago

Question

★★★★★

LetAandBbe two events of a sample space such thatP(A) = 0.5 andP(A B) = 0.8. If it is known that P(A|B) = 0.25, then the probability of the event B is (a) 0.9 (b) 0.3 (c) 0.2 (d) 0.4 (e) 0.1

Answered: 1 week ago

Question

★★★★★

The company offers low prices on a limited selection of household arid grocery products. In the past year, sales increased by approximately 8.5 percent and net earnings increased by 12 percent. The...

Answered: 1 week ago

Question

★★★★★

i. Show the truth table of a 74LS139 which is a 2 x 4 IC decoder. (1 mark) Given the truth table of a combinational circuit that accepts three input bits: minuend (X), subtrahend (Y) and previous...

Answered: 1 week ago

Question

★★★★★

Students in a political science course were asked to describe their politics as "Liberal", "Moderate", or "Conservative". Liberal Moderate Conservative Total Female 30 42 11 83 Male 41 47 23 111...

Answered: 1 week ago

Question

★★★★★

Knowing that there are many disasters that exceed local resources, but don't rise to the level of federalsupport, how can an emergency manager at a local or state level manage expectations for these...

Answered: 1 week ago

Question

★★★★★

A local University conducted a survey of over 2,000 MBA alumni to explore the issue of work-life balance. Each participant received a score ranging from 0 to 100, with lower scores indicating a...

Answered: 1 week ago

Question

★★★★★

A worker stands at the end of a production line for mint chocolate chip ice cream and uses warm water to melt the ice cream away from the chocolate. The amount of chocolate is then weighed. Each...

Answered: 1 week ago

Question

★★★★★

A sporting goods store decides to lower prices on high-end sports equipment. How could this change affect market equilibrium? (1 point) O The sporting goods market could experience a surplus. The...

Answered: 1 week ago

Question

★★★★★

This amount of carbonic acid is released by the lungs as carbon dioxide daily: (a) Five liters (about 1 gallon). (b) Ten liters (about 2.5 gallons). (c) Twenty liters (about 5 gallons). (d) Thirty...

Answered: 1 week ago

Question

★★★★★

5. Working individually or in groups, develop several specific examples to illustrate how a professor teaching human resource management could use at least four of the techniques described in this...

Answered: 1 week ago

Question

★★★★★

7. What is organizational development and how does it differ from traditional approaches to organizational change?

Answered: 1 week ago

Question

★★★★★

1. Youre the supervisor of a group of employees whose task is to assemble disk drives that go into computers. You find that quality is not what it should be and that many of your groups devices have...

Answered: 1 week ago

Previous Question Next Question