Course Overview?
Business decisions and most routine financial roles are increasingly made based on a financial model built in Excel. In today’s ever-changing business environment being able to accurately model and analyses the business activities for viability is a critical skill for business professionals. The capability to create and work with simple spreadsheets is no longer enough. You have to be able to decompose and analyses business options and performances as well as being able to stress-test any proposal to its limit.
Financial modelling involves developing dynamic spreadsheets based on best practice that describe a financial structure. A well-structured financial model can facilitate and improve the reliability, quality and timeliness of your decision-making. The ability to correctly predict and plan the future is of great importance to any economic entity regardless of sector or industry. The objective of the course is to assist professionals prepare robust and dynamic budgets and forecasts according to best practice. Delegates will leave the training ready to develop their own budgeting and forecasting models with confidence.
Target group
This training is designed for Chief Accountants, Accountants, Assistant accountants, Accounts officers, Budget officers, Finance Managers, Finance officers, Auditors, Audit assistants, Audit officers, Treasurers, Financial Analysts, Tax Consultants, Investment professionals and other interested professionals who want to transform their Excel skills to the next level and move from building simple excel models to Complex financial models. Employees from Public and Private organizations are highly invited. If you want to develop data analysis and reporting skills, this training is a perfect match to your career goals!
Course contents
- Budgeting & Forecasting Modelling Best Practice Principles
- Structuring the budgeting model – Understanding the business logic, assumptions and the structure of the model.
- The Opening Balance Sheet – the role of the opening balance sheet in achieving self- balancing budgets.
- Quantitative Budgeting – the preparation of quantity or unit budgets as a pre-requisite to the preparation of value budgets.
- Key Financial Statements – the role and interconnectivity between the Balance Sheet, Cash flow Statement and income Statement.
- The Assumptions Sheet – Designing the Assumptions sheet and the use of colour codes according to Best Practice Standards.
- Modular Approach – Linking up the budgets – the principles of linking every working schedule (module) to the financial statements (Master- Budgets) according to the Accounting Equation.
- Identifying the budget Limiting factors and mastering the various techniques of forecasting sales revenues and expenses.
- Mastering Advanced data management Tools & Functions, including Financial Functions
- Creating a Real Life Budgeting & Forecasting Model
- Creating the various support modules/schedules
- Linking the modules to the master budget (Income Statement, Cash-flow Statement & Balance Sheet) dynamic for easy of maintenance and update in the future.
- Build in error checking & error trapping mechanisms in the model
- Bullet proofing the model in order to protect the model structure.
- Budget Scenarios & Sensitivity Analysis
- Control Buttons Based scenario building- In-cell drop-down boxes & Combo-box drop down boxes.
- Data Tables – Show multiple scenario outcomes simultaneously with one and two-dimensional Data Tables.
- Scenario Manager – Using the Scenario Manager to create, store and display various scenarios.
- Goal Seek method – Goal seeking to calculate break-even point
- Optimizing using Solver add-in – Use Solver to maximize profit or minimize costs