Question

In: Accounting

Table 1: Financial Results Wal-Mart Macy's Net operating revenues 469,162 27,686 Cost of goods sold 352,488...

Table 1: Financial Results

Wal-Mart

Macy's

Net operating revenues

469,162

27,686

Cost of goods sold

352,488

16,538

Gross profit

116,674

11,148

Selling, general, and administrative expense

88,873

8,482

Operating income

27,801

2,661

Interest expense

2,251

425

Other income (loss) - net

187

(134)

Income before income taxes

25,737

2,102

Income taxes

7,981

767

Net income

17,756

1,198

Assets

Cash and cash equivalents

7,781

1,836

Net receivables

6,768

371

Inventories

43,803

5,308

Total current assets

59,940

7,876

Property, plant and equipment

116,681

8,196

Goodwill

20,497

3,743

Other assets

5,987

615

Total assets

203,105

20,991

Liabilities and Stockholder Equity

Accounts payable

59,099

4,951

Short-term debt

12,719

124

Total current liability

71,818

5,075

Long-term debt

41,417

6,806

Total liabilities

126,243

14,940

Stockholder equity

76,343

6,051

Note: Tax Rate is 35%

7) Walmart

ROA= 9.46%

ROE= 23.26%

ROFL=13.8

PM= 5.49%

AT= 2.31

APT= 5.96

ART= 69.32

INVT= 8.05

PPET= 4.02

C2C= 72.75

Macy’s

ROA= 7.02%

ROE= 19.8%

ROFL= 12.78

PM=7.6%

AT=1.32

APT= 3.34

ART= 74.63

INVT= 3.12

PPET= 3.38

C2C= 1.8

In the guidance of the financial ratios you calculated in question 7, discuss the differences you see in Walmart’s and Macy’s performance in terms of overall financial efficiency, operational efficiency, and competitive strategic positioning? (Hint: For instance, discuss the difference between profit margins of Wal-Mart and Macy’s. How do interpret the difference in profit margins? What does this difference reflect? Repeat this discussion for the metrics in Table 2 as necessary.)

Solutions

Expert Solution

1. Financial Efficiency

Return on Assets - ROA depicts the ratio a company earns on employing ts assets in whole. It is the percentage derived by dividing the returns for the year ended by the total assets as on the last day of the year. ROA of Walmart is 9.46% and that of Macy's is 7.02%. This depicts the profit earned by the company on employing 100% of its assets. The ratio of Walmart is higher as compared to Macy's and it can be interpreted as Walmart applied its assets more efficiently and effectively in earning the returns.

Return on Equity - ROE denotes the percentage of profit earned by the company for its equity. It can be referred to as the amount of profit erned for $1 of the shareholder's funds. ROE of Walmart is 23.26% and that of Macy's is 19.8%. It can be interpreted as for investing $1 in equity of Walmart the ernings are $0.2326 and for equity in Macy's is $0.198. The results can be said as more profitable for the equity holders of Walmart.

Return on Financial Liability - ROFL denotes the return a company earns from employing various financial liabilities such as loans, credits, derivatives etc. The ROFL of Walmart is 13.8% and of Macy's is 12.78%. The profit earned by the company percentaged with the financial liability provides the ratio. The higher ratio of Walmart depicts that the financial sources re more efficiently employed by Walmart as compared to Macy

2. Operational Efficiency

Profit Margin - PM is the ratio of profits earned by the sales for the year ended. This is the most used benchmark for analyzing the operational efficiency of a company. It denotes how much of the revenue is earned by the company after paying all the expenses. PM of Walmart is 5.49% and that of Macy's is 7.6%. The operational efficiency of Macy is higher than that of Walmart on the basis of Profit Margin. The revenue of Macy is converted into profits more as compared to Walmart.


Related Solutions

