Stock Analysis on Net

Merck & Co. Inc. (NYSE:MRK)

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

Merck & Co. Inc., adjusted current assets

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Current assets 32,168 35,722 30,266 27,764 27,483
Adjustments
Add: Allowance for doubtful accounts 88 72 62 85 86
Add: LIFO reserve1 562 293 16 82 171
After Adjustment
Adjusted current assets 32,818 36,087 30,344 27,931 27,740

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 LIFO reserve. See details »


Adjustments to Total Assets

Merck & Co. Inc., adjusted total assets

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Total assets 106,675 109,160 105,694 91,588 84,397
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1
Add: Allowance for doubtful accounts 88 72 62 85 86
Add: LIFO reserve2 562 293 16 82 171
Less: Deferred income tax assets (included in Other assets)3 1,968 503 692 894 719
After Adjustment
Adjusted total assets 105,357 109,022 105,080 90,861 83,935

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 LIFO reserve. See details »

3 Deferred income tax assets (included in Other assets). See details »


Adjustments to Total Liabilities

Merck & Co. Inc., adjusted total liabilities

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Total liabilities 69,040 63,102 67,437 66,184 58,396
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1
Less: Deferred income tax liabilities2 871 1,795 3,441 1,015 1,470
Less: Restructuring reserves 712 513 637 603 759
After Adjustment
Adjusted total liabilities 67,457 60,794 63,359 64,566 56,167

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Deferred income tax liabilities. See details »


Adjustments to Stockholders’ Equity

Merck & Co. Inc., adjusted total Merck & Co., Inc. stockholders’ equity

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Total Merck & Co., Inc. stockholders’ equity 37,581 45,991 38,184 25,317 25,907
Adjustments
Less: Net deferred income taxes1 1,097 (1,292) (2,749) (121) (750)
Add: Allowance for doubtful accounts 88 72 62 85 86
Add: LIFO reserve2 562 293 16 82 171
Add: Restructuring reserves 712 513 637 603 759
Add: Noncontrolling interests 54 67 73 87 94
After Adjustment
Adjusted total equity 37,900 48,228 41,721 26,295 27,767

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 Net deferred income taxes. See details »

2 LIFO reserve. See details »


Adjustments to Capitalization Table

Merck & Co. Inc., adjusted capitalization table

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Loans payable and current portion of long-term debt 1,372 1,946 2,412 6,431 3,610
Long-term debt, excluding current portion 33,683 28,745 30,690 25,360 22,736
Total reported debt 35,055 30,691 33,102 31,791 26,346
Total Merck & Co., Inc. stockholders’ equity 37,581 45,991 38,184 25,317 25,907
Total reported capital 72,636 76,682 71,286 57,108 52,253
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1
Add: Current operating lease liability (included in Accrued and other current liabilities)2 285 281 304 300 236
Add: Noncurrent operating lease liability (included in Other noncurrent liabilities)3 928 1,013 1,225 1,362 768
Adjusted total debt 36,268 31,985 34,631 33,453 27,350
Adjustments to Equity
Less: Net deferred income taxes4 1,097 (1,292) (2,749) (121) (750)
Add: Allowance for doubtful accounts 88 72 62 85 86
Add: LIFO reserve5 562 293 16 82 171
Add: Restructuring reserves 712 513 637 603 759
Add: Noncontrolling interests 54 67 73 87 94
Adjusted total equity 37,900 48,228 41,721 26,295 27,767
After Adjustment
Adjusted total capital 74,168 80,213 76,352 59,748 55,117

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Current operating lease liability (included in Accrued and other current liabilities). See details »

3 Noncurrent operating lease liability (included in Other noncurrent liabilities). See details »

4 Net deferred income taxes. See details »

5 LIFO reserve. See details »


Adjustments to Reported Income

Merck & Co. Inc., adjusted net income attributable to Merck & Co., Inc.

US$ in millions

Microsoft Excel
12 months ended: Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Net income attributable to Merck & Co., Inc. 365 14,519 13,049 7,067 9,843
Adjustments
Add: Deferred income tax expense (benefit)1 (1,899) (1,568) 187 (668) (556)
Add: Increase (decrease) in allowance for doubtful accounts 16 10 (5) (1) (33)
Add: Increase (decrease) in LIFO reserve2 269 277 (65) (89) 172
Add: Increase (decrease) in restructuring reserves 199 (124) 51 (156) 225
Less: Income from discontinued operations, net of taxes 704
Add: Other comprehensive income (loss) net of taxes (393) (339) 1,756 (441) (648)
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest 12 7 13 15 (66)
After Adjustment
Adjusted net income (1,431) 12,782 14,282 5,727 8,937

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 Deferred income tax expense (benefit). See details »

2 Increase (decrease) in LIFO reserve. See details »