Budgeting and Forecasting
This application-driven, hands-on practical 3-day programme leads delegates through various budget modelling techniques, using Excel as the tool. It focuses on the basic nuts & bolts of budget model preparation and structure, and provides the delegate with useful modelling techniques than can be immediately applied in the work place. This is a very hands-on, non-intimidating, course – delegates work through various practical exercises under the supervision, and with the help, of the instructor to get to grips with practical modelling techniques and, as a valuable spin-off, advanced Excel functions useful (and essential) in the preparation of corporate budgeting models.
Financial Modelling Masterclass
This highly practical 4-day workshop teaches delegates how to effectively prepare and structure financial models. It also provides useful modelling techniques that can immediately be applied in the work place. Delegates must be familiar with Excel’s advanced functions pertaining to Financial Modelling.
The following topics are covered in detail:
- The process of building a financial model from scratch, understanding the importance of model specifications, structure and setting up the required sheets and financial statements.
- The interaction between Income Statements, Balance Sheets, and Cash Flow statements in financial models, and the necessity for utilising this approach.
- Specialised Excel techniques so far as they pertain to financial models, e.g. sensitivity analyses, create scenarios and data tables, etc.
- Discussions and exercises on the Weighted Average Cost of Capital (WACC), Net Present Values (NPVs) and Internal Rates of Return (IRR), and the importance of these measurements.
- Knowledge related to setting up “switches” in their models, allowing users to investigate the effect of different alternatives.
- Insight into the preparation of a valuation model (DCF) and the structure of M&A models incorporating the relevant Excel techniques and functions.
- Optimisation models utilising Excel’s “Solver” function
- Random probabilities, regression analysis and Monte Carlo simulations
Financial Modelling for Mining
This application-driven, hands-on practical 3-day programme leads delegates through various financial modelling techniques, using Excel as the tool. It focuses on the basic nuts & bolts of financial model preparation and structure pertinent to mining project models. It provides the delegate with useful modelling techniques than can be immediately applied in the work place. This is a very hands-on, non-intimidating, course – delegates work through various practical exercises under the supervision, and with the help, of the instructor to get to grips with practical modelling techniques and, as a valuable spin-off, advanced Excel functions useful (and essential) in the preparation of financial models.
Financial Modelling Fundamentals
This 3-day entry level course is designed to introduce aspiring modellers to best practice modelling methods and processes using MS Excel as the model building tool.
The key to successful modelling lies in the application of correct modelling procedures, model design and structure. These core principles are explained and demonstrated using a combination of detailed course notes and Excel files. Delegates work through various practical exercises under the supervision, and with the help, of the instructor to get to grips with practical modelling techniques. All Excel functionality necessary and essential to model building is comprehensively explained and supported by appropriate Excel examples and exercises.
Intermediate Financial Modelling
This application-driven, hands-on practical 3-day programme leads delegates through various financial modelling techniques, using Excel as the tool. It focuses on the basic nuts & bolts of financial model preparation and structure, and provides the delegate with useful modelling techniques than can be immediately applied in the work place. This is a very hands-on, non-intimidating, course – delegates work through various practical exercises under the supervision, and with the help, of the instructor to get to grips with practical modelling techniques and, as a valuable spin-off, advanced Excel functions useful (and essential) in the preparation of corporate financial models.
Project and Real Estate Modelling
This application-driven, hands-on practical 3-day programme leads delegates through various project and real estate financial modelling techniques, using Excel as the tool. It focuses on the basic nuts & bolts of financial model preparation and structure, and provides the delegate with useful modelling techniques than can be immediately applied in the work place. This is a very hands-on, non-intimidating, course – delegates work through various practical exercises under the supervision, and with the help, of the instructor to get to grips with practical modelling techniques and, as a valuable spin-off, advanced Excel functions useful (and essential) in the preparation of corporate financial models.
Project Financial Modelling
This 3-day course teaches the fundamental principles of project finance and the significance of financial modelling to make certain that these project deals are profitable. Delegates who whould benefit from this course are: all persons utilising Excel Spreadsheets, all persons engaged in the construction and use of financial models, together with budgets, projections, evaluations, cash flows, projects, etc. Delegates ought to be familiar with Microsoft Excel and its advanced functions. If not, we suggest that you attend our ‘Specialised Excel Techniques for Modelling’ course before.
Real Estate Modelling
The knowledge gained in this 3-day workshop can be immediately applied in the work place in a real estate environment. The course will be valuable to: Financial Officers, Planners, Middle and Senior Management in the real estate field and persons engaged in the construction of real estate development models. Delegates are required to have a basic comprehension of company financial statement and should have a simple understanding of Microsoft Excel and its functions.
