ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Working Capital: The Impact of WC on a growing company
2
BASELINE
3
EBITDA$500,000
4
Negative WCLow WCHigh WC
5
Company ACompany BCompany C
6
Cash $ 100,000 $ 100,000 $ 100,000
7
AR $ 150,000 $ 150,000 $ 950,000
8
Inventory $ 50,000 $ 100,000 $ 600,000
9
Current Assets $ 300,000 $ 350,000 $ 1,650,000
10
11
Deferred Revenue $ 200,000 $ -
12
AP $ 150,000 $ 150,000 $ 150,000
13
Current Liabilities $ 350,000 $ 150,000 $ 150,000
14
15
Working Capital $ (50,000) $ 200,000 $ 1,500,000
16
Less Cash $ 100,000 $ 100,000 $ 100,000
17
Net Working Capital $ (150,000) $ 100,000 $ 1,400,000
18
19
THE COMPANY GROWS 50% (REV + EBITDA)
50%
20
EBITDA after growth $ 750,000
21
(All WC accounts also go up by 50%)
22
Negative WCLow WCHigh WC
23
Company ACompany BCompany C
24
Cash $ 150,000 $ 150,000 $ 150,000
25
AR $ 225,000 $ 225,000 $ 1,425,000
26
Inventory $ 75,000 $ 150,000 $ 900,000
27
Current Assets $ 450,000 $ 525,000 $ 2,475,000
28
29
Deferred Revenue $ 300,000 $ - $ -
30
AP $ 225,000 $ 225,000 $ 225,000
31
Current Liabilities $ 525,000 $ 225,000 $ 225,000
32
33
Working Capital $ (75,000) $ 300,000 $ 2,250,000
34
Less Cash $ 150,000 $ 150,000 $ 150,000
35
Net Working Capital $ (225,000) $ 150,000 $ 2,100,000
36
37
(Increase)/Decrease in WC $ 75,000 $ (50,000) $ (700,000)
38
39
Increase in EBITDA $ 250,000 $ 250,000 $ 250,000
40
EBITDA + (Increase)/Decrease in WC
$ 325,000 $ 200,000 $ (450,000)
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