Rockwell Collins (Rockwell Collins) Inventory Turnover : 0.64 (As of Sep. 2018)

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

What is Rockwell Collins Inventory Turnover?

Inventory Turnover measures how fast the company turns over its inventory within a year. It is calculated as Cost of Goods Sold divided by Total Inventories. Rockwell Collins's Cost of Goods Sold for the three months ended in Sep. 2018 was $1,696 Mil. Rockwell Collins's Average Total Inventories for the quarter that ended in Sep. 2018 was $2,645 Mil. Rockwell Collins's Inventory Turnover for the quarter that ended in Sep. 2018 was 0.64.

Days Inventory indicates the number of days of goods in sales that a company has in the inventory. Rockwell Collins's Days Inventory for the three months ended in Sep. 2018 was 142.31.

Inventory-to-Revenue determines the ability of a company to manage their inventory levels. It measures the percentage of Inventories the company currently has on hand to support the current amount of Revenue. Rockwell Collins's Inventory-to-Revenue for the quarter that ended in Sep. 2018 was 1.17.

Rockwell Collins Inventory Turnover Historical Data

The historical data trend for Rockwell Collins's Inventory Turnover 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 Inventory Turnover Chart

Rockwell Collins Annual Data

Trend

Sep09

Sep10

Sep11

Sep12

Sep13

Sep14

Sep15

Sep16

Sep17

Sep18

Inventory Turnover

Get a 7-Day Free Trial

2.15

2.05

1.94

2.22

2.50

Rockwell Collins Quarterly Data
	Dec13	Mar14	Jun14	Sep14	Dec14	Mar15	Jun15	Sep15	Dec15	Mar16	Jun16	Sep16	Dec16	Mar17	Jun17	Sep17	Dec17	Mar18	Jun18	Sep18
Inventory Turnover	Get a 7-Day Free Trial															0.64	0.58	0.62	0.62	0.64

Rockwell Collins Inventory Turnover Calculation

Rockwell Collins's Inventory Turnover for the fiscal year that ended in Sep. 2018 is calculated as

	Inventory Turnover (A: Sep. 2018 )
=	Cost of Goods Sold	/	Average Total Inventories
=	Cost of Goods Sold (A: Sep. 2018 )	/ (	(Total Inventories (A: Sep. 2017 )	+	Total Inventories (A: Sep. 2018 ))	/	count )
=	6382	/ (	(2451	+	2649)	/	2 )
=	6382	/	2550
=	2.50

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

	Inventory Turnover (Q: Sep. 2018 )
=	Cost of Goods Sold	/	Average Total Inventories
=	Cost of Goods Sold (Q: Sep. 2018 )	/ (	(Total Inventories (Q: Jun. 2018 )	+	Total Inventories (Q: Sep. 2018 ))	/	count )
=	1696	/ (	(2641	+	2649)	/	2 )
=	1696	/	2645
=	0.64

Rockwell Collins (NYSE:COL) Inventory Turnover Explanation

Inventory Turnover measures how fast the company turns over its inventory within a year. A higher Inventory Turnover means the company has light inventory. Therefore the company spends less money on storage, write downs, and obsolete inventory. If the inventory is too light, it may affect sales because the company may not have enough to meet demand.

1. Days Inventory indicates the number of days of goods in sales that a company has in the inventory.

Rockwell Collins's Days Inventory for the three months ended in Sep. 2018 is calculated as:

Days Inventory	=	Average Total Inventories (Q: Sep. 2018 )	/	Cost of Goods Sold (Q: Sep. 2018 )	*	Days in Period
	=	2645	/	1696	*	365 / 4
	=	142.31

2. Inventory-to-Revenue determines the ability of a company to manage their inventory levels. It measures the percentage of Inventories the company currently has on hand to support the current amount of Revenue.

Rockwell Collins's Inventory to Revenue for the quarter that ended in Sep. 2018 is calculated as

Inventory-to-Revenue	=	Average Total Inventories (Q: Sep. 2018 )	/	Revenue (Q: Sep. 2018 )
	=	2645	/	2266
	=	1.17

Be Aware

Usually retailers pile up their inventories at holiday seasons to meet the stronger demand. Therefore, the inventory of a particular quarter of a year should not be used to calculate Inventory Turnover. An average inventory is a better indication.

Rockwell Collins Inventory Turnover Related Terms

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

Rockwell Collins (Rockwell Collins) Business Description

Industry

GURUFOCUS.COM » STOCK LIST » Industrials » Aerospace & Defense » Rockwell Collins Inc (NYSE:COL) » Definitions » Inventory Turnover

Comparable Companies

Traded in Other Exchanges

N/A

Address

Website

http://www.rockwellcollins.com

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