Switch to:
Best Buy Co Inc (NYSE:BBY)
E10
$1.49 (As of Apr. 2014)

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.

Best Buy Co Inc's adjusted earnings per share data for the three months ended in Apr. 2014 was $1.319. Since most companies do not have as long as 10 years history, here we use 6 years to calculate. Add all the adjusted EPS for the past 6 years together and divide 6 will get our e10, which is $1.49 for the trailing six years ended in Apr. 2014.

As of today, Best Buy Co Inc's current stock price is $30.91. Best Buy Co Inc's E10 for the trailing six years ended in Apr. 2014 was $1.49. Best Buy Co Inc's Shiller P/E Ratio of today is 20.90.

During the past 13 years, the highest Shiller P/E Ratio of Best Buy Co Inc was 49.80. The lowest was 6.07. And the median was 18.56.


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, Best Buy Co Inc's adjusted earnings per share data for the three months ended in Apr. 2014 was:

Adj_EPS=Earnigns per Share/CPI of Apr. 2014*CPI of Current
=1.31/237.072*238.786
=1.319

Since most companies do not have as long as 10 years history, here we use 6 years to calculate:

Current CPI = 238.786.

Best Buy Co Inc Quarterly Data

201111201202201204201207201210201304201307201310201401201404
per share eps 0.420-4.9090.4600.040-0.030-0.2400.7700.1600.8271.310
CPI 226.230227.663230.085229.104231.317232.531233.596233.546233.916237.072
Adj_EPS 0.443-5.1490.4770.042-0.031-0.2460.7870.1640.8441.319
200905200908200911201002201005201008201011201102201105201108
per share eps 0.3600.3700.5301.8130.3600.6000.5401.6120.3500.470
CPI 213.856215.834216.330216.741218.178218.312218.803221.309225.964226.545
Adj_EPS 0.4020.4090.5851.9970.3940.6560.5891.7390.3700.495
200805200808200811200902
per share eps 0.4300.4800.1301.346
CPI 216.632219.086212.425212.193
Adj_EPS 0.4740.5230.1461.515

Add all the adjusted EPS together and divide 6 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.

Best Buy Co Inc's Shiller P/E Ratio of today is calculated as

Shiller P/E Ratio=Share Price/E10
=30.91/1.49
=20.74

* All numbers are in millions except for per share data and ratio. All numbers are in their own currency.

During the past 13 years, the highest Shiller P/E Ratio of Best Buy Co Inc was 49.80. The lowest was 6.07. And the median was 18.56.


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 own currency.

Best Buy Co Inc Annual Data

Feb04Feb05Feb06Feb07Feb08Feb09Feb10Feb11Feb12Jan14
e10 0.971.251.531.872.242.442.762.951.981.56

Best Buy Co Inc Quarterly Data

Nov11Feb12Apr12Jul12Oct12Apr13Jul13Oct13Jan14Apr14
e10 3.021.981.991.911.861.531.601.521.561.49
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)
Free 7-day Trial
FEEDBACK
Email Hide