Stock Analysis on Net

Estée Lauder Cos. Inc. (NYSE:EL)

This company has been moved to the archive! The financial data has not been updated since August 18, 2023.

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

Estée Lauder Cos. Inc., adjusted current assets

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
As Reported
Current assets 9,139 9,298 9,768 8,892 7,212 6,168
Adjustments
Add: Allowance for credit losses 16 10 20 63 32 29
After Adjustment
Adjusted current assets 9,155 9,308 9,788 8,955 7,244 6,197

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).


Adjustments to Total Assets

Estée Lauder Cos. Inc., adjusted total assets

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
As Reported
Total assets 23,415 20,910 21,971 17,781 13,156 12,567
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 2,826 2,777
Add: Allowance for credit losses 16 10 20 63 32 29
Less: Deferred tax assets (included in Other assets)2 860 695 631 443 295 120
After Adjustment
Adjusted total assets 22,571 20,225 21,360 17,401 15,719 15,253

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).

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

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


Adjustments to Current Liabilities

Estée Lauder Cos. Inc., adjusted current liabilities

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
As Reported
Current liabilities 6,240 5,815 5,298 5,179 4,605 3,310
Adjustments
Less: Current deferred revenue 323 312 322 222 314
After Adjustment
Adjusted current liabilities 5,917 5,503 4,976 4,957 4,291 3,310

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).


Adjustments to Total Liabilities

Estée Lauder Cos. Inc., adjusted total liabilities

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
As Reported
Total liabilities 16,998 14,478 15,023 13,819 8,745 7,857
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 2,826 2,777
Less: Deferred tax liabilities (included in Other noncurrent liabilities)2 620 692 849 399
Less: Deferred revenue 572 362 371 279 361
Less: Accrued restructuring charges 82 125 131 112 204 182
After Adjustment
Adjusted total liabilities 15,724 13,299 13,672 13,029 11,006 10,452

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).

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

2 Deferred tax liabilities (included in Other noncurrent liabilities). See details »


Adjustments to Stockholders’ Equity

Estée Lauder Cos. Inc., adjusted stockholders’ equity, The Estée Lauder Companies Inc.

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
As Reported
Stockholders’ equity, The Estée Lauder Companies Inc. 5,585 5,590 6,057 3,935 4,386 4,688
Adjustments
Less: Net deferred tax assets (liabilities)1 240 3 (218) 44 295 120
Add: Allowance for credit losses 16 10 20 63 32 29
Add: Deferred revenue 572 362 371 279 361
Add: Accrued restructuring charges 82 125 131 112 204 182
Add: Redeemable noncontrolling interest 832 842 857
Add: Noncontrolling interests 34 27 25 22
After Adjustment
Adjusted total equity 6,847 6,926 7,688 4,372 4,713 4,801

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).

1 Net deferred tax assets (liabilities). See details »


Adjustments to Capitalization Table

Estée Lauder Cos. Inc., adjusted capitalization table

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
As Reported
Current debt 997 268 32 1,222 516 183
Long-term debt, excluding current maturities 7,117 5,144 5,537 4,914 2,896 3,361
Total reported debt 8,114 5,412 5,569 6,136 3,412 3,544
Stockholders’ equity, The Estée Lauder Companies Inc. 5,585 5,590 6,057 3,935 4,386 4,688
Total reported capital 13,699 11,002 11,626 10,071 7,798 8,232
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 2,826 2,777
Add: Current operating lease liabilities2 357 365 379 375
Add: Long-term operating lease liabilities3 1,698 1,868 2,151 2,278
Adjusted total debt 10,169 7,645 8,099 8,789 6,238 6,321
Adjustments to Equity
Less: Net deferred tax assets (liabilities)4 240 3 (218) 44 295 120
Add: Allowance for credit losses 16 10 20 63 32 29
Add: Deferred revenue 572 362 371 279 361
Add: Accrued restructuring charges 82 125 131 112 204 182
Add: Redeemable noncontrolling interest 832 842 857
Add: Noncontrolling interests 34 27 25 22
Adjusted total equity 6,847 6,926 7,688 4,372 4,713 4,801
After Adjustment
Adjusted total capital 17,016 14,571 15,787 13,161 10,951 11,122

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).

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

2 Current operating lease liabilities. See details »

3 Long-term operating lease liabilities. See details »

4 Net deferred tax assets (liabilities). See details »


Adjustments to Revenues

Estée Lauder Cos. Inc., adjusted net sales

US$ in millions

Microsoft Excel
12 months ended: Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
As Reported
Net sales 15,910 17,737 16,215 14,294 14,863 13,683
Adjustment
Add: Increase (decrease) in deferred revenue 210 (9) 92 (82) (19)
After Adjustment
Adjusted net sales 16,120 17,728 16,307 14,212 14,844 13,683

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).


Adjustments to Reported Income

Estée Lauder Cos. Inc., adjusted net earnings attributable to The Estée Lauder Companies Inc.

US$ in millions

Microsoft Excel
12 months ended: Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
As Reported
Net earnings attributable to The Estée Lauder Companies Inc. 1,006 2,390 2,870 684 1,785 1,108
Adjustments
Add: Deferred income tax expense (benefit)1 (186) (149) (230) (143) (66) 175
Add: Increase (decrease) in allowance for credit losses 6 (10) (16) 31 3 (1)
Add: Increase (decrease) in deferred revenue 210 (9) 92 (82) (19)
Add: Increase (decrease) in accrued restructuring charges (43) (6) 19 (91) 22 31
Add: Other comprehensive income (loss), net of tax (186) (321) 179 (102) (129) 82
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest (10) (11) (11) 12 9 9
After Adjustment
Adjusted net earnings 797 1,884 2,903 309 1,605 1,404

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).

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