Measurable key performance indicators (KPIs) for finances.

Table of Contents

Financial measures are the most frequently used metrics in many organizations.  They are at the top of a for profit Balanced Scorecard and often serve as the foundation for government and nonprofit scorecards.


We get questions all the time about the best way to ensure you’re on track with your finances.  While it’s true that your measures should support on your strategy, it’s true that some measures are better than others.  Keep in mind that you should have a balance of customer, process, and HR measures as well.  (Click on the links to check out our customer measure library, our process KPI library, and our key HR metrics.).

Many organizations consider financial performance indicators to be the ultimate outcome measure—for good reason. They are very important to monitor, and because every company uses them, they’re great for comparing how you’re doing against your competition. To give you a leg up, we’ve compiled this library of 68 important financial KPIs and scorecard measures that you may want to consider implementing.

Note: We’re not suggesting nor advocating for you to begin measuring all of these KPIs. Rather, you can use this extensive list to get an idea of what like-minded organizations may be looking at, then research KPIs from other lists, and decide upon the critical few that are in line with your strategy.

Cash Flow KPIs

  1. Working Capital: Measures an organization's financial health by analyzing readily available resources that could be used to meet any short-term obligations.
  2. Operating Cash Flow: The amount of cash generated by regular business operations.
  3. Cash Rotation (365/Cash Cycle): The number of times the cash comes back to the organization for a period of one year.
  4. Cash Flow from Investing Activities: Shows the change in an organization's cash position caused by investments, gains, or losses.
  5. Cash Flow from Financing Activities: Demonstrates an organization's financial strength. Formula: (Cash Received from Issuing Stock or Debt) - (Cash Paid as Dividends and Reacquisition of Debt/Stock) = (Cash Flow from Financing Activities)
  6. Cash Flow: The total amount of money being transferred into and out of an organization.
  7. Cash Conversion Cycle: Demonstrates the amount of time it takes for money invested in the organization to come back to the organization in the form of increased revenue.
  8. Accounts Receivable Turnover: The rate at which an organization collects on outstanding accounts. Formula: (Net Credit Sales) / (Average Accounts Receivable) = (Accounts Receivable Turnover)
  9. Accounts Receivable: The amount of money an organization is owed by its customers.
  10. Accounts Payable Turnover: The rate at which an organization pays off suppliers and other expenses. Formula: (Total Supplier Purchases) / (Average Accounts Payable) = (Accounts Payable Turnover)
  11. Accounts Payable: Shows the amount of money an organization owes its suppliers.
  12. Number/Percentage of Invoices Past Due: Invoices that remain unpaid after their due date.

Cost KPIs

  1. Total Expenses: Consists of the total costs an organization incurs during a reporting period (including marketing, sales, and operations costs).
  2. SG&A: The costs of operating an organization—including selling, and general and administrative expenses—are collectively referred to as SG&A.
  3. Sales Expense: Costs incurred by the sales department—including salaries and commissions.
  4. Marketing Expenses: Encompasses the total costs incurred by the marketing department, including advertising, salaries, research, and surveys.
  5. Inventory Turnover: The number of times an organization is able to sell off its in-stock inventory in a given period. Formula: (Sales) / (Inventory) = (Inventory Turnover)
  6. Cost Per Unit: The price to produce, store, and sell one unit of a particular product including fixed and variable costs of production. Formula: ([Variable Cost] + [Fixed Cost]) / (Number of Units Produced) = (Cost Per Unit)
  7. Cost Per Hire: The average cost of hiring a new employee, including advertising fees, employee referrals, travel expenses, relocation expenses, and recruiter costs. Formula: (New Hire Expenses) / (Number of New Hires) = (Cost Per Hire)
  8. Cost of Goods Sold (COGS): Represents the cost of materials and direct labor used to produce a good.
  9. Average Annual Expenses to Serve One Customer: This is the average amount needed to serve one customer. Formula: (Total Expenses) / (Total Customers) = (Average Annual Expenses to Serve One Customer)
  10. Customer Acquisition Cost: The cost to acquire one new customer.
  11. Cost per Click: Measures the cost of a pay-per-click advertising campaign (such as Google AdWords).
  12. Percentage of Cost of Workforce: The cost of the workforce as compared to all costs can be measured by summing all salaries and dividing by the total company costs within a given time period. Formula: (Salary Costs) / (Total Company Costs) = (Percentage of Cost of Workforce)
  13. Health Care Expense per Current Employee: The total price of health care costs divided out among all employees provides an understanding of the comprehensiveness of a company's health care plan.

Debt KPIs

  1. Quick Ratio (“Acid Test”): Shows the ability of an organization to meet any short-term financial liabilities, such as upcoming bills. Formula: ([Current Assets] - [Inventories]) / (Current Liabilities) = (Quick Ratio)
  2. Price-Earnings Ratio (P/E): An equity valuation multiple that compares an organization's share price to its per-share earnings. Formula: (Market Value Per Share) / (Earnings Per Share) = (Price-Earnings Ratio)
  3. Debt to Equity Ratio: Measures how an organization is funding its growth and using shareholder investments. Formula: (Total Liabilities) / (Shareholders’ Equity) = (Debt to Equity Ratio)
  4. Debt Level: The amount of debt that an organization currently has.
  5. Current Ratio: Measures the ability of an organization to pay all of its debts over a given time period. Formula: (Current Assets) / (Current Liabilities) = (Current Ratio)
  6. Bad Debt: Debt that is not collectible, and is often written off as an expense.

Investment KPIs

  1. Savings Levels Due to Improvement Efforts: Many organizations look at investing in improvements, or merging operations (or even companies). This KPI looks at the dollar value of the savings achieved as a result of these investments.
  2. Return on Innovation Investment: Can be calculated by looking at the revenue from new products, or the number of new products meeting a revenue threshold. This is typically only reviewed by organizations that have created an innovation department or budget.
  3. Inventory Assets: The cost of merchandise purchased or manufactured, but not yet sold, may be a good leading indicator of preparedness for growth or even slowing growth.
  4. Innovation Spending: The amount of money that an organization spends on innovation. Some organizations have this budgeted as research and development, and others have different accounting terms. Ultimately, if you use this measure, you are valuing innovation as a key strategic thrust.
  5. Break Even Time: The time it takes an organization to break even from its investment in a new product or process. If the costs are big up front, this measure can help you understand how long it will take to recoup these expenses.
  6. Percentage of Investment in…: Used for measuring investments in different lines of business. You might measure the percentage of your investment in organic products vs. total investment in products overall. Formula: (Amount of Investment) / (Total Capital Spent) = (Percentage of Investment)
  7. Number of Key Capital Investments that Meet or Exceed ROI Expectations: Can be based on the plan for investments, or on the results of past investments. Useful for organizations that invest in many capital projects.

Profitability KPIs

  1. Sales Growth: The change in an organization's sales from one reporting period to another. Formula: ([Current Sales] - [Past Sales]) / (Past Sales) = (Sales Growth)
  2. ROI (Return on Investment): Shows the efficiency of an investment. Formula: ([Gain from Investment] - [Cost of Investment]) / (Cost of Investment) = (ROI)
  3. ROE (Return on Equity): The amount of net income an organization generates compared to the amount of shareholders’ equity. Formula: (Net Income) / (Shareholders’ Equity) = (ROE)
  4. ROA (Return on Assets): Indicates how profitable an organization is relative to its total assets. Formula: (Net Income) / (Total Assets) = (ROA)
  5. Return on Capital Employed: Measures an organization's profitability and the efficiency with which its capital is employed.
  6. Program Profitability: Tracks the profitability of an individual program.
  7. Operating Profit Margin: Measures income after variable costs of production are considered. Formula: (Operating Income) / (Net Sales) = (Operating Profit Margin)
  8. Net Profit Margin: The percentage of an organization's revenue that is net profit. Formula: (Net Profit) / (Revenue) = (Net Profit Margin)
  9. Net Profit: The amount of money an organization makes after taking out all expenses and other costs. Formula: (Income) - (Expenses) = (Net Profit)
  10. Gross Profit Margin: The percentage of revenue that is profit after the cost of production and sales is considered. Formula: (Gross Margin) / (Revenue) = (Gross Profit Margin)
  11. Gross Profit: An organization's profit after the cost of production and sales is considered. Formula: (Revenue) - (COGS) = (Gross Profit)
  12. Economic Value Added (EVA): An estimate of an organization's economic profit.
  13. Average Capital Employed: Shows profitability compared to investments made in new capital.
  14. Customer Lifetime Value: The net profit an organization anticipates gaining from a customer over the entire length of a relationship helps to determine the costs/benefits of acquisition efforts.
  15. (Customer Lifetime Value) / (Customer Acquisition Cost): The ratio of customer lifetime value to customer acquisition cost should ideally be greater than one, as a customer is not profitable if the cost to acquire is greater than the profit they will bring to a company. Formula: (Net Expected Lifetime Profit from Customer) / (Cost to Acquire Customer)
  16. Human Capital Value Added (HCVA): By taking all non-employee related costs away from the revenue and dividing the result by the number of full-time employees, one can deduce how profitable the average worker in an organization is. Formula: ([Revenue] - [Non-Employee-Related Costs]) / (Number of Full-Time Employees) = (HCVA)

Revenue KPIs

  1. Sales Volume: The amount of sales in a reporting period, expressed in the number of units sold.
  2. Sales Forecast Accuracy: The proximity of the forecasted quantity of sales to the actual quantity of sales.
  3. ROI of Research & Development: The revenue generated by investing money into research and development. Formula: ([Gain from Investment] - [Cost of Investment]) / (Cost of Investment) = (ROI of Research & Development)
  4. Revenue per Full-Time Employee (FTE): Demonstrates how expensive an organization is to run. Formula: (Revenue) / (Number of FTE) = (Revenue per FTE)
  5. Revenue Growth Rate: The rate at which an organization's income is increasing. Formula: ([Current Revenue] - [Past Revenue]) / (Past Revenue) = (Revenue Growth Rate)
  6. Revenue: The total income an organization receives. Formula: (Price of Goods) x (Number of Goods Sold) = (Revenue)
  7. Operating Income: The profit from operations after removing operating expenses. Formula: (Gross Income) - (Operating Expenses) - (Depreciation & Amortization) = (Operating Income)
  8. Net Income: The amount of sales after subtracting discounts, returns, and damaged goods. Formula: (Revenue) - (Expenses) = (Net Income)
  9. EBT (Earning Before Taxes): Shows how much an organization has made after considering COGS, interest, and SG&A expenses, before taxes are subtracted. Formula: (Revenue) - (COGS) - (Interest) - (SG&A) = (EBT)
  10. EBITDA (Earnings Before Interest, Taxes, Depreciation & Amortization): Measures revenue after expenses are considered and interest, taxes, depreciation and amortization are excluded. Formula: (Revenue) - (Expenses Excluding Interest, Tax, Depreciation & Amortization) = (EBITDA)
  11. Average Annual Sales Volume per Customer: This is the average amount of sales per customer, expressed in currency. Formula: (Total Sales) / (Total Customers) = (Average Annual Sales Volume per Customer)
  12. Asset Utilization: Total revenue earned for every dollar of assets an organization owns. Formula: (Total Revenue) / (Total Assets) = (Asset Utilization)
  13. Share of Wallet: Measures the portion of a customer's total spending that goes toward the company's products and services.
  14. Earnings Before Interest and Taxes (EBIT): An indicator of a company's profitability with expenses removed and interest and tax excluded. Formula: (Revenue) - (COGS) - (Operating Expenses) = (EBIT)

FAQ:

What are financial KPIs?

Financial Key Performance Indicators (KPIs) are specific metrics used to measure and track a company's financial performance and health. They provide insights into various aspects of the business, such as profitability, liquidity, efficiency, and solvency.

How do you measure financial KPIs?

Financial KPIs are typically measured using quantitative data derived from the company's financial statements, including the income statement, balance sheet, and cash flow statement. Calculations may involve simple formulas (e.g., profit margin = net income / revenue) or more complex financial ratios (e.g., return on equity, current ratio). The frequency of measurement depends on the KPI and the company's needs, ranging from daily to annually.

How do you create a financial KPI dashboard in Excel?

To create a financial KPI dashboard in Excel, follow these steps:

- Identify Key Metrics: Determine the most relevant financial KPIs for your business.
- Gather Data: Collect the necessary data from financial statements or other sources.
- Create Tables/Charts: Use Excel's charting tools to visualize the data (e.g., line graphs for trends, bar charts for comparisons).
- Organize Layout: Arrange the tables and charts in a clear and intuitive dashboard format.
- Add Context: Include labels, titles, and brief explanations to help users interpret the data.
- Update Regularly: Ensure the dashboard is updated with the latest data to maintain its relevance.

What is a financial KPI?

A financial KPI is a specific metric that measures a company's financial performance. Examples include:

- Revenue: Total income generated from sales or services.
- Net Profit Margin: Percentage of revenue remaining after all expenses are deducted.
- Return on Investment (ROI): Measures the profitability of an investment relative to its cost.
- Debt-to-Equity Ratio: Indicates the proportion of debt used to finance a company's assets.
- Operating Cash Flow: Cash generated from a company's core business operations.

What is a non-financial KPI?

Non-financial KPIs are metrics that measure aspects of a company's performance not directly related to finances. They can be quantitative (e.g., customer satisfaction rating, employee turnover rate) or qualitative (e.g., brand reputation, employee morale). Non-financial KPIs often provide insights into the drivers of financial performance and help organizations understand their overall health and success.