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