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 default 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.
Year-End Health Scorecard
A year-end health scorecard that turns the accountant pack into liquidity, leverage, profitability, and efficiency lights.
Sample figures (Rev 8.4m · NPAT 560k). Currency-agnostic.
Year-end pack inputs
P&L and balance-sheet lines. Policy bands are editable 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
Get the worked example workbook in Excel — type your own numbers into it.
The Excel is the worked example workbook — type your own numbers into it. Stays on your device.