Financial Modelling

Curriculum:

• Financial Modelling Core
• Basic To Intermediate Excel:
  • Creating a Financial Model Template
  • Cell Freeze, Row Freeze, Column Freeze and Cell Referencing
  • Logical and Statistical Functions (String Function, Offset Function, Data table, Goal seek)
  • Linkages used for Financial Modelling
  • Algebraic operations using Formulas
  • VLOOKUP / HLOOKUP
  • Match Function
  • IRR Calculation and CAGR Calculation
  • Usage of IF function, Table functions, Transpose function
  • Pivot Tables
  • Interest functions as EMI calculator
• Basics Of Business Model:
• Financial Statement Analysis:
  • Introduction to Financial statements
  • Balance Sheet, Profit and Loss and Cash Flow
  • Revenue and Expenses
  • Financial Statement Valuation -Applying DCF
  • Cost of Equity -CAPM
  • Net cost of Debt and WAC
• Financial Modelling Enhanced
• Advanced Excel:
  • Macros and Excel Visualization
  • Combination of multiple functions in a problem as VLOOKUP +Match, Index+ Match, VLOOKUP and If
  • Using Excel for Statistical Analysis like Correlation, Regression, Variance.
  • Summarising data from different sheets and collating them into a single sheet using
  • Charts – Waterfall Charts, Thermometer Charts
  • Practical Application of Formulas and Charting through Creation of Dashboards
  • Advanced excel formulas and Conditional formatting
  • Using referencing framework (usage of $) to effectively use formulas Indirect function.
  • Charts – Waterfall Charts, Thermometer Charts
  • Practical Application of Formulas and Charting through Creation of Dashboards
  • Advanced excel formulas and Conditional formatting
  • Using referencing framework (usage of $) to effectively use formulas.
• Corporate Analysis:
  • Time Value of Money
  • Interest Rates
  • Discounted Cash Flow Analysis
  • Return on Investment
  • Treatment of leases (operating and capital), R&D expenses etc
  • Role of multiples in IPO valuation
  • Running regression analysis on multiple.
• Project Valuation:
  • Project finance introduction
  • Circular Logic and looping
  • Creating EPC Schedule and CAPEX Schedule
  • GANTT Chart Lar Logic and looping
  • Building a Project Finance Model.
• Financial Modelling Advanced
• Merger And Acquisition (M&A):
  • Introduction – Categories, Merger motivators, forms of payment
  • Evaluation – Calculating FCFF, discount and terminal rate and NPVValuation – usage of 10K and 10Q, Merger Analysis
• Building Forecast:
  • Create a Basic IB Financial Model
  • Growth Rates and Proportions
  • Forecasting BS and CFS
  • Forecasting costs and revenues
  • Modelling Revenue and Expenses Drivers
  • Modelling Income Statement and Implied EBITDA
  • Visualization – Interactive excel dashboard
  • VBA:
  • Macro Recording Basics
  • The VBA Editor
  • VBA & The Object Library
  • Objects, Properties and methods
  • Referencing a Range
  • Important Range Properties
  • The Worksheets Collection
  • ActiveX and Dashboards
• Financial Modelling Turbo
  • Turbo course offers students the benefit of CORE+ ENHANCED+ ADVANCED