Switch to:
Lowe's Companies Inc (NYSE:LOW)
E10
$1.68 (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.

Lowe's Companies Inc's adjusted earnings per share data for the three months ended in Apr. 2014 was $0.616. 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.68 for the trailing six years ended in Apr. 2014.

As of today, Lowe's Companies Inc's current stock price is $52.51. Lowe's Companies Inc's E10 for the trailing six years ended in Apr. 2014 was $1.68. Lowe's Companies Inc's Shiller P/E Ratio of today is 31.18.

During the past 13 years, the highest Shiller P/E Ratio of Lowe's Companies Inc was 43.38. The lowest was 7.97. And the median was 21.23.


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, Lowe's Companies 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
=0.61/237.072*239.229
=0.616

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

Current CPI = 239.229.

Lowe's Companies Inc Quarterly Data

201204201207201210201301201304201307201310201401201404201407
per share eps 0.4300.6400.3500.2600.4900.8800.4700.2900.6101.040
CPI 230.085229.104231.317230.280232.531233.596233.546233.916237.072238.786
Adj_EPS 0.4470.6680.3620.2700.5040.9010.4810.2970.6161.042
200910201001201004201007201010201101201104201107201110201201
per share eps 0.2300.1410.3400.5800.2900.2090.3400.6400.1800.261
CPI 216.177216.687218.009218.011218.711220.223224.906225.922226.421226.665
Adj_EPS 0.2550.1560.3730.6360.3170.2270.3620.6780.1900.275
200810200901200904200907
per share eps 0.3300.1110.3200.510
CPI 216.573211.143213.240215.351
Adj_EPS 0.3650.1260.3590.567

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.

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

Shiller P/E Ratio=Share Price/E10
=52.51/1.68
=31.26

* 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 Lowe's Companies Inc was 43.38. The lowest was 7.97. And the median was 21.23.


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.

Lowe's Companies Inc Annual Data

Jan05Jan06Jan07Jan08Jan09Jan10Jan11Jan12Jan13Jan14
e10 0.891.121.381.621.681.701.701.651.591.63

Lowe's Companies Inc Quarterly Data

Apr12Jul12Oct12Jan13Apr13Jul13Oct13Jan14Apr14Jul14
e10 1.661.651.631.591.591.631.631.631.680.00
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