GURUFOCUS.COM » STOCK LIST » Industrials » Aerospace & Defense » Rockwell Collins Inc (NYSE:COL) » Definitions » Shiller PE Ratio

Rockwell Collins (Rockwell Collins) Shiller PE Ratio : 28.15 (As of Apr. 26, 2024)


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

What is Rockwell Collins Shiller PE Ratio?

As of today (2024-04-26), Rockwell Collins's current share price is $141.04. Rockwell Collins's E10 for the quarter that ended in Sep. 2018 was $5.01. Rockwell Collins's Shiller PE Ratio for today is 28.15.

The historical rank and industry rank for Rockwell Collins's Shiller PE Ratio or its related term are showing as below:

COL's Shiller PE Ratio is not ranked *
in the Aerospace & Defense industry.
Industry Median: 38.13
* Ranked among companies with meaningful Shiller PE Ratio only.

E10 is a concept invented by Prof. Robert Shiller, who uses E10 for his Shiller PE Ratio calculation. E10 is the average of the inflation adjusted earnings of a company over the past 10 years.

Rockwell Collins's adjusted earnings per share data for the three months ended in Sep. 2018 was $1.440. Add all the adjusted EPS for the past 10 years together and divide 10 will get our E10, which is $5.01 for the trailing ten years ended in Sep. 2018.

Shiller PE for Stocks: The True Measure of Stock Valuation


Rockwell Collins Shiller PE Ratio Historical Data

The historical data trend for Rockwell Collins's Shiller PE Ratio 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.

Rockwell Collins Shiller PE Ratio Chart

Rockwell Collins Annual Data
Trend Sep09 Sep10 Sep11 Sep12 Sep13 Sep14 Sep15 Sep16 Sep17 Sep18
Shiller PE Ratio
Get a 7-Day Free Trial Premium Member Only Premium Member Only 19.54 19.21 18.46 27.52 28.03

Rockwell Collins Quarterly Data
Dec13 Mar14 Jun14 Sep14 Dec14 Mar15 Jun15 Sep15 Dec15 Mar16 Jun16 Sep16 Dec16 Mar17 Jun17 Sep17 Dec17 Mar18 Jun18 Sep18
Shiller PE Ratio 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 27.52 28.32 27.76 27.22 28.03

Competitive Comparison of Rockwell Collins's Shiller PE Ratio

For the Aerospace & Defense subindustry, Rockwell Collins'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.


Rockwell Collins's Shiller PE Ratio Distribution in the Aerospace & Defense Industry

For the Aerospace & Defense industry and Industrials sector, Rockwell Collins's Shiller PE Ratio distribution charts can be found below:

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



Rockwell Collins Shiller PE Ratio Calculation

For Shiller PE Ratio, 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 PE Ratio is also called PE10.

The Shiller PE Ratio was first used by professor Robert Shiller to measure the valuation of the overall market. The same calculation is applied here to individual companies.

Rockwell Collins's Shiller PE Ratio for today is calculated as

Shiller PE Ratio=Share Price/ E10
=141.04/5.01
=28.15

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

Rockwell Collins's E10 for the quarter that ended in Sep. 2018 is calculated as:

For example, Rockwell Collins'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)
=1.44/106.5067*106.5067
=1.440

Current CPI (Sep. 2018) = 106.5067.

Rockwell Collins Quarterly Data

Earnings per Share (Diluted) CPI Adj_EPS
200812 0.950 88.697 1.141
200903 1.030 89.744 1.222
200906 0.910 91.003 1.065
200909 0.840 91.120 0.982
200912 0.760 91.111 0.888
201003 0.930 91.821 1.079
201006 0.890 91.962 1.031
201009 0.940 92.162 1.086
201012 0.960 92.474 1.106
201103 0.960 94.283 1.084
201106 1.010 95.235 1.130
201109 1.130 95.727 1.257
201112 0.860 95.213 0.962
201203 1.090 96.783 1.200
201206 1.140 96.819 1.254
201209 1.060 97.633 1.156
201212 0.940 96.871 1.034
201303 1.170 98.209 1.269
201306 1.200 98.518 1.297
201309 1.280 98.790 1.380
201312 0.960 98.326 1.040
201403 1.080 99.695 1.154
201406 1.150 100.560 1.218
201409 1.230 100.428 1.304
201412 1.240 99.070 1.333
201503 1.170 99.621 1.251
201506 1.330 100.684 1.407
201509 1.380 100.392 1.464
201512 1.020 99.792 1.089
201603 1.290 100.470 1.368
201606 1.630 101.688 1.707
201609 1.580 101.861 1.652
201612 1.100 101.863 1.150
201703 1.270 102.862 1.315
201706 1.120 103.349 1.154
201709 1.310 104.136 1.340
201712 1.690 104.011 1.731
201803 1.430 105.290 1.447
201806 1.660 106.317 1.663
201809 1.440 106.507 1.440

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


