Stock Analysis on Net

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

$22.49

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

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

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
Adjustments
Add: Allowance for credit losses
After Adjustment
Adjusted current assets

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
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1
Add: Allowance for credit losses
Less: Deferred tax assets (included in Other assets)2
After Adjustment
Adjusted total assets

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
Adjustments
Less: Current deferred revenue
After Adjustment
Adjusted current liabilities

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
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1
Less: Deferred tax liabilities (included in Other noncurrent liabilities)2
Less: Deferred revenue
Less: Accrued restructuring charges
After Adjustment
Adjusted total liabilities

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.
Adjustments
Less: Net deferred tax assets (liabilities)1
Add: Allowance for credit losses
Add: Deferred revenue
Add: Accrued restructuring charges
Add: Redeemable noncontrolling interest
Add: Noncontrolling interests
After Adjustment
Adjusted total equity

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
Long-term debt, excluding current maturities
Total reported debt
Stockholders’ equity, The Estée Lauder Companies Inc.
Total reported capital
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1
Add: Current operating lease liabilities2
Add: Long-term operating lease liabilities3
Adjusted total debt
Adjustments to Equity
Less: Net deferred tax assets (liabilities)4
Add: Allowance for credit losses
Add: Deferred revenue
Add: Accrued restructuring charges
Add: Redeemable noncontrolling interest
Add: Noncontrolling interests
Adjusted total equity
After Adjustment
Adjusted total capital

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
Adjustment
Add: Increase (decrease) in deferred revenue
After Adjustment
Adjusted net sales

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.
Adjustments
Add: Deferred income tax expense (benefit)1
Add: Increase (decrease) in allowance for credit losses
Add: Increase (decrease) in deferred revenue
Add: Increase (decrease) in accrued restructuring charges
Add: Other comprehensive income (loss), net of tax
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest
After Adjustment
Adjusted net earnings

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 »