StableBread Logo

Key Financial Ratios (KFR)

Key Financial Ratios (KFR) calculates ~135 ratios, multiples, and metrics derived primarily from the KFS tab.

Kfr: Threshold &Amp; Show Comps Example
KFR: Threshold & Show Comps Example
  • Data coverage: Up to 15 years of annual data, last 9 quarters, TTM, and NTM estimates.
  • Sparkline charts: Y/Y sparkline charts for each metric.
  • Formulas: Each metric's formula is visible in column G.
  • Font colors: Automatically formats green (favorable), red (unfavorable), or black (neutral/not applicable) based on whether the metric improved, declined, or remained unchanged compared to previous period.
  • Threshold pass/fail: Set thresholds for any metric. Three checkbox columns toggle conditional formatting on/off for each section: (1) company financials, (2) min/mean/median/max range (with selectable beginning and ending periods), and (3) comparables.
  • Comparables comparison: Check "Show Comps," select "Comps Med" or "Comps Avg," then choose a period (last 3 FY or TTM). Metrics highlight blue (better) or red (worse) relative to the selected comps median/average.
  • Quality scores: Piotroski F-Score, Altman Z-Score, Beneish M-Score, and Sloan accrual ratios (BS and CF versions) at the bottom. Components viewable via collapsible rows.
chevron-downchevron-down-circle linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram