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
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.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.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.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 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-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 Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.
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 Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.
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 Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Estée Lauder Cos. Inc.’s equity turnover ratio improved from Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.

Net Fixed Asset Turnover

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

Microsoft Excel LibreOffice Calc
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 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,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.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.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 4.01 4.05 4.12 4.22
Kimberly-Clark Corp. 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 2.53 2.55 2.56 2.62
Nike Inc. 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-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 Q4 2020 Calculation
Net fixed asset turnover = (Net salesQ4 2020 + Net salesQ3 2020 + Net salesQ2 2020 + Net salesQ1 2020) ÷ Property, plant and equipment, net
= (2,430 + 3,345 + 4,624 + 3,895) ÷ 2,055 = 6.96

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 Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.

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
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 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,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,282  2,446  2,517  2,516  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — 
Property, plant and equipment, net (including operating lease, right-of-use asset) 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.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.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-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 Q4 2020 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (Net salesQ4 2020 + Net salesQ3 2020 + Net salesQ2 2020 + Net salesQ1 2020) ÷ Property, plant and equipment, net (including operating lease, right-of-use asset)
= (2,430 + 3,345 + 4,624 + 3,895) ÷ 4,337 = 3.30

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 Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.

Total Asset Turnover

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

Microsoft Excel LibreOffice Calc
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 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 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.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.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 1.22 1.24 1.26 1.34
Kimberly-Clark Corp. 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 1.22 1.24 1.24 1.25
Nike Inc. 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-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 Q4 2020 Calculation
Total asset turnover = (Net salesQ4 2020 + Net salesQ3 2020 + Net salesQ2 2020 + Net salesQ1 2020) ÷ Total assets
= (2,430 + 3,345 + 4,624 + 3,895) ÷ 17,781 = 0.80

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 Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.

Equity Turnover

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

Microsoft Excel LibreOffice Calc
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 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. 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 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. 59.47 134.13
Kimberly-Clark Corp. 70.31 58.38 29.03 70.35 178.19 133.89 60.86 93.47 168.59
Nike Inc. 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-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 Q4 2020 Calculation
Equity turnover = (Net salesQ4 2020 + Net salesQ3 2020 + Net salesQ2 2020 + Net salesQ1 2020) ÷ Stockholders’ equity, The Estée Lauder Companies Inc.
= (2,430 + 3,345 + 4,624 + 3,895) ÷ 3,935 = 3.63

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 improved from Q2 2020 to Q3 2020 and from Q3 2020 to Q4 2020.