CASH FLOW ANALYSIS



THE BUSINESS PLAN

The TDR Small Business Blueprint suggests the following contents for a business plan (ask your bank what they suggest you include):

PREPARING A CASHFLOW FORECAST


A monthly forecast should always be maintained for at least 12 months ahead, i.e. beyond the June end of financial year. A further two years may be forecast on a quarterly basis.
  1. Forecast monthly sales - the most important step
  2. Identify cash receipts - cash sales, plus credit sales over time. Also one-off cash receipts such as owner's cash introduced, bank loans, asset sales (e.g. boat) etc.
  3. Identify cash payments - fixed costs do not change with levels of sales, but variable costs (e.g. purchases of goods for sale) will depend on sales levels. One-off cash payments will include the original equipment and stock purchases. Do not forget owner's drawings for living expenses, and to pay tax bills, etc.
  4. Total the monthly columns to forecast the monthly closing bank balance.


THE LOAN APPLICATION


The TDR Small Business Blueprint suggests the following contents for a loan application (ask your bank what they suggest you include):



Click here to download the Excel 5.0 file containing a completed example

Click here to download the Excel 5.0 file containing a blank example


return to top of page



return to John $ Hawkins home page


Last updated Thursday, 26 September 1996
© Websight and John S Hawkins

Created by Websight Web Page Editors