|
MONTHLY CASH FLOW PROJECTION |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Company: |
Pre- |
|
|
|
OWNER:____________________ |
|
|
DATE:_______________________ |
|
|
|
|
Start-up |
Month: |
Month: |
Month: |
Month: |
Month: |
Month: |
Month: |
Month: |
Month: |
Month: |
Month: |
Month: |
TOTAL |
% of Sales |
|
Position |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
|
|
| 1.) CASH ON HAND (BEGIN. OF MO.) |
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
| 2.) CASH RECEIPTS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| a. Cash Sales |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
| b. Collections from Credit Accounts |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| c. Loan or Other Cash Injection |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
| d. Loan or Other Cash Injection |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
| e. Loan or Other Cash Injection |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
| f. |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
| 3.) TOTAL CASH RECEIPTS |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
| 4.) TOTAL CASH AVAILABLE |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
| 5.) CASH PAID OUT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| a. Materials |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| b. Subcontract Labor |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| c. Direct Labor |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| d. Payroll Expenses (Direct Labor) |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| e. Subtotal Variable Expenses |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
#DIV/0! |
| f. Admin. Wages |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| g. Payroll Taxes (Admin. Wages) |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| h. Temp. Office Labor |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| i. Shop Supplies |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| j. Advertising/Convention/Shows |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| k. Insurance-W/C. PROP, MISC. |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| l. Insurance-Health |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| m. Repairs & Maintenance |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| n. Freight & Delivery |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| o. Utilities |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| p. Telephone |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| q. Vehicle Expense |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| r. Rental Equipment |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| s. Rental Building |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| t. Professional Fees/Contract Labor |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| u. Travel Expenses |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| v. Office Supplies & Expenses |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| w. Bank Charges |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| x. Interest Expense/Penalties |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| y. Miscellaneous (Unspecified) |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| z. Subtotal Fixed Expenses |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
#DIV/0! |
| aa. Subtotal Total Operating Expenses |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
#DIV/0! |
| bb. Loan Principal Payment |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| cc. Capital Purchases |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| dd. Other Start-up Costs |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| ee. Reserve and/or Escrow |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| ff. Owner's Withdrawal |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
| 6.) TOTAL CASH PAID OUT |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
#DIV/0! |
| 7.) CASH POSITION END OF MONTH |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
| ESSENTIAL OPERATING DATA |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A. Sales Volume (Dollars) |
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
#DIV/0! |
| B. Accounts Receivable (End of Month) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| C. Bad Debt (End of Month) |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
| D. Inventory on Hand (End of Month) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| E. Accounts Payable (End of Month) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| F. Depreciation |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
| Total Fixed Costs |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Contribution Margin |
#DIV/0! |
|
Break-even Sales = |
#DIV/0! |
|
|
|
|
|
|
|
|
|
|
