Skip to main content

Methodology

How FinSpry calculates each metric, and how errors get fixed

FinSpry takes raw data from providers: financial statements, daily prices, dividend and split history, analyst ratings and ETF holdings. The Data Sources page lists who supplies each dataset. Most of the ratios, margins, returns, dividend figures and scores shown on stock pages are not taken from a provider. FinSpry calculates them from that raw data with the formulas below, so every stock is measured the same way.

Formulas for the same metric differ between websites (TTM versus fiscal year, ending versus average equity, diluted versus basic shares), so our values can differ slightly from other sources. Each section below names the inputs and the choices we made. Metric names link to the financial glossary for a general explanation of what the figure means.

Shared conventions

Trailing twelve months (TTM)

Income statement and cash flow figures (revenue, net income, EBIT, EBITDA, operating cash flow, capital expenditures) are the sum of the four most recent reported quarters. When four quarters are not available, the latest fiscal-year figure is used instead. Growth rates compare the current four quarters with the four before them, so they need eight quarters of history.

Latest balance sheet

Balance sheet items (equity, total assets, debt, cash, current assets and liabilities) are point-in-time values from the most recent reported period. They are not averaged over the year. When more than one provider reports the same period, the records are merged into one, keeping reported values over blanks.

Latest close

Price-based metrics use the most recent daily close stored after each trading session. Quotes at the top of stock pages update during market hours, so a live price can differ from the close behind a ratio on the same day.

Currency

Companies that report in another currency (many ADRs, for example) have their statement figures converted to U.S. dollars at the latest stored exchange rate before any ratio is calculated. Dividends are stored in U.S. dollars.

Update schedule

Daily closing prices load Tuesday to Saturday at 06:05 UTC, covering the previous U.S. session. All calculated metrics are then recomputed at 07:00 UTC on the same days. Exchange rates refresh daily. Dividend records and stock splits are reloaded every Saturday, and financial statements and analyst ratings every Sunday, so the next daily run picks them up.

When a metric is left blank

A metric is left blank rather than estimated when an input is missing, when the denominator is zero, or when a negative denominator would make the result meaningless (for example P/E with a net loss, or ROE with negative equity). A few metrics are deliberately signed instead and noted as such below. Results too large to be real, which usually point to a unit error in the source data, are also left blank.

Plausibility limits

Some limits apply to written summaries only, while tables keep the raw values. Dividend yields above 25% are excluded from "highest yield" statements in page summaries, and market-wide dividend statistics leave out yields above 15%. A 1-year price change above 1,000% is treated in summaries as a reverse split the price history has not adjusted for. Analyst price targets more than 10 times above or below the median target are dropped as decimal errors. When providers report share counts more than 10 times apart for the same period, the count most sources agree on is used.

Dividend history depth

Dividend growth streaks are counted from the stored dividend history, which for most companies starts around the 1970s or 1980s. Streaks longer than that history cannot be confirmed, which is why FinSpry lists Dividend Aristocrats and Champions but has no Dividend Kings (50+ years) list: it would undercount badly.

Valuation

Price-based multiples use the market cap built from the latest close. Most are left blank when the denominator is zero or negative.

Market cap

Market cap = Latest close × Shares outstanding

Shares are the diluted weighted-average count from the most recent income statement, with the balance-sheet count as a fallback. Left blank when the share count is implausible: above 100 billion, or below one tenth of the 30-day average daily volume.

Enterprise value

Enterprise value = Market cap + Total debt − Cash and equivalents

Debt and cash come from the latest balance sheet. A missing debt or cash figure counts as zero.

P/E ratio

P/E = Market cap ÷ Net income (TTM)

Blank when TTM net income is zero or negative.

Forward P/E

Forward P/E = Latest close ÷ (EPS × (1 + Earnings growth))

Earnings growth compares TTM net income with the four quarters before it, capped between −50% and +100%. Requires eight quarters with both periods profitable. Shown only between 0 and 500.

PEG ratio

PEG = P/E ÷ Earnings growth (%)

Earnings growth is TTM net income against the four quarters before it. Shown only when growth is between 0% and 200% and the result is between 0 and 10.

P/S ratio

P/S = Market cap ÷ Revenue (TTM)

Blank when revenue is zero or negative.

Forward P/S

Forward P/S = Market cap ÷ (Revenue (TTM) × (1 + Revenue growth))

Revenue growth compares TTM revenue with the four quarters before it, capped between −30% and +200%. Requires eight quarters and a forward revenue above $1 million.

P/B ratio

P/B = Market cap ÷ Shareholders' equity

Equity comes from the latest balance sheet. Negative equity produces a negative P/B, which is shown rather than hidden.

Price to tangible book

