|
Cash Flow Statement for Rainbow Getter and Siding (11/1/00 - 10/31/01)
Cash Flow Projections
| Month of |
Nov |
Dec |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Total |
| Beginning Cash |
10000 |
1305 |
1838 |
2371 |
879 |
1412 |
3292 |
4327 |
7687 |
11047 |
12382 |
15742 |
|
| RECEIPTS |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sales (cash) |
|
3800 |
3800 |
3800 |
3800 |
7600 |
11400 |
11400 |
11400 |
11400 |
11400 |
11400 |
91200 |
| From Savings |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
| TOTAL RECEIPTS |
|
3800 |
3800 |
3800 |
3800 |
7600 |
11400 |
11400 |
11400 |
11400 |
11400 |
11400 |
91200 |
| DISBURSEMENTS |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cost of Sales |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Labor |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
| Materials & Supplies |
2750 |
2320 |
2320 |
2320 |
2320 |
4640 |
6960 |
6960 |
6960 |
6960 |
6960 |
6960 |
58430 |
| Total Cost of Sales |
2750 |
2320 |
2320 |
2320 |
2320 |
4640 |
6960 |
6960 |
6960 |
6960 |
6960 |
6960 |
58430 |
| Expenses |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Advertising |
25 |
25 |
25 |
25 |
25 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
510 |
| Dues/Subscriptions |
35 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
35 |
| Insurance |
400 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
400 |
| Truck Expenses |
75 |
75 |
75 |
75 |
75 |
100 |
100 |
100 |
100 |
100 |
100 |
100 |
1075 |
| Miscellaneous |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
600 |
| Office Supplies |
20 |
20 |
20 |
20 |
20 |
20 |
20 |
20 |
20 |
20 |
20 |
20 |
240 |
| Printing |
25 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
135 |
| Professional Services |
0 |
0 |
0 |
0 |
0 |
0 |
300 |
0 |
0 |
0 |
0 |
0 |
300 |
| Taxes & Licenses |
155 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
155 |
| Telephone |
75 |
28 |
28 |
28 |
28 |
28 |
28 |
28 |
28 |
28 |
28 |
28 |
383 |
| Travel |
80 |
80 |
80 |
80 |
80 |
158 |
158 |
158 |
158 |
158 |
158 |
158 |
1506 |
| Bonding |
96 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
96 |
| Total Expenses |
1036 |
288 |
288 |
288 |
288 |
421 |
721 |
421 |
421 |
421 |
421 |
421 |
5435 |
| Other Disbursements |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Loan Payment |
159 |
159 |
159 |
159 |
159 |
159 |
159 |
159 |
159 |
159 |
159 |
159 |
1908 |
| Capital Expenditure |
4250 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
4250 |
| Draw |
500 |
500 |
500 |
500 |
500 |
500 |
500 |
500 |
500 |
500 |
500 |
500 |
6000 |
| Taxes |
0 |
0 |
0 |
2025 |
0 |
0 |
2025 |
0 |
0 |
2025 |
0 |
0 |
6075 |
| Total Other |
4909 |
659 |
659 |
2684 |
659 |
659 |
2684 |
659 |
659 |
2684 |
659 |
659 |
18233 |
| TOTAL DISBURSEMENTS |
8695 |
3267 |
3267 |
5292 |
3267 |
5720 |
10365 |
8040 |
8040 |
10065 |
8040 |
8040 |
82098 |
| SURPLUS/(DEFICIT) |
(8695) |
533 |
533 |
(1492) |
533 |
1880 |
1035 |
3360 |
3360 |
1335 |
3360 |
3360 |
9102 |
| ENDING CASH |
1305 |
1838 |
2371 |
879 |
1412 |
3292 |
4327 |
7687 |
11047 |
12382 |
15742 |
19102 |
19102 |
© July 1998, 1st
Revision June 1999, 2nd Revision February 2001 |