Starting a Business by Computer Concierge

Welcome

 
Home
Products / Services
Web Development
Business Ownership
Starting a Business
Contact
Search
 


Cash Flow

MONTHLY CASH FLOW PROJECTION

Name of Business Owner Type of Business Prepared by Date
Pre-start- 1 2 3 4 5 6 Total up position Columns 1-6 Year Month
bulletCash on hand (beginning month) 
bulletCash receipts
bulletCash sales
bulletCollections from credit accounts
bulletLoan or other cash injections (specify)
bulletTotal cash receipts 


Total cash available

Cash paid out
bulletpurchases (merchandise) 
bulletGross wages (excludes withdrawals)
bulletPayroll expenses (taxes, etc.)
bulletOutside services
bulletSupplies (office and operating)
bulletRepairs and maintenance
bulletAdvertising
bulletCar, delivery and travel
bulletAccounting and legal
bulletRent
bulletTelephone
bulletUtilities
bulletInsurance
bulletTaxes (real estate, etc.)
bulletInterest
bulletOther expenses (specify each)
bulletMiscellaneous (unspecified)
bulletSubtotal
bulletLoan principal payment
bulletCapital purchases (specify)
bulletOther start-up costs
bulletReserve and/or escrow (specify)
bulletOwner's withdrawal

Total cash paid out

Cash position (end of month)

Essential operating data (non-cash flow information)
bulletSales volume (dollars)
bulletAccounts receivable (end on month)
bulletBad debt (end of month)
bulletInventory on hand (end of month)
bulletAccounts payable (end of month)

INSTRUCTIONS FOR MONTHLY CASH FLOW PROJECTION

Cash on hand (beginning of month)

Cash position, pervious month

Cash receipts- 
bulletCash sales-- All cash sales. Omit credit sales unless cash is actually received
bulletGross wages (including withdrawals)-- Amount to be expected from all accounts.
bulletLoan or other cash injection-- Indicate here all cash injections.

Total cash receipts

Total cash available (before cash out)(1+3)

Cash paid out
bulletPurchases (merchandise)--Merchandise for resale or for use in product (paid for in current month).
bulletGross wages (including withdrawals)--Base pay plus overtime (if any)
bulletPayroll expenses (taxes, etc.)-- Include paid vacations, paid sick leave, health insurance, unemployment insurance
bulletOutside services--This could include outside labor and/or material for specialized or overflow work, including subcontracting
bulletSupplies (office and operating)--Items purchased for use in the business (not for resale)
bulletRepairs and maintenance-- Include periodic large expenditures such as painting or decorating
bulletAdvertising--This amount should be adequate to maintain sales volume
bulletCar, delivery and travel--If personal car is used, charge in this column, include parking
bulletAccounting and legal--Outside services, including, for example, bookkeeping
bulletRent-- Real estate only
bulletTelephone
bulletUtilities--Water, heat, light and/or power
bulletInsurance-- Coverage on business property and products (fire, liability); also worker's compensation, fidelity, etc.
bulletTaxes (real estate, etc.)-- Plus inventory tax, sales tax, excise tax, if applicable
bulletInterest--Remember to add interest on loan as it is injected.
bulletOther expenses (specify each)


Unexpected expenditures may be included here as a safety factor.
bulletEquipment expenses during the month should be included here (non-capital equipment)
bulletWhen equipment is rented or leased, record payments here
bulletMiscellaneous (unspecified)--Small expenditures for which separate accounts would be practical
bulletSubtotal--This subtotal indicates cash out for operating costs
bulletLoan principal payment--Include payment on all loans, including vehicle and equipment purchases on time payment
bulletCapital purchases (specify)--Nonexpensed (depreciable) expenditures such as equipment, building purchases on time payment.
bulletOther start-up costs--Expenses incurred prior to first month projection and paid for after start-up
bulletReserve and/or escrow (specify)-- Example: insurance, tax or equipment escrow to reduce impact of large periodic payments
bulletOwner's withdrawals-- Should include payment for such things as owner's income tax, social security, health insurance, executive life insurance premiums, etc.

Total cash paid out

Cash position (end on month)-- Enter this amount in Cash on hand following month--

Essential operating data (non-cash flow information)--This is basic information necessary for proper planning and for proper cash flow projection. Also with this data, the cash flow can be evolved and shown in the above form.
bulletSales volume (dollars)--This is a very important figure and should be estimated carefully, taking into account size of facility and employee output as well as realistic anticipated sales (actual sales, not orders received).
bulletAccounts receivable (end of month)-- Previous unpaid credit sales plus current month's credit sales, less amounts received current month.
bulletBad debt (end on month)-- Bad debts should be subtracted from the month anticipated
bulletInventory on hand (end on month)-- Last month's inventory plus merchandise received and/or manufactured current month minus amount sold current month
bulletAccounts payable (end of month) Previous month's payable plus current month's payable minus amount paid during month.
bulletDepreciation--Established by your accountant, or value of all your equipment divided by useful life (in months) as allowed by Internal Revenue Service

 

Starting a Business

Business Description
Product - Service
Marketing
Market Mix
Competition
Pricing & Sales
Advertising
Management Plan
Finanacial Management
Entrepreneur
Tips & Tricks
Price / Quality
Income Projection
Balance Sheet
Cash Flow
Resources


 

 

Computer Concierge International -- Copyright 2003, All rights reserved