Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Target...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Target Corporation Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Wal-Mart Stores, Inc. Income Statement Data for Year $406,000 $66,800 45,000 14,400 690 (75) 1,300 $5,335 305,000 $19,000 27,300 $46,300 $12,000 17.500 16,800 $46,300 78,000 2,000 (420) 6.900 $13,680 Balance Sheet Data (End of Year) $48,000 121,000 $169,000 $55,000 44,000 70,000 $169,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $8,000 7,100 6,000 1,800 450 $4,100 34,000 25,800 11.500 3,700 For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, e.g. 15.50, debt to assets ratio and free cash flow answers to O decimal places, e.g. 5,275 and all answers to 1 decimal place, e.g. 1.8 or 1.83%) (1) (2) (3) (4) (5) (6) (7) (8) 6 (10) (11) (12) 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 Times interest earned Free cash flow Target :1 times days times days % times % % % times $ Wal-Mart times days 1 times days. % times % * times Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Target Corporation Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Wal-Mart Stores, Inc. Income Statement Data for Year $406,000 $66,800 45,000 14,400 690 (75) 1,300 $5,335 305,000 $19,000 27,300 $46,300 $12,000 17.500 16,800 $46,300 78,000 2,000 (420) 6.900 $13,680 Balance Sheet Data (End of Year) $48,000 121,000 $169,000 $55,000 44,000 70,000 $169,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $8,000 7,100 6,000 1,800 450 $4,100 34,000 25,800 11.500 3,700 For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, e.g. 15.50, debt to assets ratio and free cash flow answers to O decimal places, e.g. 5,275 and all answers to 1 decimal place, e.g. 1.8 or 1.83%) (1) (2) (3) (4) (5) (6) (7) (8) 6 (10) (11) (12) 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 Times interest earned Free cash flow Target :1 times days times days % times % % % times $ Wal-Mart times days 1 times days. % times % * times
Expert Answer:
Related Book For
Financial Accounting Tools for Business Decision Making
ISBN: 978-1119493631
9th edition
Authors: Paul D. Kimmel, Jerry J. Weygandt, 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)...
-
Suppose Nordic Boots was making production decisions for the following six boots: ot Price E(Demand) Std. Dev (Demand) Co Cu Exp. Profit Max. Profit A 220 1000 400 35.2 52.8 1101 39201 52800 230 2000...
-
A microscope is focused on the upper surface of a glass plate. A second plate is then placed over the first. To focus on the bottom surface of the second plate, the microscope must be raised 0.780...
-
Describe various types of friction.
-
Robert Ryan practiced accounting with a partnership for five years. Recently he opened his own accounting firm, which he operates as a professional corporation. The name of the new entity is Robert...
-
According to a study published in the New England Journal of Medicine, overweight people on low-carbohydrate and Mediterranean diets lost more weight and got greater cardiovascular benefits than...
-
If fixed costs are $ 3 9 0 , 0 0 0 , variable costs are 7 5 % of net sales, and the company wants to reduce the price by 1 % , how many additional sales will they need to breakeven?
-
Prepare general journal entry. Billy Bob's Bikes Transactions Nov. 1: Billy Bob paid in advance for an 8-month insurance policy, which will begin today. He paid $3,856 cash for the policy. Nov, 1-...
-
Explain whether the process of vertical technology transfer and technology commercialization are identical or distinct process.
-
What is an analytical review? How are such reviews performed? Why are they performed?
-
What is the value of a written description of the auditee as a part of the preliminary survey? What information is included?
-
Discuss the different types of non-attest services.
-
Identify the categories of managements financial statement assertions and briefly explain each one.
-
The following is a list of documents the auditors examined on a recent audit of the purchasing function of a large drug retailer: Supplier contracts. A sample of customer receipts. A sample of...
-
1. ABC, Inc., has net working capital of $3,000, and current liabilities of $2,000. What is the current ratio? 2. Forks, Inc., has net working capital of $1,520, current liabilities of $4,000, and...
-
The percentage of completion and completed contract methods are described in the FASB ASC. Search the codification to find the paragraphs covering these topics, cite them, and copy the results.
-
Assume that Acorn Inc. sold bonds with a face value of $100,000 for $104,000. Was the market interest rate equal to, less than, or greater than the bonds contractual interest rate? Explain.
-
Bridle Inc. issues $300,000, 10-year, 8% bonds at 98. Prepare the journal entry to record the sale of these bonds on March 1, 2022.
-
On January 1, 2022, Haley Company had a balance of $360,000 of goodwill on its balance sheet that resulted from the purchase of a small business in a prior year. The goodwill had an indefinite life....
-
Suppose the US investor in Question 8 were risk averse, instead of risk neutral, and wants a risk premium of \(1 \%\) (annual) for assuming the exchange-rate risk on the international investment. a....
-
When there is a concentration gradient in the system, show that the potential gradient is composed of two terms, (i) an Ohm's-law contribution and (ii) a diffusional contribution. State the equation...
-
Copper is deposited at a cathode from solution with a bulk concentration of \(0.5 \mathrm{M}\) at the rate of \(3.0 \mathrm{~g} / \mathrm{m}^{2} \cdot \mathrm{s}\). Find the surface concentration of...
Study smarter with the SolutionInn App