GURUFOCUS.COM » STOCK LIST » Healthcare » Healthcare Plans » Aetna Inc (NYSE:AET) » Definitions » E10

Aetna (AET) E10 : $6.22 (As of Sep. 2018)


View and export this data going back to 1968. Start your Free Trial

What is Aetna E10?

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's adjusted earnings per share data for the three months ended in Sep. 2018 was $3.030. Add all the adjusted EPS for the past 10 years together and divide 10 will get our e10, which is $6.22 for the trailing ten years ended in Sep. 2018.

Please click Growth Rate Calculation Example (GuruFocus) to see how GuruFocus calculates Wal-Mart Stores Inc (WMT)'s revenue growth rate. You can apply the same method to get the E10 growth rate using E10 data.

As of today (2024-04-26), Aetna's current stock price is $212.70. Aetna's E10 for the quarter that ended in Sep. 2018 was $6.22. Aetna's Shiller PE Ratio of today is 34.20.


Aetna E10 Historical Data

The historical data trend for Aetna's E10 can be seen below:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* Premium members only.

Aetna E10 Chart

Aetna Annual Data
Trend Dec08 Dec09 Dec10 Dec11 Dec12 Dec13 Dec14 Dec15 Dec16 Dec17
E10
Get a 7-Day Free Trial Premium Member Only Premium Member Only 4.10 4.26 4.66 5.03 5.30

Aetna Quarterly Data
Dec13 Mar14 Jun14 Sep14 Dec14 Mar15 Jun15 Sep15 Dec15 Mar16 Jun16 Sep16 Dec16 Mar17 Jun17 Sep17 Dec17 Mar18 Jun18 Sep18
E10 Get a 7-Day Free Trial Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 5.32 5.30 5.62 5.93 6.22

Competitive Comparison of Aetna's E10

For the Healthcare Plans subindustry, Aetna's Shiller PE Ratio, along with its competitors' market caps and Shiller PE Ratio data, can be viewed below:

* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap. Note that "N/A" values will not show up in the chart.


Aetna's Shiller PE Ratio Distribution in the Healthcare Plans Industry

For the Healthcare Plans industry and Healthcare sector, Aetna's Shiller PE Ratio distribution charts can be found below:

* The bar in red indicates where Aetna's Shiller PE Ratio falls into.



Aetna E10 Calculation

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.

Please note that we use the CPI data of the country/region where the company is headquartered. If the CPI data for that country/region is not available, then we will use the CPI data of the United States as default.

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

Adj_EPS= Earnings per Share (Diluted) /CPI of Sep. 2018 (Change)*Current CPI (Sep. 2018)
=3.03/106.5067*106.5067
=3.030

Current CPI (Sep. 2018) = 106.5067.

Aetna Quarterly Data

per share eps CPI Adj_EPS
200812 0.430 88.697 0.516
200903 0.950 89.744 1.127
200906 0.770 91.003 0.901
200909 0.730 91.120 0.853
200912 0.380 91.111 0.444
201003 1.280 91.821 1.485
201006 1.140 91.962 1.320
201009 1.190 92.162 1.375
201012 0.570 92.474 0.656
201103 1.500 94.283 1.694
201106 1.390 95.235 1.555
201109 1.300 95.727 1.446
201112 1.030 95.213 1.152
201203 1.430 96.783 1.574
201206 1.320 96.819 1.452
201209 1.470 97.633 1.604
201212 0.580 96.871 0.638
201303 1.480 98.209 1.605
201306 1.490 98.518 1.611
201309 1.380 98.790 1.488
201312 0.980 98.326 1.062
201403 1.820 99.695 1.944
201406 1.520 100.560 1.610
201409 1.670 100.428 1.771
201412 0.670 99.070 0.720
201503 2.200 99.621 2.352
201506 2.080 100.684 2.200
201509 1.590 100.392 1.687
201512 0.910 99.792 0.971
201603 2.080 100.470 2.205
201606 2.230 101.688 2.336
201609 1.700 101.861 1.778
201612 0.390 101.863 0.408
201703 -1.110 102.862 -1.149
201706 3.600 103.349 3.710
201709 2.520 104.136 2.577
201712 0.760 104.011 0.778
201803 3.670 105.290 3.712
201806 3.670 106.317 3.677
201809 3.030 106.507 3.030

Add all the adjusted EPS together and divide 10 will get our e10.


Aetna  (NYSE:AET) E10 Explanation

If a company grows much fast than inflation, E10 may underestimate the company's earnings power. Shiller PE 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.

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

Shiller PE Ratio=Share Price/E10
=212.70/6.22
=34.20

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.


Be Aware

Shiller PE Ratio works better for cyclical companies. It gives you a better idea on the company's real earnings power.


Aetna E10 Related Terms

Thank you for viewing the detailed overview of Aetna's E10 provided by GuruFocus.com. Please click on the following links to see related term pages.


Aetna (AET) Business Description

Traded in Other Exchanges
N/A
Address
Aetna is one of the largest managed-care organizations in the U.S., with over 22 million medical members. This large member count helps the firm diversify its operating risk and has formed the basis for material competitive advantages. The firm provides health insurance services to its members through products that encompass every major insurance market--individual, group, and government sponsored. Aetna and CVS recently announced their intention to merge operations, and if approved, it would form one of the most powerful players within the healthcare space.
Executives
Fernando Aguirre director CHIQUITA BRANDS INTERNATIONAL, 250 EAST FIFTH STREET, CINCINNATI OH 45202
Harold L Paz officer: EVP & Chief Medical Officer AETNA INC., 151 FARMINGTON AVENUE, HARTFORD CT 06156
Molly Joel Coye director AETNA INC, 151 FARMINGTON AVENUE, HARTFORD CT 06156
Jeffrey E Garten director AETNA INC., 151 FARMINGTON AVENUE, HARTFORD CT 06156
Frank M Clark director AETNA INC., 151 FARMINGTON AVENUE, HARTFORD CT 06156
Shawn M Guertin officer: Exec. Vice President, CFO TRINET GROUP, INC., ONE PARK PLACE, SUITE 600, DUBLIN CA 94568
Mark T Bertolini director, officer: Chairman and CEO AETNA INC., 151 FARMINGTON AVENUE, HARTFORD CT 06156
Karen S Lynch officer: President 151 FARMINGTON AVENUE, RW61, HARTFORD CT 06156
Roger N Farah director POLO RALPH LAUREN CORP, 650 MADISON AVE, NEW YORK NY 10022
Ellen M Hancock director 126 LIMESTONE ROAD, RIDGEFIELD CT 06877
Edward J Ludwig director C/O BECTON DICKERSON & CO, 1 BECTON DR, FRANKLIN LAKES NJ 07417
Margaret M Mccarthy officer: EVP, Operations & Technology AETNA INC., 151 FARMINGTON AVENUE, HARTFORD CT 06156
Olympia J. Snowe director 100 E. PRATT STREET, BALTIMORE MD 21202
Heather Brianne Dixon officer: VP, Controller & CAO AETNA INC., 151 FARMINGTON AVENUE, HARTFORD CT 06156
Sabatino Thomas J Jr officer: EVP & General Counsel C/O JAN STERN REED BAXTER INTERNATIONAL, ONE BAXTER PARKWAY DF2 2W, DEERFIELD IL 60015