Edition:
United States

Rockwell Collins Inc (COL.N)

COL.N on New York Stock Exchange

132.27USD
17 Nov 2017
Change (% chg)

$-0.34 (-0.26%)
Prev Close
$132.61
Open
$132.30
Day's High
$132.45
Day's Low
$131.95
Volume
201,489
Avg. Vol
479,613
52-wk High
$136.49
52-wk Low
$87.29

Revenue & Earnings Per Share

    Revenue* Earnings Per Share**
FY 2017 Sep '17 2,193.00 1.294
Jun '17 2,094.00 1.119
Mar '17 1,342.00 1.269
Dec 1,193.00 1.099
FY 2016 Sep '16 1,445.00 1.582
Jun '16 1,334.00 1.627
Mar '16 1,311.00 1.300
Dec 1,169.00 1.002
FY 2015 Sep '15 1,384.00 1.382
Jun '15 1,293.00 1.332
Mar '15 1,341.00 1.219
Dec 1,226.00 1.257
 
*Note: Units in Millions ofU.S. Dollars
**Note: Units in U.S. Dollars

Consensus Estimates Analysis

  # of Estimates Mean High Low 1 Year Ago
SALES (in millions)
Quarter Ending Sep-17 17 2,227.94 2,299.00 2,175.00 --
Quarter Ending Dec-18 1 2,092.49 2,092.49 2,092.49 1,364.38
Year Ending Sep-17 19 6,853.41 6,928.00 6,777.00 --
Year Ending Sep-18 20 8,739.02 8,878.88 8,437.16 5,615.01
Year Ending Sep-19 16 9,119.99 9,405.00 8,579.87 5,722.55
Earnings (per share)
Quarter Ending Sep-17 19 1.80 1.92 1.71 --
Quarter Ending Dec-18 2 1.67 1.81 1.53 1.36
Year Ending Sep-17 14 6.11 6.15 6.00 --
Year Ending Sep-18 19 7.04 7.54 6.11 5.80
Year Ending Sep-19 15 7.71 8.50 5.41 6.12
LT Growth Rate (%) 5 12.21 14.00 10.00 4.59
Sales and Profit Figures in US Dollar (USD);

Valuation Ratios

  Company industry sector
P/E Ratio (TTM) 27.66 57.11 24.70
P/E High - Last 5 Yrs. 27.29 34.59 42.96
P/E Low - Last 5 Yrs. 14.86 12.19 14.04
Beta 0.73 1.19 0.95
Price to Sales (TTM) 3.16 6.20 9.91
Price to Book (MRQ) 3.57 15.54 2.98
Price to Tangible Book (MRQ) -- 2.55 3.43
Price to Cash Flow (TTM) 19.61 43.43 15.85
% Owned Institutions 74.97 21.00 1.39

Dividends

  Company industry sector
Dividend Yield 1.00 1.34 1.41
Dividend Yield - 5 Year Avg 1.42 1.68 1.49
Dividend 5 Year Growth Rate 4.10 17.42 6.69
Payout Ratio(TTM) 27.52 21.96 27.96

Growth Rates

  Company industry sector
Sales (MRQ) vs Qtr. 1 Yr. Ago 51.76 11.05 38.99
Sales (TTM) vs TTM 1 Yr. Ago 29.72 10.65 77.38
Sales - 5 Yr. Growth Rate 8.53 5.98 8.30
EPS (MRQ) vs Qtr. 1 Yr. Ago -18.19 149.14 77.96
EPS (TTM) vs TTM 1 Yr. Ago -13.23 -- --
EPS - 5 Yr. Growth Rate 3.60 9.89 11.12
Capital Spending - 5 Yr. Growth Rate 11.07 17.34 8.01

Financial Strength

  Company industry sector
Quick Ratio (MRQ) 0.75 0.53 1.81
Current Ratio (MRQ) 1.55 0.85 2.18
LT Debt to Equity (MRQ) 110.47 132.09 78.00
Total Debt to Equity (MRQ) 118.40 145.99 103.60
Interest Coverage (TTM) 16.79 100.49 55.12

Profitability Ratios

  Company industry sector
Gross Margin (TTM) 28.64 12.61 30.73
Gross Margin - 5 Yr. Avg. 30.12 32.35 30.13
EBITD Margin (TTM) 23.45 -- --
EBITD - 5 Yr. Avg 23.79 12.59 19.73
Operating Margin (TTM) 16.15 12.34 12.15
Operating Margin - 5 Yr. Avg. 18.32 6.59 14.69
Pre-Tax Margin (TTM) 13.65 13.52 13.53
Pre-Tax Margin - 5 Yr. Avg. 17.08 8.45 12.19
Net Profit Margin (TTM) 10.33 9.07 9.55
Net Profit Margin - 5 Yr. Avg. 12.60 5.45 8.56
Effective Tax Rate (TTM) 24.27 32.09 27.02
Effective Tax Rate - 5 Yr. Avg. 26.25 38.40 28.16

Efficiency

  Company industry sector
Revenue/Employee (TTM) 235,241 3,323,507 765,772,389
Net Income/Employee (TTM) 24,310 273,447 55,214,842
Receivable Turnover (TTM) 5.41 3.55 6.31
Inventory Turnover (TTM) 2.22 3.38 82.18
Asset Turnover (TTM) 0.53 0.45 0.68

Management Effectiveness

  Company industry sector
Return on Assets (TTM) 5.49 2.62 5.32
Return on Assets - 5 Yr. Avg. 8.62 5.51 4.18
Return on Investment (TTM) 6.96 5.14 7.40
Return on Investment - 5 Yr. Avg. 11.94 10.08 6.17
Return on Equity (TTM) 17.36 48.26 12.55
Return on Equity - 5 Yr. Avg. 30.38 22.42 10.86
  1 Year 3 Year 5 Year
Sales % 29.72 11.07 8.53
EPS (TTM) % -12.97 1.93 3.60
Dividend % 0.00 3.23 4.10
Note: Units in Millions of US Dollars

Performance for Rockwell Collins Inc

Period %
Actual
% vs.
S&P 500
Rank In
Industry
Industry
Rank
4 Week -2.02 -2.16 99 56
13 Week 6.22 -0.09 99 55
26 Week 28.86 19.01 99 58
52 Week 49.58 26.86 99 67
YTD 42.59 23.79 99 65
Note:: Rank is a percentile that ranges from 0 to 99, with 99 = best.

Institutional Holders

% Shares Owned: 74.64%
# of Holders: 887
Total Shares Held: 121,592,784
3 Mo. Net Change: -7,102,518
# New Positions: 128
# Closed Positions: 92
# Increased Positions: 352
# Reduced Positions: 384
# Net Buyers: -32
NYSE and AMEX quotes delayed by at least 20 minutes. NASDAQ delayed by at least 15 minutes. For a complete list of exchanges and delays, please click here.