Question

In: Finance

Compare Wal Mart to Target financial statements. a) Compare their EPS (show calculations for the second...

Compare Wal Mart to Target financial statements. a) Compare their EPS (show calculations for the second company), which one is better and why? (10 points) b) Calculate both companies’ net profit margin. Show calculations (10 points) c) Which one is better, and why. Please be specific in your answer with tangible information. (10 points)

Solutions

Expert Solution

Soln : a) Walmart EPS(TTM) = 3.28 as per their balance sheet

For Target corporation the net income :

Income before interest and taxes 4403000.00
Interest expense -543000.00
Income before tax 3860000.00
Tax expense 33% 1273800.00
Profit after tax 2586200.00

Outstanding shares : 485.22*1000, EPS = 2586.2/485.22 = 5.33

Earning oer share of Walmart < EPS of Target corporation, on this basis we can say that Target is better as giving better return on equity.

b) For walmart : net income from operations = 10523000 and Revenue = 500343000

Net profit margin = Net income/revenue = 10523/500343 = 2.10%

For trading also, Net profit margin = 2586.2/71879 = 3.60%

Revenue of target given as on 31st Dec.2017 = 71879000

Again the profit margin us better for target corporation is better as providing better profit margin, and we can say it is managing its cost more efficiently compare to walmart that gives an edge over Walmart.


Related Solutions

Selected financial data of Target and Wal-Mart for 2017 are below (in millions). Target Wal-Mart Income...
Selected financial data of Target and Wal-Mart for 2017 are below (in millions). Target Wal-Mart 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 liabilities $11,327 $ 55,561...
3. Presented below are condensed financial statements adapted from Target and Wal-Mart ($ in millions, except...
3. Presented below are condensed financial statements adapted from Target and Wal-Mart ($ in millions, except per share amounts). Balance Sheets ($ in millions, except per share data) Target Wal-Mart Assets: Cash and cash equivalents $ 2,643 $ 6,756 Accounts receivable (net) 416 5,614 Inventories 8,657 43,783 Other current assets 848 3,511 Current assets 12,564 59,664 Property, plant, and equipment (net) 25,018 107,675 Intangibles and other assets 1,417 37,183 Total assets $ 38,999 $ 204,522 Liabilities and Shareholders' Equity: Accounts...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT