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.) | © | ||||||||||||||||||||||||||||
| (d) Outside Services | (d) | ||||||||||||||||||||||||||||
| (e) Supplies (Office and operating) | (e) | ||||||||||||||||||||||||||||
| (f) Repairs and Maintenance | (f) | ||||||||||||||||||||||||||||
| (g) Advertising | (g) | ||||||||||||||||||||||||||||
| (h) Car, Delivery, and Travel | $10.00 | (h) | |||||||||||||||||||||||||||
| (i) Accounting and Legal | (i) | ||||||||||||||||||||||||||||
| (j) Rent | (j) | ||||||||||||||||||||||||||||
| (k) Telephone | $10.00 | (k) | |||||||||||||||||||||||||||
| (l) Utilities | (l) | ||||||||||||||||||||||||||||
| (m) Insurance | (m) | ||||||||||||||||||||||||||||
| (n) Taxes (Real Estate, etc.) | (n) | ||||||||||||||||||||||||||||
| (o) Insurance | (o) | ||||||||||||||||||||||||||||
| (p) Other Expenses (Specify each) | (p) | ||||||||||||||||||||||||||||
| (q) Miscellaneous ( Unspecified) | (q) | ||||||||||||||||||||||||||||
| (r)Subtotal | $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 | ® |
| (s) Loan Principal Payment | (s) | ||||||||||||||||||||||||||||
| (t) Capital Purchases (Specify) | (t) | ||||||||||||||||||||||||||||
| (u) Other Start-up Costs | $500.00 | (u) | |||||||||||||||||||||||||||
| (v) Reserve and/or Escrow (specify) | (v) | ||||||||||||||||||||||||||||
| (w) Owner's Withdrawal | (w) | ||||||||||||||||||||||||||||
|
6. TOTAL CASH PAID OUT (Total 5a thru 5w) |
$520.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 | 6 |
|
7. CASH POSITION (End of month) (4 minus 6) |
$500.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 | 7 |
|
ESSENTIAL OPERATING DATE (Non-cash flow information) A. Sales Volume (Dollars) |
A | ||||||||||||||||||||||||||||
| B. Accounts Receivable (End of Month) | B | ||||||||||||||||||||||||||||
| C. Bad Debt (End of Month) | C | ||||||||||||||||||||||||||||
| D. Inventory on Hand (End of Month) | D | ||||||||||||||||||||||||||||
| E. Accounts Payable (End of Month) | E | ||||||||||||||||||||||||||||
| F. Depreciation | F | ||||||||||||||||||||||||||||