The KPI Report includes 28 default KPIs under 6 categories. The calculations we use are set out below. Note that there is often no standard definition for these calculations. If you want to calculate any of these ratios differently, it is easy to build your own KPIs and to hide the inbuilt ones.
Overview KPI Calculation Source Favourable Total Sales = Total Sales P&L Higher Gross Profit % = Gross Profit % P&L Higher Overheads % = Overheads / Total Sales P&L Lower Net Profit After Tax = Net Profit After Tax P&L Higher Net Cashflow = Net Cashflow Funds Flow Higher Closing Bank = Closing Bank Funds Flow Higher
Profit Generation KPI Calculation Source Favourable Total Direct Costs = Total Direct Costs P&L Lower Gross Profit = Gross Profit P&L Higher Operating Profit = Operating Profit P&L Higher EBITDA = EBITDA P&L Higher EBIT = EBIT P&L Higher Operating Profit & = Operating Profit & P&L Higher EBITDA % = EBITDA % P&L Higher EBIT % = EBIT % P&L Higher NPAT % = NPAT % P&L Higher
Cashflow KPI Calculation Source Favourable Cashflow from Operations = Cashflow from Operations Funds Flow Higher Cash Conversion Ratio = Cashflow from Operations / Net Profit After Tax Funds Flow / P&L Higher
Working Capital KPI Calculation Source Favourable Working Capital = (Trade & Other Debtors + Inventory + Prepayments) - (Trade & Other Payables + Staff Payables + Taxes Payable + Provisions) Balance Sheet Lower Trade Debtors = Trade & Other Debtors Balance Sheet Lower Inventory = Inventory Balance Sheet Lower Trade Payables = Trade Payables Balance Sheet Lower Debtor Days = 90 x Trade Debtors / Rolling 3 month Sales) Balance Sheet / P&L Lower Inventory Days = 90 x Inventory / Rolling 3 month COGS) Balance Sheet / P&L Lower
Funding KPI Calculation Source Favourable Total Funding = Current Finance + Non Current Finance Balance Sheet Higher Quick Ratio = (Bank Accounts + Trade & Other Debtors + Current Investments) / Current Liabilities Balance Sheet Higher Current Ratio = Current Assets / Current Liabilities Balance Sheet Higher
Leverage KPI Calculation Source Favourable Debt to Equity = Total Liabilities / Equity Balance Sheet Higher Debt to Total Assets = Total Liabilities / Total Assets Balance Sheet Higher
