KPI's

Learn how the formulas are calculated for the KPI library

Group - Cash

Cash on Hand

The balance of all accounts that are Bank Account 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 - Revenue

CARR

The annual total of all revenue with a product type of MRR

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

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

OpEx per Employee

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

Group - Expenses

OpEx as % of Revenue

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

Total Expense as % of Revenue

The total of Operations Expenses and other Expenses divided by the Total Revenue

% OpEx by Department

The percentage of OpEx related to each Department

% Total Expense by Department

The percentage of Total Expense related to each Department

Total COGS, OpEx

The total of Cost of Goods Sold and Operational Expenses

Total COGS, OpEx, Total Other

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