COL has been successfully added to your Stock Email Alerts list.
You can manage your stock email alerts here.
COL has been removed from your Stock Email Alerts list.
Please enter Portfolio Name for new portfolio.
Rockwell Collins's total inventories for the quarter that ended in Sep. 2018 was $2,649 Mil. Rockwell Collins's average total inventories from the quarter that ended in Jun. 2018 to the quarter that ended in Sep. 2018 was $2,645 Mil.
In Ben Graham's calculation of Net-Net Working Capital, inventory is only considered worth half of its book value. Rockwell Collins's Net-Net Working Capital per share for the quarter that ended in Sep. 2018 was $-53.02.
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 Turnover measures how fast the company turns over its inventory within a year. Rockwell Collins's Inventory Turnover for the quarter that ended in Sep. 2018 was 0.64.
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.
The historical data trend for Rockwell Collins's Total Inventories 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.
Rockwell Collins Annual Data | |||||||||||||||||||||
Trend | Sep09 | Sep10 | Sep11 | Sep12 | Sep13 | Sep14 | Sep15 | Sep16 | Sep17 | Sep18 | |||||||||||
Total Inventories | Get a 7-Day Free Trial | 1,709.00 | 1,824.00 | 1,939.00 | 2,451.00 | 2,649.00 |
Rockwell Collins Quarterly Data | ||||||||||||||||||||
Dec13 | Mar14 | Jun14 | Sep14 | Dec14 | Mar15 | Jun15 | Sep15 | Dec15 | Mar16 | Jun16 | Sep16 | Dec16 | Mar17 | Jun17 | Sep17 | Dec17 | Mar18 | Jun18 | Sep18 | |
Total Inventories | Get a 7-Day Free Trial | 2,451.00 | 2,557.00 | 2,633.00 | 2,641.00 | 2,649.00 |
Total Inventories includes the raw materials, work-in-process goods and completely finished goods of a company. It is a portion of a company's current assets.
Rockwell Collins (NYSE:COL) Total Inventories Explanation
Inventory control is an important part of business operation. If a company does not have enough inventory, it may not be able to meet customers' required delivery time. If it has too much inventory, the cost of holding the inventory can be high.
1. In Ben Graham's calculation of Net-Net Working Capital (NNWC), inventory is only considered worth half of its book value.
Rockwell Collins's Net-Net Working Capital Per Share for the quarter that ended in Sep. 2018 is
Net-Net Working Capital Per Share (Q: Sep. 2018 ) | |||||||
= | (Cash And Cash Equivalents | + | 0.75 * Accounts Receivable | + | 0.5 * Total Inventories | - | Total Liabilities |
- | Preferred Stock | - | Minority Interest) | / | Shares Outstanding (EOP) | ||
= | (738 | + | 0.75 * 1513 | + | 0.5 * 2649 | - | 11912 |
- | 0 | - | 7) | / | 164.5 | ||
= | -53.02 |
2. 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 |
3. Inventory Turnover measures how fast the company turns over its inventory within a year.
Rockwell Collins's Inventory Turnover for the quarter that ended in Sep. 2018 is calculated as
Inventory Turnover | = | Cost of Goods Sold (Q: Sep. 2018 ) | / | Average Total Inventories (Q: Sep. 2018 ) |
= | 1696 | / | 2645 | |
= | 0.64 |
4. 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 |
* 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.
Be Aware
Manufacturers with durable competitive advantages have the advantage that the products they sell do not change, and therefore will never become obsolete. Buffett likes this advantage.
When identifying manufacturers with durable competitive advantage, look for inventory and net earnings that rise correspondingly. This indicates that the company is finding profitable ways to increase sales which called for an increase in inventory.
Manufacturers with inventories that spike up and down are indicative of competitive industries subject to boom and bust.
Thank you for viewing the detailed overview of Rockwell Collins's Total Inventories provided by GuruFocus.com. Please click on the following links to see related term pages.
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 |
From GuruFocus
By Tiziano Frateschi Tiziano Frateschi • 11-29-2017
By gurufocus 10qk • 07-29-2010
By GuruFocus Research GuruFocus Editor • 07-23-2010
By PRNewswire PRNewswire • 03-22-2018
By GuruFocus Research GuruFocus Editor • 07-23-2010
By Vanina Egea Vanina Egea • 03-17-2014
By Vanin Aegea Vanin Aegea • 10-22-2013
By GuruFocus Research GuruFocus Editor • 07-27-2010
By Tiziano Frateschi Tiziano Frateschi • 06-04-2015
By gurufocus 10qk • 01-28-2011
Disclaimers: GuruFocus.com is not operated by a broker or a dealer. It has an affiliated registered investment adviser, which serves as the subadviser to an exchange traded fund. This investment adviser does not provide advice to individual investors. 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 individuals or entities selected as "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. Gurus may be added or dropped from the GuruFocus site at any time. 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.