Question
Analysis of your company's last 2 fiscal year's performance in an Excel file including: Please show in an excel file... Revenue (Sales) on a segmented
Analysis of your company's last 2 fiscal year's performance in an Excel file including: Please show in an excel file...
- Revenue (Sales) on a "segmented" basis from the 10-K .
- Each line of the company's 10-K income statement up to the Operating Income line
- Percentage growth for each year for each account
- Gross profit % and Operating % percentage for each year
- Include at least 3 observations of your company's performance quoting at least one percentage in each observation
- Mondelz International, Inc. and Subsidiaries
Consolidated Statements of Earnings
For the Years Ended December31
(in millions of U.S. dollars, except per share data)
2023 | 2022 | 2021 | |||||||||||||||
Net revenues | $ | 36,016 | $ | 31,496 | $ | 28,720 | |||||||||||
Cost of sales | (22,252) | (20,184) | (17,466) | ||||||||||||||
Gross profit | 13,764 | 11,312 | 11,254 | ||||||||||||||
Selling, general and administrative expenses | (8,002) | (7,384) | (6,263) | ||||||||||||||
Asset impairment and exit costs | (217) | (262) | (212) | ||||||||||||||
Net gain on divestitures and acquisitions | 108 | 8 | |||||||||||||||
Amortization of intangible assets | (151) | (132) | (134) | ||||||||||||||
Operating income | 5,502 | 3,534 | 4,653 | ||||||||||||||
Benefit plan non-service income | 82 | 117 | 163 | ||||||||||||||
Interest and other expense, net | (310) | (423) | (447) | ||||||||||||||
Gain on marketable securities | 606 | ||||||||||||||||
Earnings before income taxes | 5,880 | 3,228 | 4,369 | ||||||||||||||
Income tax provision | (1,537) | (865) | (1,190) | ||||||||||||||
Gain/(loss) on equity method investment transactions | 465 | (22) | 742 | ||||||||||||||
Equity method investment net earnings | 160 | 385 | 393 | ||||||||||||||
Net earnings | 4,968 | 2,726 | 4,314 | ||||||||||||||
less: Noncontrolling interest earnings | (9) | (9) | (14) | ||||||||||||||
Net earnings attributable to Mondelz International | $ | 4,959 | $ | 2,717 | $ | 4,300 | |||||||||||
Per share data: | |||||||||||||||||
Basic earnings per share attributable to Mondelz International | $ | 3.64 | $ | 1.97 | $ | 3.06 | |||||||||||
Diluted earnings per share attributable to Mondelz International | $ | 3.62 | $ | 1.96 | $ | 3.04 |
See accompanying notes to the consolidated financial statements.
65 |
Table of Contents
Mondelz International, Inc. and Subsidiaries
Consolidated Statements of Comprehensive Earnings
For the Years Ended December31
(in millions of U.S. dollars)
2023 | 2022 | 2021 | |||||||||||||||
Net earnings | $ | 4,968 | $ | 2,726 | $ | 4,314 | |||||||||||
Other comprehensive earnings/(losses), net of tax: | |||||||||||||||||
Currency translation adjustment | 229 | (725) | (458) | ||||||||||||||
Pension and other benefit plans | (218) | 274 | 495 | ||||||||||||||
Derivative cash flow hedges | (15) | 114 | 13 | ||||||||||||||
Total other comprehensive earnings/(losses) | (4) | (337) | 50 | ||||||||||||||
Comprehensive earnings | 4,964 | 2,389 | 4,364 | ||||||||||||||
less: Comprehensive earnings/(losses) attributable to noncontrolling interests | 4 | (5) | (2) | ||||||||||||||
Comprehensive earnings attributable to Mondelz International | $ | 4,960 | $ | 2,394 | $ | 4,366 |
See accompanying notes to the consolidated financial statements.
66 |
Table of Contents
Mondelz International, Inc. and Subsidiaries
Consolidated Balance Sheets, as of December31
(in millions of U.S. dollars, except share data)
2023 | 2022 | ||||||||||
ASSETS | |||||||||||
Cash and cash equivalents | $ | 1,810 | $ | 1,923 | |||||||
Trade receivables (net of allowances of $66at December31, 2023 and $45at December31, 2022) | 3,634 | 3,088 | |||||||||
Other receivables (net of allowances of $50at December31, 2023 and $59at December31, 2022) | 878 | 819 | |||||||||
Inventories, net | 3,615 | 3,381 | |||||||||
Other current assets | 1,766 | 880 | |||||||||
Total current assets | 11,703 | 10,091 | |||||||||
Property, plant and equipment, net | 9,694 | 9,020 | |||||||||
Operating lease right-of-use assets | 683 | 660 | |||||||||
Goodwill | 23,896 | 23,450 | |||||||||
Intangible assets, net | 19,836 | 19,710 | |||||||||
Prepaid pension assets | 1,043 | 1,016 | |||||||||
Deferred income taxes | 408 | 473 | |||||||||
Equity method investments | 3,242 | 4,879 | |||||||||
Other assets | 886 | 1,862 | |||||||||
TOTAL ASSETS | $ | 71,391 | $ | 71,161 | |||||||
LIABILITIES | |||||||||||
Short-term borrowings | $ | 420 | $ | 2,299 | |||||||
Current portion of long-term debt | 2,101 | 383 | |||||||||
Accounts payable | 8,321 | 7,562 | |||||||||
Accrued marketing | 2,683 | 2,370 | |||||||||
Accrued employment costs | 1,158 | 949 | |||||||||
Other current liabilities | 4,330 | 3,168 | |||||||||
Total current liabilities | 19,013 | 16,731 | |||||||||
Long-term debt | 16,887 | 20,251 | |||||||||
Long-term operating lease liabilities | 537 | 514 | |||||||||
Deferred income taxes | 3,292 | 3,437 | |||||||||
Accrued pension costs | 437 | 403 | |||||||||
Accrued postretirement health care costs | 124 | 217 | |||||||||
Other liabilities | 2,735 | 2,688 | |||||||||
TOTAL LIABILITIES | 43,025 | 44,241 | |||||||||
Commitments and Contingencies (Note 14) | |||||||||||
EQUITY | |||||||||||
Common Stock, no par value (5,000,000,000shares authorized and 1,996,537,778shares issued at December31, 2023 and December31, 2022) | |||||||||||
Additional paid-in capital | 32,216 | 32,143 | |||||||||
Retained earnings | 34,236 | 31,481 | |||||||||
Accumulated other comprehensive losses | (10,946) | (10,947) | |||||||||
Treasury stock, at cost (648,055,073shares at December31, 2023 and 630,646,687shares at December31, 2022) | (27,174) | (25,794) | |||||||||
Total Mondelz International Shareholders' Equity | 28,332 | 26,883 | |||||||||
Noncontrolling interest | 34 | 37 | |||||||||
TOTAL EQUITY | 28,366 | 26,920 | |||||||||
TOTAL LIABILITIES AND EQUITY | $ | 71,391 | $ | 71,161 |
See accompanying notes to the consolidated financial statements.
67 |
Table of Contents
Mondelz International, Inc. and Subsidiaries
Consolidated Statements of Equity
(in millions of U.S. dollars, except per share data)
Mondelz International Shareholders' Equity | |||||||||||||||||||||||||||||||||||||||||
Common Stock | Additional Paid-in Capital | Retained Earnings | Accumulated Other Comprehensive Earnings/ (Losses) | Treasury Stock | Non-controlling Interest | Total Equity | |||||||||||||||||||||||||||||||||||
Balances at January 1, 2021 | $ | $ | 32,070 | $ | 28,402 | $ | (10,690) | $ | (22,204) | $ | 76 | $ | 27,654 | ||||||||||||||||||||||||||||
Comprehensive earnings/(losses): | |||||||||||||||||||||||||||||||||||||||||
Net earnings | 4,300 | 14 | 4,314 | ||||||||||||||||||||||||||||||||||||||
Other comprehensive earnings/ (losses), net of income taxes | 66 | (16) | 50 | ||||||||||||||||||||||||||||||||||||||
Exercise of stock options and issuance of other stock awards | 27 | (34) | 290 | 283 | |||||||||||||||||||||||||||||||||||||
Common Stock repurchased | (2,096) | (2,096) | |||||||||||||||||||||||||||||||||||||||
Cash dividends declared ($1.330per share) | (1,867) | (1,867) | |||||||||||||||||||||||||||||||||||||||
Dividends paid on noncontrolling interest and other activities | 5 | (20) | (15) | ||||||||||||||||||||||||||||||||||||||
Balances at December 31, 2021 | $ | $ | 32,097 | $ | 30,806 | $ | (10,624) | $ | (24,010) | $ | 54 | $ | 28,323 | ||||||||||||||||||||||||||||
Comprehensive earnings/(losses): | |||||||||||||||||||||||||||||||||||||||||
Net earnings | 2,717 | 9 | 2,726 | ||||||||||||||||||||||||||||||||||||||
Other comprehensive earnings/ (losses), net of income taxes | (323) | (14) | (337) | ||||||||||||||||||||||||||||||||||||||
Exercise of stock options and issuance of other stock awards | 46 | (20) | 216 | 242 | |||||||||||||||||||||||||||||||||||||
Common Stock repurchased | (2,000) | (2,000) | |||||||||||||||||||||||||||||||||||||||
Cash dividends declared ($1.470per share) | (2,025) | (2,025) | |||||||||||||||||||||||||||||||||||||||
Dividends paid on noncontrolling interest and other activities | 3 | (12) | (9) | ||||||||||||||||||||||||||||||||||||||
Balances at December 31, 2022 | $ | $ | 32,143 | $ | 31,481 | $ | (10,947) | $ | (25,794) | $ | 37 | $ | 26,920 | ||||||||||||||||||||||||||||
Comprehensive earnings/(losses): | |||||||||||||||||||||||||||||||||||||||||
Net earnings | 4,959 | 9 | 4,968 | ||||||||||||||||||||||||||||||||||||||
Other comprehensive earnings/ (losses), net of income taxes | 1 | (5) | (4) | ||||||||||||||||||||||||||||||||||||||
Exercise of stock options and issuance of other stock awards | 73 | (6) | 199 | 266 | |||||||||||||||||||||||||||||||||||||
Common Stock repurchased | (1,579) | (1,579) | |||||||||||||||||||||||||||||||||||||||
Cash dividends declared ($1.620per share) | (2,209) | (2,209) | |||||||||||||||||||||||||||||||||||||||
Dividends paid on noncontrolling interest and other activities | 11 | (7) | 4 | ||||||||||||||||||||||||||||||||||||||
Balances at December 31, 2023 | $ | $ | 32,216 | $ | 34,236 | $ | (10,946) | $ |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started