Monthly Cash Flow Projection Worksheet

You are here: Business Finance >> Monthly Cash Flow Projection Worksheet

Monthly Cash Flow Projection Worksheet

1.	Cash on hand (beginning month)		$ ____________________
2.	Cash Receipts		$ ____________________
	(a)	Cash sales	$ ____________________
	(b)	Collections from credit accounts	$ ____________________
	(c)	Loan or other cash injections (specify)	$ ____________________
3.	Total cash receipts		$ ____________________
4.	Total cash available (before cash out)(1+2+3)		$ ____________________
5.	Cash Receipts		$ ____________________
	(a)	Cash sales	$ ____________________
	(b)	Collections from credit accounts	$ ____________________
	(c)	Loan or other cash injections (specify)	$ ____________________
	(d)	Outside services	$ ____________________
	(e)	Supplies (office and operating)	$ ____________________
	(f)	Repairs and maintenance	$ ____________________
	(g)	Advertising	$ ____________________
	(h)	Car, delivery and travel	$ ____________________
	(i)	Accounting and legal	$ ____________________
	(j)	Rent	$ ____________________
	(k)	Telephone	$ ____________________
	(l)	Utilities	$ ____________________
	(m)	Insurance	$ ____________________
	(n)	Taxes (real estate, etc.)	$ ____________________
	(o)	Interest	$ ____________________
	(p)	Other expenses (specify each)	$ ____________________
	(q)	Miscellaneous (unspecified)	$ ____________________
	(r)	Subtotal	$ ____________________
	(s)	Loan principal payment	$ ____________________
	(t)	Capital purchases (specify)	$ ____________________
	(u)	Other start-up costs	$ ____________________
	(v)	Reserve and/or escrow (specify)	$ ____________________
	(w)	Owner's withdrawal	$ ____________________
6.	Total cash paid out (5a through 5w)		$ ____________________
7.	Cash position (end of month) (4 minus 6)		$ ____________________

Essential operating data(non-cash flow information)
A.	Sales volume (dollars)		$ ____________________
B.	Accounts receivable (end of month)		$ ____________________
C.	Bad debt (end of month)		$ ____________________
D.	Inventory on hand (end of month)		$ ____________________
E.	Accounts payable (end of month)		$ ____________________
F.	Depreciation (in months)		$ ____________________

	PREVIOUS PAGE	Table of Contents	NEXT PAGE		Page 27 of 37
Click Here to download this book in PDF format.