Switch to:
Aetna Inc (NYSE:AET)
Shiller P/E Ratio
18.93 (As of Today)

As of today, Aetna Inc's current share price is $90.84. Aetna Inc's E10 for the quarter that ended in Sep. 2014 was $4.80. Aetna Inc's Shiller P/E Ratio for today is 18.93.

AET' s 10-Year Shiller P/E Ratio Range
Min: 5.83   Max: 130.18
Current: 18.94

5.83
130.18

During the past 13 years, Aetna Inc's highest Shiller P/E Ratio was 130.18. The lowest was 5.83. And the median was 14.76.

AET's Shiller P/E Ratiois ranked higher than
94% of the 48 Companies
in the Global Health Care Plans industry.

( Industry Median: 37.66 vs. AET: 18.94 )

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.

Aetna Inc's adjusted earnings per share data for the three months ended in Sep. 2014 was $1.652. 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 $4.80 for the trailing six years ended in Sep. 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.

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

Shiller P/E Ratio=Share Price/E10
=90.84/4.80
=18.93

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

Aetna Inc's E10 for the fiscal year that ended in Dec13 is calculated as:

For example, Aetna Inc's adjusted earnings per share data for the three months ended in Sep. 2014 was:

Adj_EPS=Earnigns per Share/CPI of Sep. 2014*CPI of Current
=1.67/238.031*235.51
=1.652

Since most companies do not have as long as 10 years history, GuruFocus uses 6 years to do the calculation.

Current CPI = 235.51.

Aetna Inc Quarterly Data

201206201209201212201303201306201309201312201403201406201409
per share eps 1.3201.4700.5621.4801.4901.3800.9961.8201.5201.670
CPI 229.478231.407229.601232.773233.504234.149233.049236.293238.343238.031
Adj_EPS 1.3551.4960.5761.4971.5031.3881.0071.8141.5021.652
200912201003201006201009201012201103201106201109201112201203
per share eps 0.3761.2801.1401.1900.5351.5001.3901.3001.0191.430
CPI 215.949217.631217.965218.439219.179223.467225.722226.889225.672229.392
Adj_EPS 0.4101.3851.2321.2830.5751.5811.4501.3491.0631.468
200812200903200906200909
per share eps 0.4160.9500.7700.730
CPI 210.228212.709215.693215.969
Adj_EPS 0.4661.0520.8410.796

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.

Aetna Inc Annual Data

Dec04Dec05Dec06Dec07Dec08Dec09Dec10Dec11Dec12Dec13
ShillerPE 112.1295.3244.8135.159.599.799.2311.1911.4815.75

Aetna Inc Quarterly Data

Jun12Sep12Dec12Mar13Jun13Sep13Dec13Mar14Jun14Sep14
ShillerPE 9.679.5811.4812.1614.7914.7215.7516.4917.5216.96
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