P/TBV = Market cap ÷ (Shareholders' equity − Goodwill − Intangible assets)

Blank when tangible book value is zero or negative.

P/FCF ratio

P/FCF = Market cap ÷ Free cash flow (TTM)

Blank when free cash flow is zero or negative. Price to operating cash flow follows the same rule with operating cash flow.

EV/Sales

EV/Sales = Enterprise value ÷ Revenue (TTM)

Blank when revenue is zero or negative.

EV/EBITDA

EV/EBITDA = Enterprise value ÷ EBITDA (TTM)

Blank only when EBITDA is zero, so negative EBITDA gives a negative multiple. EV/Earnings and EV/FCF use net income and free cash flow the same way.

EV/EBIT

EV/EBIT = Enterprise value ÷ EBIT (TTM)

Blank when EBIT is zero, or when the result is too large to be a real multiple.

Earnings yield

Earnings yield = Net income (TTM) ÷ Market cap × 100

Signed: loss-making companies show a negative yield.

FCF yield

FCF yield = Free cash flow (TTM) ÷ Market cap × 100

Signed: negative free cash flow gives a negative yield.

Profitability and returns

Margins divide a TTM income or cash flow line by TTM revenue and need revenue above zero. Returns divide TTM profit by the latest balance sheet.

Gross margin

Gross margin = Gross profit ÷ Revenue × 100

Both figures are TTM.

Operating margin and EBIT margin

Operating margin = Operating income ÷ Revenue × 100; EBIT margin = EBIT ÷ Revenue × 100

Both figures are TTM. Pretax margin uses pretax income the same way.

EBITDA margin

EBITDA margin = EBITDA ÷ Revenue × 100

Both figures are TTM.

Net profit margin

Net margin = Net income ÷ Revenue × 100

Both figures are TTM.

FCF margin

FCF margin = Free cash flow ÷ Revenue × 100

Both figures are TTM.

Return on equity (ROE)

ROE = Net income (TTM) ÷ Shareholders' equity × 100

Uses ending equity from the latest balance sheet, not the average of opening and closing equity. Blank when equity is zero or negative.

Return on assets (ROA)

ROA = Net income (TTM) ÷ Total assets × 100

Uses ending total assets from the latest balance sheet.

Return on invested capital (ROIC)

ROIC = EBIT × (1 − Tax rate) ÷ (Shareholders' equity + Total debt − Cash) × 100

Tax rate = 1 − Net income ÷ Pretax income, held between 0% and 50%. When pretax income is missing or not positive, 21% is used. Blank when invested capital is zero or negative.

Return on capital employed (ROCE)

ROCE = EBIT (TTM) ÷ (Total assets − Current liabilities) × 100

Blank when capital employed is zero or negative.

Revenue growth

Revenue growth = (Revenue (TTM) − Prior TTM revenue) ÷ Prior TTM revenue × 100

The prior period is the four quarters before the current TTM window. With fewer than eight quarters, the last two fiscal years are compared instead. Blank when prior revenue is zero or negative.

Liquidity and leverage

Balance sheet items come from the most recent reported balance sheet.

Current ratio

Current ratio = Current assets ÷ Current liabilities

Blank when current liabilities are zero or missing.

Quick ratio

Quick ratio = (Current assets − Inventory) ÷ Current liabilities

A missing inventory figure counts as zero.

Total debt

Total debt = Short-term debt + Long-term debt

Blank only when both debt lines are missing.

Debt-to-equity

Debt-to-equity = Total debt ÷ Shareholders' equity

Blank when equity is zero or negative.

Debt/EBITDA and Debt/FCF

Debt/EBITDA = Total debt ÷ EBITDA (TTM); Debt/FCF = Total debt ÷ Free cash flow (TTM)

Uses gross total debt, not net debt. Blank when EBITDA or free cash flow is zero or negative.

Net cash

Net cash = Cash and equivalents − Total debt

Negative when debt exceeds cash. Net cash per share divides this by shares outstanding.

Working capital

Working capital = Current assets − Current liabilities

Converted to USD at the latest exchange rate for non-USD reporters.

Cash flow and per-share figures

Per-share figures divide by the same share count used for market cap.

Free cash flow

Free cash flow = Operating cash flow − Capital expenditures

Both figures are TTM.

Earnings per share (EPS)

EPS = Net income (TTM) ÷ Average diluted shares over the same four quarters

Each quarter reports its own weighted-average diluted count; the four are averaged. Falls back to the latest fiscal year when four quarters are not available.

Book value per share

Book value per share = Shareholders' equity ÷ Shares outstanding

Blank when shares outstanding are missing.

FCF per share

FCF per share = Free cash flow (TTM) ÷ Shares outstanding

Blank when shares outstanding are missing.

Dividends and shareholder returns

Dividend figures are built from the stored dividend history by ex-dividend date. ETFs use the same formulas on their distributions.

Dividend per share

Dividend per share = Sum of dividends with an ex-date in the last 12 months

Zero for securities with no dividend in that window.

Dividend yield

Dividend yield = Dividend per share ÷ Latest close × 100

A trailing yield: it reflects payments already made, not a forecast.

Payout ratio

Payout ratio = Dividend per share ÷ EPS × 100

Capped at 200%. Blank when EPS is zero or negative.

FCF payout ratio

FCF payout ratio = (Dividend per share × Shares outstanding) ÷ Free cash flow (TTM) × 100

Capped at 200%. Blank when free cash flow is zero or negative.

Dividend growth (1 year)

Dividend growth = (Last 12 months of dividends − Prior 12 months) ÷ Prior 12 months × 100

The prior window is 12 to 24 months ago. Blank when nothing was paid in it.

Dividend CAGR (3, 5 and 10 years)

CAGR = (Latest full-year dividends ÷ Full-year dividends N years earlier)^(1 ÷ N) − 1

Uses completed calendar years only; the current partial year is dropped. Needs N + 1 years of history.

Years of dividend growth

Count of consecutive completed calendar years in which the annual regular dividend rate rose

The annual rate is the typical payment times the payment frequency, so one-off specials do not count as raises. The current partial year is excluded.

Buyback yield

Buyback yield = (Shares repurchased − Shares issued) ÷ Market cap × 100

Net of stock issuance, summed over the last four quarters, or the latest fiscal year when quarters are missing.

Shareholder yield

Shareholder yield = Dividend yield + Buyback yield

Blank when either part is missing, rather than treating it as zero.

Dividend score

Score from 0 to 100 = Yield (30) + Payout ratio (25) + 1-year growth (20) + Growth streak (20) + Financial health (5)

Full points for a 2% to 5% yield, a 30% to 75% payout ratio, growth of 10% or more and a streak of 25 years or more. Health points need positive net income and an FCF payout ratio of 80% or less. Only dividend payers are scored.

Scores and fair value estimates

These combine several inputs into one figure. They are rules of thumb from published models, not price targets.

Graham number

Graham number = √(22.5 × EPS × Book value per share)

Blank when EPS or book value per share is zero or negative. Graham upside = (Graham number − Latest close) ÷ Latest close × 100.

Peter Lynch fair value

Lynch fair value = EPS × (Earnings growth (%) + Dividend yield (%))

Earnings growth is P/E ÷ PEG, so the value needs a PEG ratio. Lynch upside = (Fair value − Latest close) ÷ Latest close × 100.

Piotroski F-Score

One point each for: positive net income, positive operating cash flow, higher ROA, operating cash flow above net income, lower or equal long-term debt, higher current ratio, no increase in shares, higher gross margin, higher asset turnover

Compares the latest fiscal year with the one before, so it ranges from 0 to 9.

Altman Z-Score

Z = 1.2 × A + 1.4 × B + 3.3 × C + 0.6 × D + 1.0 × E

A = working capital ÷ total assets, B = retained earnings ÷ total assets, C = EBIT ÷ total assets, D = market cap ÷ total liabilities, E = revenue ÷ total assets. Financials, real estate, technology, communication services, utilities and healthcare use the non-manufacturing version: 6.56 × A + 3.26 × B + 6.72 × C + 1.05 × D, with D based on book equity. Skipped when any input is missing.

Price and technical figures

These use the stored daily price history only.

52-week high and low

Highest daily high and lowest daily low over the last 365 days

The range is widened to include the latest close if a provider reports a close outside it.

Price change

Change = (Latest close − Close on or before the start date) ÷ That close × 100

Calculated for 1 month, 6 months, 1 year, 5 years and 10 years.

50-day and 200-day moving averages

Simple average of the last 50 or 200 daily closes

Trading days, not calendar days.

RSI (14-day)

RSI = 100 − 100 ÷ (1 + Average gain ÷ Average loss)

Averages use Wilder's smoothing over 14 trading days.

Analyst consensus

Which ratings count

The consensus uses ratings issued in the last 90 days, counted back from today. Only the latest rating from each analyst at each firm is kept, so an analyst who revises a call is counted once. Only ratings that map to one of five categories are counted: Strong Buy, Buy (including Outperform and Overweight), Hold (including Neutral and Market Perform), Sell (including Underperform and Underweight) and Strong Sell. Ratings from social, aggregator and editorial sources, and automated model ratings, are excluded so that only professional research counts.

How the consensus label is chosen

Strong Buy needs at least five classified ratings, 60% or more on the buy side, and at least 40% of those buy-side ratings being Strong Buy. Buy needs 50% or more on the buy side. Strong Sell and Sell mirror those rules on the sell side. When no threshold is met, the label follows the largest of the buy, hold and sell groups.

Price targets

The average, median, high and low price targets use positive targets from the same set of ratings. Before they are calculated, any target more than 10 times above or below the median is dropped, because a target that far out is almost always a decimal or unit error in the source. These are third-party forecasts, not FinSpry recommendations.

Corrections

Corrected inputs flow through automatically

Source data is reloaded on every scheduled run, so when a provider fixes a figure the corrected value replaces the old one at the next load. Calculated metrics are never edited by hand. They are recomputed from the stored inputs every day, so one corrected input fixes every figure that depends on it on the next run.

Guards against bad source data

Values that cannot be real, such as cash larger than total assets, share counts above 100 billion or price targets far from the median, are discarded instead of published. The affected metric shows as blank until the source data is fixed.

Renamed and delisted tickers

When a ticker is renamed, merged or delisted, its listing is marked with the date and any successor ticker rather than deleted, and its page shows a notice. Its last data stays available, and delisted listings are removed after 12 months.

Dates and sources on every page

Data blocks on stock and ETF pages state their source and the date of the newest data shown, so you can tell how current a figure is. If you spot an error, see Report a data issue on the Data Sources page.