Stock Analysis on Net
Stock Analysis on Net

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

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Beginner level

Long-term Activity Ratios (Summary)

Estée Lauder Cos. Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014
Net fixed asset turnover 6.62 6.72 6.96 7.39 7.60 7.55 7.19 7.70 7.64 7.58 7.51 7.70 7.39 7.22 7.08 7.35 7.28 7.20 7.11 7.38 7.39 7.48 7.23
Net fixed asset turnover (including operating lease, right-of-use asset) 3.18 3.17 3.30 3.41 3.44 3.36 7.19 7.70 7.64 7.58 7.51 7.70 7.39 7.22 7.08 7.35 7.28 7.20 7.11 7.38 7.39 7.48 7.23
Total asset turnover 0.72 0.78 0.80 0.84 0.88 0.99 1.13 1.13 1.12 1.11 1.09 1.04 1.01 1.00 1.02 1.01 1.01 1.21 1.22 1.26 1.29 1.30 1.31
Equity turnover 2.62 3.14 3.63 3.57 3.47 3.36 3.39 3.18 3.30 3.16 2.92 2.82 2.80 2.59 2.70 2.81 3.00 3.09 3.15 2.92 3.07 3.15 2.96

Based on: 10-Q (filing date: 2021-02-05), 10-Q (filing date: 2020-11-02), 10-K (filing date: 2020-08-28), 10-Q (filing date: 2020-05-01), 10-Q (filing date: 2020-02-06), 10-Q (filing date: 2019-10-31), 10-K (filing date: 2019-08-23), 10-Q (filing date: 2019-05-01), 10-Q (filing date: 2019-02-05), 10-Q (filing date: 2018-10-31), 10-K (filing date: 2018-08-24), 10-Q (filing date: 2018-05-02), 10-Q (filing date: 2018-02-02), 10-Q (filing date: 2017-11-01), 10-K (filing date: 2017-08-25), 10-Q (filing date: 2017-05-03), 10-Q (filing date: 2017-02-02), 10-Q (filing date: 2016-11-02), 10-K (filing date: 2016-08-24), 10-Q (filing date: 2016-05-03), 10-Q (filing date: 2016-02-05), 10-Q (filing date: 2015-11-02), 10-K (filing date: 2015-08-20), 10-Q (filing date: 2015-05-05), 10-Q (filing date: 2015-02-05), 10-Q (filing date: 2014-11-04).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Estée Lauder Cos. Inc.’s net fixed asset turnover ratio deteriorated from Q4 2020 to Q1 2021 and from Q1 2021 to Q2 2021.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Estée Lauder Cos. Inc.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q4 2020 to Q1 2021 but then slightly improved from Q1 2021 to Q2 2021.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Estée Lauder Cos. Inc.’s total asset turnover ratio deteriorated from Q4 2020 to Q1 2021 and from Q1 2021 to Q2 2021.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Estée Lauder Cos. Inc.’s equity turnover ratio deteriorated from Q4 2020 to Q1 2021 and from Q1 2021 to Q2 2021.

Net Fixed Asset Turnover

Estée Lauder Cos. Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014
Selected Financial Data (US$ in millions)
Net sales 4,853  3,562  2,430  3,345  4,624  3,895  3,590  3,744  4,005  3,524  3,295  3,370  3,744  3,274  2,894  2,857  3,208  2,865  2,646  2,657  3,125  2,835  2,524  2,581  3,045  2,631 
Property, plant and equipment, net 2,142  2,077  2,055  2,092  2,086  2,018  2,068  1,891  1,859  1,838  1,823  1,726  1,728  1,695  1,671  1,576  1,563  1,569  1,583  1,511  1,497  1,469  1,490  1,398  1,434  1,444 
Long-term Activity Ratio
Net fixed asset turnover1 6.62 6.72 6.96 7.39 7.60 7.55 7.19 7.70 7.64 7.58 7.51 7.70 7.39 7.22 7.08 7.35 7.28 7.20 7.11 7.38 7.39 7.48 7.23
Benchmarks
Net Fixed Asset Turnover, Competitors2
Colgate-Palmolive Co. 4.43 4.61 4.58 4.56 4.18 4.20 4.06 4.04 4.01 4.04 4.03 3.84 3.80 3.82 3.86 3.91 3.96
Kimberly-Clark Corp. 2.38 2.52 2.56 2.61 2.48 2.58 2.55 2.58 2.58 2.63 2.63 2.53 2.46 2.49 2.51 2.51 2.54
Nike Inc. 7.71 7.51 7.69 8.63 8.74 8.63 8.25 8.26 8.30 8.31 8.17 8.21 8.44 8.41 8.61 8.94 9.40 9.24 9.20 9.59 9.69 9.97 10.16

