Browse KPI formulas
Each page includes a business formula, Excel formula, example table, and reporting tips.
Gross Margin
(Revenue - Cost of Goods Sold) / Revenue
📊Net Profit Margin
Net Profit / Revenue
📊Operating Margin
Operating Income / Revenue
📊EBITDA Margin
EBITDA / Revenue
📊Revenue Growth Rate
(Current Revenue - Previous Revenue) / Previous Revenue
📊Expense Ratio
Total Expenses / Revenue
📊Current Ratio
Current Assets / Current Liabilities
📊Quick Ratio
(Cash + Marketable Securities + Receivables) / Current Liabilities
📊Debt-to-Equity Ratio
Total Debt / Total Equity
📊Return on Assets
Net Income / Total Assets
📊Return on Equity
Net Income / Shareholder Equity
📊Return on Investment
(Gain - Cost) / Cost
📊Break-even Units
Fixed Costs / (Price per Unit - Variable Cost per Unit)
📊Burn Rate
Cash Spent During Period / Number of Months
📊Cash Runway
Cash Balance / Monthly Burn Rate
📊Working Capital
Current Assets - Current Liabilities
📊Accounts Receivable Turnover
Net Credit Sales / Average Accounts Receivable
📊Days Sales Outstanding
Accounts Receivable / Revenue × Days
📊Budget Variance
Actual - Budget
📊Budget Variance Percent
(Actual - Budget) / Budget