A company has revenues of $450,000, cost of goods sold of $250,000, and operating expenses of...
A company has revenues of $450,000, cost of goods sold of $250,000, and operating expenses of $150,000. Its average current assets are $200,000 of which $75,000 is inventory and $20,000 are prepaid items. Of its liquid assets, 30 percent is cash and the remainder is accounts receivable. Its average total assets are $500,000 and its average total owners’ equity is $400,000. Seventy-five percent of its liabilities are current. Of the current liabilities, 80 percent is accounts payable. What are the...
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...
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).                                Target Corporation Wal-Mart stores,Inc                               Income Statement   Datafor Year Net sales                       $67.000     $413,000 Cost of goods sold          ...
Blackwell Company's income statement for 2020 consisted of: Revenues 1,220,000 Cost of goods sold 627,000 Operating...
Blackwell Company's income statement for 2020 consisted of: Revenues 1,220,000 Cost of goods sold 627,000 Operating expenses 295,000 Depreciation expense 60,000 Interest expense 26,000 Gain on the sale of machinery (12,000) Loss on the sale of investments 8,000 1,004,000 Income before income tax 216,000 Income tax expense 40,000 Net income 176,000 Blackwell's comparative balance sheet information for 2020 included: 12/31/20 12/31/19 Accounts receivable 268,000 257,000 Accounts payable 47,000 42,000 Income taxes payable 17,000 13,500 Interest payable 9,000 7,500 Bonds payable...
Blackwell Company's income statement for 2020 consisted of: Revenues 1,220,000 Cost of goods sold 627,000 Operating...
Blackwell Company's income statement for 2020 consisted of: Revenues 1,220,000 Cost of goods sold 627,000 Operating expenses 295,000 Depreciation expense 60,000 Interest expense 26,000 Gain on the sale of machinery (12,000) Loss on the sale of investments 8,000 1,004,000 Income before income tax 216,000 Income tax expense 40,000 Net income 176,000 Blackwell's comparative balance sheet information for 2020 included: 12/31/20 12/31/19 Accounts receivable 268,000 257,000 Accounts payable 47,000 42,000 Income taxes payable 17,000 13,500 Interest payable 9,000 7,500 Bonds payable...
Precision Manufacturing had the following operating results for 2014: sales = $36,942; cost of goods sold...
Precision Manufacturing had the following operating results for 2014: sales = $36,942; cost of goods sold = $24,600; depreciation expense = $1,700; interest expense = $1,400; dividends paid = $1,000. At the beginning of the year, net fixed assets were $14,300, current assets were $8,700, and current liabilities were $6,600. At the end of the year, net fixed assets were $13,900, current assets were $9,200, and current liabilities were $7,400. The tax rate for 2014 was 34 percent. What is...
Nanticoke Industries had the following operating results for 2018: sales $29,000; cost of goods sold =...
Nanticoke Industries had the following operating results for 2018: sales $29,000; cost of goods sold = $19,710; depreciation expense = $5,220; interest expense = $2,640; dividends paid = $1,400. At the beginning of the year, net fixed assets were $17,330, current assets were $5,850, and current liabilities were $3,300. At the end of the year, net fixed assets were $20,610, current assets were $7,150, and current liabilities were $3,970. The tax rate for 2018 was 30 %. a) net income...
Cusic Industries had the following operating results for 2015: sales = $28,560; cost of goods sold...
Cusic Industries had the following operating results for 2015: sales = $28,560; cost of goods sold = $19,460; depreciation expense = $5,020; interest expense = $2,340; dividends paid = $1,150. At the beginning of the year, net fixed assets were $16,980, current assets were $5,800, and current liabilities were $3,280. At the end of the year, net fixed assets were $20,360, current assets were $7,360, and current liabilities were $3,900. The tax rate for 2015 was 30 percent.    a....
Cardinal Industries had the following operating results for 2018: Sales = $33,510; Cost of goods sold...
Cardinal Industries had the following operating results for 2018: Sales = $33,510; Cost of goods sold = $23,820; Depreciation expense = $5,917; Interest expense = $2,670; Dividends paid = $1,924. At the beginning of the year, net fixed assets were $19,860, current assets were $6,998, and current liabilities were $3,944. At the end of the year, net fixed assets were $24,430, current assets were $8,636, and current liabilities were $4,601. The tax rate for 2018 was 24 percent.    a....
Cardinal Industries had the following operating results for 2018: Sales = $33,510; Cost of goods sold...
Cardinal Industries had the following operating results for 2018: Sales = $33,510; Cost of goods sold = $23,820; Depreciation expense = $5,917; Interest expense = $2,670; Dividends paid = $1,924. At the beginning of the year, net fixed assets were $19,860, current assets were $6,998, and current liabilities were $3,944. At the end of the year, net fixed assets were $24,430, current assets were $8,636, and current liabilities were $4,601. The tax rate for 2018 was 24 percent.    a....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT