NYSE:COL (USA) Also trade in: Germany

Rockwell Collins Inc

$ 141.04 0 (0%)
Volume: 0 Avg Vol (1m): 0
Market Cap $: 23.18 Bil Enterprise Value $: 30.38 Bil
P/E (TTM): 22.68 P/B: 3.26
Earnings Power Value 15.58
Net Current Asset Value -37.33
Tangible Book -25.48
Projected FCF 66.36
Median P/S Value 111.31
Graham Number 0
Peter Lynch Value 49.45
DCF (FCF Based) -36.59
DCF (Earnings Based) 66.56
1Y (-%)

Financial Strength : 5/10

GuruFocus Financial Strength Rank measures how strong a company's financial situation is . It is based on these factors
1. The debt burden that the company has as measured by its Interest coverage (current year).
2. Debt to revenue ratio. The lower, the better
3. Altman Z-score.
A company ranks high with financial strength is likely to withstand any business slowdowns and recessions.
Current vs industry vs history
Cash-to-Debt 0.09
Cash-To-Debt ranked lower than
86.63% of 202 companies
in the Aerospace & Defense industry.
Industry Max: 31692.43, Med: 0.53, Min: -0.55
COL: 0.09
Ranked among companies with meaningful Cash-To-Debt only.
Cash-To-Debt range over the past 10 years
Min: 0.09, Med: 0.43, Max: 10000
Current: 0.09
0.09
10000
Equity-to-Asset 0.37
Equity-to-Asset ranked lower than
60.89% of 202 companies
in the Aerospace & Defense industry.
Industry Max: 0.98, Med: 0.44, Min: -20.15
COL: 0.37
Ranked among companies with meaningful Equity-to-Asset only.
Equity-to-Asset range over the past 10 years
Min: 0.24, Med: 0.32, Max: 0.43
Current: 0.37
0.24
0.43
Debt-to-Equity 1.12
Debt-to-Equity ranked lower than
82.93% of 164 companies
in the Aerospace & Defense industry.
Industry Max: 31.32, Med: 0.5, Min: 0.01
COL: 1.12
Ranked among companies with meaningful Debt-to-Equity only.
Debt-to-Equity range over the past 10 years
Min: 0.05, Med: 0.37, Max: 1.18
Current: 1.12
0.05
1.18
Debt-to-EBITDA 4.04
Debt-to-EBITDA ranked lower than
65.79% of 152 companies
in the Aerospace & Defense industry.
Industry Max: 897.49, Med: 2.54, Min: 0.01
COL: 4.04
Ranked among companies with meaningful Debt-to-EBITDA only.
Debt-to-EBITDA range over the past 10 years
Min: 0.51, Med: 1.3, Max: 4.73
Current: 4.04
0.51
4.73
Interest Coverage 5.60
Interest Coverage ranked lower than
74.21% of 159 companies
in the Aerospace & Defense industry.
Industry Max: 10000, Med: 12.39, Min: 0.03
COL: 5.6
Ranked among companies with meaningful Interest Coverage only.
Interest Coverage range over the past 10 years
Min: 5.6, Med: 23.69, Max: 47.89
Current: 5.6
5.6
47.89
Piotroski F-Score 2
0
1
2
3
4
5
6
7
8
9
Altman Z-Score 2.27
DISTRESS
GREY
SAFE
Beneish M-Score -1.66
Not Manipulator
Manipulator

Profitability & Growth : 6/10

GuruFocus Profitability Rank ranks how profitable a company is and how likely the company's business will stay that way.
Current vs industry vs history
Operating Margin % 16.92
Operating Margin ranked higher than
85.22% of 203 companies
in the Aerospace & Defense industry.
Industry Max: 106.77, Med: 5.39, Min: -47817.23
COL: 16.92
Ranked among companies with meaningful Operating Margin only.
Operating Margin range over the past 10 years
Min: 16.92, Med: 18.39, Max: 19.58
Current: 16.92
16.92
19.58
Net Margin % 11.91
Net Margin ranked higher than
81.28% of 203 companies
in the Aerospace & Defense industry.
Industry Max: 409.5, Med: 3.92, Min: -47694.39
COL: 11.91
Ranked among companies with meaningful Net Margin only.
Net Margin range over the past 10 years
Min: 10.33, Med: 13.14, Max: 14.13
Current: 11.91
10.33
14.13
ROE % 15.67
ROE ranked higher than
81.38% of 188 companies
in the Aerospace & Defense industry.
Industry Max: 12960.44, Med: 7.18, Min: -221.93
COL: 15.67
Ranked among companies with meaningful ROE only.
ROE range over the past 10 years
Min: 15.67, Med: 38.64, Max: 44
Current: 15.67
15.67
44
ROA % 5.62
ROA ranked higher than
71.57% of 204 companies
in the Aerospace & Defense industry.
Industry Max: 25.4, Med: 2.78, Min: -550
COL: 5.62
Ranked among companies with meaningful ROA only.
ROA range over the past 10 years
Min: 5.49, Med: 10.54, Max: 13.52
Current: 5.62
5.49
13.52
ROC (Joel Greenblatt) % 45.88
ROC (Joel Greenblatt) ranked higher than
83.17% of 202 companies
in the Aerospace & Defense industry.
Industry Max: 257.9, Med: 10.11, Min: -4842.58
COL: 45.88
Ranked among companies with meaningful ROC (Joel Greenblatt) only.
ROC (Joel Greenblatt) range over the past 10 years
Min: 45.88, Med: 59.04, Max: 65.25
Current: 45.88
45.88
65.25
3-Year Total Revenue Growth Rate 18.20
3-Year Revenue Growth Rate ranked higher than
71.82% of 181 companies
in the Aerospace & Defense industry.
Industry Max: 158.5, Med: 4.3, Min: -100
COL: 10
Ranked among companies with meaningful 3-Year Revenue Growth Rate only.
3-Year Revenue Growth Rate range over the past 10 years
Min: 1.1, Med: 7.65, Max: 16.9
Current: 10
1.1
16.9
3-Year Total EBITDA Growth Rate 15.50
3-Year EBITDA Growth Rate ranked higher than
54.55% of 154 companies
in the Aerospace & Defense industry.
Industry Max: 211.7, Med: 5.6, Min: -88.1
COL: 7.5
Ranked among companies with meaningful 3-Year EBITDA Growth Rate only.
3-Year EBITDA Growth Rate range over the past 10 years
Min: -0.9, Med: 8.35, Max: 23.6
Current: 7.5
-0.9
23.6
3-Year EPS w/o NRI Growth Rate 6.20
3-Year EPS w/o NRI Growth Rate ranked lower than
58.09% of 136 companies
in the Aerospace & Defense industry.
Industry Max: 200, Med: 7.7, Min: -150.7
COL: 6.2
Ranked among companies with meaningful 3-Year EPS w/o NRI Growth Rate only.
3-Year EPS w/o NRI Growth Rate range over the past 10 years
Min: 0, Med: 7.7, Max: 30.2
Current: 6.2
0
30.2

» COL's 30-Y Financials

Financials (Next Earnings Date: 2019-07-27 Est.)

Guru Trades Click for details

» Details

Insider Trades

SEC Filings

Gurus Latest Trades with NYSE:COL

» Interactive Chart

Peter Lynch Chart

Business Description

Industry Aerospace & Defense » Aerospace & Defense    NAICS : 336413    SIC : 3728
Compare LSE:RR. NYSE:TDG LSE:BA. XPAR:HO SHSE:601989 NYSE:LLL NYSE:HEI.A XPAR:AM NYSE:TXT XTER:MTX NYSE:SPR NYSE:HII SGX:S63 SHSE:600893 MIL:LDO SZSE:000768 NAS:WWD SHSE:600760 TSX:CAE NYSE:HXL
Traded in other countries RWC.Germany
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.

Ratios

Current vs industry vs history
PE Ratio (TTM) 22.68
PE Ratio ranked lower than
52.52% of 139 companies
in the Aerospace & Defense industry.
Industry Max: 1095.24, Med: 24.7, Min: 0.05
COL: 22.68
Ranked among companies with meaningful PE Ratio only.
PE Ratio range over the past 10 years
Min: 6.78, Med: 16.39, Max: 28.32
Current: 22.68
6.78
28.32
Forward PE Ratio 18.73
Forward P/E ranked lower than
50.85% of 59 companies
in the Aerospace & Defense industry.
Industry Max: 58.14, Med: 19.8, Min: 5.98
COL: 18.73
Ranked among companies with meaningful Forward P/E only.
N/A
PE Ratio without NRI 22.68
PE without NRI ranked lower than
52.52% of 139 companies
in the Aerospace & Defense industry.
Industry Max: 1095.24, Med: 24.7, Min: 0.05
COL: 22.68
Ranked among companies with meaningful PE without NRI only.
PE without NRI range over the past 10 years
Min: 6.78, Med: 16.4, Max: 28.32
Current: 22.68
6.78
28.32
PB Ratio 3.26
PB Ratio ranked lower than
73.26% of 187 companies
in the Aerospace & Defense industry.
Industry Max: 589.88, Med: 2.22, Min: 0.15
COL: 3.26
Ranked among companies with meaningful PB Ratio only.
PB Ratio range over the past 10 years
Min: 2.75, Med: 5.68, Max: 8.37
Current: 3.26
2.75
8.37
PS Ratio 2.70
PS Ratio ranked lower than
74.61% of 193 companies
in the Aerospace & Defense industry.
Industry Max: 2500, Med: 1.43, Min: 0.01
COL: 2.7
Ranked among companies with meaningful PS Ratio only.
PS Ratio range over the past 10 years
Min: 0.97, Med: 2.13, Max: 2.98
Current: 2.7
0.97
2.98
EV-to-EBIT 22.11
EV-to-EBIT ranked lower than
61.29% of 155 companies
in the Aerospace & Defense industry.
Industry Max: 370.68, Med: 19.18, Min: 0.11
COL: 22.11
Ranked among companies with meaningful EV-to-EBIT only.
EV-to-EBIT range over the past 10 years
Min: 5.1, Med: 12.55, Max: 25.8
Current: 22.11
5.1
25.8
EV-to-EBITDA 15.47
EV-to-EBITDA ranked lower than
62.28% of 167 companies
in the Aerospace & Defense industry.
Industry Max: 1225.68, Med: 13.86, Min: 0.11
COL: 15.47
Ranked among companies with meaningful EV-to-EBITDA only.
EV-to-EBITDA range over the past 10 years
Min: 4.5, Med: 10.3, Max: 19.8
Current: 15.47
4.5
19.8
EV-to-Revenue 3.51
EV-to-Revenue ranked lower than
79.00% of 200 companies
in the Aerospace & Defense industry.
Industry Max: 2445, Med: 1.7, Min: 0.02
COL: 3.51
Ranked among companies with meaningful EV-to-Revenue only.
EV-to-Revenue range over the past 10 years
Min: 1.1, Med: 2.3, Max: 4.6
Current: 3.51
1.1
4.6
PEG Ratio 2.87
PEG Ratio ranked lower than
59.02% of 61 companies
in the Aerospace & Defense industry.
Industry Max: 159.5, Med: 2.47, Min: 0.39
COL: 2.87
Ranked among companies with meaningful PEG Ratio only.
PEG Ratio range over the past 10 years
Min: 0.32, Med: 2.31, Max: 10.03
Current: 2.87
0.32
10.03
Shiller PE Ratio 28.28
Shiller PE Ratio ranked higher than
64.04% of 89 companies
in the Aerospace & Defense industry.
Industry Max: 464, Med: 33.61, Min: 5.43
COL: 28.28
Ranked among companies with meaningful Shiller PE Ratio only.
Shiller PE Ratio range over the past 10 years
Min: 14.44, Med: 20.21, Max: 29.22
Current: 28.28
14.44
29.22
Current Ratio 1.23
Current Ratio ranked lower than
53.54% of 198 companies
in the Aerospace & Defense industry.
Industry Max: 40.67, Med: 1.62, Min: 0.01
COL: 1.23
Ranked among companies with meaningful Current Ratio only.
Current Ratio range over the past 10 years
Min: 1.23, Med: 1.55, Max: 1.94
Current: 1.23
1.23
1.94
Quick Ratio 0.67
Quick Ratio ranked lower than
79.19% of 197 companies
in the Aerospace & Defense industry.
Industry Max: 40.67, Med: 1.15, Min: 0.01
COL: 0.67
Ranked among companies with meaningful Quick Ratio only.
Quick Ratio range over the past 10 years
Min: 0.66, Med: 0.84, Max: 1.16
Current: 0.67
0.66
1.16
Days Inventory 147.91
Days Inventory ranked lower than
59.57% of 188 companies
in the Aerospace & Defense industry.
Industry Max: 829.75, Med: 128.86, Min: 1
COL: 147.91
Ranked among companies with meaningful Days Inventory only.
Days Inventory range over the past 10 years
Min: 105.97, Med: 155.21, Max: 188.56
Current: 147.91
105.97
188.56
Days Sales Outstanding 63.73
Days Sales Outstanding ranked lower than
55.03% of 169 companies
in the Aerospace & Defense industry.
Industry Max: 781.43, Med: 66.94, Min: 1
COL: 63.73
Ranked among companies with meaningful Days Sales Outstanding only.
Days Sales Outstanding range over the past 10 years
Min: 40.17, Med: 49.91, Max: 80.71
Current: 63.73
40.17
80.71
Days Payable 46.95
Days Payable ranked lower than
56.41% of 156 companies
in the Aerospace & Defense industry.
Industry Max: 841.1, Med: 59.17, Min: -334.28
COL: 46.95
Ranked among companies with meaningful Days Payable only.
Days Payable range over the past 10 years
Min: 42.41, Med: 52.24, Max: 69.51
Current: 46.95
42.41
69.51

Dividend & Buy Back

Current vs industry vs history
Dividend Yield % 0.94
Trailing Dividend Yield ranked lower than
62.20% of 254 companies
in the Aerospace & Defense industry.
Industry Max: 28.33, Med: 1.27, Min: 0.06
COL: 0.94
Ranked among companies with meaningful Trailing Dividend Yield only.
Trailing Dividend Yield range over the past 10 years
Min: 0.93, Med: 1.56, Max: 3.39
Current: 0.94
0.93
3.39
Dividend Payout Ratio 0.22
Dividend Payout Ratio ranked higher than
71.87% of 128 companies
in the Aerospace & Defense industry.
Industry Max: 2.09, Med: 0.28, Min: 0.02
COL: 0.22
Ranked among companies with meaningful Dividend Payout Ratio only.
Dividend Payout Ratio range over the past 10 years
Min: 0.21, Med: 0.26, Max: 0.28
Current: 0.22
0.21
0.28
3-Year Dividend Growth Rate (Per Share) 1.60
3-Year Dividend Growth Rate ranked lower than
53.41% of 88 companies
in the Aerospace & Defense industry.
Industry Max: 163, Med: 4.1, Min: -100
COL: 1.6
Ranked among companies with meaningful 3-Year Dividend Growth Rate only.
3-Year Dividend Growth Rate range over the past 10 years
Min: 0, Med: 7.7, Max: 63
Current: 1.6
0
63
Forward Dividend Yield % 0.94
Forward Dividend Yield ranked lower than
75.83% of 240 companies
in the Aerospace & Defense industry.
Industry Max: 45.57, Med: 1.49, Min: 0.06
COL: 0.94
Ranked among companies with meaningful Forward Dividend Yield only.
N/A
Yield-on-Cost (5-Year) % 1.05
Yield-on-Cost (5y) ranked lower than
68.20% of 327 companies
in the Aerospace & Defense industry.
Industry Max: 987.24, Med: 2.07, Min: 0.04
COL: 1.05
Ranked among companies with meaningful Yield-on-Cost (5y) only.
Yield-on-Cost (5y) range over the past 10 years
Min: 1.04, Med: 1.75, Max: 3.8
Current: 1.05
1.04
3.8
3-Year Share Buyback Rate -7.60
3-Year Share Buyback Rate ranked lower than
62.60% of 131 companies
in the Aerospace & Defense industry.
Industry Max: 6.8, Med: -3.1, Min: -900
COL: -7.6
Ranked among companies with meaningful 3-Year Share Buyback Rate only.
3-Year Share Buyback Rate range over the past 10 years
Min: -7.6, Med: 1.9, Max: 4.8
Current: -7.6
-7.6
4.8

