Switch to:
Xilinx Inc  (NAS:XLNX) E10: $2.12 (As of Sep. 2017)

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.

Xilinx Inc's adjusted earnings per share data for the three months ended in Sep. 2017 was $0.650. Add all the adjusted EPS for the past 10 years together and divide 10 will get our e10, which is $2.12 for the trailing ten years ended in Sep. 2017.

As of today, Xilinx Inc's current stock price is $71.81. Xilinx Inc's E10 for the quarter that ended in Sep. 2017 was $2.12. Xilinx Inc's Shiller PE Ratio of today is 33.87.

During the past 13 years, the highest Shiller PE Ratio of Xilinx Inc was 40.47. The lowest was 17.00. And the median was 26.95.


Historical Data

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

* Premium members only.

Xilinx Inc Annual Data

Mar08 Mar09 Mar10 Mar11 Mar12 Mar13 Mar14 Mar15 Mar16 Mar17
E10 Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 1.51 1.64 1.76 1.87 2.02

Xilinx Inc Quarterly Data

Dec12 Mar13 Jun13 Sep13 Dec13 Mar14 Jun14 Sep14 Dec14 Mar15 Jun15 Sep15 Dec15 Mar16 Jun16 Sep16 Dec16 Mar17 Jun17 Sep17
E10 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 Premium Member Only Premium Member Only Premium Member Only 1.95 1.97 2.02 2.07 2.12

Competitive Comparison
* 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.


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.

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

Adj_EPS= Earnings per Share (Diluted) /CPI of Sep. 2017 (Change)*Current CPI (Sep. 2017)
=0.65/246.819*246.819
=0.650

Current CPI (Sep. 2017) = 246.819.

Xilinx Inc Quarterly Data

per share eps CPI Adj_EPS
200712 0.350 210.036 0.411
200803 0.330 213.528 0.381
200806 0.300 218.815 0.338
200809 0.290 218.783 0.327
200812 0.440 210.228 0.517
200903 0.280 212.709 0.325
200906 0.140 215.693 0.160
200909 0.230 215.969 0.263
200912 0.380 215.949 0.434
201003 0.540 217.631 0.612
201006 0.580 217.965 0.657
201009 0.650 218.439 0.734
201012 0.580 219.179 0.653
201103 0.600 223.467 0.663
201106 0.560 225.722 0.612
201109 0.470 226.889 0.511
201112 0.470 225.672 0.514
201203 0.450 229.392 0.484
201206 0.470 229.478 0.506
201209 0.460 231.407 0.491
201212 0.380 229.601 0.408
201303 0.480 232.773 0.509
201306 0.560 233.504 0.592
201309 0.490 234.149 0.517
201312 0.610 233.049 0.646
201403 0.530 236.293 0.554
201406 0.620 238.343 0.642
201409 0.620 238.031 0.643
201412 0.620 234.812 0.652
201503 0.500 236.119 0.523
201506 0.550 238.638 0.569
201509 0.480 237.945 0.498
201512 0.490 236.525 0.511
201603 0.540 238.132 0.560
201606 0.610 241.018 0.625
201609 0.610 241.428 0.624
201612 0.520 241.432 0.532
201703 0.580 243.801 0.587
201706 0.630 244.955 0.635
201709 0.650 246.819 0.650

Add all the adjusted EPS together and divide 10 will get our 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.

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

Shiller PE Ratio=Share Price/E10
=71.81/2.12
=33.87

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

During the past 13 years, the highest Shiller P/E Ratio of Xilinx Inc was 40.47. The lowest was 17.00. And the median was 26.95.


Be Aware

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


Related Terms


Headlines

From the Internet

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)

GF Chat

{{numOfNotice}}
FEEDBACK