Start here: what these KPIs are for
Finance KPIs help you understand profitability, cash flow, liquidity, debt, and whether the business is creating value after costs.
Use these pages when you need to explain a KPI to a beginner, build it in Excel, validate the inputs, or recreate the same logic in Power BI. Each page includes a plain-English definition, real-life example, Excel formula, DAX measure, interpretation notes, and common mistakes.
Finance KPI list
Accounts Receivable Turnover
Net Credit Sales / Average Accounts Receivable
💰Break-even Units
Fixed Costs / (Price per Unit - Variable Cost per Unit)
💰Budget Variance
Actual - Budget
💰Budget Variance Percent
(Actual - Budget) / Budget
💰Burn Rate
Cash Spent During Period / Number of Months
💰Cash Runway
Cash Balance / Monthly Burn Rate
💰Current Ratio
Current Assets / Current Liabilities
💰Days Sales Outstanding
Accounts Receivable / Revenue × Days
💰Debt-to-Equity Ratio
Total Debt / Total Equity
💰EBITDA Margin
EBITDA / Revenue
💰Expense Ratio
Total Expenses / Revenue
💰Gross Margin
(Revenue - Cost of Goods Sold) / Revenue
💰Net Profit Margin
Net Profit / Revenue
💰Operating Margin
Operating Income / Revenue
💰Quick Ratio
(Cash + Marketable Securities + Receivables) / Current Liabilities
💰Return on Assets
Net Income / Total Assets
💰Return on Equity
Net Income / Shareholder Equity
💰Return on Investment
(Gain - Cost) / Cost
💰Revenue Growth Rate
(Current Revenue - Previous Revenue) / Previous Revenue
💰Working Capital
Current Assets - Current Liabilities
How to use these KPI formulas
- Pick one KPI and confirm the business definition.
- Add the inputs to a clean Excel table, one row per period or segment.
- Paste the formula from the KPI page and format the result correctly.
- Add a target or benchmark column so the number has context.
- Link related KPIs together instead of judging one metric alone.