Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me with this question, thank you! The following table gives abbreviated balance sheets and income statements for Walmart. Balance Sheet (figures in $
Please help me with this question, thank you!
The following table gives abbreviated balance sheets and income statements for Walmart. Balance Sheet (figures in $ millions) End of Year Start of Year $ 6,766 5,624 43,793 3,521 $ 59,704 $ 6,877 5,845 43,056 1,951 $ 57,729 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 $114,828 30,050 $204,582 $114,188 26,968 $198,885 $ 46,102 32,439 $ 78,541 36,835 11,317 $126,693 77,889 $204,582 $ 41,443 25,505 $ 66,948 42,028 12,091 $121,067 77,818 $198,885 95,991 Income Statement (figures in $ millions) Net sales $500, 353 Cost of goods sold 373,406 Selling, general, and administrative expenses Depreciation 10,539 Earnings before interest and taxes (EBIT) $ 20,417 Interest expense 2,188 Taxable income $ 18, 229 Tax 4,600 Net income $ 13,629 Dividends Addition to retained earnings $ 7,495 $485,883 361, 266 91,783 10,090 $ 22,744 2,277 $ 20,467 7,163 $ 13,304 6,705 $ 6,599 6,134 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.)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started