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