GURUFOCUS.COM » STOCK LIST » Consumer Defensive » Consumer Packaged Goods » The Estee Lauder Companies Inc (MEX:EL) » Definitions » Cyclically Adjusted Book per Share

The Estee Lauder (MEX:EL) Cyclically Adjusted Book per Share : MXN236.19 (As of Mar. 2024)


View and export this data going back to 2014. Start your Free Trial

What is The Estee Lauder Cyclically Adjusted Book per Share?

E10 is a concept invented by Prof. Robert Shiller, who uses E10 for his Shiller PE Ratio calculation. E10 is the average of the inflation adjusted earnings of a company over the past 10 years. The similar calculation is applied by GuruFocus to calculate the Cyclically Adjusted Book per Share and the Cyclically Adjusted PB Ratio. The Cyclically Adjusted Book per Share is the average of the inflation adjusted Book Value per Share of a company over the past 10 years.

The Estee Lauder's adjusted book value per share for the three months ended in Mar. 2024 was MXN265.869. Add all the adjusted book value per share for the past 10 years together and divide the count will get our Cyclically Adjusted Book per Share, which is MXN236.19 for the trailing ten years ended in Mar. 2024.

During the past 12 months, The Estee Lauder's average Cyclically Adjusted Book Growth Rate was 5.80% per year. During the past 3 years, the average Cyclically Adjusted Book Growth Rate was 11.90% per year. During the past 5 years, the average Cyclically Adjusted Book Growth Rate was 10.90% per year. During the past 10 years, the average Cyclically Adjusted Book Growth Rate was 10.80% per year. Please click Growth Rate Calculation Example (GuruFocus) to see how GuruFocus calculates Wal-Mart Stores Inc (WMT)'s revenue growth rate. You can apply the same method to get the Cyclically Adjusted Book Growth Rate using Cyclically Adjusted Book per Share data.

During the past 13 years, the highest 3-Year average Cyclically Adjusted Book Growth Rate of The Estee Lauder was 11.90% per year. The lowest was 6.70% per year. And the median was 10.00% per year.

As of today (2024-07-22), The Estee Lauder's current stock price is MXN1784.00. The Estee Lauder's Cyclically Adjusted Book per Share for the quarter that ended in Mar. 2024 was MXN236.19. The Estee Lauder's Cyclically Adjusted PB Ratio of today is 7.55.

During the past 13 years, the highest Cyclically Adjusted PB Ratio of The Estee Lauder was 30.00. The lowest was 6.47. And the median was 13.99.


The Estee Lauder Cyclically Adjusted Book per Share Historical Data

The historical data trend for The Estee Lauder's Cyclically Adjusted Book per Share can be seen below:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* Premium members only.

The Estee Lauder Cyclically Adjusted Book per Share Chart

The Estee Lauder Annual Data
Trend Jun14 Jun15 Jun16 Jun17 Jun18 Jun19 Jun20 Jun21 Jun22 Jun23
Cyclically Adjusted Book per Share
Get a 7-Day Free Trial Premium Member Only Premium Member Only 188.66 238.02 233.53 285.85 253.67

The Estee Lauder Quarterly Data
Jun19 Sep19 Dec19 Mar20 Jun20 Sep20 Dec20 Mar21 Jun21 Sep21 Dec21 Mar22 Jun22 Sep22 Dec22 Mar23 Jun23 Sep23 Dec23 Mar24
Cyclically Adjusted Book per Share Get a 7-Day Free Trial Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 261.32 253.67 252.52 251.92 236.19

Competitive Comparison of The Estee Lauder's Cyclically Adjusted Book per Share

For the Household & Personal Products subindustry, The Estee Lauder's Cyclically Adjusted PB Ratio, along with its competitors' market caps and Cyclically Adjusted PB Ratio data, can be viewed below:

* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap. Note that "N/A" values will not show up in the chart.


The Estee Lauder's Cyclically Adjusted PB Ratio Distribution in the Consumer Packaged Goods Industry

For the Consumer Packaged Goods industry and Consumer Defensive sector, The Estee Lauder's Cyclically Adjusted PB Ratio distribution charts can be found below:

* The bar in red indicates where The Estee Lauder's Cyclically Adjusted PB Ratio falls into.



The Estee Lauder Cyclically Adjusted Book per Share Calculation

E10 is a concept invented by Prof. Robert Shiller, who uses E10 for his Shiller PE Ratio calculation. E10 is the average of the inflation adjusted earnings of a company over the past 10 years. The similar calculation is applied by GuruFocus to calculate the Cyclically Adjusted Book per Share and the Cyclically Adjusted PB Ratio. The Cyclically Adjusted Book per Share is the average of the inflation adjusted Book Value per Share of a company over the past 10 years.

What is Cyclically Adjusted Book per Share? How do we calculate Cyclically Adjusted Book per Share?

Cyclically Adjusted Book per Share is the average of the inflation adjusted Book Value per Share of a company over the past 10 years. Let's use an example to explain.

If we want to calculate the Cyclically Adjusted Book per Share of Wal-Mart (WMT) for Dec. 31, 2010, we need to have the inflation data and the book value per share from 2001 through 2010.

