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

Rockwell Collins (Rockwell Collins) Cyclically Adjusted PB Ratio : (As of May. 05, 2024)


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

What is Rockwell Collins Cyclically Adjusted PB Ratio?

Shiller PE for Stocks: The True Measure of Stock Valuation


Rockwell Collins Cyclically Adjusted PB Ratio Historical Data

The historical data trend for Rockwell Collins's Cyclically Adjusted PB 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 Cyclically Adjusted PB Ratio Chart

Rockwell Collins Annual Data
Trend Sep09 Sep10 Sep11 Sep12 Sep13 Sep14 Sep15 Sep16 Sep17 Sep18
Cyclically Adjusted PB Ratio
Get a 7-Day Free Trial Premium Member Only Premium Member Only - - - - -

Rockwell Collins Quarterly Data
Dec13 Mar14 Jun14 Sep14 Dec14 Mar15 Jun15 Sep15 Dec15 Mar16 Jun16 Sep16 Dec16 Mar17 Jun17 Sep17 Dec17 Mar18 Jun18 Sep18
Cyclically Adjusted PB 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 - - - - -

Competitive Comparison of Rockwell Collins's Cyclically Adjusted PB Ratio

For the Aerospace & Defense subindustry, Rockwell Collins's Cyclically Adjusted PB Ratio, along with its competitors' market caps and Cyclically Adjusted PB 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 Cyclically Adjusted PB Ratio Distribution in the Aerospace & Defense Industry

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

* The bar in red indicates where Rockwell Collins's Cyclically Adjusted PB Ratio falls into.



Rockwell Collins Cyclically Adjusted PB Ratio Calculation

Like the Shiller PE Ratio, the Cyclically Adjusted PB Ratio takes the Book Value per Share from the past 10 years, adjusts it for inflation, and then calculates the average. This average is then used for the P/B calculation. Because it considers this 10-year average, it's often referred to as the CAPB Ratio.

The Shiller PE Ratio was first used by professor Robert Shiller to measure the valuation of the overall market. The similar calculation is applied by GuruFocus to calculate the Cyclically Adjusted PB Ratio.

Rockwell Collins's Cyclically Adjusted Book per Share for the quarter that ended in Sep. 2018 is calculated as:

For example, Rockwell Collins's adjusted Book Value per Share data for the three months ended in Sep. 2018 was:

Adj_Book=Book Value per Share/CPI of Sep. 2018 (Change)*Current CPI (Sep. 2018)
=43.204/106.5067*106.5067
=43.204

Current CPI (Sep. 2018) = 106.5067.

Rockwell Collins Quarterly Data

Book Value per Share CPI Adj_Book
200812 9.405 88.697 11.293
200903 10.298 89.744 12.221
200906 10.989 91.003 12.861
200909 8.224 91.120 9.613
200912 8.779 91.111 10.262
201003 9.479 91.821 10.995
201006 10.025 91.962 11.611
201009 9.452 92.162 10.923
201012 9.541 92.474 10.989
201103 10.201 94.283 11.524
201106 10.839 95.235 12.122
201109 9.935 95.727 11.054
201112 8.569 95.213 9.585
201203 9.134 96.783 10.052
201206 8.958 96.819 9.854
201209 8.854 97.633 9.659
201212 7.690 96.871 8.455
201303 8.241 98.209 8.937
201306 8.891 98.518 9.612
201309 11.976 98.790 12.911
201312 12.749 98.326 13.810
201403 13.631 99.695 14.562
201406 14.412 100.560 15.264
201409 14.060 100.428 14.911
201412 14.068 99.070 15.124
201503 14.728 99.621 15.746
201506 15.546 100.684 16.445
201509 14.215 100.392 15.081
201512 14.474 99.792 15.448
201603 15.207 100.470 16.121
201606 16.228 101.688 16.997
201609 15.960 101.861 16.688
201612 16.835 101.863 17.603
201703 18.262 102.862 18.909
201706 34.501 103.349 35.555
201709 37.096 104.136 37.941
201712 38.768 104.011 39.698
201803 40.396 105.290 40.863
201806 41.333 106.317 41.407
201809 43.204 106.507 43.204

Add all the adjusted book value per share together and divide the count will get our Cyclically Adjusted Book per Share.

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) Cyclically Adjusted PB Ratio Explanation

Compared with the regular PB Ratio, which works poorly for cyclical businesses, the Cyclically Adjusted PB Ratio smoothed out the fluctuations of book value during business cycles. Therefore it is more accurate in reflecting the valuation of the company.

If a company has consistent business performance, the Cyclically Adjusted PB Ratio should give similar results to regular PB Ratio.


Rockwell Collins Cyclically Adjusted PB Ratio Related Terms

Thank you for viewing the detailed overview of Rockwell Collins's Cyclically Adjusted PB 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