10 Year Financial Data of Rockwell Collins, Inc. (COL)

66.05 (1y: +30%)

Market Cap	8.94 B	P/E(ttm)	15.30
Enterprise Value	9.76 B	P/B	7.20

COL- NYSE (USA)
Rockwell Collins, Inc.

Currently 1/5

Business Predictability Rank: 1-Star (On Watch)
Back Testing Results:
Average gain of all 1-Star stocks: 1.1% per year.
% of Stocks that are in still loss if held for 10yrs: 45%.
Read more:
What is Predictability Rank?
Performances of real portfolio
Top Ranked Predictable Companies

$66.05

3 Severe Warning Signs 5 Medium Warning Signs

Bookmark

Annual Rates (per share)	10 yrs*	5 yrs*	12 months*
Revenue Growth (%)	9.4	2.9	5.7
EBITDA Growth (%)	16.2	-17.9	-39.5
Free Cash Flow Growth (%)	7.1	0.4	38.5
Book Value Growth (%)	7.5	1.7	-9.7

*12-month growth rate is calculated with the per share revenue (EBITDA, FCF, earnings) of the last 12 months over the per share revenue (EBITDA, FCF, earnings) over the previous 12 months. 5-year and 10-year growth rates are calculated with least-square regression based on the 5-year and 10-year numbers.

Trendline:

Export:

Print This Table Print

See this page for the explanation of the data and charts * All numbers are in millions except for per share data

Per Share Data	Annuals											Quarterly
Fiscal Period	Sep03	Sep04	Sep05	Sep06	Sep07	Sep08	Sep09	Sep10	Sep11	Sep12	TTM	Mar12	Jun12	Sep12	Dec12	Mar13

Revenue per Share ($)	14.11	16.28	19.12	22.14	26.02	29.28	28.04	29.30	30.79	32.19	32.89	7.87	8.31	8.82	7.55	8.21
EBITDA per Share	2.44	2.99	3.66	4.45	5.65	6.62	51.58	6.01	6.32	7.04	7.24	7.14	1.82	1.99	1.64	1.79
Free Cashflow per Share	1.68	1.64	2.53	2.58	2.79	2.71	3.00	3.74	3.21	2.67	3.74	0.56	0.78	2.12	0.16	0.68
Earnings per Share ($)	1.43	1.67	2.20	2.73	3.45	4.16	3.73	3.52	4.06	4.15	4.31	1.09	1.14	1.06	0.94	1.17
Dividends Per Share	0.36	0.39	0.48	0.56	0.64	0.80	0.96	0.96	0.96	1.08	1.50	0.24	0.30	0.30	0.60	0.30
Book Value per Share	4.63	6.29	5.21	6.91	9.27	8.64	8.11	9.31	9.76	8.58	8.13	9.00	8.78	8.77	7.48	8.13
Month End Stock Price	25.25	37.14	48.32	54.84	73.04	48.09	50.80	58.25	52.76	53.64	63.12	57.56	49.35	53.64	58.17	63.12
Ratios	Annuals											Quarterly
Fiscal Period	Sep03	Sep04	Sep05	Sep06	Sep07	Sep08	Sep09	Sep10	Sep11	Sep12	Latest Q.	Mar12	Jun12	Sep12	Dec12	Mar13

Return on Equity %	31.00	26.60	42.20	39.60	37.20	48.20	46.00	37.90	41.60	48.40	57.60	48.40	52.00	48.40	50.00	57.60
Return on Assets %	10.00	10.50	12.60	14.60	15.60	16.40	12.80	11.10	11.80	11.50	12.00	12.40	12.80	11.60	10.00	12.00
Return on Capital - Joel Greenblatt %	37.10	46.70	58.40	66.30	77.40	68.30	543	52.70	52.30	48.10	42.00	219	46.40	49.60	40.40	42.00
Debt to Equity	0.05	0.18	0.21	0.20	0.14	0.37	0.41	0.37	0.35	0.62	1.03	0.66	0.77	0.62	1.07	1.03

Gross Margin %	26.60	26.80	27.40	28.80	30.00	30.10	29.50	27.60	28.70	29.70	28.90	30.20	29.80	29.40	29.40	28.90
Operating Margin %	13.20	14.70	15.70	17.30	19.00	19.90	181	17.30	17.60	18.20	17.80	87.60	18.80	17.50	17.70	17.80
Net Margin %	10.10	10.30	11.50	12.30	13.30	14.20	13.30	12.00	13.20	12.90	14.20	13.90	13.80	12.00	12.40	14.20

Days Sales Outstanding	77.80	78.00	77.60	77.60	73.00	72.70	74.60	80.10	73.60	75.00	76.80	70.40	73.00	69.80	77.60	76.80
Days Inventory	121	111	99.90	96.40	97.20	106	109	109	127	146	163	153	146	136	170	163
Inventory Turnover	3.00	3.30	3.70	3.80	3.80	3.40	3.30	3.40	2.90	2.50	0.60	0.60	0.60	0.70	0.50	0.60

Debt to Revenue	0.02	0.07	0.06	0.06	0.05	0.11	0.12	0.12	0.11	0.17	1.02	0.75	0.81	0.62	1.06	1.02
COGS to Revenue	0.73	0.73	0.73	0.71	0.70	0.70	0.70	0.72	0.71	0.70	0.71	0.70	0.70	0.71	0.71	0.71
Inventory to Revenue	0.24	0.22	0.20	0.19	0.19	0.20	0.21	0.22	0.25	0.28	1.28	1.18	1.12	1.05	1.32	1.28
Interest Exp. to Revenue %	-0.04	-0.21	-0.17	-0.21	-0.20	-0.27	-0.29	-0.34	-0.40	-0.51	-0.71	-0.52	-0.50	-0.47	-0.57	-0.71

Asset Turnover	0.98	1.02	1.10	1.18	1.18	1.15	0.96	0.92	0.89	0.89	0.21	0.22	0.23	0.24	0.20	0.21
Buyback Ratio	-11.20	--	-24.20	--	--	--	--	--	--	--	--	--	--	--	--	--
Dividend Payout Ratio	0.25	0.23	0.22	0.21	0.19	0.19	0.26	0.27	0.24	0.26	0.26	0.22	0.26	0.28	0.64	0.26
Income Statement	Annuals (USD $) View: $ %											Quarterly
Fiscal Period	Sep03	Sep04	Sep05	Sep06	Sep07	Sep08	Sep09	Sep10	Sep11	Sep12	TTM	Mar12	Jun12	Sep12	Dec12	Mar13

Revenue	2,542	2,930	3,445	3,863	4,415	4,769	4,470	4,665	4,806	4,726	4,664	1,161	1,205	1,266	1,062	1,131
Cost of Goods Sold	1,866	2,144	2,502	2,752	3,092	3,334	3,150	3,379	3,427	3,324	3,294	810	846	894	750	804
Gross Profit	676	786	943	1,111	1,323	1,435	1,320	1,286	1,379	1,402	1,370	351	359	372	312	327

Selling, General, &Admin. Expense	341	356	402	441	482	485	458	478	533	543	532	137	132	150	124	126
Earnings Before DDA	440	539	660	776	959	1,079	8,222	957	987	1,033	1,026	1,054	264	285	231	246

Depreciation, Depletion and Amortization	105	109	119	106	118	129	144	149	141	174	188	37.00	37.00	63.00	43.00	45.00

Operating Income	335	430	541	670	841	950	8,078	808	846	859	838	1,017	227	222	188	201
Interest Income/Expense	-1.00	-6.00	-6.00	-8.00	-9.00	-13.00	-13.00	-16.00	-19.00	-24.00	-26.00	-6.00	-6.00	-6.00	-6.00	-8.00
Net Income	258	301	396	477	585	678	594	561	634	609	611	161	166	152	132	161

Earnings per Share ($)	1.43	1.67	2.20	2.73	3.45	4.16	3.73	3.52	4.06	4.15	4.31	1.09	1.14	1.06	0.94	1.17
Total Shares Outstanding	180	180	180	175	170	163	159	159	156	147	138	148	145	144	141	138
Balance Sheet	Annuals (USD $) View: $ %											Quarterly
Fiscal Period	Sep03	Sep04	Sep05	Sep06	Sep07	Sep08	Sep09	Sep10	Sep11	Sep12	Latest Q.	Mar12	Jun12	Sep12	Dec12	Mar13

Cash and cash equivalents	66.00	196	145	144	231	175	235	435	530	335	337	297	265	335	337	337
Accounts Receivable	542	626	732	821	883	950	913	1,024	969	971	954	898	967	971	906	954
Inventory	618	650	685	727	823	970	943	1,004	1,195	1,332	1,444	1,365	1,353	1,332	1,403	1,444
Other Current Assets	201	191	213	235	232	243	271	226	195	149	139	197	168	149	147	139
Total Current Assets	1,427	1,663	1,775	1,927	2,169	2,338	2,362	2,689	2,889	2,787	2,874	2,757	2,753	2,787	2,793	2,874

Property, Plant and Equipment	401	418	473	552	607	680	719	707	754	773	758	751	750	773	767	758
Intangible Assets	440	550	571	654	691	807	964	1,072	1,088	1,071	1,067	1,078	1,068	1,071	1,074	1,067
Other Long Term Assets	323	243	321	145	283	319	600	596	658	683	654	621	577	683	679	654
Total Assets	2,591	2,874	3,140	3,278	3,750	4,144	4,645	5,064	5,389	5,314	5,353	5,207	5,148	5,314	5,313	5,353

Accounts Payable	417	493	602	646	729	716	565	870	1,078	918	838	942	784	918	785	838
Current Portion of Long-Term Debt	42.00	--	--	--	--	287	--	24.00	--	--	585	97.00	201	--	549	585
Other Current Liabilities	442	471	575	678	730	737	794	558	417	522	537	414	500	522	581	537
Total Current Liabilities	901	964	1,177	1,324	1,459	1,740	1,359	1,452	1,495	1,440	1,960	1,453	1,485	1,440	1,915	1,960

Long-Term Debt	--	201	200	245	223	228	532	525	528	779	570	774	778	779	573	570
Other Long-Term Liabilities	857	576	824	503	495	768	1,462	1,605	1,843	1,836	1,703	1,651	1,612	1,836	1,773	1,703
Total Liabilities	1,758	1,741	2,201	2,072	2,177	2,736	3,353	3,582	3,866	4,055	4,233	3,878	3,875	4,055	4,261	4,233

Common Stock	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00
Retained Earnings	273	492	771	1,105	1,533	2,058	2,444	2,816	3,288	3,708	3,911	3,489	3,609	3,708	3,793	3,911
Additional Paid-In Capital	1,213	1,228	1,263	1,305	1,353	1,378	1,395	1,420	1,437	1,460	1,463	1,446	1,453	1,460	1,458	1,463
Treasury Stock	-139	-192	-493	-813	-979	-1,452	-1,469	-1,497	-1,707	-2,304	-2,657	-2,132	-2,313	-2,304	-2,603	-2,657
Total Equity	833	1,133	939	1,206	1,573	1,408	1,292	1,482	1,523	1,259	1,120	1,329	1,273	1,259	1,052	1,120
Cashflow Statement	Annuals (USD $) View: $ %											Quarterly
Fiscal Period	Sep03	Sep04	Sep05	Sep06	Sep07	Sep08	Sep09	Sep10	Sep11	Sep12	TTM	Mar12	Jun12	Sep12	Dec12	Mar13

Net Income	258	301	396	477	585	678	594	561	634	609	611	161	166	152	132	161
Depreciation, Depletion and Amortization	105	109	119	106	118	129	144	149	141	174	188	37.00	37.00	63.00	43.00	45.00
Cash Flow from Others	11.00	-9.00	59.00	12.00	-96.00	-187	-105	1.00	-118	-249	-131	-89.00	-56.00	127	-112	-90.00
Cash Flow from Operations	374	401	574	595	607	620	633	711	657	534	668	109	147	342	63.00	116

Investment for Property, Plant & Equipement	-72.00	-105	-118	-144	-133	-179	-155	-116	-156	-142	-134	-26.00	-34.00	-38.00	-40.00	-22.00
Cash Flow from Acquisitions	2.00	-126	-19.00	-100.00	-32.00	-105	-146	-96.00	27.00	-3.00	-3.00	--	--	-3.00	--	--
Cash Flow from Investing	-71.00	-230	-134	-159	-153	-284	-302	-232	-92.00	-129	-119	-25.00	-19.00	-38.00	-40.00	-22.00

