Suppose selected financial data of Target and Walmart for 2022 are as follows (in millions). Net...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose selected financial data of Target and Walmart for 2022 are as follows (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Target Corporation Walmart, Inc. Income Statement Data for Year $66,800 46,000 14,400 680 (90) 1,400 $4,230 $413,000 308,000 77,000 1,800 (380) 6,900 $18,920 Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Total assets Total stockholders' equity Current liabilities Total liabilities Balance Sheet Data (End of Year) $18,000 27,500 $45,500 $11,000 16,800 17,700 $45,500 $43,000 13,500 10,500 $47,000 29,500 121,000 $168,000 $54,000 Beginning-of-Year Balances $162,000 45,000 69,000 $168,000 64,000 54,000 98,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $7,700 6,800 5,600 1,800 450 $3,800 34,200 25,600 12,100 4,300 For each company, compute the following ratios. (Round current ratio to 2 decimal places, e.g. 1.83. Round accounts receivable turnover, average collection period, inventory turnover, days in inventory, profit margin, asset turnover, return on assets, return on common stockholders' equity and times interest earned to 1 decimal places, e.g. 1.8 or 1.8%. Round debt to assets ratio to 0 decimal places, e.g. 15%.) (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Ratio Current ratio Accounts receivable turnover Average collection period. Inventory turnover Days in inventory Profit margin Asset turnover Return on assets Return on common stockholders' equity Debt to assets ratio (11) Times interest earned (12) Free cash flow $ times $ times Suppose selected financial data of Target and Walmart for 2022 are as follows (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Target Corporation Walmart, Inc. Income Statement Data for Year $66,800 46,000 14,400 680 (90) 1,400 $4,230 $413,000 308,000 77,000 1,800 (380) 6,900 $18,920 Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Total assets Total stockholders' equity Current liabilities Total liabilities Balance Sheet Data (End of Year) $18,000 27,500 $45,500 $11,000 16,800 17,700 $45,500 $43,000 13,500 10,500 $47,000 29,500 121,000 $168,000 $54,000 Beginning-of-Year Balances $162,000 45,000 69,000 $168,000 64,000 54,000 98,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $7,700 6,800 5,600 1,800 450 $3,800 34,200 25,600 12,100 4,300 For each company, compute the following ratios. (Round current ratio to 2 decimal places, e.g. 1.83. Round accounts receivable turnover, average collection period, inventory turnover, days in inventory, profit margin, asset turnover, return on assets, return on common stockholders' equity and times interest earned to 1 decimal places, e.g. 1.8 or 1.8%. Round debt to assets ratio to 0 decimal places, e.g. 15%.) (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Ratio Current ratio Accounts receivable turnover Average collection period. Inventory turnover Days in inventory Profit margin Asset turnover Return on assets Return on common stockholders' equity Debt to assets ratio (11) Times interest earned (12) Free cash flow $ times $ times
Expert Answer:
Answer rating: 100% (QA)
Step 1 Ratio Analysis Ratio analysis is the relationship between the two items of financial statemen... View the full answer
Related Book For
Managerial Accounting Tools for business decision making
ISBN: 978-1118096895
6th Edition
Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso
Posted Date:
Students also viewed these accounting questions
-
Selected financial data of Target and Wal-Mart Stores, Inc. for a recent year are presented here (in millions). Instructions (a) For each company, compute the following ratios. (1) Current. (2)...
-
Selected financial data of Target (USA) and Wal-Mart (USA) for a recent year are-presented here and on the shown below (in millions) Instructions (a) For each company, compute the following ratios....
-
Selected financial data of Target (USA) and Wal-Mart Stores, Inc. (USA) for a recent year are presented below (in millions). Instructions (a) For each company, compute the following ratios. (1)...
-
Kebri LTD. sells Radios and Televisions. They have recorded their monthly revenue as follows. Revenue(Y) 330 180 209 390 391 304 347 461 538 610 Radio units (X1) 55 71 92 113 134 156 171 193 219 232...
-
What does a SWOT analysis reveal about the overall attractiveness of Under Armour's situation?
-
Match each item in the left column with the correct description in the right column. a. Refers to whether or not a particular amount is large enough to affect a decision. 1. Relevance 2....
-
What is an economic rent? What is it based on?
-
On December 1, Year 1, John and Patty Driver formed a corporation called Susquehanna Equipment Rentals. The new corporation was able to begin operations immediately by purchasing the assets and...
-
On May 1, 2019, AIPNA Advertising Company received $3,600 from John Smith for advertising services to be completed through April 30, 2020. The Cash receipt was recorded by AIPNA as unearned fees. The...
-
Mr. M has been employed as an engineer by A Ltd., a company incorporated in Hong Kong. During the year ended 31 March 2019, Mr. M had the following income and expenditure. A monthly salary of...
-
1) Big Bear Company has supplied the following information from its accounting records for the month of August. Direct labor cost Purchases of raw materials Advertising Factory property taxes Raw...
-
GP is a package delivery company. GP has to visit 8 different customer locations. Based on past experience, GP forecasts the demand values. Related information is given in Graph 1. The depot is the...
-
Discuss the similarities and differences between PDCA and PDSA methods for continuous improvement. What makes the methods differ in how they are implemented within an organization to accomplish...
-
discuss briefly on board governance as it relates to ethics and corporate culture.
-
Find the differential of the function. z = ex cos(3t) e-9x dz == dx + dt
-
Discuss the requirements for a valid non-compete agreement and explain the implications for employers and employees.
-
A 5-year project is expected to generate revenues of $120000, variable costs of $40000, and fixed costs of $19500. The annual depreciation is $14000 and the tax rate is 35 percent. What is the annual...
-
Before the 1973 oil embargo and subsequent increases in the price of crude oil, gasoline usage in the United States had grown at a seasonally adjusted rate of 0.57 percent per month, with a standard...
-
Kaspar Corporation makes a commercial-grade cooking griddle. The following information is available for Kaspar Corporations anticipated annual volume of 30,000 units. The company uses a 40% markup...
-
Hamby Inc. has sales of $2,000,000 for the first quarter of 2014. In making the sales, the company incurred the following costs and expenses. Prepare a CVP income statement for the quarter ended...
-
For Eckstein Company, the predetermined overhead rate is 130% of direct labor cost. During the month, Eckstein incurred $100,000 of factory labor costs, of which $85,000 is direct labor and $15,000...
-
Review the minutes of recent meetings by Bank of Japan officials. Summarize at least one recent meeting that was associated with possible or actual intervention to affect the yens value.
-
Why might the foreign exchange intervention strategies of the Bank of Japan be relevant to the U.S. government and to U.S.-based MNCs?
-
Explain the concept of interest rate parity.
Study smarter with the SolutionInn App