GURUFOCUS.COM » STOCK LIST » Industrials » Aerospace & Defense » Rockwell Collins Inc (NYSE:COL) » Definitions » Piotroski F-Score

Rockwell Collins (Rockwell Collins) Piotroski F-Score : 0 (As of Apr. 26, 2024)


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

What is Rockwell Collins Piotroski F-Score?

The zones of discrimination were as such:

Good or high score = 7, 8, 9
Bad or low score = 0, 1, 2, 3

Rockwell Collins has an F-score of 2. It is a bad or low score, which usually implies poor business operation.

The historical rank and industry rank for Rockwell Collins's Piotroski F-Score or its related term are showing as below:


Rockwell Collins Piotroski F-Score Historical Data

The historical data trend for Rockwell Collins's Piotroski F-Score 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 Piotroski F-Score Chart

Rockwell Collins Annual Data
Trend Sep09 Sep10 Sep11 Sep12 Sep13 Sep14 Sep15 Sep16 Sep17 Sep18
Piotroski F-Score
Get a 7-Day Free Trial Premium Member Only Premium Member Only 6.00 7.00 5.00 5.00 2.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
Piotroski F-Score Get a 7-Day Free Trial Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 5.00 6.00 6.00 4.00 2.00

How is the Piotroski F-Score calculated?

* 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.

This Year (Sep18) TTM:Last Year (Sep17) TTM:
Net Income was 280 + 237 + 275 + 240 = $1,032 Mil.
Cash Flow from Operations was -259 + 182 + 273 + -506 = $-310 Mil.
Revenue was 2011 + 2180 + 2208 + 2266 = $8,665 Mil.
Gross Profit was 548 + 582 + 583 + 570 = $2,283 Mil.
Average Total Assets from the begining of this year (Sep17)
to the end of this year (Sep18) was
(17997 + 18052 + 18300 + 18359 + 19026) / 5 = $18346.8 Mil.
Total Assets at the begining of this year (Sep17) was $17,997 Mil.
Long-Term Debt & Capital Lease Obligation was $5,681 Mil.
Total Current Assets was $5,778 Mil.
Total Current Liabilities was $4,686 Mil.
Net Income was 145 + 168 + 179 + 213 = $705 Mil.

Revenue was 1193 + 1342 + 2094 + 2193 = $6,822 Mil.
Gross Profit was 377 + 412 + 570 + 595 = $1,954 Mil.
Average Total Assets from the begining of last year (Sep16)
to the end of last year (Sep17) was
(7699 + 7709 + 7780 + 18351 + 17997) / 5 = $11907.2 Mil.
Total Assets at the begining of last year (Sep16) was $7,699 Mil.
Long-Term Debt & Capital Lease Obligation was $6,676 Mil.
Total Current Assets was $4,760 Mil.
Total Current Liabilities was $3,069 Mil.

*Note: If the latest quarterly/semi-annual/annual total assets data is 0, then we will use previous quarterly/semi-annual/annual data for all the items in the balance sheet.

Profitability

Question 1. Return on Assets (ROA)

Net income before extraordinary items for the year divided by Total Assets at the beginning of the year.

Score 1 if positive, 0 if negative.

Rockwell Collins's current Net Income (TTM) was 1,032. ==> Positive ==> Score 1.

Question 2. Cash Flow Return on Assets (CFROA)

Net cash flow from operating activities (operating cash flow) divided by Total Assets at the beginning of the year.

Score 1 if positive, 0 if negative.

Rockwell Collins's current Cash Flow from Operations (TTM) was -310. ==> Negative ==> Score 0.

Question 3. Change in Return on Assets

Compare this year's return on assets (1) to last year's return on assets.

Score 1 if it's higher, 0 if it's lower.

ROA (This Year)=Net Income/Total Assets (Sep17)
=1032/17997
=0.05734289

ROA (Last Year)=Net Income/Total Assets (Sep16)
=705/7699
=0.09157033

Rockwell Collins's return on assets of this year was 0.05734289. Rockwell Collins's return on assets of last year was 0.09157033. ==> Last year is higher ==> Score 0.

Question 4. Quality of Earnings (Accrual)

Compare Cash flow return on assets (2) to return on assets (1)

Score 1 if CFROA > ROA, 0 if CFROA <= ROA.

Rockwell Collins's current Net Income (TTM) was 1,032. Rockwell Collins's current Cash Flow from Operations (TTM) was -310. ==> -310 <= 1,032 ==> CFROA <= ROA ==> Score 0.

Funding

Question 5. Change in Gearing or Leverage

Compare this year's gearing (long-term debt divided by average total assets) to last year's gearing.

Score 0 if this year's gearing is higher, 1 otherwise.

Gearing (This Year: Sep18)=Long-Term Debt & Capital Lease Obligation/Average Total Assets from Sep17 to Sep18
=5681/18346.8
=0.30964528

Gearing (Last Year: Sep17)=Long-Term Debt & Capital Lease Obligation/Average Total Assets from Sep16 to Sep17
=6676/11907.2
=0.56066917

