OVERVIEW
The ability to understand and transform financial concepts into live working templates in Microsoft Excel is one of the most valued skilled in finance and commerce. These are the realms of financial modelling.
This is an intensive two-day workshop imparting the basics to advanced real-world methodologies used for building budgets and forecasts in Excel using best practice financial modelling. The workshop uses a step by step approach to learning about the concepts of budgeting and forecasting and nuisances in building financial models. The workshop is designed to give you the skills and information you need without having to have a technical background in financial modelling.
BENEFITS OF ATTENDING
By the end of the course participants will develop:
- The ability to not only understand the use of budgets and forecast, but to build from scratch.
- The ability to communicate and explain budgetary controls and forecasting outcomes.
- The assimilation of basic financial modelling best practices techniques
- The ability to develop commercial standard budgeting and forecast reports.
SHOULD ATTEND?
- Professional preparing for Accounting and business qualifications.
- Practitioners in finance, treasury and business development implementing products and services.
- Individuals with start-up business or principals of self-made companies wanting to take the next financial steps in controlling their financial resources.
- Students with an interest in finance and wanting to learn how to approach financial concept realisation.
PRE-REQUISITES
- An understanding of basic financial concepts like cash, accruals double entry etc.
- An intermediate level of skill with Microsoft Excel
- A laptop or computer with Excel 2016 or later (Office 365)
- A reasonable command of English language
COURSE MODULES
Budgeting and Forecasting Fundamentals
- Understanding budgets and budget types
- Understanding Financial Forecasts
- Budgets vs Forecast in the industry
- Why budget and Forecasts?
- Forecasting methods.
Financial Modelling Fundamentals
- What is a financial model?
- Financial modelling best practices
- Modelling design for budget and forecasts.
Budget Model Build
- Design and build the budget structure
- Design and build the forecast.
- Building timescales and management.
- Building scenarios in the Budgets and forecasts
- Implementation of the budget and forecast model
Reporting and Outputs
- Implementing user reporting for budget models.
- Modelling presentation techniques
- Model controls and error checking.
Case Study
- Develop a budget and forecast model from real world case study
- Review case studies for critique.