ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
WORKING CAPITALKPIsForecast vs. Actual vs BenchmarkDSO / DIO / DPO
3
Working Capital as a % of Sales
4
DSO + DIO - DPO
5
Accounts ReceivableOverdue$ total balance of overdue accounts
6
% accounts overdue for collection
7
Termsaverage terms per client/unit/region
8
% clients with payment term exceptions
9
Invoicingnumber of delay days vs. standard
10
Accounts PayableOverdue$ total balance of overdue accounts
11
% accounts overdue for payment
12
Termsaverage terms per client/unit/region
13
% suppliers with payment term exceptions
14
Processing% of accounts paid early
15
$ total value of payments made early
16
InventoryForecast vs. Actual$ inventory balances by type (raw/WIP/FG/transit)
17
Obsolete$ inventory balances written off
18
At Risk$ inventory balances with ptential to be written off
19
20
EXPENDITURESCAPEXForecast vs. Actual$ total spend vs. plan
21
Capex as % of revenue over time
22
COGS$ total spend vs. plan
23
COGS total as % of revenue over time
24
OPEX$ total spend vs. plan
25
OPEX categories as % of revenue over time (SG&A, R&D, Sales, Marketing)
26
27
FINANCIAL HEALTHLiquidityActual vs. BenchmarkCurrent Ratio
28
Quick Ratio (for manufacturers)
29
LeverageTotal Liabilities to Net Worth
30
Funded Debt to EBITDA
31
Debt ServicingFixed Charge Coverage Ratio
32
EBITDA/Interest (if no term debt)
33
EBITDACurrent and Rolling 12 month EBITDA
34
Management Adjusted EBITDA (if applicable)
35
Cash FlowsOperating Cash Flow
36
Investing Cash Flow
37
Financing Cash Flow
38
Free Cash Flow to the Firm
39
Free Cash Flow to Equity
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100