We adjusted the 2001 book value per share data with the total inflation from 2001 through 2010 to the equivalent book value in 2010. If the total inflation from 2001 to 2010 is 40%, and Wal-Mart's book value is $1 a share in 2001, then the 2001's equivalent book value in 2010 is $1.4 a share. If Wal-Mart's book value is $1 again in 2002, and the total inflation from 2002 through 2010 is 35%, then the equivalent 2002 book value in 2010 is $1.35. So on and so forth, you get the equivalent book value per share of past 10 years. Then you add them together and divided the sum by the count to get Cyclically Adjusted Book per Share.

Please note that we use the CPI data of the country/region where the company is headquartered. If the CPI data for that country/region is not available, then we will use the CPI data of the United States as default.

For example, The Estee Lauder's adjusted Book Value per Share data for the three months ended in Mar. 2024 was:

Adj_Book= Book Value per Share /CPI of Mar. 2024 (Change)*Current CPI (Mar. 2024)
=265.869/131.7762*131.7762
=265.869

Current CPI (Mar. 2024) = 131.7762.

The Estee Lauder Quarterly Data

Book Value per Share CPI Adj_Book
201406 130.577 100.560 171.112
201409 133.140 100.428 174.699
201412 148.652 99.070 197.727
201503 155.325 99.621 205.460
201506 152.481 100.684 199.569
201509 159.111 100.392 208.853
201512 167.754 99.792 221.520
201603 177.739 100.470 233.121
201606 179.625 101.688 232.774
201609 193.026 101.861 249.715
201612 213.583 101.863 276.305
201703 210.921 102.862 270.210
201706 215.280 103.349 274.495
201709 232.979 104.136 294.818
201712 243.578 104.011 308.600
201803 233.018 105.290 291.636
201806 250.900 106.317 310.982
201809 226.136 106.507 279.788
201812 233.649 105.998 290.472
201903 246.005 107.251 302.261
201906 233.314 108.070 284.495
201909 247.937 108.329 301.600
201912 240.029 108.420 291.737
202003 281.973 108.902 341.201
202006 251.932 108.767 305.226
202009 272.064 109.815 326.473
202012 297.365 109.897 356.568
202103 311.661 111.754 367.498
202106 333.290 114.631 383.138
202109 346.700 115.734 394.756
202112 355.042 117.630 397.741
202203 342.214 121.301 371.767
202206 314.964 125.017 331.993
202209 310.826 125.227 327.083
202212 322.193 125.222 339.057
202303 296.425 127.348 306.733
202306 267.739 128.729 274.077
202309 260.035 129.860 263.873
202312 270.507 129.419 275.433
202403 265.869 131.776 265.869

Add all the adjusted book value per share together and divide the count will get our Cyclically Adjusted Book per Share.


The Estee Lauder  (MEX:EL) Cyclically Adjusted Book per Share Explanation

If a company grows much fast than inflation, Cyclically Adjusted Book per Share may underestimate the company's equity. Cyclically Adjusted PB Ratio can seem to be too high even the actual PB Ratio is low.

For the Cyclically Adjusted PB Ratio, the book value of the past 10 years are inflation-adjusted and averaged. The result is used for P/B calculation. Since it looks at the average over the last 10 years, the Cyclically Adjusted PB Ratio is also called CAPB Ratio.

The Shiller PE Ratio was first used by professor Robert Shiller. He uses E10 for his Shiller PE Ratio calculation. E10 is the average of the inflation adjusted earnings per share of a company over the past 10 years. The similar calculation is applied by GuruFocus to calculate the Cyclically Adjusted PB Ratio. The Cyclically Adjusted Book per Share is the average of the inflation adjusted book value per share of a company over the past 10 years.

The Estee Lauder's Cyclically Adjusted PB Ratio of today is calculated as

Cyclically Adjusted PB Ratio=Share Price/Cyclically Adjusted Book per Share
=1784.00/236.19
=7.55

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

During the past 13 years, the highest Cyclically Adjusted PB Ratio of The Estee Lauder was 30.00. The lowest was 6.47. And the median was 13.99.


Be Aware

Cyclically Adjusted PB Ratio works better for cyclical companies. It gives you a better idea on the company's real book value.


The Estee Lauder Cyclically Adjusted Book per Share Related Terms

Thank you for viewing the detailed overview of The Estee Lauder's Cyclically Adjusted Book per Share provided by GuruFocus.com. Please click on the following links to see related term pages.


The Estee Lauder (MEX:EL) Business Description

Address
767 Fifth Avenue, New York, NY, USA, 10153
Estee Lauder is a leader in the global prestige beauty market, participating across skin care (56% of 2022 sales), makeup (26%), fragrance (14%), and hair care (4%) categories, with top-selling brands such as Estee Lauder, Clinique, M.A.C, La Mer, Jo Malone London, Aveda, Bobbi Brown, and Origins. The firm operates in more than 150 countries, generating 26% of revenue from the Americas, 43% from Europe, the Middle East and Africa (including travel retail), and 31% from Asia Pacific. Estee Lauder sells its products through department stores, travel retail, specialty multibrand beauty stores, brand-dedicated freestanding stores, e-commerce, salons/spas, and perfumeries.