ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
ABC Construction - Cash Flow Projection Report
2
3
Category Jan Feb Mar
4
Beginning Balance $ 550,000.00 $ 620,500.00 $ 635,500.00
5
6
Operating Activities
7
Projected Income $ 100,000.00 $ 150,000.00 $ 75,000.00
8
Supplier Payments $ (14,000.00) $ (20,000.00) $ (10,000.00)
9
Subcontractor Payments
$ (25,000.00) $ (50,000.00) $ (25,000.00)
10
Payroll Expenses $ (10,500.00) $ (10,500.00) $ (10,500.00)
11
Interest Expense $ (1,000.00) $ (1,000.00) $ (1,000.00)
12
Tax Expense $ (2,500.00) $ (2,500.00) $ (2,500.00)
13
Office Expenses $ (1,500.00) $ (1,000.00) $ (2,500.00)
14
Operating Activities Total
$ 45,500.00 $ 65,000.00 $ 23,500.00
15
16
Investing Activities
17
Truck Purchase $ 35,000.00 $ - $ 35,000.00
18
Bulldozer Sale $ 10,000.00 $ - $ -
19
Investing Activities Total
$ (25,000.00) $ - $ (35,000.00)
20
21
Financing Activities
22
Sale of Stock $ 200,000.00 $ - $ -
23
Building Lease Payment $ (50,000.00) $ (50,000.00) $ (50,000.00)
24
Dividend Payments $ (100,000.00) $ - $ -
25
Financing Activities Total
$ 50,000.00 $ (50,000.00) $ (50,000.00)
26
27
Net Cash Flow $ 70,500.00 $ 15,000.00 $ (61,500.00)
28
Projected Bank Balance
$ 620,500.00 $ 635,500.00 $ 574,000.00
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