Certificate Program in Financial Modelling


Financial modelling assists the management not only in the decision-making process but also in the preparation of financial analysis. Certificate program in financial modelling focuses 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 Modelling and Financial Statements
    Understanding Income Statement and Balance Sheet
    Understanding Cash Flow Statement
    Financial Ratio Analysis

    Day 2
    Introduction to Business Valuation
    Relative valuation
    Cash flow based valuation

    Day 3
    Financial Model - I: Building Income Statement and Balance Sheet

    Day 4
    Forecasting financial statements and scenario analysis
    Income Statement
    Balance Sheet – Assets, Liabilities Shareholders' Equity, other assumptions

    Day 5
    Fixed assets schedule
    Add, depreciate, split, revalue, and dispose of fixed assets.

    Day 6
    Working capital schedule and analysis
    Concept of Working Capital
    Importance of Working Capital
    Requirement of Working Capital
    Working Capital Analysis of GSRTC

    Day 7
    Equity schedule

    Day 8
    Case Study
  • Managers and Executives working with Banks, Financial Services, AMC, Hedge Funds and Mutual Funds, Investment Banking, Brokerage Houses and Financial Market Intermediaries
  • Research Analyst
  • Portfolio Managers
  • Risk Managers
  • Accountants
  • Project Managers
  • Managers and Executives in the finance department of manufacturing firms & IT firms
  • 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