Financial Modelling

 

FINANCIAL MODELING using MS Excel

 

Module 1: Excel Proficiency (optional) – if not opted for, then it is expected that the participants already possess the requisite knowledge of the following)

  • Formatting of Excel Sheets
  • Use of Excel Formulae Function
  • Advanced Modeling Techniques
  • Data Filter and Sort, Table formula, Scenario building, Lookups, Pivot Tables
  • Charts and Graphs
  • Macros, Recording of Macros, understanding Visual Basic Environment

 

Module 2: Valuation Modeling

  • Understanding Integrated Financial Models
  • Scenario Analysis
  • Excel Efficiency Shortcuts and formulae
  • Cash and Interest Revolver
  • Building Historical Financial Statements
  • Ratio Analysis
  • Projecting Financial Statements
  • Valuation by Discounted Cash Flow Method (DCF),
  • Relative Valuation (Football Field Chart)
  • Valuation Assumptions for Valuation Model

 

Module 3: Mergers and Acquisition Analysis

  • Building Merger Inputs
  • Stock and Cash Mix Deal
  • Contribution Analysis
  • Accretion and Dilution

 

Module 4: Project Finance Modeling

  • Project evaluation
  • Stage of project
  • Construction & development phase
  • Funding during investment phase
  • Costs during investment phase
  • Life of project
  • Decision making
  • Interest during construction
  • Understanding Date functions
  • Modeling Cash flow waterfall
  • Delays in Projects