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!