Comprehensive Financial Modeling (Using Excel) for Financial Professionals

Having a well developed financial model will allow any companies to perform  better in their market and business environment. It means they can have better strategic planning, detailed valuation analysis, multi-year budget perspective, or better management of their budget facilities as well as CAPEX programs.

The skill in Financial Modeling will empower any finance professionals in advancing their career through specialized knowledge solutions and better productivity in their roles.

In this practical workshop, participants  will exercise in building a multi-year, dynamic financial model for a real, public company. They will use the common spreadsheet program and discuss real world cases in building a comprehensive financial model.

This two-day program will help the participants how to:

  • Understand the essence of financial modeling
  • Exercise building a financial model
  • Use techniques in building a financial model fits to their company needs
  • Use excel spreadsheet for financial modeling
  • Connecting and balancing the financial model
  • Make meaning analysis of the financial models

Training Outline:

1. Introduction

  • The definition and applications of financial modeling in practical world

2. Getting Started in Financial Modelling

  • Good practices in financial modelling
  • Financial modelling  layout, formatting and design
  • Reviewing the fundamentals of financial statements and the relationships between financial statements
3. Excel & Financial Modeling
  • Excel best practices & commonly used functions
  • Useful techniques & Excel shortcuts
  • Creating powerful graphs and charts Historical financial  of key trends and drivers. Historical data manipulation
  • Importance of the analysis of historical financial statements
  • Analysis of historical Income Statement and Balance Sheet
  • Identification of key trends and drivers and historical data manipulation

 4. Making Financial Model – Modeling Income Statement

  • Analysis of the historical income statement, macroeconomic environment and market trends
  • Identification of relevant trends and model drivers
  • Analysis of the cost items and structure
  • Making projections of the Income Statement items
  • Income tax expense forecasting

5. Modeling Balance Sheet

  • Organization and structure of the Balance Sheet
  • Approach to Balance Sheet forecasting
  • Overview of different supporting schedules used in the model Shareholders’ Equity forecasting
  • Forecasting dividends
  • Working Capital Schedule
  • CAPEX and amortization schedule
  • Debt Schedule
6. Modeling Balance Sheet
  • Cash flows from operating, investing and financing activities
  • Integrating the Statement of Cash Flows into the model
7. Connecting and Balancing the Financial Model
  • Connecting the projected financial statements and supporting schedules
  • Balancing the balance sheet – common errors and useful checks
  • Dealing with circular references and making the model robust
  • Checking the model and managing model output
  • Building the scenario manager
  • Running scenarios under different operating assumptions
  • Analyzing model outputs under different scenarios
  • Running sensitivity analysis using data tables
 Recommended Participants:

Analysts, Investment Banking, Private Equity Analysts & Associates, Commercial Bankers, Controllers, Finance Managers & Directors , Business Development Professionals,
MBA and Business/Commerce Students

Training Schedule:

27 – 28 January 2016
2 – 3 March 2016
12 – 13 May 2016
18 – 19 July 2016
1 – 2 September 2016
7 – 8 November 2016


Tags: , , , , , , , , ,