23

Twelve-Month Cash Flow Projection

Would you like to send the completed form to yourself or someone else by e-mail? If so, please provide the following:

Your name:
Your e-mail address:
Address you wish to send the results to:

Please don't enter commas or dollar signs, just the numbers and the decimals.

Work
sheet
#		 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL
1. CASH ON HAND (beginning of month)
PLUS
(a) Cash Sales
(b) Collections From Accounts Receivable
(c) Other Cash Income
2. TOTAL CASH AVAILABLE (before cash paid out)
3. CASH PAID OUT
(a) Purchases (inventory) 11
(b) Gross Wages (excludes withdrawals) 12,17
(c) Payroll Expenses (taxes, etc.)
(d) Outside Services 18
(e) Supplies (offices and operating) 11
(f) Reparis and Maintenance 10
(g) Advertising 8
(h) Car, Delivery, and Travel 9
(i) Accounting and Legal 18
(j) Facilities 10
(k) Telephone
(l) Utilities
(m) Insurance 16
(n) Taxes (real estate, etc.)
(o) Interest Expense
(p) Owner's Withdrawl 17
(q) Loan Principal Payment
(r) Other Expenses (specify each)
(s) Miscellaneous (unspecified)
4. TOTAL CASH PAID OUT (total 3a - 3s)
5. CASH SURPLUS (DEFICIT 2-4)
6. BORROWINGS
7. LOAN REPAYMENT
8. CASH ON HAND (4 plus 6 minus 7) (end of month)
Copyright©1995 Northern Initiatives Corporation
Northern Initiatives can be contacted at (906)228-5571

site created by the U.P. Web Maestro