1. Beginning Cash Balance (Beginning of Month) Cash on hand same as (10.) Cash Position Previous Month
2. Cash Receipts
a. Cash Sales All cash sales. Omit credit sales unless cash is actually received
b. Accounts Receivable Collected Ammount to be expected from all credit accounts
c. Loans & Other Cash Income Indicate here all cash injections not shown in 2a. or 2b. above
3. Total Cash Recepts (2a+2b+2c) Self-explanatory
4. Total Cash Available (1+3) Self-explanatory
5. CASH EXPENDITURES
a. Purchases Merchandise for resale or for use in product (paid for in current month)
b. Advertising Ammount to be spent to maintain sales volume-include telephone book yellow page cost
c. Automobile If personal car is used, charge in this column-include parking
d. Dues/Subscriptions/Licenses Self-explanatory
e. Insurance Coverages on business property and products e.g. fire, liability; also workman's compensation,
fidelity, etc.
f. Interest Remember to add interest on loan as it is injected
g. Legal and Professional Outside services, including, for example, bookkeeping, accounting
h. Office supplies Items purchased for use in the business (not for resale)
i. Proyroll Expenses (inlude taxes & benefits) Include paid vacations, paid sick leave, health insurance, unemployment insurance, etc.
j. Rent Real estate only
k. Salaries Pay to managment and executives
l. Taxes-Sales, etc. Inventory tax-sales, tax-excis tax, if applicable
m. Telephone Self-explanatory
n. Travel & Entertainment Self-explanatory
o. Utilities Water, heat, light, and/or power
p. Wages - Employees Base pay plus overtime (if any)
q. Other Expenses:____________________________ Unexpected expenditure may be included here as a safety factor
r. ___________________________________________ Equipment expenses duriing the month shoud be included here (Non-Capital equipment)
s. ___________________________________________ When equipment is rented or leased, record payment here along or small expenditures for which
separate accounts would not be practical
6. TOTAL EXPENSES (5a thru 5s) Self-explanatory
7. Owners Withdrawals Should include payment for such things as owner's income tax, socialy security, health insurance,
"executive" life insurance premiums, etc.
8. Loan Principal Repayments Include payment on all loans, including vehicle and equipment purchases on time payment
9. Total Cash Paid Out (6+7+8) Self-explanatory
10. ENDING CASH BALANCE (4-9) Enter this amount in (1) Beginining Cash Balance following month
(End of the Month)
_____________________PROFORMA CASH FLOW FOR PERIOD ___________TO__________
First Year Company Name
=============================================================================================================================================================
PROFORMA CASHFLOW MO1 MO2 MO3 MO4 MO5 MO6 MO7 MO8 MO9 MO10 MO11 MO12 TOTAL
=============================================================================================================================================================
1. Beginning Cash Balance ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
2. Cash Receipts ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
a. Cash Sales ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
b. Accounts Receivable Collected ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
c. Loans & Other cash Income ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
---------------------------------------------------------------------------------------------------------
3. Total Cash Recepts (2a+2b+2c) ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
4. Total Cash Available (1+3) ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
=========================================================================================================
5. CASH EXPENDITURES ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
a. Purchases ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
b. Advertising ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
c. Automobile ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
d. Dues/Subscriptions/Licenses ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
e. Insurance ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
f. Interest ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
g. Legal and Professional ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
h. Office supplies ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
i. Proyroll Espenses (inlude taxes & benefits) ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
j. Rent ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
k. Salaries ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
l. Taxes-Sales, etc. ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
m. Telephone ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
n. Travel & Entertainment ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
o. Utilities ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
p. Wages - Employees ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
q. Other Expenses:____________________________ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
r. ___________________________________________ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
s. ___________________________________________ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
_________________________________________________________________________________________________________
6. TOTAL EXPENSES (5a thru 5s) ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
---------------------------------------------------------------------------------------------------------
7. Owners Withdrawals ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
8. Loan Principal Repayments ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
9. Total Cash Paid Out (6+7+8) ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
_________________________________________________________________________________________________________
10. ENDING CASH BALANCE (4-9) ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______
=========================================================================================================