Cash Flow Projection Worksheet
| YEAR |
Pre-Start-up Position |
January | February | March | April | May | June | July | August | September | October | November | December | Total | |||||||||||||||
| Estimate | Actual | Estimate | Actual | Estimate | Actual | Estimate | Actual | Estimate | Actual | Estimate | Actual | Estimate | Actual | Estimate | Actual | Estimate | Actual | Estimate | Actual | Estimate | Actual | Estimate | Actual | Estimate | Actual | Estimate | Actual | ||
|
1. CASH ON HAND (Beginning of month) |
$1,000.00 | $500.00 | $0.00 | 1 | |||||||||||||||||||||||||
|
2. CASH RECEIPTS (a) Cash Sales |
$10.00 |
2 (a) |
|||||||||||||||||||||||||||
| (b) Collections from Credit Accounts | $10.00 | (b) | |||||||||||||||||||||||||||
| (c) Loan or Other Cash Injection (Specify) | © | ||||||||||||||||||||||||||||
|
3. TOTAL CASH RECEIPTS (2a+2b+2c=3) |
$20.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 3 |
|
4. TOTAL CASH AVAILABLE (Before cash out) (1+3) |
$1,020.00 | $0.00 | $500.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | 4 |
|
5. CASH PAID OUT (a) Purchases (Merchandise) |
5 (a) |
||||||||||||||||||||||||||||
| (b) Gross Wages (Excludes Withdrawals) | (b) | ||||||||||||||||||||||||||||
| (c) Payroll Expenses (Taxes etc.) | |||||||||||||||||||||||||||||