Financial KPIs: 25 that finance teams report, with the formula for each and one company worked through

Financial KPIs are the measures a company chooses to judge its financial performance: growth, profitability, returns, liquidity, working capital, leverage and cash. Below are 25 of them with the formula for each, all computed on one company with revenue of $24,000,000, so you can rebuild every figure and see how they tie together.

What makes a financial KPI a KPI

Any ratio from the accounts is a metric. It becomes a key performance indicator when the company picks it, sets a target, names an owner and acts when it misses. Current ratio is a metric in a textbook; it is a KPI at a company whose lender requires it to stay above 1.25. The distinction is set out in KPI vs metric vs measure.

The second requirement is a written definition. When US public companies disclose a KPI in MD&A, the SEC expects "a clear definition of the metric and how it is calculated", and if the calculation changes, disclosure of what changed. Internal KPIs deserve the same: one formula, written down, used every period.

For KPIs across sales, operations, procurement and service, see the 60 KPI examples by team. This page covers the finance set in depth.

The 25 financial KPIs, grouped

The ratio formulas follow the standard definitions in the CFA Institute's reading on financial analysis techniques. ROCE has more than one definition in use; this page uses total assets less current liabilities, which equals equity plus debt in the example below.

One company, every figure computed

One year, in millions of dollars. Year-end balances are used to keep the arithmetic visible; averages of opening and closing balances are more accurate when balances move during the year.

The P&L: gross profit 24.0 - 14.4 = 9.6; EBITDA 9.6 - 5.4 = 4.2; EBIT 4.2 - 0.8 = 3.4; income before taxes 3.4 - 0.4 = 3.0; income tax 0.75; net income 2.25. Current assets are 1.8 + 3.6 + 1.8 = 7.2 and current liabilities 2.4 + 2.4 = 4.8.

The cash conversion cycle is computed from the unrounded day counts; adding the rounded ones gives 39.6. The depth on single KPIs is on their own pages: gross profit margin, EBITDA margin and days sales outstanding.

In Excel, with revenue in B2, cost of sales in B3 and receivables in B10, gross margin is =(B2-B3)/B2 and DSO is =B10/B2*365. Keep each formula in one named cell and point every report at it.

How the KPIs connect

Twenty-five KPIs from one set of accounts are not independent. Three identities prove the set was computed consistently.

ROA = net margin × asset turnover. Asset turnover is 24.0 / 19.8 = 1.212. Then 9.375% × 1.212 = 11.4%, the same as 2.25 / 19.8.

ROE = ROA × equity multiplier. The equity multiplier is 19.8 / 10.0 = 1.98. Then 11.36% × 1.98 = 22.5%, the same as 2.25 / 10.0. This is the DuPont breakdown: ROE is high here because the company earns a fair margin, turns its assets over 1.2 times and funds half its assets with liabilities.

CCC = DSO + DIO - DPO. 54.75 + 45.63 - 60.83 = 39.5 days. If DSO falls by ten days, the cycle falls by ten days and working capital falls by 24.0 × 10 / 365 = 0.66, about $660,000 of cash released.

Two more ties: the balance sheet balances (4.8 + 5.0 + 10.0 = 19.8), and capital employed for ROCE, 19.8 - 4.8 = 15.0, equals equity plus debt. If your KPIs fail these checks, some were computed from different periods or different definitions.

Choosing the eight for your dashboard

Twenty-five is the reference list; a dashboard holds about eight. Pick by reader:

A sales-led company adds commercial measures beside them, such as pipeline coverage and customer retention. The rest of the 25 stay in the monthly reporting package, where they are there when someone asks.

EBITDA, net debt to EBITDA and free cash flow are not US GAAP measures. A public company that presents EBITDA must calculate it from net income as presented under GAAP and reconcile it to net income under the SEC's non-GAAP rules; anything adjusted further is "Adjusted EBITDA". Internally, write down the definition anyway.

Where it goes wrong

• Mixed balances. Year-end balances in one KPI and averages in another, so ROA no longer equals net margin times asset turnover and the set does not tie.
• All 25 on the dashboard. Choose about eight and keep the rest in the reporting package; a dashboard of 25 tiles is read as none.
• Undefined EBITDA. Two teams compute it differently, one before and one after a restructuring charge, and both are called EBITDA.
• Cross-company comparison without adjusting. Lease accounting, capitalized development costs and inventory method change the ratios with no change in the business.
• No owner, no target. A KPI without either is a metric: it gets read and not acted on.

Computing them from your own files

Twenty-five KPIs from one set of accounts must tie together. Covirage's tools compute each from your ledger exports under one versioned definition and check the identities; the external AI model explains the movement and never does the arithmetic. See FP&A reporting for every KPI computed from one set of definitions, in the reporting package and in the answers to follow-up questions. For the profitability and liquidity ratios worked over two years, see financial ratios; for single measures in depth, return on assets and revenue per employee.