Question

In: Accounting

Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Net...

Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Net sales Cost of good(8) 16 19) Return on assets Return on common stockholders equity Debt to assets ratio % (10) (11) Times interest earned time

Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). 

                              Target Corporation Wal-Mart stores,Inc

                              Income Statement   Datafor 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                1400        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     $172,000 Current liabilities             $10,000     $54,000 Long-term debt                   17.400      43,000 Total stockholders' equity       15.600      75,000 Total liabilities and stockholders' equity      $43,000      $172,000                                 Bginning-ofYear Balances Total assets                    $43,000     $162,000 Total stockholders' equity       14,100      64,000 Current liabilities              10.800      54,000 Total liabilities                28.900      98,000                                      Other Data Average net accountsreceivable   $7.800      $3,800 Averageinventory                  7.100      33,400 Net cash provided by operating activities       5,700       27.400 Capital expenditures              1,800      12,000 Dividends                          450        4,400


(8) Return on assets

(9) Retum on common stockholders'equity

(10) Debt to assets ratio

(11) Times interest earned

(12) Free cash flow


Solutions

Expert Solution

1. Ratio Analysis -


Related Solutions

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...
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...
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Please...
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Please show how to do the equations. Thank you. Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $66,700 $409,000 Cost of goods sold 46,000 306,000 Selling and administrative expenses 14,700 76,000 Interest expense 650 1,800 Other income (expense) (95 ) (420 ) Income tax expense 1,400 7,200 Net income $ 3,855 $ 17,580 Balance Sheet Data (End of Year) Current assets...
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Compute...
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Compute selected ratios, and compare liquidity, profitability, and solvency for two companies. 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...
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Please...
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Please show how to do the equations. Thank you. Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $66,700 $409,000 Cost of goods sold 46,000 306,000 Selling and administrative expenses 14,700 76,000 Interest expense 650 1,800 Other income (expense) (95 ) (420 ) Income tax expense 1,400 7,200 Net income $ 3,855 $ 17,580 Balance Sheet Data (End of Year) Current assets...
Selected hypothetical financial data of Targetand Wal-Mart for 2022 are presented here (inmillions).Target...
Selected hypothetical financial data of Targetand Wal-Mart for 2022 are presented here (in millions).TargetCorporationWal-MartStores, Inc.Income Statement Data for YearNet sales$66,400$414,000Cost of goods sold45,000302,000Selling and administrative expenses15,50081,000Interest expense6501,900Other income (expense)(80)(400)Income tax expense1,4007,300Net income$ 3,770$ 21,400Balance Sheet Data(End of Year)Current assets$17,000$47,000Noncurrent assets26,700120,000Total assets$43,700$167,000Current liabilities$11,000$56,000Long-term debt16,80045,000Total stockholders’ equity15,90066,000Total liabilities and stockholders’ equity$43,700$167,000Beginning-of-Year BalancesTotal assets$45,000$164,000Total stockholders’ equity13,30064,000Current liabilities10,50058,000Total liabilities31,700100,000Other DataAverage net accounts receivable$7,500$3,900Average inventory7,00033,600Net cash provided by operating activities5,50027,400Capital expenditures1,80011,800Dividends5004,500For each company, compute the following ratios. (Round current ratio answers to 2 decimal places,...
Selected hypothetical financial data of Targetand Wal-Mart for 2022 are presented here (inmillions).Target...
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions).     TargetCorporation   Wal-MartStores, 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     $168,000   Current liabilities    ...
Selected hypothetical financial data of Targetand Wal-Mart for 2022 are presented here (inmillions).Target...
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions).     TargetCorporation   Wal-MartStores, Inc.     Income Statement Data for Year Net sales     $65,000     $406,000   Cost of goods sold     46,000     306,000   Selling and administrative expenses     14,800     76,000   Interest expense     660     2,200   Other income (expense)     (70 )   (390 ) Income tax...
Selected hypothetical financial data of Target and Walmart for 2022 are presented here (in millions). Target...
Selected hypothetical financial data of Target and Walmart for 2022 are presented here (in millions). Target Corporation Walmart Inc. Income Statement Data for Year Net sales $66,750 $414,180 Cost of goods sold 44,800 302,400 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 $ 4,320 $ 21,180 Balance Sheet Data (End of Year) Current assets $17,050 $47,040 Noncurrent assets 26,700 120,000 Total assets $43,750 $167,040...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT