Excel formulas
Finance KPI Excel Formulas
Copy Excel formulas for common finance KPIs and adapt them for your spreadsheet or dashboard.
Affiliate resources
Ideas for You
Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.
Finance Excel KPI books
Books that help you understand Finance Excel KPI and related business metrics more deeply.
Explore resources →
Finance Excel KPI audiobooks
Audiobook searches for learning Finance Excel KPI while commuting, walking, or working.
Explore resources →
Financial modeling Excel resources
Excel-focused resources for building KPI trackers and dashboard workflows.
Explore resources →
Business valuation resources
Practical resources for turning Finance Excel KPI into reports, dashboards, and business decisions.
Explore resources →
Finance formulas for Excel
| KPI | Formula | Excel |
|---|---|---|
| Gross Margin | (Revenue - Cost of Goods Sold) / Revenue | =IFERROR((B2-C2)/B2,0) |
| Net Profit Margin | Net Profit / Revenue | =IFERROR(B2/C2,0) |
| Operating Margin | Operating Income / Revenue | =IFERROR(B2/C2,0) |
| EBITDA | Net Income + Interest + Taxes + Depreciation + Amortization | =SUM(B2:F2) |
| EBIT | Revenue - Operating Expenses | =B2-C2 |
| Revenue Growth Rate | (Current Period Revenue - Previous Period Revenue) / Previous Period Revenue | =IFERROR((B2-C2)/C2,0) |
| Free Cash Flow | Operating Cash Flow - Capital Expenditures | =B2-C2 |
| Cash Conversion Cycle | DIO + DSO - DPO | =B2+C2-D2 |
| Return on Equity | Net Income / Shareholders’ Equity | =IFERROR(B2/C2,0) |
| Return on Assets | Net Income / Total Assets | =IFERROR(B2/C2,0) |
| Return on Invested Capital | NOPAT / Invested Capital | =IFERROR(B2/C2,0) |
| WACC | (E/V × Re) + (D/V × Rd × (1 - Tax Rate)) | =IFERROR((B2/(B2+C2))*D2+(C2/(B2+C2))*E2*(1-F2),0) |
| Debt-to-Equity Ratio | Total Debt / Total Equity | =IFERROR(B2/C2,0) |
| Current Ratio | Current Assets / Current Liabilities | =IFERROR(B2/C2,0) |
| Quick Ratio | (Cash + Marketable Securities + Accounts Receivable) / Current Liabilities | =IFERROR((B2+C2+D2)/E2,0) |
| Interest Coverage Ratio | EBIT / Interest Expense | =IFERROR(B2/C2,0) |
| Working Capital | Current Assets - Current Liabilities | =B2-C2 |
| Burn Rate | Cash Spent per Month | =B2-C2 |
| Runway | Cash Balance / Monthly Burn Rate | =IFERROR(B2/C2,0) |