Switch to:
Dell Inc (NAS:DELL)
E10
$1.30 (As of Jul. 2013)

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.

Dell Inc's adjusted earnings per share data for the three months ended in Jul. 2013 was $0.121. 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.30 for the trailing six years ended in Jul. 2013.

As of today, Dell Inc's current stock price is $13.86. Dell Inc's E10 for the trailing six years ended in Jul. 2013 was $1.30. Dell Inc's Shiller P/E Ratio of today is 10.64.

During the past 13 years, the highest Shiller P/E Ratio of Dell Inc was 51.26. The lowest was 6.37. And the median was 15.12.


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, Dell Inc's adjusted earnings per share data for the three months ended in Jul. 2013 was:

Adj_EPS=Earnigns per Share/CPI of Jul. 2013*CPI of Current
=0.12/233.596*236.511
=0.121

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

Current CPI = 236.511.

Dell Inc Quarterly Data

201104201107201110201201201204201207201210201301201304201307
per share eps 0.4900.4800.4900.4270.3600.4200.2700.3030.0700.120
CPI 224.906225.922226.421226.665230.085229.104231.317230.280232.531233.596
Adj_EPS 0.5150.5020.5120.4460.3700.4340.2760.3110.0710.121
200810200901200904200907200910201001201004201007201010201101
per share eps 0.3700.1800.1500.2400.1700.1690.1700.2800.4200.479
CPI 216.573211.143213.240215.351216.177216.687218.009218.011218.711220.223
Adj_EPS 0.4040.2020.1660.2640.1860.1840.1840.3040.4540.514
200710200801200804200807
per share eps 0.3400.3080.3800.310
CPI 208.936211.080214.823219.964
Adj_EPS 0.3850.3450.4180.333

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.

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

Shiller P/E Ratio=Share Price/E10
=13.86/1.30
=10.66

* 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 Dell Inc was 51.26. The lowest was 6.37. And the median was 15.12.


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.

Dell Inc Annual Data

Jan04Jan05Jan06Jan07Jan08Jan09Jan10Jan11Jan12Jan13
e10 0.740.861.021.071.251.301.251.271.351.37

Dell Inc Quarterly Data

Apr11Jul11Oct11Jan12Apr12Jul12Oct12Jan13Apr13Jul13
e10 1.311.311.361.351.361.391.391.371.331.30
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
Hide