Switch to:
GuruFocus has detected 5 Warning Signs with Constellation Brands Inc $STZ.
More than 500,000 people have already joined GuruFocus to track the stocks they follow and exchange investment ideas.
Constellation Brands Inc (NYSE:STZ)
E10
$3.06 (As of Feb. 2017)

E10 is a concept invented by Prof. Robert Shiller, who uses E10 for his Shiller P/E calculation. E10 is the average of the inflation adjusted earnings of a company over the past 10 years.

Constellation Brands Inc's adjusted earnings per share data for the three months ended in Feb. 2017 was $2.250. Add all the adjusted EPS for the past 10 years together and divide 10 will get our e10, which is $3.06 for the trailing ten years ended in Feb. 2017.

As of today, Constellation Brands Inc's current stock price is $184.11. Constellation Brands Inc's E10 for the quarter that ended in Feb. 2017 was $3.06. Constellation Brands Inc's Shiller P/E Ratio of today is 60.17.

During the past 13 years, the highest Shiller P/E Ratio of Constellation Brands Inc was 66.53. The lowest was 17.15. And the median was 35.14.


Definition

E10 is a concept invented by Prof. Robert Shiller, who uses E10 for his Shiller P/E calculation. When we calculate the today’'s Shiller P/E ratio of a stock, we use today’s price divided by E10.

What is E10? How do we calculate E10?

E10 is the average of the inflation adjusted earnings of a company over the past 10 years. Let’s use an example to explain.

If we want to calculate the E10 of Wal-Mart (WMT) for Dec. 31, 2010, we need to have the inflation data and the earnings from 2001 through 2010.

We adjusted the earnings of 2001 earnings data with the total inflation from 2001 through 2010 to the equivalent earnings in 2010. If the total inflation from 2001 to 2010 is 40%, and Wal-Mart earned $1 a share in 2001, then the 2001’s equivalent earnings in 2010 is $1.4 a share. If Wal-Mart earns $1 again in 2002, and the total inflation from 2002 through 2010 is 35%, then the equivalent 2002 earnings in 2010 is $1.35. So on and so forth, you get the equivalent earnings of past 10 years. Then you add them together and divided the sum by 10 to get E10.

For example, Constellation Brands Inc's adjusted earnings per share data for the three months ended in Feb. 2017 was:

Adj_EPS=Earnigns per Share/CPI of Feb. 2017 (Change)*Current CPI (Feb. 2017)
=2.25/243.603*243.603
=2.250

Current CPI (Feb. 2017) = 243.603.

Constellation Brands Inc Quarterly Data

201411201502201505201508201511201602201605201608201611201702
per share eps 1.1001.0601.1801.4901.3301.1901.5501.7501.9802.250
CPI 236.151234.722237.805238.316237.336237.111240.229240.849241.353243.603
Adj_EPS 1.1351.1001.2091.5231.3651.2231.5721.7701.9982.250
201205201208201211201302201305201308201311201402201405201408
per share eps 0.3800.6700.5800.4200.2707.7401.0700.7601.0300.980
CPI 229.815230.379230.221232.166232.945233.877233.069234.781237.900237.852
Adj_EPS 0.4030.7080.6140.4410.2828.0621.1180.7891.0551.004
200911201002201005201008201011201102201105201108201111201202
per share eps 0.200-0.2300.2200.4300.6501.3200.3500.7600.5200.510
CPI 216.330216.741218.178218.312218.803221.309225.964226.545226.230227.663
Adj_EPS 0.225-0.2590.2460.4800.7241.4530.3770.8170.5600.546
200705200708200711200802200805200808200811200902200905200908
per share eps 0.1300.3300.550-3.8500.200-0.1100.380-1.8900.0300.410
CPI 207.949207.917210.177211.693216.632219.086212.425212.193213.856215.834
Adj_EPS 0.1520.3870.637-4.4300.225-0.1220.436-2.1700.0340.463

Add all the adjusted EPS together and divide 10 will get our e10.


Explanation

If a company grows much fast than inflation, E10 may underestimate the company's earnings power. Shiller P/E Ratio can seem to be too high even the actual P/E is low.

For the Shiller P/E, the earnings of the past 10 years are inflation-adjusted and averaged. The result is used for P/E calculation. Since it looks at the average over the last 10 years, the Shiller P/E is also called PE10.

The Shiller P/E was first used by professor Robert Shiller to measure the valuation of the overall market. The same calculation is applied here to individual companies.

Constellation Brands Inc's Shiller P/E Ratio of today is calculated as

Shiller P/E Ratio=Share Price/E10
=184.11/3.06
=60.17

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

During the past 13 years, the highest Shiller P/E Ratio of Constellation Brands Inc was 66.53. The lowest was 17.15. And the median was 35.14.


Be Aware

Shiller P/E Ratio works better for cyclical companies. It gives you a better idea on the company's real earnings power.


Related Terms

Shiller P/E Ratio


Historical Data

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

Constellation Brands Inc Annual Data

Feb08Feb09Feb10Feb11Feb12Feb13Feb14Feb15Feb16Feb17
e10 0.660.480.460.650.790.871.752.012.393.06

Constellation Brands Inc Quarterly Data

Nov14Feb15May15Aug15Nov15Feb16May16Aug16Nov16Feb17
e10 1.932.012.112.222.302.392.522.672.813.06
Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names | Earn affiliate commissions by embedding GuruFocus Charts
GuruFocus Affiliate Program: Earn up to $400 per referral. ( Learn More)

GF Chat

{{numOfNotice}}
FEEDBACK