Valuation & Return

Current vs industry vs history
Price-to-Projected-FCF 2.13
Price-to-Intrinsic-Value-Projected-FCF ranked lower than
54.72% of 106 companies
in the Aerospace & Defense industry.
Industry Max: 51.27, Med: 1.84, Min: 0.02
COL: 2.13
Ranked among companies with meaningful Price-to-Intrinsic-Value-Projected-FCF only.
Price-to-Intrinsic-Value-Projected-FCF range over the past 10 years
Min: 1.08, Med: 1.5, Max: 2.13
Current: 2.13
1.08
2.13
Price-to-DCF (Earnings Based) 2.12
Price-to-Intrinsic-Value-DCF (Earnings Based) ranked lower than
58.06% of 31 companies
in the Aerospace & Defense industry.
Industry Max: 22.77, Med: 2.32, Min: 0.77
COL: 2.12
Ranked among companies with meaningful Price-to-Intrinsic-Value-DCF (Earnings Based) only.
Price-to-Intrinsic-Value-DCF (Earnings Based) range over the past 10 years
Min: 0.57, Med: 1.32, Max: 2.53
Current: 2.12
0.57
2.53
Price-to-Median-PS-Value 1.27
Price-to-Median-PS-Value ranked lower than
58.64% of 162 companies
in the Aerospace & Defense industry.
Industry Max: 22.18, Med: 1.08, Min: 0.16
COL: 1.27
Ranked among companies with meaningful Price-to-Median-PS-Value only.
Price-to-Median-PS-Value range over the past 10 years
Min: 0.76, Med: 0.98, Max: 1.34
Current: 1.27
0.76
1.34
Price-to-Peter-Lynch-Fair-Value 2.85
Price-to-Peter-Lynch-Fair-Value ranked lower than
65.91% of 44 companies
in the Aerospace & Defense industry.
Industry Max: 46.49, Med: 2, Min: 0.06
COL: 2.85
Ranked among companies with meaningful Price-to-Peter-Lynch-Fair-Value only.
Price-to-Peter-Lynch-Fair-Value range over the past 10 years
Min: 0.54, Med: 1.73, Max: 3.41
Current: 2.85
0.54
3.41
Earnings Yield (Joel Greenblatt) % 4.52
Earnings Yield (Greenblatt) ranked higher than
53.43% of 204 companies
in the Aerospace & Defense industry.
Industry Max: 909.09, Med: 3.57, Min: -10000
COL: 4.52
Ranked among companies with meaningful Earnings Yield (Greenblatt) only.
Earnings Yield (Greenblatt) range over the past 10 years
Min: 3.9, Med: 8, Max: 19.6
Current: 4.52
3.9
19.6
Forward Rate of Return (Yacktman) % 10.14
Forward Rate of Return ranked higher than
64.17% of 120 companies
in the Aerospace & Defense industry.
Industry Max: 779.19, Med: 5.58, Min: -2702.52
COL: 10.14
Ranked among companies with meaningful Forward Rate of Return only.
Forward Rate of Return range over the past 10 years
Min: 6.1, Med: 11.6, Max: 28.8
Current: 10.14
6.1
28.8

More Statistics

Revenue (TTM) (Mil) $ 8,665
EPS (TTM) $ 6.22
Beta 0
Volatility % 12.59
52-Week Range $ 125.04 - 142.98
Shares Outstanding (Mil) 164.63

Analyst Estimate

Piotroski F-Score Details

Piotroski F-Score 2
Positive ROA Y
Positive CFROA N
Higher ROA yoy N
CFROA > ROA N
Lower Leverage yoy Y
Higher Current Ratio yoy N
Less Shares Outstanding yoy N
Higher Gross Margin yoy N
Higher Asset Turnover yoy N