Net Issuance of Stock	-125	-179	-402	-492	-333	-576	-153	-183	-328	-714	-649	-109	-208	-4.00	-336	-101
Net Issuance of Debt	-90.00	156	--	46.00	-27.00	287	9.00	--	-24.00	247	288	49.00	104	-201	345	40.00
Cash Flow for Dividends	-64.00	-69.00	-85.00	-96.00	-107	-129	-152	-151	-148	-157	-169	-35.00	-43.00	-43.00	-42.00	-41.00
Other Financing	--	55.00	--	101	94.00	25.00	21.00	55.00	29.00	30.00	29.00	17.00	1.00	6.00	8.00	14.00
Cash Flow from Financing	-279	-37.00	-487	-441	-373	-393	-275	-279	-471	-594	-501	-78.00	-146	-242	-25.00	-88.00

Net Change in Cash	17.00	130	-51.00	-1.00	87.00	-56.00	60.00	200	95.00	-195	40.00	11.00	-32.00	70.00	2.00	--

Free Cash Flow	302	296	456	451	474	441	478	595	501	392	534	83.00	113	304	23.00	94.00
Valuation Ratios (Daily)	Annuals											Quarterly
Fiscal Period	Sep03	Sep04	Sep05	Sep06	Sep07	Sep08	Sep09	Sep10	Sep11	Sep12	Latest Q.	Mar12	Jun12	Sep12	Dec12	Mar13

PE Ratio(ttm)
Price to Tangible Book
Price-to-Free-Cash-Flow ratio
PS Ratio
EV-to-Revenue
EV-to-EBITDA
EV-to-EBIT
Earnings Yield (Joel Greenblatt)
Forward Rate of Return
Shiller PE Ratio
Valuation and Quality	Annuals											Quarterly
Fiscal Period	Sep03	Sep04	Sep05	Sep06	Sep07	Sep08	Sep09	Sep10	Sep11	Sep12	Latest Q.	Mar12	Jun12	Sep12	Dec12	Mar13

Market Cap
Enterprise Value
Month End Stock Price
Net Cash (per share)
Net Current Asset Value (per share)
DCF (per share)
Median PS (per share)
Peter Lynch Fair Value (per share)
Graham Number (per share)
Altman Z-Score
Piotroski F-Score
Beneish M-Score

Switch to Another Stock:

COL Quarterly/Annuals Reports

COL: 10-Q - ROCKWELL COLLINS INC (0001137411) (Filer): (10-Q) - 2013-01-18
COL: 10-Q - ROCKWELL COLLINS INC (0001137411) (Filer): (10-Q) - 2012-07-24
COL: 10-Q - ROCKWELL COLLINS INC (0001137411) (Filer): (10-Q) - 2012-04-19
COL: 10-Q - ROCKWELL COLLINS INC (0001137411) (Filer): (10-Q) - 2012-01-19
COL: 10-K - ROCKWELL COLLINS INC (0001137411) (Filer): (10-K) - 2011-11-15

GuruFocus Affiliate Program: Earn up to $400 per referral. ( Learn More)
Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names

Home About Jobs Advertise Site Map Term of Use Privacy Policy RSS Email Alerts Affiliate Program FAQ Contact Us
Disclaimers: GuruFocus.com is not operated by a broker, a dealer, or a registered investment adviser. Under no circumstances does any information posted on GuruFocus.com represent a recommendation to buy or sell a security. The information on this site, and in its related newsletters, is not intended to be, nor does it constitute, investment advice or recommendations. The gurus may buy and sell securities before and after any particular article and report and information herein is published, with respect to the securities discussed in any article and report posted herein. In no event shall GuruFocus.com be liable to any member, guest or third party for any damages of any kind arising out of the use of any content or other material published or available on GuruFocus.com, or relating to the use of, or inability to use, GuruFocus.com or any content, including, without limitation, any investment losses, lost profits, lost opportunity, special, incidental, indirect, consequential or punitive damages. Past performance is a poor indicator of future performance. The information on this site, and in its related newsletters, is not intended to be, nor does it constitute, investment advice or recommendations. The information on this site is in no way guaranteed for completeness, accuracy or in any other way. The gurus listed in this website are not affiliated with GuruFocus.com, LLC. Stock quotes provided by InterActive Data. Fundamental company data provided by Morningstar, updated daily.

FocusBar

Home

Premium Membership

Value Screens

Model Portfolios

Guru Stocks

Market Valuation

By Country

Articles

Submit Articles

COL Quarterly/Annuals Reports