The following table gives abbreviated balance sheets and income statements for Walmart. Balance Sheet (figures in...

Transcribed Image Text:

The following table gives abbreviated balance sheets and income statements for Walmart. Balance Sheet (figures in $ millions) Fiscal Fiscal 2019 2018 Assets Current assets: Cash and marketable securities $ 9,465 $ 7,722 Accounts receivable Inventories 6,284 44,435 6,283 44,269 Other current assets Total current assets Fixed assets: Net fixed assets Other long-term assets Total assets Liabilities and Shareholders' Equity Current liabilities: Accounts payable Other current liabilities Total current liabilities Long-term debt Other long-term liabilities Total liabilities Total shareholders' equity Total liabilities and shareholders' equity 1,622 3,623 $ 61,806 $ 61,897 $ 127,049 47,640 $ 236,495 $ 111,395 46,003 $ 219,295 $ 46,973 30,817 $ 77,790 43,714 33,439 $ 47,060 30,417 $ 77,477 43,520 18,664 $ $ 139,661 154,943 81,552 79,634 $ 219,295 236,495 Income Statement (figures in $ millions) Net sales Cost of goods sold Selling, general, and administrative expenses Depreciation Other income/expenses Earnings before interest and taxes (EBIT) Interest expense Taxable income Tax Net income $ 523,964 394,605 97,804 10,987 2,147 $ 22,715 2,599 $ 20,116 4,915 $ 15,201 Assume a tax rate of 21%. Calculate the following using balance-sheet figures and Income statement figures: a. Calculate the return on assets. (Fiscal 2018) Note: Enter your answer as a percent rounded to 2 decimal places. b. Calculate the operating profit margin. Note: Enter your answer as a percent rounded to 2 decimal places. c. Calculate the sales-to-assets ratio. (Fiscal 2019) Note: Round your answer to 2 decimal places. d. Calculate the inventory turnover. (Fiscal 2018) Note: Round your answer to 2 decimal places. e. Calculate the debt-equity ratio. (Fiscal 2019) Note: Round your answer to 4 decimal places. f. Calculate the current ratio. (Fiscal 2019) Note: Round your answer to 4 decimal places. g. Calculate the quick ratio. (Fiscal 2019) Note: Round your answer to 4 decimal places. The following table gives abbreviated balance sheets and income statements for Walmart. Balance Sheet (figures in $ millions) Fiscal Fiscal 2019 2018 Assets Current assets: Cash and marketable securities $ 9,465 $ 7,722 Accounts receivable Inventories 6,284 44,435 6,283 44,269 Other current assets Total current assets Fixed assets: Net fixed assets Other long-term assets Total assets Liabilities and Shareholders' Equity Current liabilities: Accounts payable Other current liabilities Total current liabilities Long-term debt Other long-term liabilities Total liabilities Total shareholders' equity Total liabilities and shareholders' equity 1,622 3,623 $ 61,806 $ 61,897 $ 127,049 47,640 $ 236,495 $ 111,395 46,003 $ 219,295 $ 46,973 30,817 $ 77,790 43,714 33,439 $ 47,060 30,417 $ 77,477 43,520 18,664 $ $ 139,661 154,943 81,552 79,634 $ 219,295 236,495 Income Statement (figures in $ millions) Net sales Cost of goods sold Selling, general, and administrative expenses Depreciation Other income/expenses Earnings before interest and taxes (EBIT) Interest expense Taxable income Tax Net income $ 523,964 394,605 97,804 10,987 2,147 $ 22,715 2,599 $ 20,116 4,915 $ 15,201 Assume a tax rate of 21%. Calculate the following using balance-sheet figures and Income statement figures: a. Calculate the return on assets. (Fiscal 2018) Note: Enter your answer as a percent rounded to 2 decimal places. b. Calculate the operating profit margin. Note: Enter your answer as a percent rounded to 2 decimal places. c. Calculate the sales-to-assets ratio. (Fiscal 2019) Note: Round your answer to 2 decimal places. d. Calculate the inventory turnover. (Fiscal 2018) Note: Round your answer to 2 decimal places. e. Calculate the debt-equity ratio. (Fiscal 2019) Note: Round your answer to 4 decimal places. f. Calculate the current ratio. (Fiscal 2019) Note: Round your answer to 4 decimal places. g. Calculate the quick ratio. (Fiscal 2019) Note: Round your answer to 4 decimal places.