Rockwell Collins's gearing of this year was 0.30964528. Rockwell Collins's gearing of last year was 0.56066917. ==> This year is lower or equal to last year. ==> Score 1.

Question 6. Change in Working Capital (Liquidity)

Compare this year's current ratio (current assets divided by current liabilities) to last year's current ratio.

Score 1 if this year's current ratio is higher, 0 if it's lower

Current Ratio (This Year: Sep18)=Total Current Assets/Total Current Liabilities
=5778/4686
=1.23303457

Current Ratio (Last Year: Sep17)=Total Current Assets/Total Current Liabilities
=4760/3069
=1.55099381

Rockwell Collins's current ratio of this year was 1.23303457. Rockwell Collins's current ratio of last year was 1.55099381. ==> Last year's current ratio is higher ==> Score 0.

Question 7. Change in Shares in Issue

Compare the number of shares in issue this year, to the number in issue last year.

Score 0 if there is larger number of shares in issue this year, 1 otherwise.

Rockwell Collins's number of shares in issue this year was 166.1. Rockwell Collins's number of shares in issue last year was 164.6. ==> There is larger number of shares in issue this year. ==> Score 0.

Efficiency

Question 8. Change in Gross Margin

Compare this year's gross margin (Gross Profit divided by sales) to last year's.

Score 1 if this year's gross margin is higher, 0 if it's lower.

Gross Margin (This Year: TTM)=Gross Profit/Revenue
=2283/8665
=0.26347374

Gross Margin (Last Year: TTM)=Gross Profit/Revenue
=1954/6822
=0.28642627

Rockwell Collins's gross margin of this year was 0.26347374. Rockwell Collins's gross margin of last year was 0.28642627. ==> Last year's gross margin is higher ==> Score 0.

Question 9. Change in asset turnover

Compare this year's asset turnover (total sales for the year divided by total assets at the beginning of the year) to last year's asset turnover ratio.

Score 1 if this year's asset turnover ratio is higher, 0 if it's lower

Asset Turnover (This Year)=Revenue/Total Assets at the Beginning of This Year (Sep17)
=8665/17997
=0.48146913

Asset Turnover (Last Year)=Revenue/Total Assets at the Beginning of Last Year (Sep16)
=6822/7699
=0.8860891

Rockwell Collins's asset turnover of this year was 0.48146913. Rockwell Collins's asset turnover of last year was 0.8860891. ==> Last year's asset turnover is higher ==> Score 0.

Evaluation

Piotroski F-Score= Que. 1+ Que. 2+ Que. 3+Que. 4+Que. 5+Que. 6+Que. 7+Que. 8+Que. 9
=1+0+0+0+1+0+0+0+0
=2

Good or high score = 7, 8, 9
Bad or low score = 0, 1, 2, 3

Rockwell Collins has an F-score of 2. It is a bad or low score, which usually implies poor business operation.

Rockwell Collins  (NYSE:COL) Piotroski F-Score Explanation

The developer of the system is Joseph D. Piotroski is relatively unknown accounting professor who shuns publicity and rarely gives interviews.

He graduated from the University of Illinois with a B.S. in accounting in 1989, received an M.B.A. from Indiana University in 1994. Five years later, in 1999, after earning a Ph.D. in accounting from the University of Michigan, he became an associate professor of accounting at the University of Chicago.

In 2000, he wrote a research paper called "Value Investing: The Use of Historical Financial Statement Information to Separate Winners from Losers" (pdf).

He wanted to see if he can develop a system (using a simple nine-point scoring system) that can increase the returns of a strategy of investing in low price to book (referred to in the paper as high book to market) value companies.

What he found was something that exceeded his most optimistic expectations.

Buying only those companies that scored highest (8 or 9) on his nine-point scale, or F-Score as he called it, over the 20 year period from 1976 to 1996 led to an average out-performance over the market of 13.4%.

Even more impressive were the results of a strategy of investing in the highest F-Score companies (8 or 9) and shorting companies with the lowest F-Score (0 or 1).

Over the same period from 1976 to 1996 (20 years) this strategy led to an average yearly return of 23%, substantially outperforming the average S&P 500 index return of 15.83% over the same period.


Rockwell Collins Piotroski F-Score Related Terms

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


Rockwell Collins (Rockwell Collins) Business Description

Traded in Other Exchanges
N/A
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.
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

Rockwell Collins (Rockwell Collins) Headlines

From GuruFocus

Rockwell Collins Inc. (COL) Sr. VP and CFO Patrick E Allen sells 19,000 Shares

By GuruFocus Research GuruFocus Editor 04-30-2010

Rockwell Collins Inc: Fundamental Stock Research Analysis

By FAST Graphs FAST Graphs 12-13-2012

Westport Funds Portfolio Review as of Dec. 31, 2013

By Holly LaFon Holly LaFon 03-26-2014

Aerospace, U.S. Defense Cuts and International Presence

By Vanin Aegea Vanin Aegea 10-22-2013

Rockwell Collins, Eros International Moving Higher Today

By Omar Venerio Omar Venerio 08-07-2017

Tudor Investment buys Verizon, PayPal, Electronic Arts

By Tiziano Frateschi Tiziano Frateschi 11-29-2017