Core Tables

Liquidity Formula Watch
Current CA / CL <1.2 flag
Quick (Cash + AR) / CL Inventory distortion
Cash Cash / CL Payroll coverage
Efficiency Formula Tie
DSO AR / revenue × 365 See Collections
DIO Inv / COGS × 365 See Inventory
DPO AP / COGS × 365 See AP Fraud
Profitability Formula Note
Gross margin (Rev − COGS) / Rev Mix matters
EBITDA margin EBITDA / Rev Add-back discipline — see EBITDA
ROE Net / equity Leverage effect

Pair with Financial Statement Analysis, Cash-Flow Analysis, Cash Forecast, and Going Concern.

Covenant Math

Use agreement definitions, not generic formulas. Model headroom monthly in Month-End Close and link to Debt.

Retain calc packets per PBC and Audit Procedures.

Worked Example: Two Companies, Same Revenue, Different Health

Both do $10m revenue. Company A: AR $1.6m, inventory $2.2m, AP $0.9m, COGS $6m. Company B: AR $0.7m, inventory $0.4m, AP $1.1m, COGS $6m.

Metric A B Read
DSO 58 days 26 days B collects twice as fast — see Collections
DIO 134 days 24 days A carries 4+ months of stock — obsolescence risk, see Inventory
DPO 55 days 67 days B negotiates better terms without strain
Cash conversion cycle 137 days −17 days B is funded by suppliers; A funds its customers + warehouse

Same P&L, opposite liquidity. A needs a revolver to operate; B self-finances growth. This is why lenders price on the cash cycle, not just EBITDA — link the analysis to Debt headroom and Going Concern memos.

Solvency and Returns (Beyond Liquidity)

Ratio Formula Healthy signal
Debt / EBITDA Total debt / EBITDA <3× for most SMBs; covenant-defined
Interest coverage EBIT / interest >3× comfortable; <1.5× distress watch
DSCR Operating cash flow / debt service >1.25× typical covenant floor
ROE Net income / equity Read with leverage — high ROE from thin equity is fragility, not strength
ROA Net income / assets Compares asset efficiency across peers
Gross margin trend Quarterly, by segment Mix shifts explain more than totals

Segment the margins: blended 45% gross margin hiding a 60% SaaS line and a 20% services line misleads pricing decisions. Reconcile ratio inputs to the Month-End Close binder so the board pack and the audit file agree — see PBC.

Traps

  • Annualizing seasonal months without disclosure.
  • EBITDA add-backs without support.
  • Comparing SaaS deferred-heavy to inventory-heavy peers.

FAQ

How many ratios in a board pack?

8-12 with trends and commentary; appendix the rest.

Ratios on forecast validate Burn/Runway and covenant compliance.

Next Steps

  1. Lock 10 ratios with definitions and targets.
  2. Automate from close, not spreadsheets.
  3. Report variance with owner and action.