The objective of the course is to provide comprehensive overview of the latest analytical tools used by financial advisors and industry consultants for developing financial statements, while applying globally accepted best practices.
- Construct a financial model, real-time, under the guidance of a seasoned investment professional.
- Identify and incorporate Globally Accepted Best Practises pertaining to financial modelling.
- Learn the necessary tool-kit required to prepare decision making dash-boards.
- Discuss business cases with a focus on identifying Key Value Drivers required to understand business mechanics.
The course is designed to cover the following key objectives:
- Follow a logical, structured and disciplined approach towards model building
- Build a model from start to finish
- Learn how to translate key financial and commercial aspects into Excel
- Understand how to tailor the outputs of the model and interpret the results
- Learn ways to reduce the incidence of modelling errors
- Professionals using MS Excel.
- Professional involved in the construction and use of financial models, including budgets, projections, evaluations, cash flows, projects, etc.
- Professional aspiring to pursue a career in financial advisory.
- Senior executives looking for opportunities to rejuvenate their financial modeling skills.
Modeling Basics
- Purpose of financial models and the risks associated with financial modeling
- Leading approaches to model building, their benefits and the importance of formatting
Model Design
- Overall process of model development and model design
- Set a typical layout, structure and flow of the model
- Adopting a template-based approach to achieve consistency between model worksheets
Layouts and Assumptions
- Alternative layouts for model inputs and scenarios
- Using range names and data validation to increase model robustness
Fixed Assets and Depreciation
- Different ways of modelling capital expenditure relating to different asset classes
- Depreciation methodologies including cases where multiple asset acquisitions take place across the model timeline
Operations Modeling
- Forecasting for revenues, operating and maintenance costs and working capital
- Using indexation factors based on different cash flow timing assumptions
Debt and Equity Financing
- Modelling different drawdown approaches to service funding needs
- Costs related to debt financing such as interest
- Different debt repayment methods
Taxation
- Different approaches for modelling corporate taxation
Outputs
- The importance of integrated financial statements and how to set them up
- IRR and NPV calculations, using both project and equity cash flows
- Other key output measures such as lending and profitability ratios and industry KPls
Implementation and Use of Model
- Creating dashboards, hyperlinks and contents pages for easier use and navigation
- Performing stress testing on a model based on designated sensitivities and in-built scenario cases
Model Review and Testing
- Use of checks sheets to automatically detect and identify potential modelling errors
- Common modelling errors including tips on how to spot them
Valuation
- Introduction to company valuation
- Difference between equity and enterprise value
- Stages of a complete DCF valuation
IBA CEE Cancellation Policy for Open Enrollment Programs:
In the event of participant's cancellation, the following schedule will apply:
- 5 days before start of workshop - No cancellation
- Within 4 to 2 days prior to workshop Half program fee forfeiture
- Within 1 day and No Shows - Full program fee forfeiture
Cancellation notification must be made in writing to CEE.
Postponement
Due to any unavoidable circumstances, the workshop may be postponed by the institute. In case of postponement, the institute will refund full fee of the program or the participant may opt to defer his/her registration to the next program.
Substitute
Substitutes will be taken at least 2 days prior to the workshop. Should we be unable to accept your application for any reason, your payment (cheque/draft) will be returned to you.
Deferrals
All registrations deferrals must be requested in writing at least 2 days prior to the workshop. Send a note to the Program Registration Team indicating that you wish to have your registration deferred to another session of the same program within one year. The deposited fee will be carried forward. Please note that only one transfer is permitted. After one year, the deposited fee will be fully forfeited.
