F Score (Piotroski F-Score)

Returns the Piotroski F-Score, a discrete score between 0-9 that grades the financial strength of a company. Developed by Professor Joseph Piotroski.

Interpretation

F-Score Classification
8-9 Strong - High quality value stock
5-7 Average - Moderate financial health
0-4 Weak - Potential value trap

Components (9 Criteria)

Profitability (4 points):

  1. Positive net income
  2. Positive operating cash flow
  3. Cash flow > net income
  4. Improving ROA

Leverage/Liquidity (3 points): 5. Decreasing long-term debt ratio 6. Improving current ratio 7. No equity dilution

Operating Efficiency (2 points): 8. Improving gross margin 9. Improving asset turnover

Notes

  • Score 0-9 (integer, not decimal)
  • Higher is better
  • Designed for value investing

Examples

=FScore()
Get Piotroski F-Score
=IF(FScore()>=8,"Strong","")
Flag strong companies
=IF(FScore()<=4,"Weak","")
Flag weak companies

When to Use

  • Value investing screening
  • Financial health assessment
  • Avoiding value traps
  • Quality stock selection

When NOT to Use

Scenario Use Instead
Bankruptcy prediction AltmanZScore()
Earnings manipulation BeneishMScore()
Growth stocks Growth-focused metrics
Technical analysis Technical indicators

Common Issues & FAQ

Q: What is a good F-Score? A: 8-9 indicates strong fundamentals. Studies show stocks with high F-Scores outperform those with low scores.

Q: Why is this useful for value investing? A: Low P/B stocks can be cheap for good or bad reasons. The F-Score helps distinguish quality value stocks from value traps.

Q: Is this suitable for all stocks? A: Best suited for value stocks (low P/B). Growth stocks may naturally have lower scores due to investment spending.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use F Score and Other Financial Formulas
How does MarketXLS work?