Integrated Financial Modelling using Advanced Ms. Excel & VBA
Category: Productivity Operational Efficiency and Service Excellence
Target Group
ROI Derivatives
Training Brief
Training Objectives
Topical Outline
Target Group
Finance, Investment and Business Development teams
Key ROI Derivatives
Business Development and scenario planning value proposition
Savings on external financial modelling consulting fees
Training Brief
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.
Training Objectives
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
Performing Valuations
Creating Executive Dashboards
Remarks
Need to Get Ahead?
Our courses are designed for fast-tracking business transformation through organizational learning and leadership development. Get started today!