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 Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $65,400 $418,000 Cost of goods sold 44,000 309,000 Selling and administrative expenses 15,000 79,000 Interest expense 740 2,100 Other income (expense) (90) (380) Income tax expense 1,400 7,300 Net income $ 4,170 $20,220 Balance Sheet Data (End of Year) Current assets $19,000 $50,000 Noncurrent assets 26,700 121,000 Total assets $45,700 $171,000 Current liabilities $11,000 $55,000 Long-term debt 18,500 45,000 Total stockholders' equity 16,200 71,000 Total liabilities and stockholders' equity $45,700 $171,000 Beginning-of-Year Balances Total assets $44,000 $165,000 Total stockholders' equity 12,800 64,000 Current liabilities 10,600 58,000 Total liabilities 31,200 101,000 Other Data Average net accounts receivable $8,000 $3,900 Average inventory 6,900 34,500 Net cash provided by operating activities 5,500 25,800 Capital expenditures 1,800 11,700 Dividends 450 4,500 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.8%.) Ratio (1) Current ratio (2) Accounts receivable turnover (3) Average collection period (4) Inventory turnover (5) Days in inventory (6) Profit margin (7) Asset turnover Target 1.73 :1 Wal-Mart .91 :1 .69 times 6.62 times 44.65 days 3.41 days 6.38 times 8.96 times 57.24 days 40.75 days 6.38 % 4.84 % .63 times 4 times (8) Return on assets 3.99 % 19.35 % (9) Return on common stockholders' equity 10.86 % 52.66 de % (10) Debt to assets ratio .71 % .61 % (11) Times interest earned 8.53 times 14.10 times Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $65,400 $418,000 Cost of goods sold 44,000 309,000 Selling and administrative expenses 15,000 79,000 Interest expense 740 2,100 Other income (expense) (90) (380) Income tax expense 1,400 7,300 Net income $ 4,170 $20,220 Balance Sheet Data (End of Year) Current assets $19,000 $50,000 Noncurrent assets 26,700 121,000 Total assets $45,700 $171,000 Current liabilities $11,000 $55,000 Long-term debt 18,500 45,000 Total stockholders' equity 16,200 71,000 Total liabilities and stockholders' equity $45,700 $171,000 Beginning-of-Year Balances Total assets $44,000 $165,000 Total stockholders' equity 12,800 64,000 Current liabilities 10,600 58,000 Total liabilities 31,200 101,000 Other Data Average net accounts receivable $8,000 $3,900 Average inventory 6,900 34,500 Net cash provided by operating activities 5,500 25,800 Capital expenditures 1,800 11,700 Dividends 450 4,500 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.8%.) Ratio (1) Current ratio (2) Accounts receivable turnover (3) Average collection period (4) Inventory turnover (5) Days in inventory (6) Profit margin (7) Asset turnover Target 1.73 :1 Wal-Mart .91 :1 .69 times 6.62 times 44.65 days 3.41 days 6.38 times 8.96 times 57.24 days 40.75 days 6.38 % 4.84 % .63 times 4 times (8) Return on assets 3.99 % 19.35 % (9) Return on common stockholders' equity 10.86 % 52.66 de % (10) Debt to assets ratio .71 % .61 % (11) Times interest earned 8.53 times 14.10 times
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Ballard Ltd makes three products A, B and C. Each passes throughtwo departments: Machining and Assembly. Budgeted production ineach department by each productUnitsMachiningAssemblyPr 2 answers
-
On April 1, 2008, Brad Bridgewater Inc. entered into a cost-plus-fixed-fee contract to construct an electric generator for Tom Dolan Corporation. At the contract date, Bridgewater estimated that it...
-
What is a defined benefit pension plan? What is a flat benefit plan? Describe the various types of unit benefit plans. What is vesting? What does it mean to be fully vested? Describe the tax...
-
Below are income statements and balance sheets for the Peyton Company for 2019 and 2018: Required Calculate the following ratios for the Peyton Company for 2019 and 2018 and discuss your findings: 1....
-
1. Determine whether this case would be prosecuted as a criminal or civil offense, and state reasons to support your conclusion. 2. Who are the victims of this late-trading scheme, and what losses do...
-
What are some policy implications for the punishment and treatment of crime according to Critical Race Theory and Merton's Strain theory? How do these two theories differ in their analytical level...
-
CASE STUDY No orders for Aspen's vaccine - it may have to shut its PE line Aspen needs clear commitments within weeks from African governments for orders of its Covid-19 vaccine or will recommit that...
-
11. Using the information given below, how much did it cost to operate the vehicle per month? $41.56 oil $175/month gas $48.00 wiper fluid $12.00 air filter 3.29 $1129.43 insurance $327.18/ monthly...
-
Audit follow-up procedures refer to the actions taken by auditors after completing an audit engagement to ensure that management has implemented the agreed-upon recommendations and corrective...
-
Tracy bought a dozen of her mother's favorite flowers for $9.00. How much did each flower cost? Show your thinking. Gavin also bought a dozen flowers for his mother, but her favorite flowers cost...
-
Read an integer number of a fixed length (3 digits) from the standard input then print its digits separated by spaces. For example if 364 is the input then the output should be 3 6 4 or 4 6 3. Hint:...
-
A new business owner developed the inequality, y < -0.95s + 96s-497 , to calculate his profit, in dollars. The variable, , represents the number of pairs of shoes sold. What is the range of pairs of...
-
a) Name the three hybridization states and geometries found in organic compounds. (3) b) Draw one structure each of related hybridize carbon mentioned in (a) above and give their respectively names....
-
Prove the formula for (d/dx)(cos-1x) by the same method as for (d/dx)(sin-1x).
-
Folk Landscaping is evaluating an offer to purchase Bruce Lawn Care, its main competitor, for \($250,000.00.\) An accountant has projected that the purchase will increase Folks annual net cash flow...
-
How much do we need to invest each year to have \($100,000.00\) in a college fund when our child turns 18 years old? New parents often seek similar advice from their financial advisors to establish...
-
Forester Company is evaluating the purchase of equipment from two vendors. Differences in the technology and labor requirements to operate the equipment of each vendor affect the projected net cash...
Study smarter with the SolutionInn App