Target |
Wal-Mart |
|||
---|---|---|---|---|
Income Statement Data for Year |
||||
Net sales |
$67,000 |
$410,000 |
||
Cost of goods sold |
44,890 |
287,000 |
||
Selling and administrative expenses |
16,080 |
77,900 |
||
Interest expense |
670 |
3,280 |
||
Other income |
20 |
4,000 |
||
Income taxes |
1,883 |
16,037 |
||
Net income |
$ 3,497 |
$ 29,783 |
Target |
Wal-Mart |
|||
---|---|---|---|---|
Balance Sheet Data (End of Year) |
||||
Current assets |
$21,160 |
$ 45,360 |
||
Noncurrent assets |
27,000 |
111,000 |
||
Total assets |
$48,160 |
$156,360 |
||
Current liabilities |
$11,500 |
$ 56,000 |
||
Long-term liabilities |
22,212 |
37,816 |
||
Total stockholders’ equity |
14,448 |
62,544 |
||
Total liabilities and stockholders’ equity |
$48,160 |
$156,360 |
||
Net cash provided by operating activities |
$5,200 | $23,400 | ||
Cash paid for capital expenditures |
$3,700 | $11,800 | ||
Dividends declared and paid on common stock |
$450 | $3,400 | ||
Weighted-average common shares outstanding (millions) |
650 | 3,950 |
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 |
$ | enter a dollar amount for working capital for Target | $ | enter a dollar amount for working capital for Wal-Mart | ||||
(b) |
Current ratio |
enter the current ratio for Target rounded to 2 decimal places :1 | enter the current ratio for Wal-Mart rounded to 2 decimal places | :1 | |||||
(c) |
Debt to assets ratio |
enter debt for assets ratio for Target in percentages rounded to 1 decimal place % | enter debt for assets ratio for Wal-Mart in percentages rounded to 1 decimal place | % | |||||
(d) |
Free cash flow |
$ | enter a dollar amount for free cash flow for Target | $ | enter a dollar amount for free cash flow for Wal-Mart | ||||
(e) |
Earnings per share |
$ | enter a dollar amount for earnings per share for Target rounded to 2 decimal place | $ | enter a dollar amount for earnings per share for Wal-Mart rounded to 2 decimal place |
(f) |
Which company has better liquidity? |
select between Target or Wal-Mart TargetWal-Mart | |
---|---|---|---|
Which company has better solvency? |
select between Target or Wal-Mart TargetWal-Mart |
Calculate following
Target | Wal-mart | |
1. working capital | 21160-11500 = 9660 | 45360-56000 = -10640 |
2. Current ratio | 21160/11500 = 1.84:1 | 45360/56000 = 0.81:1 |
3. Debt to assets ratio | 33712/48160 = 70% | 93816/156360 = 60% |
4. Free cash flow | 1050 | 8200 |
5. Earning per share | 5.38 | 7.54 |
(f) |
Which company has better liquidity? |
Target | |
---|---|---|---|
Which company has better solvency? |
Wal-mart |
Target (1/31/22) Wal-Mart (1/31/22) Income Statement Data for Year Net sales $67,000 $410,000 Cost of goods...
Net sales Cost of goods sold Selling and administrative expenses Interest expense Other Income Income taxes Net Income Target Wal-Mart (1/31/22) (1/31/22) Income Statement Data for Year $78,000 $420,000 54,600 310,900 19,500 88,200 780 2,100 204,300 B, 120 $ 2.041 S 15.080 1.099 Current assets Noncurrent assets Tatal assets Current liabilities Long-term liabilities Tatal stockhalders' equity Tatal liabilities and stockholders' equity Target Wal-Mart Balance Sheet Data (End of Year) $20,160 $ 47,520 28,000 121,000 $48,160 $168,520 $12,000 $ 54.000 21,712...
Crane Company Income Statement For the Year Ended December 31, 2022 Net sales $2,192,500 Cost of goods sold 1,010,500 Selling and administrative expenses 900,500 Interest expense 78,000 Income tax expense 62,500 Net income $ 141,000 Crane Company Balance Sheet December 31, 2022 Assets Current assets Cash $ 55,100 Debt investments 89,000 Accounts receivable (net) 168,400 Inventory 236,500 Total current assets 549,000 Plant assets (net) 572,500 Total assets $ 1,121,500 Liabilities and Stockholders’ Equity Current liabilities Accounts payable $ 152,000 Income...
ted financial data of two competitors, Target and Wal-Mart, are presented he were taken from the 2022 financial statements of each company. Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income Income taxes Net income Target Wal-Mart (1/31/22) (1/31/22) Income Statement Data for Year $69,000 $425,000 46,230 297,500 17,250 72,250 690 4,250 30 4,100 1,701 19,285 $ 3,159 $ 35,815 Current assets Noncurrent assets Total assets Current liabilities Long-term liabilities Total stockholders' equity Total liabilities...
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. Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income Income taxes Net income Target Wal-Mart (1/31/22) (1/31/22) Income Statement Data for Year $64,000 $405,000 41,600 291,600 16,000 72,900 640 4,050 20 4,150 2,023 14,210 $ 3,757 $ 26,390 Target Wal-Mart Balance Sheet Data (End of...
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. Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income Income taxes Net Income Target Wal-Mart (1/31/22) (1/31/22) Income Statement Data for Year $64,000 $405,000 41,600 291,600 16.000 72,900 640 4,050 20 4,150 2,023 14,210 $3,757 $ 26,390 Current assets Noncurrent assets Total assets Current liabilities...
Target Wal-Mart (a) Working capital 6,600,0006800000 (b) Current ratio 1.58 88 :1 (c) Debt to assets ratio 25 33.33% (d) Free cash flow (e) Earnings per share $ (f) Which company has better liquidity? Target 4.07 Which company has better solvency? Wal-Mart Click if you would like to Show Work for this question Open Show Work 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...
Condensed balance sheet and income statement data for Marigold Corp. are presented as follows. Marigold Corp. Balance Sheets December 31 Assets 2017 2016 Cash $ 30,210 $ 22,210 Receivables (net) 82,900 74,900 Other current assets 102,900 85,900 Long-term investments 62,000 60,000 Property, plant, and equipment (net) 522,900 482,900 Total assets $ 800,910 725,910 Liabilities and Stockholders’ Equity Current liabilities $ 77,210 $ 72,210 Long-term liabilities 92,900 102,900 Common stock 342,900 312,900 Retained earnings 287,900 237,900 Total liabilities and stockholders’ equity...
Please explain answers in detail. 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 $69,000 $425,000 Cost of goods sold 46,230 297,500 Selling and administrative expenses 17,250 72,250 Interest expense 690 4,250 Other income 30 4,100 Income taxes 1,701 19,285 Net income $3,159 $ 35,815 Target Wal-Mart Balance...
Wal-Mart Stores, Inc. Target Corporation Income Statement Data for Year Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income $65,300 45,000 14,000 660 $417,000 301,000 79,000 1,800 (85) (380) 1,500 4,055 7,100 $27,720 Balance Sheet Data (End of Year) Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders $16,000 27.400 $43,400 $11,000 17,800 14,600 $50,000 121,000 $171,000 $54,000 43,000 74,000 $171,000...
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). 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 Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $65,357 $408,214 45,583 304,657 15,101 79,607 707 2,065 (94) (411) 1,384 7.139 $ 2,488 $ 14,335 Balance...