Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following table gives abbreviated balance sheets and income statements for Walmart. At the end of fiscal 2017, Walmart had 3,045 million shares outstanding with

The following table gives abbreviated balance sheets and income statements for Walmart. At the end of fiscal 2017, Walmart had 3,045 million shares outstanding with a share price of $140. The company's weighted-average cost of capital was about 5%. Assume a tax rate of 35%.

Balance Sheet (figures in $ millions)
End of Year Start of Year
Assets
Current assets:
Cash and marketable securities $ 6,926 $ 7,037
Accounts receivable 5,784 6,005
Inventories 43,953 43,216
Other current assets 3,681 2,111
Total current assets $ 60,344 $ 58,369
Fixed assets:
Net fixed assets $ 114,988 $ 114,348
Other long-term assets 30,210 27,128
Total assets $ 205,542 $ 199,845
Liabilities and Shareholders' Equity
Current liabilities:
Accounts payable $ 46,262 $ 41,603
Other current liabilities 32,599 25,665
Total current liabilities $ 78,861 $ 67,268
Long-term debt 36,995 42,188
Other long-term liabilities 11,477 12,251
Total liabilities $ 127,333 $ 121,707
Total shareholders' equity 78,209 78,138
Total liabilities and shareholders equity $ 205,542 $ 199,845
Income Statement (figures in $ millions)
Net sales $ 500,513 $ 486,043
Cost of goods sold 373,566 361,426
Selling, general, and administrative expenses 96,151 91,943
Depreciation 10,699 10,250
Earnings before interest and taxes (EBIT) $ 20,097 $ 22,424
Interest expense 2,348 2,437
Taxable income $ 17,749 $ 19,987
Tax 4,600 6,995
Net income $ 13,149 $ 12,992
Dividends 6,294 6,865
Addition to retained earnings $ 6,855 $ 6,127

a. Calculate the market value added. (Do not round intermediate calculations. Enter your answer in millions rounded to nearest whole number.)

b. Calculate the market-to-book ratio. (Do not round intermediate calculations. Round your answer to 2 decimal places.)

c. Calculate the economic value added. (Do not round intermediate calculations. Enter your answer in millions rounded to nearest whole number.)

d. Calculate the return on start-of-the-year capital. (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)

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

Smart Diversification

Authors: Fuquan Bilal

1st Edition

979-8986481609

More Books

Students also viewed these Finance questions

Question

a. Given the circumstances, what decision should the CEO make? Why?

Answered: 1 week ago