Based on: 10-Q (filing date: 2021-02-05), 10-Q (filing date: 2020-11-02), 10-K (filing date: 2020-08-28), 10-Q (filing date: 2020-05-01), 10-Q (filing date: 2020-02-06), 10-Q (filing date: 2019-10-31), 10-K (filing date: 2019-08-23), 10-Q (filing date: 2019-05-01), 10-Q (filing date: 2019-02-05), 10-Q (filing date: 2018-10-31), 10-K (filing date: 2018-08-24), 10-Q (filing date: 2018-05-02), 10-Q (filing date: 2018-02-02), 10-Q (filing date: 2017-11-01), 10-K (filing date: 2017-08-25), 10-Q (filing date: 2017-05-03), 10-Q (filing date: 2017-02-02), 10-Q (filing date: 2016-11-02), 10-K (filing date: 2016-08-24), 10-Q (filing date: 2016-05-03), 10-Q (filing date: 2016-02-05), 10-Q (filing date: 2015-11-02), 10-K (filing date: 2015-08-20), 10-Q (filing date: 2015-05-05), 10-Q (filing date: 2015-02-05), 10-Q (filing date: 2014-11-04).

1 Q2 2021 Calculation
Net fixed asset turnover = (Net salesQ2 2021 + Net salesQ1 2021 + Net salesQ4 2020 + Net salesQ3 2020) ÷ Property, plant and equipment, net
= (4,853 + 3,562 + 2,430 + 3,345) ÷ 2,142 = 6.62

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Estée Lauder Cos. Inc.’s net fixed asset turnover ratio deteriorated from Q4 2020 to Q1 2021 and from Q1 2021 to Q2 2021.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Estée Lauder Cos. Inc., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014
Selected Financial Data (US$ in millions)
Net sales 4,853  3,562  2,430  3,345  4,624  3,895  3,590  3,744  4,005  3,524  3,295  3,370  3,744  3,274  2,894  2,857  3,208  2,865  2,646  2,657  3,125  2,835  2,524  2,581  3,045  2,631 
 
Property, plant and equipment, net 2,142  2,077  2,055  2,092  2,086  2,018  2,068  1,891  1,859  1,838  1,823  1,726  1,728  1,695  1,671  1,576  1,563  1,569  1,583  1,511  1,497  1,469  1,490  1,398  1,434  1,444 
Operating lease right-of-use assets 2,325  2,322  2,282  2,446  2,517  2,516  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Property, plant and equipment, net (including operating lease, right-of-use asset) 4,467  4,399  4,337  4,538  4,603  4,534  2,068  1,891  1,859  1,838  1,823  1,726  1,728  1,695  1,671  1,576  1,563  1,569  1,583  1,511  1,497  1,469  1,490  1,398  1,434  1,444 
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 3.18 3.17 3.30 3.41 3.44 3.36 7.19 7.70 7.64 7.58 7.51 7.70 7.39 7.22 7.08 7.35 7.28 7.20 7.11 7.38 7.39 7.48 7.23
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Nike Inc. 4.76 4.59 4.70 5.37 5.40 5.35 8.25 8.26 8.30 8.31 8.17 8.21 8.44 8.41 8.61 8.94 9.40 9.24 9.20 9.59 9.69 9.97 10.16

