AET has been removed from your Stock Email Alerts list.
Please enter Portfolio Name for new portfolio.
As of today, Aetna Inc's current share price is $129.46. Aetna Inc's E10 for the quarter that ended in Dec. 2016 was $5.02. Aetna Inc's Shiller P/E Ratio for today is 25.79.
During the past 13 years, Aetna Inc's highest Shiller P/E Ratio was 45.19. The lowest was 10.36. And the median was 18.43.
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 Dec. 2016 was $0.390. Add all the adjusted EPS for the past 10 years together and divide 10 will get our E10, which is $5.02 for the trailing ten years ended in Dec. 2016.
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|
* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.
Aetna Inc's E10 for the fiscal year that ended in Dec16 is calculated as:
For example, Aetna Inc's adjusted earnings per share data for the three months ended in Dec. 2016 was:
|Adj_EPS||=||Earnigns per Share||/||CPI of Dec. 2016 (Change)||*||Current CPI (Dec. 2016)|
Current CPI (Dec. 2016) = 241.432.
Aetna Inc Quarterly Data
|per share eps||1.670||0.670||2.200||2.080||1.590||0.910||2.060||2.230||1.700||0.390|
|per share eps||1.430||1.320||1.470||0.580||1.480||1.490||1.380||0.980||1.820||1.520|
|per share eps||0.730||0.380||1.280||1.140||1.190||0.570||1.500||1.390||1.300||1.030|
|per share eps||0.810||0.850||0.950||0.860||0.850||0.970||0.580||0.430||0.950||0.770|
Add all the adjusted EPS together and divide 10 will get our E10.
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.
The Shiller P/E assumes that over the long term, businesses and profitability revert to their means. If a companys business model does not work in the future compared with the past, the Shiller P/E and P/S ratio will give false valuations.
Aetna Inc Annual Data
Aetna Inc Quarterly Data