Skip to content
ruly

Stock analysis template: free Excel spreadsheet and criteria grid

A free stock analysis template for Excel, plus a grid to copy: profitability, balance sheet, cash flow, growth, valuation and qualitative criteria, and where to read them.

A stock analysis template sorts your criteria into six families: profitability, balance sheet strength, cash flow, growth, valuation and qualitative. For each criterion, note whether it is a minimum or a maximum, and where to read the figure in the annual report. Copy the template below, keep two or three criteria per family, then set your thresholds.

How do you download the Excel template?

To start from a ready-made spreadsheet instead of copying the grid by hand, download the stock analysis template for Excel (.xlsx file). It is free, with no sign-up.

  • One tab per preset strategy: Long-term quality, Growing dividend, Value and Reasonable growth.
  • For each criterion, its thresholds, a weight from 1 to 5 that you can change, and where to read the figure.
  • A verdict per criterion, in green, orange or red, then a score out of 100 and a verdict for the sheet.
  • Room for your thesis, your risks and your decision.

The file opens in Excel and LibreOffice. In Google Sheets, use File > Import. What it does not do: keep dated versions. Each tab has a single state, and changing a threshold or a figure overwrites the earlier verdict. In the ruly app, frozen versions keep each analysis with the rule of its date (paid plan).

Why group criteria by family?

Each family answers one question. Profitability: does the company earn a good living? Balance sheet: can it absorb a bad year? Cash flow: does profit turn into cash it can use? Growth: is the business expanding? Valuation: is the asking price reasonable? Qualitative: what do the figures not say?

Grouping shows the gaps and the duplicates. A template with three margins and no debt criterion looks at the same thing three times and ignores financial risk.

How to choose criteria, thresholds and weights is covered in the article on the stock investment checklist. Here is the template itself, ready to copy.

Which profitability criteria belong in the template?

CriterionDirectionWhere to read it
ROIC (Return on Invested Capital)MinimumIncome statement and balance sheet
Operating marginMinimumIncome statement
Gross marginMinimumIncome statement

Take ROIC as an average over 5 to 10 fiscal years, and the margins over the last fiscal year. For a bank or an insurer, these three criteria do not apply: mark them as not applicable.

Which criteria for balance sheet strength?

CriterionDirectionWhere to read it
Net debt / EBITDAMaximumBalance sheet, EBITDA in the management report
Current ratioMinimumBalance sheet
Net cashYes or noBalance sheet

Cash above debt gives a negative net debt / EBITDA. That is a good sign, not a typo.

Which criteria for cash flow?

CriterionDirectionWhere to read it
FCF conversionMinimumCash flow statement and income statement
FCF payout ratioMaximumCash flow statement
Change in diluted share countMaximumBottom of the income statement

FCF is operating cash flow minus capital expenditure. The share count shows where part of that cash goes: down means share buybacks, up means dilution.

Which criteria for growth?

CriterionDirectionWhere to read it
Revenue growth (Revenue CAGR)MinimumTop of the income statement, over 3 to 5 reports
EPS growthMinimumBottom of the income statement
Dividend growth rateMinimumSuccessive annual reports

Use an annual average over 3 or 5 years, never a single year: an acquisition or an exceptional year skews the figure.

Which criteria for valuation?

CriterionDirectionWhere to read it
P/E ratioMaximumEPS in the income statement, and the share price
EV/EBITMaximumEBIT, net debt on the balance sheet, and the share price
FCF yieldMinimumCash flow statement, and the market cap
Dividend yieldRangeDividend per share, and the share price
Margin of safetyMinimumYour own value estimate, and the share price

The share price is not in the annual report: it is the only figure in the template that changes every day. Fill in this family last, once the others are rated.

Which qualitative criteria should you add?

CriterionDirectionWhere to read it
Competitive advantageYes or noManagement report: strategy, competition
Founders or managers own sharesYes or noCorporate governance report or proxy statement
Target market, catalystText, not scoredManagement report, press releases

A yes-or-no criterion gets scored. Free text informs the decision without entering the score. Write down what justifies each yes: a competitive advantage shows up as high and stable margins over several fiscal years.

What thresholds should you set for each criterion?

The template gives the direction, not the threshold. A minimum ROIC of 15% suits a quality-focused strategy, not necessarily a value strategy. To start from common benchmarks, look at the preset strategies: each lists its criteria with their threshold and orange zone. They are starting points to duplicate and adjust, and they do not predict any result.

Preset strategyFamilies most represented
Long-term qualityProfitability, cash flow
Growing dividendCash flow, dividend growth, balance sheet
ValueValuation, balance sheet
Reasonable growthGrowth, valuation

Worked example: the template filled in for Company A

Company A is fictitious: it makes measuring instruments for industry. The template uses the nine criteria of the Long-term quality preset strategy, with its starting thresholds: the first for a criterion met, the second for the orange zone.

CriterionThreshold, then orangeCompany A
Revenue growth, 5 yearsAt least 8%, orange from 4%6%, to monitor
Gross marginAt least 40%, orange from 25%58%, met
Operating marginAt least 20%, orange from 10%22%, met
Average ROIC, 5 to 10 yearsAt least 15%, orange from 10%18%, met
FCF / net income, 5 yearsAt least 90%, orange from 70%92%, met
Net debt / EBITDA1.5 at most, orange up to 32.1, to monitor
Share count, per year0% at most, orange up to 2%Down 1%, met
Price / FCF against its 5-year average0% at most, orange up to 20%12% above, to monitor
Competitive advantageYes expectedYes, met

By family, Company A meets profitability, cash flow and qualitative. It is to monitor on growth, balance sheet and valuation, with one point in each of those three families. With nine criteria of weight 1, that gives 15 points out of 18, a score of 83: “Criteria partly met”.

The template does not tell you what to do with Company A. It shows three figures to track, each in a different family, and no criterion missed.

How does ruly apply your template?

In ruly, a template is called a strategy. You start from one of the four preset strategies, which are read-only, and duplicate it to adapt it, or you start from a blank strategy. Each criterion has a type (“Threshold” as a minimum or a maximum, “Range”, “Yes or no”, “Choice”, “Text (not scored)”), an optional orange threshold and a weight from 1 to 5.

In a preset strategy, each criterion says where to find the figure in the annual report. You enter your figures by hand: ruly provides no market data. Each criterion gets its verdict and the sheet its score. The details are on the Features page.

Frequently asked questions

How many criteria per family?

Two or three. Beyond that, the family weighs more than the others in the score without teaching you anything new. A template of 6 to 12 criteria in total gets filled in completely.

Do you need to cover all six families?

Cover at least profitability, balance sheet and valuation. A template with no price criterion describes the company, not the price you pay. The qualitative family can fit in a single criterion.

Does the template work for a bank?

Not as it stands. Margins, net debt / EBITDA and the current ratio mean little for a bank or an insurer. Replace them with return on equity and price to book, read from the income statement and the balance sheet.

Where do you find a ratio’s historical average?

You can calculate it from past annual reports and the share prices of the time, or read it on a data website under its usual name, for example “Price to Free Cash Flow”. Note the source you used, and keep it for every company you compare.

Start free

Build your strategy, score each stock against your own criteria and note your decision next to the figures.

Free for up to 3 sheets, with no time limit. An email address is all you need, and your sheets stay private.

Read next