Based on: 10-Q (filing date: 2021-02-05), 10-Q (filing date: 2020-11-02), 10-K (filing date: 2020-08-28), 10-Q (filing date: 2020-05-01), 10-Q (filing date: 2020-02-06), 10-Q (filing date: 2019-10-31), 10-K (filing date: 2019-08-23), 10-Q (filing date: 2019-05-01), 10-Q (filing date: 2019-02-05), 10-Q (filing date: 2018-10-31), 10-K (filing date: 2018-08-24), 10-Q (filing date: 2018-05-02), 10-Q (filing date: 2018-02-02), 10-Q (filing date: 2017-11-01), 10-K (filing date: 2017-08-25), 10-Q (filing date: 2017-05-03), 10-Q (filing date: 2017-02-02), 10-Q (filing date: 2016-11-02), 10-K (filing date: 2016-08-24), 10-Q (filing date: 2016-05-03), 10-Q (filing date: 2016-02-05), 10-Q (filing date: 2015-11-02), 10-K (filing date: 2015-08-20), 10-Q (filing date: 2015-05-05), 10-Q (filing date: 2015-02-05), 10-Q (filing date: 2014-11-04).

1 Q2 2021 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (Net salesQ2 2021 + Net salesQ1 2021 + Net salesQ4 2020 + Net salesQ3 2020) ÷ Property, plant and equipment, net (including operating lease, right-of-use asset)
= (4,853 + 3,562 + 2,430 + 3,345) ÷ 4,467 = 3.18

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Estée Lauder Cos. Inc.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q4 2020 to Q1 2021 but then slightly improved from Q1 2021 to Q2 2021.

Total Asset Turnover

Estée Lauder Cos. Inc., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014
Selected Financial Data (US$ in millions)
Net sales 4,853  3,562  2,430  3,345  4,624  3,895  3,590  3,744  4,005  3,524  3,295  3,370  3,744  3,274  2,894  2,857  3,208  2,865  2,646  2,657  3,125  2,835  2,524  2,581  3,045  2,631 
Total assets 19,595  17,903  17,781  18,363  17,937  15,431  13,156  12,931  12,676  12,543  12,567  12,772  12,604  12,202  11,568  11,445  11,212  9,348  9,223  8,816  8,582  8,425  8,239  8,095  7,857  7,664 
Long-term Activity Ratio
Total asset turnover1 0.72 0.78 0.80 0.84 0.88 0.99 1.13 1.13 1.12 1.11 1.09 1.04 1.01 1.00 1.02 1.01 1.01 1.21 1.22 1.26 1.29 1.30 1.31
Benchmarks
Total Asset Turnover, Competitors2
Colgate-Palmolive Co. 1.03 1.05 1.05 1.06 1.04 1.03 1.17 1.20 1.28 1.24 1.25 1.19 1.22 1.20 1.21 1.22 1.25
Kimberly-Clark Corp. 1.09 1.14 1.17 1.20 1.21 1.23 1.20 1.21 1.27 1.27 1.27 1.21 1.21 1.21 1.21 1.23 1.25
Nike Inc. 1.10 1.12 1.19 1.57 1.53 1.52 1.65 1.69 1.68 1.66 1.62 1.56 1.44 1.45 1.48 1.46 1.48 1.56 1.51 1.52 1.39 1.49 1.42

Based on: 10-Q (filing date: 2021-02-05), 10-Q (filing date: 2020-11-02), 10-K (filing date: 2020-08-28), 10-Q (filing date: 2020-05-01), 10-Q (filing date: 2020-02-06), 10-Q (filing date: 2019-10-31), 10-K (filing date: 2019-08-23), 10-Q (filing date: 2019-05-01), 10-Q (filing date: 2019-02-05), 10-Q (filing date: 2018-10-31), 10-K (filing date: 2018-08-24), 10-Q (filing date: 2018-05-02), 10-Q (filing date: 2018-02-02), 10-Q (filing date: 2017-11-01), 10-K (filing date: 2017-08-25), 10-Q (filing date: 2017-05-03), 10-Q (filing date: 2017-02-02), 10-Q (filing date: 2016-11-02), 10-K (filing date: 2016-08-24), 10-Q (filing date: 2016-05-03), 10-Q (filing date: 2016-02-05), 10-Q (filing date: 2015-11-02), 10-K (filing date: 2015-08-20), 10-Q (filing date: 2015-05-05), 10-Q (filing date: 2015-02-05), 10-Q (filing date: 2014-11-04).

