The following table gives abbreviated balance sheets and income statements for Walmart. Balance Sheet (figures in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following table gives abbreviated balance sheets and income statements for Walmart. Balance Sheet (figures in $ millions) 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 Net sales Cost of goods sold Fiscal 2019 Selling, general, and administrative expenses $ 9,465 6,284 44,435 1,622 $ 61,806 $ 127,049 47,640 $ 236,495 Income Statement (figures in $ millions) $ 154,943 81,552 $ 46,973 $ 47,060 30,817 30,417 $ 77,790 43,714 33,439 $ 236,495 Fiscal 2018 $ 7,722 6,283 44,269 3,623 $ 61,897 $ 111,395 46,003 $ 219,295 $ 523,964 394,605 97,804 $ 77,477 43,520 18,664 $ 139,661 79,634 $ 219,295 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 Note: Round your answer to 2 decimal places. d. Calculate the inventory turnover. Note: Round your answer to 2 decimal places. e. Calculate the debt-equity ratio. Note: Round your answer to 4 decimal places. f. Calculate the current ratio. 97,804 10,987 2,147 Note: Round your answer to 4 decimal places. g. Calculate the quick ratio. Note: Round your answer to 4 decimal places. $ 22,715 2,599 $ 20,116 Assume a tax rate of 21%. Calculate the following using balance-sheet figures from the start of the year and Income statement figures from the end of the year: 4,915 $ 15,201 a. Calculate the return on assets. 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. The following table gives abbreviated balance sheets and income statements for Walmart. Balance Sheet (figures in $ millions) 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 Net sales Cost of goods sold Fiscal 2019 Selling, general, and administrative expenses $ 9,465 6,284 44,435 1,622 $ 61,806 $ 127,049 47,640 $ 236,495 Income Statement (figures in $ millions) $ 154,943 81,552 $ 46,973 $ 47,060 30,817 30,417 $ 77,790 43,714 33,439 $ 236,495 Fiscal 2018 $ 7,722 6,283 44,269 3,623 $ 61,897 $ 111,395 46,003 $ 219,295 $ 523,964 394,605 97,804 $ 77,477 43,520 18,664 $ 139,661 79,634 $ 219,295 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 Note: Round your answer to 2 decimal places. d. Calculate the inventory turnover. Note: Round your answer to 2 decimal places. e. Calculate the debt-equity ratio. Note: Round your answer to 4 decimal places. f. Calculate the current ratio. 97,804 10,987 2,147 Note: Round your answer to 4 decimal places. g. Calculate the quick ratio. Note: Round your answer to 4 decimal places. $ 22,715 2,599 $ 20,116 Assume a tax rate of 21%. Calculate the following using balance-sheet figures from the start of the year and Income statement figures from the end of the year: 4,915 $ 15,201 a. Calculate the return on assets. 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.
Expert Answer:
Answer rating: 100% (QA)
To calculate the requested ratios well use the following formulas a Return on Assets ROA Net Income Average Total Assets b Operating Profit Margin Ear... View the full answer
Related Book For
Principles of Corporate Finance
ISBN: 978-0077404895
10th Edition
Authors: Richard A. Brealey, Stewart C. Myers, Franklin Allen
Posted Date:
Students also viewed these accounting questions
-
Table on the following page gives abbreviated balance sheets and income statements for Estée Lauder Companies. Calculate the following ratios: a. Return on assets. b. Operating profit...
-
Table 28.11 shown below gives abbreviated balance sheets and income statements for Estée Lauder Companies. Calculate the following ratios: a. Return on assets. b. Operating profit margin. c....
-
Table 28.8 gives abbreviated balance sheets and income statements for Walmart. At the end of fiscal 2017, Walmart had 2,960 million shares outstanding with a share price of $106. The company?s...
-
Corning-Howell reported taxable income in 2013 of $120 million. At December 31, 2013, the reported amount of some assets and liabilities in the financial statements differed from their tax bases as...
-
A parallel-plate capacitor has capacitance C = 12.5 pF when the volume between the plates is filled with air. The plates are circular, with radius 3.00 cm. The capacitor is connected to a battery and...
-
Which of the following base sequences would most likely he recognized by a restriction (endonuclease? Explain. (a) GAATTC (b) GATTACA (c) CTCGAG
-
Zeds Manufacturing incurred the following costs in acquiring land, making land improvements, and constructing and furnishing a new building. Zeds Manufacturing depreciates buildings over 50 years,...
-
On January 1, 2016, Prairie Enterprises purchased a parcel of land for $28,000 cash. At the time of purchase, the company planned to use the land for a warehouse site. In 2018, Prairie Enterprises...
-
What are the ethical considerations surrounding organizational culture, such as the promotion of ethical behavior, integrity, and accountability, and how can organizations foster a culture of ethical...
-
Post - Combination Balance Sheet Presented below are the balance sheets of Allen Corporation and Benson Corporation, immediately prior to a business combination. The fair values of Benson s reported...
-
Prompt Your Information Technology Solutions Plan should address the following prompt: Given the business case scenario below, you will design a Information Technology Solutions Plan that will...
-
In year 1, Adam earns $1,000 and saves $100. In year 2, Adam gets a $500 raise so that he earns a total of $1,500. Out of that $1,500, he saves $200. What is Adams MPC out of his $500 raise? a. 0.50...
-
Go Green is a business selling worm farm start-up kits for \(\$ 12\) each. This year, Go Green's fixed cost totals \(\$ 110000\). The variable cost per kit is \(\$ 7\). Required: a What is the...
-
Suppose that a country has a trade surplus of $50 billion, a balance on the capital account of $10 billion, and a balance on the current account of $200 billion. The balance on the capital and...
-
During the month of July, Sands Insurance entered into the following transactions: Required: a Prepare journal entries to record the preceding transactions. b List the source documents normally used...
-
Make a table to summarize the information about trading blocs. Include the name of each of the six types of economic integration, a definition and examples. The table should illustrate how economic...
-
Total Lingo Inc. budgets to make 375,000 standard units of output during a budget period of 1,875,000 hours. Actual output during the period amounted to 450,000 units, which took 2,175,000 hours to...
-
If the jobs displayed in Table 18.24 are processed using the earliestdue-date rule, what would be the lateness of job C? TABLE 18.24 Processing Times and Due Dates for Five Jobs Job C D E...
-
Suppose the concatenator division, which we valued based on Table, is spun off as an independent company, Concatco, with 1 million shares of common stock outstanding. What would each share sell for?...
-
Figure below shows some complicated position diagrams. Work out the combination of stocks, bonds, and options that produces each of thesepositions. (a) (b) (d)| (c)
-
Consider this simplified balance sheet for Geomorph Trading: a. Calculate the ratio of debt to equity. b. What are Geomorphs net working capital and total long-term capital? Calculate the ratio of...
-
Determine the state of stress at point \(A\) on the cross section of the post at section \(a-a\). Indicate the results on a differential element at the point. 5ft 400 lb a 1.5 ft 300 lb a 2.5 in. 2...
-
The rod has a diameter of \(40 \mathrm{~mm}\). Determine the stress components that act at point \(B\), and show the results on a volume element located at this point. 1500 N 300 mm 600 N 100 Nm 800...
-
Determine the state of stress at point \(B\) on the cross section of the post at section \(a-a\). Indicate the results on a differential element at the point. 5 ft 400 lb 1.5 ft 300 lb a a 2.5 in.- 2...
Study smarter with the SolutionInn App