Using Financial Modelling for Analysis and Valuation

Regular price Rs.14,160.00

Shipping calculated at checkout.

 Basic Info : Using Financial Modelling for Analysis and Valuation (Course on Financial Modelling)
Level : Advanced
Commitment  : 8 Days
Language : English
Scheduled Date : 14th Oct 2023


What Will I Learn

At the end of this course you will:

  • Understand Income Statement, Balance Sheet, Cash Flow Statement
  • Learn scheduling & techniques
  • Learn to put it all together and determining clusters from where to extract value
  • Learn important concepts required in valuation


  • Understand how to work with balance sheet components




  • Formatting the data, summarizing, and creating a presentable format.
  • Manipulating Text and Numerical Data
  • Using Pivot Tables to Sumerize Data


  • Converting data into tabular format
  • Identify high profit sales using conditional formatting
  • Excel Best Practices


  • Inputs/Assumptions Worksheet
  • Preparing the 3 Financial Statements


  • Preparing Depreciation & Amortization Schedule
  • Preparing Debt Schedule
  • Other Working Notes


  • Understand the Business Model and Operating Model
  • Modeling the Historical Statement
  • 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
  • Modeling the Depreciation Schedule – Book and Income Tax Depreciation
  • Working Capital and Term Loan Modelling – Debt Infusion
  • Equity Modelling – Equity Infusion


  • WACC and Cost of Equity Analysis
  • Performing Valuation using DCF


  • Performing Sensitivity/Scenario Analysis
  • Comparing the Valuation Summary using Different Parameters


    How It works

       Live Online Sessions
    Each session is interactive and informative, featuring case studies, quizzes and projects

       Interact, Learn and Grow enables you to master the concepts, interact with expert faculty and other learners, and be a part of the community whilst growing.

       Get Certified
    Get Certified from Share your success with the world

    Training 5 or more people?

    We provide custom courses and group sessions as well. To know more about our Customized Programs.

    Try BSE Business Click here