Certificate Program on Financial Modelling


To provide an effective management approach to improve performance in related areas, viz.

  • Decision Making in Finance
  • Quantitative Techniques
  • Appraisal and Project Investment Skills
  • Project Finance Technique
  • Financial Statement Modelling
  • Valuation Modelling
  • It will outline the contemporary Financial Modelling approaches available to managers by using EXCEL spreadsheets.

    DAY - 1: Introduction to Financial Modeling and Spreadsheet Essentials
  • Introduction to Financial Modeling
  • Spreadsheet essentials
    •    • Lookup and reference functions
    •    • NPV and IRR functions
    •    • Data tables
    •    • IF function
    •    • Excel Skills - Shortcuts, Formulas, Array Function and Pivot Tables
    •    • Simple exercise/models in excel

    DAY - 2
  • Economy Analysis
  • Sectoral Analysis

  • DAY - 3 & 4: Frameworks and concepts covered (Data, cost and revenues)
  • Data Collection and Data Structuring
  • Preliminary Scrutiny of the Data and Information
  • Understand the Business Model and Operating Model
  • Modeling the Historical Statement
  • Business Drivers Identification and Modeling
  • Modeling Assumptions for Future Action
    •    • Modeling Revenue Build-up - projecting the future revenues
    •    • Modeling Cost Build-up - projecting the future cost
    •    • Modeling the Asset Schedule

    Day 5, 6, 7: Financial modeling (Financial statement analysis)
  • Equity Modeling - Equity Infusion
  • Modeling Paid Up Capital and Share Premium Account
  • Modeling Retained Earning Schedule
  • Modeling the projected P/L and BS
  • Modeling the projected Cash Flow Statement
  • Conducting Covenant Testing
  • Performing Ratio Analysis
  • WACC and Cost of Equity Analysis
  • Performing Valuation using DCF (FCFF & Enterprise Value) and Comparable analysis (Relative Valuation)
  • Performing sensitivity/scenario analysis

  • Day 8: Case study 1

    Managers and Executives working with Banks, Financial Services, AMC, Hedge Funds, Mutual Funds, Investment Banking, Brokerage Houses, Financial Market Intermediaries, Research Analyst, Portfolio Managers, Risk Managers, Accountants, Project Managers, Managers and Executives in the finance department of manufacturing firms & IT firms.

    NOTE: Prior understanding of spreadsheets and Excel is not a pre requisite and the program would start with the basics of spreadsheet modeling.

    8 full days (Saturdays & Sundays)
    10.00 am to 5.30 pm

    Rs. 24,000.00 + Applicable Taxes per participant inclusive of tuition fees, reference material and (morning / evening) refreshments only.

    For further details regarding contents,
    E-mail: training@bseindia.com