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?
| Criterion | Direction | Where to read it |
|---|---|---|
| ROIC (Return on Invested Capital) | Minimum | Income statement and balance sheet |
| Operating margin | Minimum | Income statement |
| Gross margin | Minimum | Income 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?
| Criterion | Direction | Where to read it |
|---|---|---|
| Net debt / EBITDA | Maximum | Balance sheet, EBITDA in the management report |
| Current ratio | Minimum | Balance sheet |
| Net cash | Yes or no | Balance sheet |
Cash above debt gives a negative net debt / EBITDA. That is a good sign, not a typo.
Which criteria for cash flow?
| Criterion | Direction | Where to read it |
|---|---|---|
| FCF conversion | Minimum | Cash flow statement and income statement |
| FCF payout ratio | Maximum | Cash flow statement |
| Change in diluted share count | Maximum | Bottom 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?
| Criterion | Direction | Where to read it |
|---|---|---|
| Revenue growth (Revenue CAGR) | Minimum | Top of the income statement, over 3 to 5 reports |
| EPS growth | Minimum | Bottom of the income statement |
| Dividend growth rate | Minimum | Successive 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?
| Criterion | Direction | Where to read it |
|---|---|---|
| P/E ratio | Maximum | EPS in the income statement, and the share price |
| EV/EBIT | Maximum | EBIT, net debt on the balance sheet, and the share price |
| FCF yield | Minimum | Cash flow statement, and the market cap |
| Dividend yield | Range | Dividend per share, and the share price |
| Margin of safety | Minimum | Your 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?
| Criterion | Direction | Where to read it |
|---|---|---|
| Competitive advantage | Yes or no | Management report: strategy, competition |
| Founders or managers own shares | Yes or no | Corporate governance report or proxy statement |
| Target market, catalyst | Text, not scored | Management 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 strategy | Families most represented |
|---|---|
| Long-term quality | Profitability, cash flow |
| Growing dividend | Cash flow, dividend growth, balance sheet |
| Value | Valuation, balance sheet |
| Reasonable growth | Growth, 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.
| Criterion | Threshold, then orange | Company A |
|---|---|---|
| Revenue growth, 5 years | At least 8%, orange from 4% | 6%, to monitor |
| Gross margin | At least 40%, orange from 25% | 58%, met |
| Operating margin | At least 20%, orange from 10% | 22%, met |
| Average ROIC, 5 to 10 years | At least 15%, orange from 10% | 18%, met |
| FCF / net income, 5 years | At least 90%, orange from 70% | 92%, met |
| Net debt / EBITDA | 1.5 at most, orange up to 3 | 2.1, to monitor |
| Share count, per year | 0% at most, orange up to 2% | Down 1%, met |
| Price / FCF against its 5-year average | 0% at most, orange up to 20% | 12% above, to monitor |
| Competitive advantage | Yes expected | Yes, 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.
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.