GURUFOCUS.COM » STOCK LIST » Technology » Hardware » Dell Inc (DELISTED:DELL) » Definitions » Piotroski F-Score

Dell (DELL) Piotroski F-Score : 0 (As of Jun. 04, 2024)


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

What is Dell 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

Dell has an F-score of 4 indicating the company's financial situation is typical for a stable company.

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


Dell Piotroski F-Score Historical Data

The historical data trend for Dell'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.

Dell Piotroski F-Score Chart

Dell Annual Data
Trend Jan04 Jan05 Jan06 Jan07 Jan08 Jan09 Jan10 Jan11 Jan12 Jan13
Piotroski F-Score
Get a 7-Day Free Trial Premium Member Only Premium Member Only 4.00 3.00 7.00 6.00 5.00

Dell Quarterly Data
Oct08 Jan09 Apr09 Jul09 Oct09 Jan10 Apr10 Jul10 Oct10 Jan11 Apr11 Jul11 Oct11 Jan12 Apr12 Jul12 Oct12 Jan13 Apr13 Jul13
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 6.00 5.00 5.00 5.00 4.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 (Jul13) TTM:Last Year (Jul12) TTM:
Net Income was 475 + 530 + 130 + 204 = $1,339.00 Mil.
Cash Flow from Operations was 1343 + 1441 + -39 + 1678 = $4,423.00 Mil.
Revenue was 13721 + 14314 + 14074 + 14514 = $56,623.00 Mil.
Gross Profit was 2872 + 3109 + 2747 + 2689 = $11,417.00 Mil.
Average Total Assets from the begining of this year (Jul12)
to the end of this year (Jul13) was
(44097 + 45446 + 47540 + 44791 + 45871) / 5 = $45549 Mil.
Total Assets at the begining of this year (Jul12) was $44,097.00 Mil.
Long-Term Debt & Capital Lease Obligation was $4,075.00 Mil.
Total Current Assets was $26,866.00 Mil.
Total Current Liabilities was $22,756.00 Mil.
Net Income was 893 + 764 + 635 + 732 = $3,024.00 Mil.

Revenue was 15365 + 16031 + 14422 + 14483 = $60,301.00 Mil.
Gross Profit was 3469 + 3385 + 3067 + 3138 = $13,059.00 Mil.
Average Total Assets from the begining of last year (Jul11)
to the end of last year (Jul12) was
(41604 + 42043 + 44533 + 43289 + 44097) / 5 = $43113.2 Mil.
Total Assets at the begining of last year (Jul11) was $41,604.00 Mil.
Long-Term Debt & Capital Lease Obligation was $5,832.00 Mil.
Total Current Assets was $27,250.00 Mil.
Total Current Liabilities was $20,712.00 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.

Dell's current Net Income (TTM) was 1,339.00. ==> 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.

Dell's current Cash Flow from Operations (TTM) was 4,423.00. ==> Positive ==> Score 1.

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 (Jul12)
=1339/44097
=0.03036488

ROA (Last Year)=Net Income/Total Assets (Jul11)
=3024/41604
=0.07268532

Dell's return on assets of this year was 0.03036488. Dell's return on assets of last year was 0.07268532. ==> 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.

Dell's current Net Income (TTM) was 1,339.00. Dell's current Cash Flow from Operations (TTM) was 4,423.00. ==> 4,423.00 > 1,339.00 ==> CFROA > ROA ==> Score 1.

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: Jul13)=Long-Term Debt & Capital Lease Obligation/Average Total Assets from Jul12 to Jul13
=4075/45549
=0.08946409

Gearing (Last Year: Jul12)=Long-Term Debt & Capital Lease Obligation/Average Total Assets from Jul11 to Jul12
=5832/43113.2
=0.1352718

Dell's gearing of this year was 0.08946409. Dell's gearing of last year was 0.1352718. ==> 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: Jul13)=Total Current Assets/Total Current Liabilities
=26866/22756
=1.18061171

Current Ratio (Last Year: Jul12)=Total Current Assets/Total Current Liabilities
=27250/20712
=1.31566242

Dell's current ratio of this year was 1.18061171. Dell's current ratio of last year was 1.31566242. ==> 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.

Dell's number of shares in issue this year was 1764. Dell's number of shares in issue last year was 1753. ==> 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
=11417/56623
=0.20163185

Gross Margin (Last Year: TTM)=Gross Profit/Revenue
=13059/60301
=0.21656357

Dell's gross margin of this year was 0.20163185. Dell's gross margin of last year was 0.21656357. ==> 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 (Jul12)
=56623/44097
=1.2840556

Asset Turnover (Last Year)=Revenue/Total Assets at the Beginning of Last Year (Jul11)
=60301/41604
=1.4494039

Dell's asset turnover of this year was 1.2840556. Dell's asset turnover of last year was 1.4494039. ==> 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+1+0+1+1+0+0+0+0
=4

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

Dell has an F-score of 4 indicating the company's financial situation is typical for a stable company.

Dell  (DELISTED:DELL) 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.


Dell Piotroski F-Score Related Terms

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


Dell (DELL) Business Description

Traded in Other Exchanges
N/A
Address
Dell Inc is a Delaware Corporation, which was founded in 1984. The Company offers a range of technology solutions, including servers and networking products, storage products, services, software and peripherals, mobility products, and desktop PCs. The Company sells its products and services directly to customers through dedicated distribution channels, such as retailers, distributors, and resellers. Its business segments are Large Enterprise, Public, Small and Medium Business ('SMB'), and Consumer. Large Enterprise customers include large global and national corporate businesses. Public customers, which include educational institutions, government, health care, and law enforcement agencies, operate in their own communities. SMB segment is focused on helping small and medium-sized businesses get the most out of their technology by offering scalable products, services, and solutions. Consumer segment is focused on delivering what customers want from the total technology experience of entertainment, mobility, gaming, and design. The Company designs, develops, manufactures, markets, sells, and supports a range of products, solutions, and services. The Company also provides various customer financial services to its Commercial and Consumer customers. Its enterprise solutions include servers, networking, and storage products. The Company's services include a range of configurable IT and business services, including infrastructure technology, consulting and applications, and product-related support services. The Company offers Dell-branded printers and displays and a multitude of competitively priced third-party peripheral products such as printers, televisions, notebook accessories, mice, keyboards, networking and wireless products, digital cameras, and other products. The Company also sells a range of third-party software products, including operating systems, business and office applications, anti-virus and related security software, entertainment software, and products in various other categories. Client Products offers a variety of mobility and desktop products, including notebooks, workstations, tablets, smartphones, and desktop PCs, to its Commercial and Consumer customers. The Company offers or arranges various financing options and services for its Commercial and Consumer customers in the U.S. and Canada through Dell Financial Services ('DFS'). DFS offers a range of financial services, including originating, collecting, and servicing customer receivables related to the purchase of Dell products. DFS offers private label credit financing programs to qualified Consumer and Commercial customers and offers leases and fixed-term financing to Commercial customers. The Company sells its products and services directly to customers and through various other sales distribution channels, such as retailers, third-party solution providers, system integrators, and third-party resellers. Its customers include large global and national corpora