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