Rockwell Collins  (NYSE:COL) Shiller PE Ratio Explanation

Compared with the regular PE Ratio, which works poorly for cyclical businesses, the Shiller PE Ratio 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 PE Ratio should give similar results to regular PE Ratio.

Compared with the PS Ratio, the Shiller PE Ratio makes the comparison between different industries more meaningful.


Be Aware

Shiller PE Ratio 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, Shiller PE Ratio and PS Ratio will give false valuations.


Rockwell Collins Shiller PE Ratio Related Terms

Thank you for viewing the detailed overview of Rockwell Collins's Shiller PE Ratio provided by GuruFocus.com. Please click on the following links to see related term pages.


Rockwell Collins (Rockwell Collins) Business Description

Traded in Other Exchanges
N/A
Address
Rockwell Collins Inc develops communications and aviation electronics for commercial and military customers worldwide. It employs over 20,000 people. Competencies include communications, navigation, automated flight control, displays, simulation and training, integrated electronics, and information systems. The firm sells to governments, airlines, and aircraft manufacturers, while providing aftermarket services for many of its products. The company recently closed its acquisition of B/E Aerospace, an aircraft seat and cabin manufacturer.
Executives
John A Edwardson director P O BOX 66100-WHQLD, CHICAGO IL 60666
Robert Kelly Ortberg director, officer: Chairman, Pres & CEO 870 WINTER STREET, WALTHAM MA 02451
Patrick E Allen officer: Sr. VP and CFO 400 COLLINS ROAD NE, CEDAR RAPIDS IA 52498
David Lilley director
Ralph E Eberhart director 909 N. WASHINGTON STREET, ALEXANDRIA VA 22314
Richard Hamermesh director C/O BE AEROSPACE, INC., 1400 CORPORATE CENTER WAY, WELLINGTON FL 33414
Jeffrey L Turner director SPIRIT AEROSYSTEMS HOLDINGS, INC., 3801 SOUTH OLIVER, WICHITA KS 67210
Cheryl L Shavers director 400 COLLINS ROAD NE, M/S 124-323, CEDAR RAPIDS IA 52498
Andrew J Policano director
Robert J Perna officer: Sr. VP, Gnrl Counsel & Secy 1151 MAPLEWOOD DRIVE, ITASCA IL 60143
John T Whates director 1400 CORPORATE CENTER WAY, WELLINGTON FL 33414
Besong John Paul E officer: Sr. VP, eBusiness 400 COLLINS ROAD NE M/S 124-003, CEDAR RAPIDS IA 52498001
Clayton M Jones director 400 COLLINS ROAD NE, CEDAR RAPIDS IA 52498
Donald R Beall director 5 SAN JOAQUIN PLAZA, SUITE 320, NEWPORT BEACH CA 92660
Toot Joseph F Jr director 400 COLLINS ROAD NE, M/S 124-323, CEDAR RAPIDS IA 52498

Rockwell Collins (Rockwell Collins) Headlines

From GuruFocus

Rockwell Collins Inc. (COL) Sr. VP and CFO Patrick E Allen sells 19,000 Shares

By GuruFocus Research GuruFocus Editor 04-30-2010

Insider Sells Shares of Rockwell Collins

By Kyle Ferguson Kyle Ferguson 05-01-2017

Rockwell Collins Inc: Fundamental Stock Research Analysis

By FAST Graphs FAST Graphs 05-21-2013

Westport Funds Portfolio Review as of Dec. 31, 2013

By Holly LaFon Holly LaFon 03-26-2014

5 Companies Hit 52-Week Highs

By yifan900 yifan900 12-04-2018