Dates for this course

18/08/10 - 18/08/10

08/12/10 - 08/12/10

Who should attend:
• Accountants preparing departmental budgets
• Capital project managers where there is a complex pattern of expenditure over several years
• Credit controllers
• Financial managers planning future cash requirements to support business expansion
• Departmental managers preparing cash budgets for their departments
• Those planning a new business start-up

Objectives:
• To develop an awareness of the data required to prepare a cash flow forecast.
• To show how to set out the forecast to ensure that all the flows are identified.
• To show a methodology that allows changes to be made easily.
• To show how to set out cash flows to reflect different sets of assumptions – best case, worst case, most likely etc. Using the EXCEL Scenario Manager.

Content:
• Defining the activity to be defined by the cash flow forecast – an existing operation, or a projected business development.
• Gathering the technical and financial facts – seeking advice and information from across the organisation on costs, resource levels, and timing.
• Making a start on the forecast layout using a spreadsheet – what do the rows and columns represent?
• Identifying the shortcomings of the model, and gradually improving it.
• Projecting cash outflows for capital projects.
• Generating opening and closing balances for each evaluation period – typically a month.
• Building in assumptions about how quickly invoiced revenue will come into the company.
• Dealing with the calculations of interest charges where funding is by bank loans.
• Exercises and discussion related to delegates’ practical experiences of cash flow planning and management.