1 Q2 2021 Calculation
Total asset turnover = (Net salesQ2 2021 + Net salesQ1 2021 + Net salesQ4 2020 + Net salesQ3 2020) ÷ Total assets
= (4,853 + 3,562 + 2,430 + 3,345) ÷ 19,595 = 0.72

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Estée Lauder Cos. Inc.’s total asset turnover ratio deteriorated from Q4 2020 to Q1 2021 and from Q1 2021 to Q2 2021.

Equity Turnover

Estée Lauder Cos. Inc., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014
Selected Financial Data (US$ in millions)
Net sales 4,853  3,562  2,430  3,345  4,624  3,895  3,590  3,744  4,005  3,524  3,295  3,370  3,744  3,274  2,894  2,857  3,208  2,865  2,646  2,657  3,125  2,835  2,524  2,581  3,045  2,631 
Stockholders’ equity, The Estée Lauder Companies Inc. 5,421  4,452  3,935  4,329  4,574  4,530  4,386  4,588  4,306  4,406  4,688  4,711  4,565  4,731  4,384  4,119  3,793  3,657  3,572  3,812  3,604  3,490  3,643  3,855  3,818  3,780 
Long-term Activity Ratio
Equity turnover1 2.62 3.14 3.63 3.57 3.47 3.36 3.39 3.18 3.30 3.16 2.92 2.82 2.80 2.59 2.70 2.81 3.00 3.09 3.15 2.92 3.07 3.15 2.96
Benchmarks
Equity Turnover, Competitors2
Colgate-Palmolive Co. 22.17 24.75 59.47 134.13
Kimberly-Clark Corp. 30.58 56.38 70.31 58.38 29.03 70.35 178.19 133.89
Nike Inc. 3.60 4.05 4.64 4.56 4.36 4.33 4.33 4.32 4.36 4.15 3.71 3.61 2.95 2.86 2.77 2.67 2.72 2.71 2.64 2.59 2.34 2.41 2.41

Based on: 10-Q (filing date: 2021-02-05), 10-Q (filing date: 2020-11-02), 10-K (filing date: 2020-08-28), 10-Q (filing date: 2020-05-01), 10-Q (filing date: 2020-02-06), 10-Q (filing date: 2019-10-31), 10-K (filing date: 2019-08-23), 10-Q (filing date: 2019-05-01), 10-Q (filing date: 2019-02-05), 10-Q (filing date: 2018-10-31), 10-K (filing date: 2018-08-24), 10-Q (filing date: 2018-05-02), 10-Q (filing date: 2018-02-02), 10-Q (filing date: 2017-11-01), 10-K (filing date: 2017-08-25), 10-Q (filing date: 2017-05-03), 10-Q (filing date: 2017-02-02), 10-Q (filing date: 2016-11-02), 10-K (filing date: 2016-08-24), 10-Q (filing date: 2016-05-03), 10-Q (filing date: 2016-02-05), 10-Q (filing date: 2015-11-02), 10-K (filing date: 2015-08-20), 10-Q (filing date: 2015-05-05), 10-Q (filing date: 2015-02-05), 10-Q (filing date: 2014-11-04).

1 Q2 2021 Calculation
Equity turnover = (Net salesQ2 2021 + Net salesQ1 2021 + Net salesQ4 2020 + Net salesQ3 2020) ÷ Stockholders’ equity, The Estée Lauder Companies Inc.
= (4,853 + 3,562 + 2,430 + 3,345) ÷ 5,421 = 2.62

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Estée Lauder Cos. Inc.’s equity turnover ratio deteriorated from Q4 2020 to Q1 2021 and from Q1 2021 to Q2 2021.