Sample Cash Flow Budget Template

ADVERTISEMENT

Sample Cash Flow Budget
Total
January
February
March
April
May
June
Budget
(actual)
(projected)
(projected)
(projected)
(projected)
(projected)
EXPECTED
REVENUES
Government
Grants
$
35,000
$
12,000
$
4,000
$ 16,000
Foundation
Grants
$
50,000
$
5,000
$
7,500
$
15,000
Individuals
$
12,000
$
1,500
$ 30,000
Fees for Service
$
55,000
$ 3,000
$
4,500
$
4,500
$
5,000
$
5,000
$
3,000
Total Revenue
$
152,000
$ 3,000
$
9,500
$
6,000
$
24,500
$
24,000
$ 49,000
EXPECTED
EXPENSES
Salaries &
Fringe Benefits
Executive
Director
$
38,000
$ 3,167
$
3,167
$
3,167
$
3,167
$
3,167
$
3,167
Program
Directors
$
50,000
$ 4,167
$
4,167
$
4,167
$
4,167
$
4,167
$
4,167
Secretary
$
27,000
$ 2,250
$
2,250
$
2,250
$
2,250
$
2,250
$
2,250
Rent
$
12,000
$ 1,000
$
1,000
$
1,000
$
1,000
$
1,000
$
1,000
Supplies
$
11,000
$ 5,000
$
6,000
Telephone
$
3,300
$
300
$
250
$
300
$
500
$
350
$
250
Postage
$
2,500
$
150
$
150
$
150
$
1,500
$
150
$
150
Copying
$
2,950
$
100
$
100
$
100
$
1,000
$
100
$
100
Total Expenses
$
146,750
$16,134
$
11,084
$
11,134
$
13,584
$
11,184
$ 17,084
NET INCOME
$
5,250
<13,134>
<1,584>
<5,134>
$
10,916
$
12,816
$ 31,916
Cash on Hand -
Beginning
$
2,648
$ 2,648
<10,486>
<12,070>
<17,204>
<6,288>
$
6,528
Ending Cash
Available(Before
Loan Activity)
$
7,898
<10,486>
<12,070>
<17,204>
<6,288>
$
6,528
$ 38,444
Loan
$
0
$ 12,000
$
0
$
6,000
<10,000>
<8,000>
$
0
Cash After Loan
Activity
$
7,898
$ 1,514
<70>
$
796
$
1,712
$
6,528
$ 38,444

ADVERTISEMENT

00 votes

Related Articles

Related forms

Related Categories

Parent category: Business
Go
Page of 2