KPIs

Learn how the formulas are calculated for the KPI library

Group - Cash

Cash on Hand

The balance of all accounts that are Bank Accounts within the General Ledger system

Change in Cash

Current month less prior month Cash on Hand

Runway

Cash on Hand divided by Change in Cash

Zero Cash Date

This month plus Runway

Operating Cash Flow

Total change in period of accounts marked as Operating in the Cash Flow Statement

Investing Cash Flow

Total change in period of accounts marked as Investing in the Cash Flow Statement

Financing Cash Flow

Total change in period of accounts marked as Financing in the Cash Flow Statement

Group - Balance Sheet

Accounts Receivable (A/R)

The balance of all accounts that are Accounts Receivable within the General Ledger system

Accounts Payable (A/P)

The balance of all accounts that are Accounts Payable within the General Ledger system

Group - Workforce

Salary Run Rate

The total period salary forecast based on the Staffing table data

Salary Run Rate Annualized

The total period salary forecast based on the Staffing table data multiplied by 12

Headcount Distribution % & Ratio

The quantity of staff in the respective Department divided by the total staff

Group - Employee

Revenue per Employee

The total of all Revenue accounts in the period divided by the total staff

COGS per Employee

The total of all Cost of Goods Sold accounts in the period divided by the total staff

Gross Margin per Employee

The Gross Margin from the Income Statement in the period divided by the total staff

Operating Income per Employee

The Operating Income from the Income Statement in the period divided by the total staff

Net Income per Employee

The Net Income from the Income Statement in the period divided by the total staff

OpEx per Employee

The total of all Operating Expenses in the period divided by the total staff

Revenue by Salary

Total Revenue in the period divided by Salary

% Salary by Department/Role

Salary of respective Department or role divided by Total Salary

Group - Expenses

OpEx as % of Revenue

The total of all Operating Expenses divided by the total of all Revenue accounts in the period

COGS as % of Revenue

The total of all Cost of Goods Sold divided by the total of all Revenue accounts in the period

Total Expense as % of Revenue

The total of Total Expenses divided by the Total Revenue

% OpEx by Department

The percentage of Operating Expenses related to each Department

% COGS by Department

The percentage of Cost of Goods Sold related to each Department

% Total Expense by Department

The percentage of Total Expenses related to each Department

OpEx as % of Total Expense

The total of all Operating Expenses divided by the total of all Expense accounts in the period

COGS as % of Total Expense

The total of all Cost of Goods Sold divided by the total of all Expense accounts in the period

Total COGS, OpEx

Total of Cost of Goods Sold and Operational Expenses

Total COGS, OpEx, Total Other

Total Cost of Goods Sold, Operational Expenses, and total Other Expenses

COGS, OpEx

Cost of Goods Sold and Operational Expenses

Group - Financial Ratios

Cash as % of Assets

The total of all Cash divided by the total of all Asset accounts in the period

Current Liabilities as % of Liabilities

The total of all Current Liabilities divided by the total of all Liability accounts in the period

Current Ratio

The total of all Current Assets divided by the total of all Current Liabilities in the period

Operating Cash Flow Ratio

The total of Operating Cash Flow divided by the total of all Current Liabilities in the period

Debt Ratio

The total of all Liabilities divided by the total of all Assets in the period

Return on Assets

Net Income divided by the total of all Assets in the period