Key ROI Derivatives
Financial Modeling course has been designed for business and finance professionals who need to set out a business case, study past performance, predict future performance using discernible trends, valid assumptions and management opinions.
In addition, the delegates are trained on key advanced excel skills applicable in Financial Modelling and Data Manipulation.
The course will revisit business finance concepts before getting into the deep dive to Advanced Excel formulas, functions and tools.
Participants will gain capability to:
- Set up and model financial revenue drivers
- Set up and model financial cost drivers
- Set up Asset assumptions
- Set up financing assumptions
- Use enterprise valuation methods
- Generate financial statements and conduct financial analysis
Summarised Topical Outline
Using Advanced Excel formulas & functions
Excel shortcuts for efficiency
Preparing Income Statement
Preparing Balance Sheet
Preparing Cash flow Statement
Evaluating business performance at different levels
Creating Executive Dashboards