Calculate the WACC for Walmart (NYSE: WMT). Please utilize the attached file for the cost of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Calculate the WACC for Walmart (NYSE: WMT). Please utilize the attached file for the cost of debt calculation and Yahod Finance historical data for the time period of January 1, 2018 through January 1, 2023 for the other components of the WACC. Consider 20% as the effective tax rate for Walmart. For your final submission, please screenshot your Cost of Debt sheet, Beta calculation sheet, market return calculation sheet, and submit inside a pdf along with screenshots of the remainder of your WACC calculation. Please use =FORMULATEXT in Excel to show any applicable formulas you used. Note: For the cost of debt calculation, please use the midpoint of the ask yield and bid yield. Please let me know if you have any questions. This is NOT a group assignment. Please honor pledge. Ticker Coupon Maturity Currency Ask Price Ask Yield to Maturity WMT 99.493 4.214493663 WMT 99.017 4.30539631 4.121505287 99.288 99.652 4.581097875 4.15 9/9/2032 USD 3.9 9/9/2025 USD 3.95 9/9/2027 USD 2.55 4/11/2023 USD 4.5 9/9/2052 USD 1.05 9/17/2026 USD 3.3 4/22/2024 USD 3.7 6/26/2028 USD 3.4 6/26/2023 USD 4.535845582 4.338274053 4.740556593 4.106244961 4.838127986 WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT 1.8 9/22/2031 USD 4.05 6/29/2048 USD: 2.85 7/8/2024 USD 1.5 9/22/2028 USD 2.65 9/22/2051 USD 2.375 9/24/2029 USD 6.2 4/15/2038 USD 7.55 2/15/2030 USD. 3.05 7/8/2026 USD 0.298 7/18/2024 JPY 3.55 6/26/2025 USD 4.875 9/21/2029 EUR 5.25 9/1/2035 USD 6.75 10/15/2023 USD 2.5 9/22/2041 USD 2.65 12/15/2024 USD 3.95 6/28/2038 USD 2.55 4/8/2026 EUR 6.5 8/15/2037 USD 3.25 7/8/2029 USD 5.75 12/19/2030 GBP 4.875 1/19/2039 GBP 4.875 7/8/2040 USD 5.875 4/5/2027 USD 5.625 3/27/2034 GBP 4 4/11/2043 USD 5.25 9/28/2035 GBP 0.52 7/16/2027 JPY 3.625 12/15/2047 USD 5.625 4/15/2041 USD 5 10/25/2040 USD 2.95 9/24/2049 USD 5.625 4/1/2040 USD 4.75 10/2/2043 USD 4.3 4/22/2044 USD 4.15 9/9/2032 USD 4.5 9/9/2052 USD 3.9 9/9/2025 USD 3.95 9/9/2027 USD 4.15 9/9/2032 USD 4.5 9/9/2052 USD 3.9 9/9/2025 USD 3.95 9/9/2027 USD 99.416 89.14 98.334 98.054 99.459 83.147 93.569 97.567 67.178 72.061 89.393 118.64 119.678 96.567 99.68 98.408 110.716 109.009 101.523 75.816 97.188 94.743 96.417 121.39 94.986 112.733 107.21 102.868 106.945 114.595 93.936 111.358 99.484 86.732 113.237 104.995 77.03 112.011 103.768 97.114 99.493 99.416 99.017 99.288 99.493 99.416 99.017 99.288 4.145713985 4.476232325 4.649543412 4.077009675 4.370030821 4.227756242 4.49226079 4.273187998 4.138767738 0.521504561 4.259569696 3.057213116 4.31306722 4.440482511 4.419214773 4.247203675 4.424397342 3.082308157 4.479616307 4.148281333 3.855562464 4.247611062 4.632861304 4.039973473 3.987851402 4.458580929 4.089317376 0.638219984 4.518852479 4.546614584 4.584483613 4.427227801 4.603658914 4.468239511 4.512468701 4.214493663 4.535845582 4.30539631 4.121505287 4.214493663 4.535845582 4.30539631 4.121505287 Bid Yield to Maturity Issued Amount 4.251254906 1250000000 4.348270053 1750000000 4.16038571 1000000000 4.782383427 175000000 4.574643106 100000 4.376822762 12500 4.808984868 15000000 4.144141215 2750000000 4.98394341 275000000 4.180369125 2000000000 4.519936631 30000000 4.689448339 150000 4.138368082 4.404661866 15000 4.307109911 5000 4.579257591 20000 4.318355726 100000000 4.214999666 12500 0.548811345 4000 4.336315689 15000 3.176209989 10000 4.383130463 25000 4.952454454 2500000 4.456572302 10000 4.29817579 100000000 4.468416937 150000 3.212827265 65000000 4.555416771 300000000 4.207656285 12500000 3.964411533 5000 4.332766826 10000000 4.695736122 75000000 4.090482517 750000000 4.066051542 1000000000 4.53690211 10000000 4.177601418 10000 0.855142252 60000 4.624547489 1000 4.599023654 200000 4.662358941 1250 4.477245165 10000 4.670977922 12500 4.558854405 7500 4.580412973 10000000 4.251254966 125000 4.574643106 10000000 4.348270053 17500 4.16038571 1000000 4.251254966 1250 4.574643106 10000000 4.348270053 1750000 4.16038571 1000000000 Calculate the WACC for Walmart (NYSE: WMT). Please utilize the attached file for the cost of debt calculation and Yahod Finance historical data for the time period of January 1, 2018 through January 1, 2023 for the other components of the WACC. Consider 20% as the effective tax rate for Walmart. For your final submission, please screenshot your Cost of Debt sheet, Beta calculation sheet, market return calculation sheet, and submit inside a pdf along with screenshots of the remainder of your WACC calculation. Please use =FORMULATEXT in Excel to show any applicable formulas you used. Note: For the cost of debt calculation, please use the midpoint of the ask yield and bid yield. Please let me know if you have any questions. This is NOT a group assignment. Please honor pledge. Ticker Coupon Maturity Currency Ask Price Ask Yield to Maturity WMT 99.493 4.214493663 WMT 99.017 4.30539631 4.121505287 99.288 99.652 4.581097875 4.15 9/9/2032 USD 3.9 9/9/2025 USD 3.95 9/9/2027 USD 2.55 4/11/2023 USD 4.5 9/9/2052 USD 1.05 9/17/2026 USD 3.3 4/22/2024 USD 3.7 6/26/2028 USD 3.4 6/26/2023 USD 4.535845582 4.338274053 4.740556593 4.106244961 4.838127986 WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT 1.8 9/22/2031 USD 4.05 6/29/2048 USD: 2.85 7/8/2024 USD 1.5 9/22/2028 USD 2.65 9/22/2051 USD 2.375 9/24/2029 USD 6.2 4/15/2038 USD 7.55 2/15/2030 USD. 3.05 7/8/2026 USD 0.298 7/18/2024 JPY 3.55 6/26/2025 USD 4.875 9/21/2029 EUR 5.25 9/1/2035 USD 6.75 10/15/2023 USD 2.5 9/22/2041 USD 2.65 12/15/2024 USD 3.95 6/28/2038 USD 2.55 4/8/2026 EUR 6.5 8/15/2037 USD 3.25 7/8/2029 USD 5.75 12/19/2030 GBP 4.875 1/19/2039 GBP 4.875 7/8/2040 USD 5.875 4/5/2027 USD 5.625 3/27/2034 GBP 4 4/11/2043 USD 5.25 9/28/2035 GBP 0.52 7/16/2027 JPY 3.625 12/15/2047 USD 5.625 4/15/2041 USD 5 10/25/2040 USD 2.95 9/24/2049 USD 5.625 4/1/2040 USD 4.75 10/2/2043 USD 4.3 4/22/2044 USD 4.15 9/9/2032 USD 4.5 9/9/2052 USD 3.9 9/9/2025 USD 3.95 9/9/2027 USD 4.15 9/9/2032 USD 4.5 9/9/2052 USD 3.9 9/9/2025 USD 3.95 9/9/2027 USD 99.416 89.14 98.334 98.054 99.459 83.147 93.569 97.567 67.178 72.061 89.393 118.64 119.678 96.567 99.68 98.408 110.716 109.009 101.523 75.816 97.188 94.743 96.417 121.39 94.986 112.733 107.21 102.868 106.945 114.595 93.936 111.358 99.484 86.732 113.237 104.995 77.03 112.011 103.768 97.114 99.493 99.416 99.017 99.288 99.493 99.416 99.017 99.288 4.145713985 4.476232325 4.649543412 4.077009675 4.370030821 4.227756242 4.49226079 4.273187998 4.138767738 0.521504561 4.259569696 3.057213116 4.31306722 4.440482511 4.419214773 4.247203675 4.424397342 3.082308157 4.479616307 4.148281333 3.855562464 4.247611062 4.632861304 4.039973473 3.987851402 4.458580929 4.089317376 0.638219984 4.518852479 4.546614584 4.584483613 4.427227801 4.603658914 4.468239511 4.512468701 4.214493663 4.535845582 4.30539631 4.121505287 4.214493663 4.535845582 4.30539631 4.121505287 Bid Yield to Maturity Issued Amount 4.251254906 1250000000 4.348270053 1750000000 4.16038571 1000000000 4.782383427 175000000 4.574643106 100000 4.376822762 12500 4.808984868 15000000 4.144141215 2750000000 4.98394341 275000000 4.180369125 2000000000 4.519936631 30000000 4.689448339 150000 4.138368082 4.404661866 15000 4.307109911 5000 4.579257591 20000 4.318355726 100000000 4.214999666 12500 0.548811345 4000 4.336315689 15000 3.176209989 10000 4.383130463 25000 4.952454454 2500000 4.456572302 10000 4.29817579 100000000 4.468416937 150000 3.212827265 65000000 4.555416771 300000000 4.207656285 12500000 3.964411533 5000 4.332766826 10000000 4.695736122 75000000 4.090482517 750000000 4.066051542 1000000000 4.53690211 10000000 4.177601418 10000 0.855142252 60000 4.624547489 1000 4.599023654 200000 4.662358941 1250 4.477245165 10000 4.670977922 12500 4.558854405 7500 4.580412973 10000000 4.251254966 125000 4.574643106 10000000 4.348270053 17500 4.16038571 1000000 4.251254966 1250 4.574643106 10000000 4.348270053 1750000 4.16038571 1000000000
Expert Answer:
Related Book For 
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Calculate the WACC for the following company, using both book value and market value weightings. Book value Cost Ordinary shares GH30 million 20% Long-term debt 15 m 10% The debt is permanent and its...
-
Calculate the WACC for the Uprite Door Corporation. The all equity cost of capital is 17% and the target debt to value ratio is 40%. The current cost of debt for a firm of this risk is 9% and the...
-
Calculate the WACC for HFC using the data provided in the exhibits; assume a Market Risk Premium of 5.5%. Estimate the stand-alone value of HFC using the free-cash-flow projections provided in case...
-
Explain the purpose of each of the following accounts used in a public share issue: Share Capital, Application, Cash Trust, Allotment, Call, Calls in Advance.
-
Jim Gaffigan has prepared the following list of statements about internal control. 1. One of the objectives of internal control is to safeguard assets from employee theft, robbery, and unauthorized...
-
A particle that is at the origin of coordinates at exactly t = 0 vibrates about the origin along the y-axis with a frequency of 20 Hz and an amplitude of 3.0 cm. Write out its equation of motion in...
-
A crystal particle of pure \(\mathrm{NaCl}\) is dissolving in an aqueous liquid (water) solution at \(18^{\circ} \mathrm{C}\). The dissolution of the particle is controlled by mass transfer. The...
-
During 2014, DeLuca Company had net sales of $5,700,000. Most of the sales were on credit. At the end of 2014, the balance of Accounts Receivable was $700,000 and Allowance for Uncollectible Accounts...
-
INSTRUCTIONS: This question contains two (2) parts. Respond to both parts. In your answer, use bold text to label your response to each part (e.g. Part a): Your response...) Part a): Define NPV and...
-
Question 1 According to a distribution network optimization conducted 5 years ago, all the demand of AL, GA, KY, SC, and TN is shipped from the warehouse located in Atlanta, GA. The warehouse in...
-
Assume the company has $20 000 in tax losses carried forward from the previous year. Explain how the company would treat this tax loss assuming that taxation legislation allows such losses to be...
-
Richards Corporation issued $400,000 of 3%, 10-year bonds on January 1, 2024, for $337,643. This price provided a yield of 5% on the bonds. Interest is payable semiannually on June 30 and December...
-
From reviewing Amazon's latest Annual Report that is made accessible to general public through the SEC, what are the overall impressions of the company's diversification strategies (products and/or...
-
In the land of Mordor, the Dark Lord Sauron rules over alarge population of Orcs. Orcs produce weapons (final output, Y)with their own work (labor input L) and using steel tools (capitalinput K),...
-
Kate's Candy Corporation makes chewy chocolate candles at a plant in Winston-Salem, North Carolina. Steve Bishop, the production manager at this facility. Installed a packaging machine last year at a...
-
A diagonal of a square connects the points (-4,3) and (2,-3). Find the area and the perimeter of the square.
-
Identify the top three concepts or skills you learned in this course that you believe will be the most useful to you in your current or future professional career or education along with rationale as...
-
Marc Company assembles products from a group of interconnecting parts. The company produces some of the parts and buys some from outside vendors. The vendor for Part X has just increased its price by...
-
Steve Jackson (age 51) is a single taxpayer living at 3215 Pacific Dr., Del Mar, CA 92014. His Social Security number is 465-88-9415. In 2012, Steve's earnings and income tax withholding as the...
-
Ken (age 31) and Amy (age 28) Booth have brought you the following information regarding their income, expenses, and withholding for the year. They are unsure which of these items must be used to...
-
Scott Butterfield is self-employed as a CPA. He uses the cash method of accounting, and his Social Security number is 644-47-7833. His principal business code is 541211. Scott's CPA practice is...
-
Indicate whether the following items, a through j, are (1) typical characteristics of open-book management or (2) not typical characteristics of open-book management. a. Considered a large size...
-
Match each of the blockchain terms, 1 through 7, with the most appropriate definition, choosing from items a through \(g\). Definitions a. b. C. - Allows for automation of external transactions...
-
Match the concept listed in items 1 through 8 with the most appropriate description listed in items a through h. Concept 1. Capital investment analysis 2. Type of environmental control 3. End-of-pipe...
Study smarter with the SolutionInn App