Annual financial statement worksheet

Piotroski F-score screener: audit all nine signals

A Piotroski F-score screener adds nine binary accounting signals to produce a score from 0 to 9. A usable screen also needs comparable annual statements and dates showing when the inputs became public. Use the worksheet to inspect every signal, separate missing data from failed tests, and select only complete scores of 8 or 9. The examples are synthetic; this page does not fetch live stocks.

Use the calculator

Piotroski F-score screener worksheet

Audit three editable companies against the same fixed cutoff: F-score at least 8, with all nine signals known. Initial rows are synthetic examples, not stock recommendations or live data. Changes stay in this page until reload.

CompanyKnown signalsScore / possible rangeCutoff resultReview
Company Alder (synthetic)9/99/9Pass
Company Birch (synthetic)9/93/9Below cutoff
Company Cedar (synthetic)7/97 to 9 (incomplete)Unresolved
Review company 1

Use one currency and scale for both fiscal years. Amounts may be in millions; issued shares use a separate consistent share unit. Blank means unknown. Confirm comparable consolidated annual statements; TTM and quarterly mixtures are excluded.

Availability means the latest public release date among every input used, including restated figures and issuance notes. The date must precede the screen date; this conservative date-only rule holds out same-day releases. Links and dates are user supplied and are not independently verified.

Enter issued shares from the equity note, adjusted for splits. Repurchases cannot cancel issuance for this test; weighted-average shares and a year-end share-count difference are not substitutes. If the issuance event is unclear, leave it blank.

Company Alder (synthetic): F-score 9/9

9 known signals; 0 known failures; 0 unknown. Pass.

SignalCurrent valueCompared withPoint
1. Positive ROA0.12> 01: pass
2. Positive CFO0.15> 01: pass
3. Improving ROA0.12> 0.0555561: pass
4. CFO above ROA0.15> 0.121: pass
5. Lower leverage0.171429< 0.2105261: pass
6. Higher current ratio2> 1.51: pass
7. No common equity issued0= 01: pass
8. Higher gross margin0.4> 0.351: pass
9. Higher asset turnover1.3> 1.1111111: pass

Ratios are decimals. A nonpositive denominator, negative debt or cost of sales, missing input, or nonfinite calculation leaves the affected signal unknown. With invalid dates or mixed periods, all nine signals are unavailable. A partial lower bound is not a complete F-score, even if it exceeds the cutoff.

The nine tests and their denominators

Let t be the latest complete fiscal year, t-1 the preceding year, and A the total assets at each year end. Beginning assets for t are A(t-1); beginning assets for t-1 are A(t-2). Average assets for t are [A(t) + A(t-1)] / 2. Use the same reporting scope, currency and units across both years. NI means net income before extraordinary items; OCF means cash flow from operations. Every test below is worth one point when true and zero when false, provided its inputs are known.

  • Definition choice: the Chicago Booth reprint describes beginning assets for turnover in section 2.3.3, while its Table 1 note says average assets. This worksheet follows section 2.3.3. Record that choice when reconciling a provider score.
  • Boundary choice: the paper describes falling leverage as favorable but does not explicitly assign equality in that sentence. This worksheet requires a strict decline. Providers that accept unchanged leverage can differ by one point.
  • Issuance evidence: an unchanged or declining share count can hide issuance offset by buybacks. Weighted-average diluted shares also change for reasons other than a common equity offering. Review the equity note instead of substituting either field.
  • A reported net-income field is not automatically the historical NI definition. Reconcile extraordinary, discontinued and other adjustments in the filing before entering it. Keep the definition consistent across the two years.
SignalCondition for 1 pointInputs and comparison
1. Positive ROANI(t) / A(t-1) > 0Current annual income; beginning assets. A loss or zero income fails.
2. Positive CFOOCF(t) / A(t-1) > 0Annual operating cash flow, not free cash flow.
3. Improving ROANI(t) / A(t-1) > NI(t-1) / A(t-2)Compare both years on their own beginning asset bases.
4. AccrualsOCF(t) / A(t-1) > NI(t) / A(t-1)Both use the same positive denominator. This is an earnings-quality flag, not proof of manipulation.
5. Lower leverageDebt(t) / average A(t) < Debt(t-1) / average A(t-1)Long-term debt includes its current portion. Equal leverage earns zero in this worksheet.
6. Improving liquidityCA(t) / CL(t) > CA(t-1) / CL(t-1)Year-end current assets and current liabilities. Both liability denominators must be positive.
7. No equity issuanceCommon shares issued during t = 0Use gross issuance evidence. Repurchases do not offset new issuance; a split is not a capital raise.
8. Improving gross margin[Sales(t) - COGS(t)] / Sales(t) > [Sales(t-1) - COGS(t-1)] / Sales(t-1)Full-year net sales and cost of sales; both sales denominators must be positive.
9. Improving asset turnoverSales(t) / A(t-1) > Sales(t-1) / A(t-2)This worksheet fixes the beginning-assets convention from section 2.3.3 of the paper.

Reproduce the three-company screen

The initial worksheet uses FY 2025 versus FY 2024, with a March 10, 2026 screen date. All monetary inputs are hypothetical USD millions. Year-end assets for 2023, 2024 and 2025 are 90, 100 and 110 for each company. Prior-year income, sales, cost of sales, debt, current assets and current liabilities are 5, 100, 65, 20, 45 and 30. The latest current input set was publicly available on March 2, 2026; the prior set on March 3, 2025. These are teaching assumptions, not actual company disclosures.

  • Alder: ROA rises from 5/90 = 0.055556 to 12/100 = 0.12. CFO/assets = 0.15 exceeds 0.12. Leverage falls from 20/95 = 0.210526 to 18/105 = 0.171429.
  • Alder: current ratio rises from 1.5 to 2.0, gross margin from 35% to 40%, and turnover from 100/90 = 1.111111 to 130/100 = 1.30. No issuance supplies the remaining point.
  • Birch: positive earnings, positive cash flow and rising ROA supply three points. CFO is below income; leverage rises to 30/105 = 0.285714; liquidity, margin and turnover fall; issuance fails the seventh test.
  • Cedar: missing OCF affects signals 2 and 4. Seven confirmed points and two unknowns imply a range of 7 to 9. Entering zero OCF would falsely convert uncertainty into two failures.
Current-year inputs / resultAlderBirchCedar
Net income / operating cash flow12 / 158 / 412 / unknown
Sales / cost of sales130 / 78105 / 73.5130 / 78
Long-term debt including current portion183018
Current assets / current liabilities60 / 3040 / 3060 / 30
Common shares issued (millions)020
Signals 1 through 91, 1, 1, 1, 1, 1, 1, 1, 11, 1, 1, 0, 0, 0, 0, 0, 01, ?, 1, ?, 1, 1, 1, 1, 1
Complete score or possible range9/93/97 to 9; incomplete
Fixed cutoff at least 8PassBelow cutoffUnresolved; not admitted

Availability dates prevent future-data leakage

A fiscal year end identifies the economic period; it is not the date investors could see the accounts. Record the original filing or release timestamp for each input and use the latest one as the input-set availability date. This worksheet uses dates only, so it requires both availability dates to be strictly earlier than the screen date. It cannot prove a user-supplied date or inspect a linked filing.

SituationWorksheet or research treatment
FY ends December 31; full input set released March 2Unavailable in a January screen. Under the date-only rule, first eligible on March 3.
A corrected 2024 value first appears in a 2026 amendmentUse the amendment availability date for that value. Do not apply it retroactively to a 2025 screen.
Annual income paired with TTM cash flow or one quarter of salesChoose the mixed/TTM basis to exclude the row. Rebuild comparable annual inputs before scoring.
Fiscal calendar change or short transition yearDo not force an annual comparison. The worksheet accepts consecutive year ends 350 to 380 days apart, but comparable annual duration still needs manual review.
Historical company disappeared from today's universeRetain delisted and failed companies when reconstructing an old universe. Current survivors alone introduce selection bias.

Missing, invalid and weak are different states

A complete score ranges from 0 to 9. A partial range runs from the number of confirmed passes to that number plus unknown signals. The filter admits only complete scores of at least 8. A partial upper bound below 8 can already rule a company out, but a lower bound of 8 still does not create a complete score. This conservative completeness rule is a worksheet policy.

  • A negative valid income or cash-flow amount remains negative and can fail a signal. It is not missing. Zero at a strictly positive test also fails.
  • Zero or negative assets, sales denominators or current liabilities make the affected ratios unavailable. Negative debt, current assets or cost of sales require reconciliation. No infinity or invented zero is scored.
  • If current liabilities are zero, the current-ratio test remains unknown even if the business has no current debt. The denominator is all current liabilities, not only interest-bearing debt.
  • A high score counts favorable historical changes; it does not measure valuation, fraud probability or return certainty. Banks, insurers and businesses without comparable gross profit or current balance-sheet classifications need a different review.

Use the candidate list in Pineify and TradingView

Pineify Market Screener supplies technical fields and saved symbol collections. Its current field registry does not include the nine accounting signals or a native F-score threshold. AI Finance Agent can request a provider financial score and annual financial statements by ticker. The provider score response does not expose the nine flags, their fiscal periods or their availability dates, so it cannot replace this audit.

  • Preserve a candidate sheet with ticker, fiscal years, input values, source references, availability dates, nine flags, score range and inclusion reason. The local worksheet resets on reload; save your reviewed figures separately.
  • The original research concerns high book-to-market stocks. Substituting a low-P/E universe or applying the score to every growth stock changes the experiment. This worksheet does not reproduce the historical portfolio or its returns.
Research stepVerified product pathWhat still needs checking
Fetch financial figuresAI Finance Agent incomeStatement, balanceSheetStatement and cashFlowStatementRequest annual periods; compare date, fiscalYear, period, filingDate and acceptedDate, plus currency.
Inspect a provider scorefinancialScores returns piotroskiScore when availableReconcile the provider definition and missing coverage; do not assume agreement with this worksheet.
Resolve missing inputsReview issuer statements and equity notes alongside Agent outputNet income before extraordinary items, current portion of long-term debt and gross issuance may need explicit reconciliation.
Monitor complete candidatesSave supported symbols in Market Screener; inspect Close / EMA 200 and RSI 14These technical fields do not verify financial statements or supply the F-score.
Review the chartOpen the exact exchange and ticker in TradingViewConfirm chart symbol, timeframe, liquidity and corporate actions before any separate trading decision.
Where Pineify fits

Pineify Market Screener

After the accounting review, create a collection of supported symbols and inspect technical conditions such as Close / EMA 200 and RSI 14. F-score is not a native Market Screener filter.

Also useful: AI Finance Agent. Request annual financial statements and a provider financial score. Verify the nine inputs, dates and issuance evidence against public filings before accepting a company.

Explore Market Screener

Frequently asked questions

Educational information, not investment or accounting advice. Examples use synthetic figures and dates. Historical accounting signals do not guarantee future earnings, solvency or investment returns. Verify filings, reporting definitions and data availability before using a score.

Sources and verification