Year-End Health Scorecard
A year-end health scorecard that turns the accountant pack into liquidity, leverage, profitability, and efficiency lights.
It measures the key ratios from P&L and balance sheet — with desk policy bands and a one-line meaning for each.
Use it to spot the weakest light before the board pack and assign one owner to the lever that moves it.
Your numbers stay in this browser. Export only — nothing is uploaded. Illustrative, not financial advice.
Signal Lab · Model
Year-End Health Scorecard
A year-end health scorecard that turns the accountant pack into liquidity, leverage, profitability, and efficiency lights.
Illustrative SMB sample (Rev 8.4m · NPAT 560k). Currency-agnostic. Not financial advice.
Year-end pack inputs
P&L and balance-sheet lines. Policy bands are editable desk defaults · Jump to results
Scorecard
Stack levels, ratios, and policy traffic lights.
Equations
- Gross → NPAT = Rev − COGS − Opex − DA − Interest − Tax
- Current / Quick / Cash = CA÷CL · (Cash+AR)÷CL · Cash÷CL
- CCC = AR days + Inv days − AP days
| Metric | Value | Light | What it means |
|---|
How this is calculated
- P&L stack Gross = Rev − COGS; EBITDA = Gross − OpexExclDA; EBIT = EBITDA − DA; EBT = EBIT − Interest; NPAT = EBT − Tax
- CA / CL / NWC from cash, AR, inventory, other CA / AP, other CL
- Lights use editable green / amber floors (or ceilings for leverage & CCC)
- AR / Inv / AP days are informational; CCC carries the WC light
Illustrative — not financial advice. Pair with your year-end accountant pack.
Take it with you
Download a prompt or export the Excel workbook from your current inputs.
Takes your current inputs — stays on your device.