Monthly Cash Flow Projection Worksheet

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

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

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) $  ____________________
Left Green Arrow PREVIOUS PAGE
Table of Contents
 NEXT PAGE Right Green Arrow Page 27 of 37

Click Here to download this book in PDF format.

EIN-Only Unsecured Business Credit Lines
Use IRA/401k to Finance Your Business

  Print   |     |   XML Feed: Monthly Cash Flow Projection Worksheet

  
 
New Lender Signup
Lender Members Login
Copyright © 1995 - 2010 BusinessFinance.com, All Rights Reserved. Terms and Conditions. Privacy Policy.
Small Business Loans    Home    |   About Us    |   Contact    |   Link to us    |   Partners    |   Site Map
Capital Seeker Signup
Capital Seeker Members Login
BusinessFinance.com
Last update: 2/12/2012
Web BusinessFinance.com
"Marketing is simply sales with a college education. - John Freund"