Financial Modelling - A Workshop
All organisations have to pay attention to the money.
Financial models create the link between what people in the organisation do or intend to do and delivery of the financial outcomes.
This workshop is aimed at those responsible for the costs and related outputs (revenues and/or service levels) in an organisation and finance personnel who are required to model the expected financial outcomes of options and decisions that the organisation faces or who are asked what the organisation has to do to achieve particular financial targets.
What You Will Learn
This workshop will cover the following:
- Part I - Introduction
- What does a financial model do?
- Different types and complexity of model - which will best suit my purposes?
- Different outputs: a step through frequently used financial ratios; how the Balance Sheet and P&L statements relate to one another and how to get the model to forecast them
- The role of financial modelling in budgeting
- Part II - Structure of the Financial Model
- How to convert 'what we do' into financial numbers: the concept of cost and revenue drivers
- Simple Excel facilities that make your models easy to build, modify and document
- Introduction to VBA. The kind of things this programming language allows you to do if you want a Rolls Royce model
- Reminder of basic project management techniques so that your model does what the stakeholders have agreed it should do and is built on time and at agreed cost
- Part III - Building and Maintaining the Financial Model
- Incorporating uncertainty into the model by providing a range of financial outcomes that reflect the risk profile
- Checking that the model does what you want
- Practicalities: who owns the model? Responsibility, accountability
- What quantified operational goals do you have to achieve in order to meet your financial objectives?