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) End of Year Start of Year Assets Current assets: Cash and marketable securities Accounts receivable Inventories 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 $ 6,776 5,634 $ 6,887 43,803 3,531 5,855 43,066 1,961 $ 57,769 $ 59,744 $114,838 30,060 $204,642 $114,198 26,978 $198,945 $ 46,112 32,449 $ 78,561 36,845 11,327 $ 41,453 25,515 $ 66,968 42,038 12,101 $126,733 $121,107 77,909 77,838 $204,642 $198,945 Income Statement (figures in $ millions) $500,363 $485,893 373,416 361,276 96,001 10,549 Net sales Cost of goods sold Selling, general, and administrative expenses Depreciation Earnings before interest and taxes (EBIT) Interest expense Taxable income Tax Net income Dividends Addition to retained earnings $ 20,397 2,198 $ 18,199 4,600 $ 13,599 6,144 $ 7,455 91,793 10,100 $ 22,724 2,287 $ 20,437 7,153 $ 13,284 6,715 $ 6,569 Assume a tax rate of 35%. Calculate the following using balance-sheet figures from the start of the year and Income statement figures from the end of the year: a. Calculate the return on assets. (Enter your answer as a percent rounded to 2 decimal places.) b. Calculate the operating profit margin. (Enter your answer as a percent rounded to 2 decimal places.) c. Calculate the sales-to-assets ratio. (Round your answer to 2 decimal places.) d. Calculate the inventory turnover. (Round your answer to 2 decimal places.) e. Calculate the debt-equity ratio. (Round your answer to 4 decimal places.) f. Calculate the current ratio. (Round your answer to 3 decimal places.) g. Calculate the quick ratio. (Round your answer to 4 decimal places.) a. Return on assets b. Operating profit margin c. Sales-to-assets ratio d. Inventory turnover e Debt-equity ratio f Current ratio g Quick ratio % % The following table gives abbreviated balance sheets and income statements for Walmart. Balance Sheet (figures in $ millions) End of Year Start of Year Assets Current assets: Cash and marketable securities Accounts receivable Inventories 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 $ 6,776 5,634 $ 6,887 43,803 3,531 5,855 43,066 1,961 $ 57,769 $ 59,744 $114,838 30,060 $204,642 $114,198 26,978 $198,945 $ 46,112 32,449 $ 78,561 36,845 11,327 $ 41,453 25,515 $ 66,968 42,038 12,101 $126,733 $121,107 77,909 77,838 $204,642 $198,945 Income Statement (figures in $ millions) $500,363 $485,893 373,416 361,276 96,001 10,549 Net sales Cost of goods sold Selling, general, and administrative expenses Depreciation Earnings before interest and taxes (EBIT) Interest expense Taxable income Tax Net income Dividends Addition to retained earnings $ 20,397 2,198 $ 18,199 4,600 $ 13,599 6,144 $ 7,455 91,793 10,100 $ 22,724 2,287 $ 20,437 7,153 $ 13,284 6,715 $ 6,569 Assume a tax rate of 35%. Calculate the following using balance-sheet figures from the start of the year and Income statement figures from the end of the year: a. Calculate the return on assets. (Enter your answer as a percent rounded to 2 decimal places.) b. Calculate the operating profit margin. (Enter your answer as a percent rounded to 2 decimal places.) c. Calculate the sales-to-assets ratio. (Round your answer to 2 decimal places.) d. Calculate the inventory turnover. (Round your answer to 2 decimal places.) e. Calculate the debt-equity ratio. (Round your answer to 4 decimal places.) f. Calculate the current ratio. (Round your answer to 3 decimal places.) g. Calculate the quick ratio. (Round your answer to 4 decimal places.) a. Return on assets b. Operating profit margin c. Sales-to-assets ratio d. Inventory turnover e Debt-equity ratio f Current ratio g Quick ratio % %