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 Custom 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

If you need any assistance please contact our support team at: support@castawayforecasting.com