ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
BasePoint CPA Cash Conversion Cycle Calculator
2
3
Indicates Fillable Field
4
5
Daily RevenueUsage (CCC)Cash Needed
As Percent of Revenue
6
Revenue For The Period 2,000,000 5,479.45 x DIO 23.1 35.3 = 193,333.33 9.7%
7
 Add
8
DSO 36.5
9
 Less
10
DPO 24.3
11
12
13
Days Inventory Outstanding (DIO)(Avg Inventory / COGS) x Period in Days 23.1
14
Days Sales Outstanding (DSO)
(Avg AR / Total Credit Sales) x Period in Days
 36.5
15
Days Payables Outstanding (DPO)
(Avg AP / COGS) x Period in Days 24.3
16
Cash Conversion CycleDIO + DSO - DPO 35.3
17
18
Period Length365Days
19
For the noted period length
20
Avg Inventory and/or WIP 95,000
21
Avg Accounts Receivable 200,000
22
Avg Accounts Payable 100,000
23
Total Credit Sales 2,000,000
24
Cost of Goods Sold 1,500,000
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
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