1. Walmart's net sales in fiscal year 2021 increased $6.79% from 2020 to $555,233 million, its gross profit (or margin) increased 20 bps to 24.30%, and its operating income (or profit) rate increased 6 bps to 4.06% from 2020. A. Please complete the P&L statement of Walmart in 2021 and 2020. B. According to its annual report, Walmart's effective tax rate was 33.3% for 2021 and 24.4% in 2020. Its net income in 2021 and 2020 were $13.7 billion and 15.2 billion respectively. Although the company's net sales and operating income increased in 2021 but its net income decreased due to the higher effective tax rate. Please find out Walmart's net profit margin (%) in 2021 and 2020 and describe bps change between the two fiscal years.

1. Walmart's net sales in fiscal year 2021 increased $6.79% from 2020 to $555,233 million, its gross profit (or margin) increased 20 bps to 24.30%, and its operating income (or profit) rate increased 6 bps to 4.06% from 2020. A. Please complete the P&L statement of Walmart in 2021 and 2020. B. According to its annual report, Walmart's effective tax rate was 33.3% for 2021 and 24.4% in 2020. Its net income in 2021 and 2020 were $13.7 billion and 15.2 billion respectively. Although the company's net sales and operating income increased in 2021 but its net income decreased due to the higher effective tax rate. Please find out Walmart's net profit margin (%) in 2021 and 2020 and describe bps change between the two fiscal years.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

The following information pertains to JCU Company. All dollar amounts are in thousands. If JCU is computing trend percentages with 2018 as the base year, what % will 2019 sales be? Sales Gross Margin Net operating income Net income Year 2020 $58,000 $17,500 $3,200 $1,750 2019 $51,000 $15,100 $2,850 $1,400 2018 $47,000 $13,800 $2,100 $1,100
Abbott Laboratories’ Consolidated Statements of Earnings for the 3 fiscal year’s ending December 31, 2019. Required: Using the attached earnings statement, for each period presented, Compute the gross margin % Note: Gross margin % = [(Net sales – Cost of products sold)/Net sales] x 100 Compute the net profit margin on sales % Note: Net profit margin % = (Net earnings/Net sales) x 100 Considering the 3-year trend for a. and b. above, provide a brief comment about the company’s performance for: Gross margin % and Net profit margin %.
Calculate the Sales Growth of the most recent year. Enter answer as decimal (not percent. Example: .1234 is ok, 12.34% is not ok).
In fiscal year 2018, Wal-Mart Stores (WMT) had revenue of $514.41 billion, gross profit of $129.10 billion, and net income of $6.67 billion. Costco Wholesale Corporation (COST) had revenue of $141.6 billion, gross profit of $18.42 billion, and net income of $3.13 billion. a. Compare the gross margins for Walmart and Costco. b. Compare the net profit margins for Walmart and Costco. c. Which firm was more profitable in 2018? a. Compare the gross margins for Walmart and Costco. The gross margin for Walmart is enter your response here %. (Round to two decimal places.) The gross margin for Costco is enter your response here %. (Round to two decimal places.) Part 3 b. Compare the net profit margins for Walmart and Costco. The net profit margin for Walmart is enter your response here %. (Round to two decimal places.) Part 4 The net profit margin for Costco is enter your response here %. (Round to two decimal places.) c. Which firm was more profitable in 2018? (Select from the…
Bramble Corp. reported the following in its 2022 and 2021 income statements.
Ayayai Ltd. had the following 2020 income statement data: Sales $205,600 Cost of goods sold 119,400 Gross profit 86,200 Operating expenses (includes depreciation of $22,400) 48,300 Income before income taxes 37,900 Income taxes 15,000 Net income $22,900 The following accounts increased during 2020 by the amounts shown: Accounts Receivable, $16,000; Inventory, $10,500; Accounts Payable (relating to inventory), $14,000; Taxes Payable, $2,000; and Mortgage Payable, $40,200.
The following items were taken from the financial statements of Kramer Manufacturing, Inc., over a 3-year period: Item 2021 2020 2019 Net sales $226,000 $212,000 $200,000 Cost of goods sold 150,000 140,000 125,000 Gross profit $ 76,000 $ 72,000 $ 75,000 Instructions Using horizontal analysis and 2019 as the base year, compute the trend percentages for net sales, cost of goods sold, and gross profit. Item 2021 2020 2019 Net sales % % 100% Cost of goods sold % % 100% Gross profit % % 100% Explain whether the trends are favorable or unfavorable for each…
Operating data for Cheyenne Corp. are presented below. 2022 2021 Sales revenue $831,900 $629,500 Cost of goods sold 529,700 410,900 Selling expenses 125,400 74,300 Administrative expenses 79,400 52,000 Income tax expense 37,000 24,500 Net income 60,400 67,800 Prepare a schedule showing a vertical analysis for 2022 and 2021. (Round percentages to 1 decimal place, e.g. 12.1%.)
Below are Samarahan Jaya Berhad’s income statement, statement of retained earnings and balance sheet for 2019 and 2020. Samarahan Jaya Berhad Comparative Income Statement For the Years Ended December 31, 2019 and 2020 2020 (RM) 2019 (RM) Sales 5,125,000 3,257.600 Sales returns and allowances 125,000 57,600 Net sales 5,000,000 3,200,000 Cost of goods sold 3,400,000 2,080,000 Gross Profit 1,600,000 1,120,00 Selling expenses 650,000 464,000 Administrative expenses 325,000 224,000 Total operating expenses 975,000 688,000 Income from operations 625,000 432,000 Other income 25,000 19,200 650,000 451,200 Interest expense 105,000 64,000 Income before tax 545,000 387,200 Income tax expense 300,000 176,000 Net income 245,000 211,200 Samarahan Jaya Berhad Comparative Retained Earnings Statement For the Years Ended December 31, 2019 and 2020…
Sunland Company reported the following in its 2022 and 2021 income statements. Net sales Cost of goods sold Operating expenses Income tax expense Net income Gross profit rate 2022 Profit margin $152,000 91,200 30,400 18,000 $12,400 Determine the company's gross profit rate and profit margin for both years. (Round answers to 1 decimal place, e.g. 52.7%) 2021 $122,000 73,200 14,640 10,000 2022 $24,160 % 2021
The following data for the years ended December 31, 2019 and 2020 were presented to the management Zigzag Company: 2020 = Net sales: 1,363,000, Cost of Sales: 911,800, Gross Profit: 451,200; 2019 = Net Sales: 1,250,000, Cost of Sales: 776,000, Gross Profit: 474,000. The management requested you to determine the cause of the decline in gross profit on sales in spite of the favorable information given by the sales division that the quantity sold in 2020 was higher than in 2019 and that the production costs in 2020 were lower than that of 2019 by 6%. The increase (decrease) in net sales due to price factor is: A. (113,000) B. 113,000 C. (P199,500) D. 199,500
The following data for the years ended December 31, 2019 and 2020 were presented to the management Zigzag Company: 2020 = Net sales: 1,363,000, Cost of Sales: 911,800, Gross Profit: 451,200; 2019 = Net Sales: 1,250,000, Cost of Sales: 776,000, Gross Profit: 474,000. The management requested you to determine the cause of the decline in gross profit on sales in spite of the favorable information given by the sales division that the quantity sold in 2020 was higher than in 2019 and that the production costs in 2020 were lower than that of 2019 by 6%. The percent change in volume is: (Based on information given above) The increase (decrease) in net sales due to volume factor is:

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS