Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Date WMT AMZN SP500 Portfolio 1/29/2010 -0.0374 -6.7722 -3.5971 -3.4048 2/26/2010 1.1978 -5.5897 3.0956 -2.19595 3/31/2010 3.4097 14.6706 6.0347 9.04015 4/30/2010 -3.5252 0.9796 1.578 -1.2728

image text in transcribedimage text in transcribedimage text in transcribed

image text in transcribed

image text in transcribed

Date WMT AMZN SP500 Portfolio 1/29/2010 -0.0374 -6.7722 -3.5971 -3.4048 2/26/2010 1.1978 -5.5897 3.0956 -2.19595 3/31/2010 3.4097 14.6706 6.0347 9.04015 4/30/2010 -3.5252 0.9796 1.578 -1.2728 5/31/2010 -5.1987 -8.4902 -7.9848 -6.84445 6/30/2010 -4.9248 -12.9125 -5.2355 -8.91865 7/30/2010 6.4905 7.89 86 7.0059 7.19455 8/31/2010 -1.4704 5.8868 4.5147 2.2082 9/30/2010 6.7411 25.8191 8.924 16.2801 10/29/2010 1.2145 5.2018 3.8048 3.20815 11/30/2010 -0.1477 6.1551 0.012 3.0037 12/31/2010 0.2577 2.62 26 6.6837 1.44015 1/31/2011 3.9681 -5.7556 2.3697 -0.89375 2/28/2011 -7.2945 2.1516 3.4251 -2.57145 3/31/2011 0.8 286 3.9471 0.0403 2.38785 4/29/2011 5.6292 8.7048 2.9607 7.167 5/31/2011 1.101 0.4494 -1.13 23 0.7752 6/30/2011 -3.7668 3.9656 -1.667 0.0994 7/29/2011 -0.8092 8.8171 -2.0341 4.00395 8/31/2011 1.6715 -3.2761 -5.433 -0.8023 9/30/2011 -2.4253 0.4646 -7.0296 -0.98035 10/31/2011 9.2871 -1.2579 10.9292 4.0146 11/30/2011 3.8434 -9.9386 -0.222 -3.0476 12/30/2011 2.093 -9.9797 1.021 -3.94335 1/31/2012 2.6774 12.3281 4.4812 7.50275 2/29/2012 -3.7158 -7.5859 4.3242 -5.65085 3/30/2012 4.2773 12.6996 3.2853 8.48845 4/30/2012 -3.7418 14.5129 -0.6283 5.38555 5/31/2012 12.4821 -8.1889 -6.0099 2.1466 6/29/2012 5.9253 7.2519 4.1204 6.5886 7/31/2012 6.7556 2.1677 1.3886 4.46165 8/31/2012 -1.9369 6.4166 2.2542 2.23985 9/28/2012 1.6529 2.4369 2.5839 2.0449 10/31/2012 1.6531 -8.4252 -1.8464 -3.38605 11/30/2012 -3.9989 8.2256 0.5799 2.11335 12/31/2012 -4.7368 -0.4682 0.9075 -2.6025 1/31/2013 2.5 209 5.8317 5.1791 4.1763 2/28/2013 1.1866 -0.4633 1.3569 0.36165 3/29/2013 6.4024 0.84 3.7505 3.6212 4/30/2013 3.8621 -4.7582 1.9265 -0.44805 5/31/2013 -3.1272 6.0636 2.338 1.4682 6/28/2013 -0.4677 3.1538 -1.3426 1.34305 7/31/2013 4.6315 8.4735 5.08 84 6.5525 8/30/2013 -5.7951 -6.7193 -2.8972 -6.2572 9/30/2013 1.3428 11.2677 3.1362 6.30525 10/31/2013 3.7723 16.43 74 4.5963 10.10485 2.1285 1.3134 -10.0554 0.9507 -7.1072 -9.5233 2.76 3.913 -3.6301 23229 -4.8962 -5.2661 10.8629 11/29/2013 5.5505 12/31/2013 -2.2947 1/31/2014 -5.6959 2/28/2014 0.0268 3/31/2014 19744 4/30/2014 4.2915 5/30/2014 3.0554 6/30/2014 -2.2144 7/31/2014 -1.984g 8/29/2014 3.2732 9/30/2014 1.2242 10/31/2014 -0.2615 11/28/2014 14.7765 12/31/2014 -1.3419 1/30/2015 -1.048 2/27/2015 -1.2356 3/31/2015 -1.4066 4/30/2015 -5.1064 5/29/2015 -4.2426 6/30/2015 -4.4971 7/31/2015 1.4803 8/31/2015 -9.4728 9/30/2015 0.1699 10/30/2015 -11.7212 11/30/2015 2.7952 12/31/2015 5.0557 1/29/2016 8.2545 2/29/2016 -0.0301 3/31/2016 4.0053 4/29/2016 -2.3653 5/31/2016 6.6441 6/30/2016 3.1647 7/29/2016 -0.0685 8/31/2016 -1.4348 9/30/2016 0.9518 10/31/2016 -2.6118 11/30/2016 0.5855 12/30/2016 -1.165 1/31/2017 3.4433 2/28/2017 6.2781 3/31/2017 2.3638 4/28/2017 4.300g 5/31/2017 5.2443 6/30/2017 3.715 7/31/2017 5. E95 8/31/2017 -1.7904 9/29/2017 0.0 g -8.354 14.2355 7.223 -2.1202 13.35 12 1.768 1.1323 23.5113 -4.3383 -0.155 22.2724 6.2151 1. 6682 -13.1515 -5.8739 7.4423 11.1094 5.5817 -0.992 6.0353 1.364 8. 8603 -5.6717 -4.9695 -0.2S 33 9.2164 2.6182 4.11 4.3971 7.526 -2.67M 2.0434 -0.28 -1.631 3.0468 6.8395 2.5248 -0.49065 -3.454 -7.57565 4.5735 6.42275 0.240g -2.0664 0.739 -2.6459 2346 -0.1634 2.0658 6.2493 -1.3792 -2.80745 4.0601 5.79205 -1.4021 -1.8057 2.442 -2.7638 2.6882 12.2194 -0.2573 -4.84795 3.2018 6.59375 5747 299685 -1.5812 -1.7634 0.959 4.1224 1.2261 -1.23815 -1.9352 -1.6824 2.09 54 12.495g -6.03 38 -6.90555 2.47 39 -0.01255 8.4352 5.2756 0.2975 4.50515 -1.5862 3.36195 4.9626 -2.4485 -0.1347 -2.952 6.786 5.7238 0.3879 437205 1.7954 2.1129 0.2595 1.08635 3.6865 2.9834 0.1407 -0.0354 0.6187 4.50605 -1.8242 -4.29175 3.766 -2.192 1.9699 -0.62915 1.8966 3.18655 3.9705 4.44815 0.116 3.6874 1.0271 4.31895 1.4072 638595 0.6241 3.1957 2.05 62 3.8692 0.3661 -1.25865 2.06 28 -0.967 10/31/2017 11/30/2017 12/29/2017 1/31/2018 2/28/2018 3/30/2018 4/30/2018 5/31/2018 6/29/2018 7/31/2018 8/31/2018 9/28/2018 10/31/2018 11/30/2018 12/31/2018 1/31/2019 2/28/2019 3/29/2019 4/30/2019 5/31/2019 6/28/2019 7/31/2019 8/30/2019 9/30/2019 10/31/2019 11/29/2019 12/31/2019 1/31/2020 2/28/2020 3/31/2020 4/30/2020 5/29/2020 11.7353 11.3618 2.0985 1.9494 -15.5629 -0.5708 -0.5732 -.1055 3.7679 4.1798 8.0578 -2.0342 6.7831 -2.6227 -4.0849 2.8771 3.2975 -0.9433 5.4445 -0.8361 8.9215 -0.0996 14.9717 2.3334 13.3535 6.4662 3.0671 3.914 -0.6187 1.1047 0.7399 24.0639 5.7232 16.00665 4.2429 -3.686 -5.66 -4.3049 2.5412 -2.43785 8. 2075 0.3836 3.81715 4.05 39 2.4077 -1.0258 4.3065 0.6155 4.0372 4.5676 3.7215 4.3737 13.2365 3.2583 10.64715 -0.48 24 0.5692 -12583 -20.2192 -6.8352 -6.71805 5.7672 2.0375 1.57225 -11.135 -9.0332 -7.60995 14.4317 8.0134 8.6544 -4.5906 3.2108 -0.64655 8.5936 1.9432 3.82515 8.1859 4.0489 6.8152 -7.8613 -6.3549 -4.3487 6.6792 7.0477 7.80035 -1.4179 1.4373 -0.75875 -4.8474 -1.534 -0.41335 -2.2733 1.8711 0.79755 2.3475 2.1657 0.5755 1.3587 3.63 1.45965 2.6122 3.01 15 1.424 8.7064 0.0439 2.523 -6.2214 -8.2321 -6.08475 3.5021 -12.3512 4.74775 26.09 12.8194 16.9347 -1.27 85 4.763 0.61935 4.0207 3.8694 -1.1965 1.560 0.2358 -3.6604 -5.9481 5.9934 6.9794 2.5172 What is the standard deviation of Walmart's stock returns over the 5 months in 2020? Answer in % terms w/o % sign and to 4 decimal places (1.2345) Compute the weight of common equity that should be used in the firm's WACC calculation if the market value of the firm's debt is $59 million, the market value of the firm's preferred stock is $7 million and the market value of the firm's common equity is $111 million. Enter your answer as a decimal (i.e. 0.54)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Business Analysis And Valuation Using Financial Statements

Authors: Krishna G Palepu, Paul M Healy

4th Edition

032430286X, 9780324302868

More Books

Students also viewed these Finance questions