Question

In: Accounting

Selected financial data of two competitors, Target and Wal-Mart, are presented here. (All dollars are in...

Selected financial data of two competitors, Target and Wal-Mart, are presented here. (All dollars are in millions.) Suppose tFor each company, compute these values and ratios. All dollars are in millions.) (Round Current ratio and Earnings per share

Selected financial data of two competitors, Target and Wal-Mart, are presented here. (All dollars are in millions.) Suppose the data were taken from the 2022 financial statements of each company. 

Target (1/31/22) Wal-Mart (1/31/22) 

                                Income Statement Data for                                         Year Net sales                          $65.000      $421,000 Cost of goods sold                  45.500       319.960 Selling and administrative expenses 16.250        88.410 Interest expense                      650          4.210 Other income                           20          4.300 Income taxes                          917          4.452 Net income                          Ŝ1.703       $8.268

                                                Balance Sheet Data (End of                                                         ear) Current assets                                   $19680          $46.980 Noncurrent assets                                 33.000         122000 Total assets                                     $52,680        $168.980 Current liabilities                              $12,000        $54000 Long-term liabilities                             24,876          47.388 Total stockholders' equity                        15,804          67592 Total liabilities and stockholders' equity       $52.680        $168,980 Net cash provided by operating activities         $4,60          $23,000 Cash paid for capital expenditures                $3 400         $11.700 Dividends dedlared and paid on common stock        $530           $3500 Weighted-average common shares outstandinglmillions)          650  2650

For each company, compute these values and ratios. All dollars are in millions.) (Round Current ratio and Earnings per share to 2 decimal places, e.g. 15.25 and Debt to assets ratio to 1 decimal place, e.g. 78.9%. If answer is negative enter it with a negative sign preceding the number e.g. - 15,000 or in parentheses e.g. (15,000).) 

Target Wal-Mart 

(a) Working capital 

(b) Current ratio 

(c) Debt to assets ratio 

(d) Free cash flow 

(e) Earnings per share

(f) Which company has better liquidity? 

Which company has better solvency?

Solutions

Expert Solution


Related Solutions

Selected financial data of two competitors, Target and Wal-Mart, are presented here. (All dollars are in...
Selected financial data of two competitors, Target and Wal-Mart, are presented here. (All dollars are in millions.) Suppose the data were taken from the 2022 financial statements of each company.                             Target        Wal-Mart                           (1/31/22)     (1/31/22)                            Income Statement Data for ...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Income Statement Data for YearTarget CorporationWal-Mart Stores, Inc.Net sales$65,357$408,214Cost of goods sold45,583304,657Selling and administrative expenses15,10179,607Interest expense7072,065Other income (expense)(94)(411)Income tax expense1,3847,139Net income$2,488$14,335Balance Sheet Data (End ofYear)Current assets$18,424$48,331Noncurrent assets26,109122,375Total assets$44,533$170,706Current liabilities$11,327$55,561Long-term debt17,85944,089Total stockholders' equity15,34771,056(b) Compare the liquidity, solvency, and profitability of the two companies.
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Target...
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,600 $410,000 Cost of goods sold 44,000 308,000 Selling and administrative expenses 14,600 75,000 Interest expense 690 2,100 Other income (expense) (90 ) (420 ) Income tax expense 1,400 7,300 Net income $ 4,820 $ 17,180 Balance Sheet Data (End of Year) Current assets $17,000 $48,000 Noncurrent assets 26,700 120,000 Total assets $43,700...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $65,357 $408,214 Cost of goods sold 45,583 304,657 Selling and administrative expenses 15,101 79,607 Interest expense 707 2,065 Other income (expense) (94) (411) Income tax expense 1,384 7,139 Net income $ 2,488 $ 14,335 Balance Sheet Data (End of Year) Current assets $18,424 $48,331 Noncurrent assets 26,109 122,375 Total assets $44,533 $170,706 Current...
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target...
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $64,900 $405,000 Cost of goods sold 44,000 300,000 Selling and administrative expenses 14,000 75,000 Interest expense 650 1,800 Other income (expense) (70 ) (380 ) Income tax expense 1,300 6,500 Net income $ 4,880 $ 21,320 Balance Sheet Data (End of Year) Current assets $16,000 $45,000 Noncurrent assets 25,000 120,000 Total assets $41,000...
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target...
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $66,400 $414,000 Cost of goods sold 45,000 302,000 Selling and administrative expenses 15,500 81,000 Interest expense 650 1,900 Other income (expense) (80 ) (400 ) Income tax expense 1,400 7,300 Net income $ 3,770 $ 21,400 Balance Sheet Data (End of Year) Current assets $17,000 $47,000 Noncurrent assets 26,700 120,000 Total assets $43,700...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $65,357 $408,214 Cost of goods sold 45,583 304,657 Selling and administrative expenses 15,101 79,607 Interest expense 707 2,065 Other income (expense) (94) (411) Income tax expense 1,384 7,139 Net income $ 2,488 $ 14,335 Balance Sheet Data (End of Year) Current assets $18,424 $48,331 Noncurrent assets 26,109 122,375 Total assets $44,533 $170,706 Current...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $65,357 $408,214 Cost of goods sold 45,583 304,657 Selling and administrative expenses 15,101 79,607 Interest expense 707 2,065 Other income (expense) (94) (411) Income tax expense 1,384 7,139 Net income $ 2,488 $ 14,335 Balance Sheet Data (End of Year) Current assets $18,424 $48,331 Noncurrent assets 26,109 122,375 Total assets $44,533 $170,706 Current...
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Target...
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 $66,300 $411,000 Cost of goods sold 44,000 305,000 Selling and administrative expenses 14,300 77,000 Interest expense 660 1,900 Other income (expense) (80 ) (420 ) Income tax expense 1,500 7,200 Net income $ 5,760 $ 19,480 Balance Sheet Data (End of Year) Current assets $17,000 $48,000 Noncurrent assets 26,800 122,000 Total assets $43,800...
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Target...
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 $67,000 $413,000 Cost of goods sold 44,000 301,000 Selling and administrative expenses 14,000 75,000 Interest expense 660 2,200 Other income (expense) (70 ) (410 ) Income tax expense 1,400 7,000 Net income $ 6,870 $ 27,390 Balance Sheet Data (End of Year) Current assets $17,000 $49,000 Noncurrent assets 26,000 123,000 Total assets $43,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT