Switch to:
Staples Inc (NAS:SPLS)
Shiller P/E Ratio
11.80 (As of Today)

As of today, Staples Inc's current share price is $11.20. Staples Inc's E10 for the quarter that ended in Apr. 2014 was $0.95. Staples Inc's Shiller P/E Ratio for today is 11.80.

SPLS' s 10-Year Shiller P/E Ratio Range
Min: 8.22   Max: 45.18
Current: 11.8

8.22
45.18

During the past 13 years, Staples Inc's highest Shiller P/E Ratio was 45.18. The lowest was 8.22. And the median was 19.77.

SPLS's Shiller P/E Ratiois ranked higher than
93% of the 1169 Companies
in the Global Specialty Retail industry.

( Industry Median: 9999.00 vs. SPLS: 11.80 )

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.

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


Definition

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.

Staples Inc's Shiller P/E Ratio for today is calculated as

Shiller P/E Ratio=Share Price/E10
=11.20/0.95
=11.79

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

Staples Inc's E10 for the fiscal year that ended in Jan14 is calculated as:

For example, Staples 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.15/237.072*239.556
=0.152

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

Current CPI = 239.556.

Staples Inc Quarterly Data

201201201204201207201210201301201304201307201310201401201404
per share eps 0.4100.2700.180-0.8900.1190.2600.1600.2100.3260.150
CPI 226.665230.085229.104231.317230.280232.531233.596233.546233.916237.072
Adj_EPS 0.4330.2810.188-0.9220.1240.2680.1640.2150.3340.152
200907200910201001201004201007201010201101201104201107201110
per share eps 0.1300.3700.3220.2600.1800.4000.3810.2800.2500.470
CPI 215.351216.177216.687218.009218.011218.711220.223224.906225.922226.421
Adj_EPS 0.1450.4100.3560.2860.1980.4380.4140.2980.2650.497
200807200810200901200904
per share eps 0.2100.2200.4010.200
CPI 219.964216.573211.143213.240
Adj_EPS 0.2290.2430.4550.225

Add all the adjusted EPS together and divide 6 will get our E10.


Explanation

Compared with the regular P/E ratio, which works poorly for cyclical businesses, the Shiller P/E smoothed out the fluctuations of profit margins during business cycles. Therefore it is more accurate in reflecting the valuation of the company.

If a company has consistent business performance, the Shiller P/E should give similar results to regular P/E.

Compared with the P/S ratio, the Shiller P/E makes the comparison between different industries more meaningful.


Be Aware

The Shiller P/E assumes that over the long term, businesses and profitability revert to their means. If a company’s business model does not work in the future compared with the past, the Shiller P/E and P/S ratio will give false valuations.


Related Terms

P/E Ratio, P/B Ratio, P/S Ratio, Price-to-Free-Cash-Flow ratio, E10


Historical Data

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

Staples Inc Annual Data

Jan05Jan06Jan07Jan08Jan09Jan10Jan11Jan12Jan13Jan14
ShillerPE 41.3337.2230.1022.7914.3219.7017.8711.0912.9613.69

Staples Inc Quarterly Data

Jan12Apr12Jul12Oct12Jan13Apr13Jul13Oct13Jan14Apr14
ShillerPE 11.0911.489.6710.4012.9612.7216.6916.3913.6913.16
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