Module 1 - 4 live interactive webinars
Content: Modelling background, principles and applications
Essential Excel for successful modeling
Exercises: Improving a model design completing a monthly budget mod
Module 2 - 2 live interactive webinars
Content: Principles of model design, model anatomy, modeling conventions, FAST standard
Exercises: creating model templates, input sheets and support schedules for 2 different models
Designing the financial statements
Building the three financial statements and balancing the balance sheet for both models
Module 3 - 3 live interactive webinars
Content: Analysis of the model results, ratios, sensitivity, scenarios data tables
Calculating Discounted Cashflows, Free Cash Flow, Net Cash Flow, RONA, ROE, DSCR, WACC, Project IRR, Equity IRR, Dividend IRR
Exercises: completing analysis of the two models in Module 2
Creating an Executive summary
Finalizing and protecting the model
A review of alternative loan structures
Combining best practice modeling methodology with advanced Excel modeling functions and techniques, the Goalfix Certification program builds the skills necessary for using and interpreting predictive financial models relating to projects, budgets and projections, business evaluations, and cash flows.
The program is designed to empower financial modelers to produce effective, flexible financial models for use by corporate executives to make informed decisions.
The training methodology follows the principles of meaningful learning to ensure delegates not only have a clear and complete understanding of all the related facts, concepts and principles but also have the ability to apply the knowledge learned to a variety of situations and contexts.
The program is based on the FAST international modeling standards.
If possible, delegates should have:
1. working knowledge of Excel and preferably familiarity with Excel functions relevant to financial modeling (not essential)
2. a basic understanding of accounting principles and financial statements
3. some knowledge of corporate financial terminology and the metrics used to measure corporate performance
4. some exposure to financial models or experience of financial models in the workplace
While it is useful for delegates to have an understanding of the points above, it is not a prerequisite as these issues will be addressed during the program.
It is recommended that delegates execute the pre-course reading as indicated in the program manual.