Using Financial Modelling for Analysis and Valuation

Regular price Rs.14,160.00


 Basic Info : Course on Financial Modelling
Level : Advance
Commitment  : 16 hours of study, 8 Days 2 hours 
Language : English
Scheduled Date : 27th July 2020

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

Curriculum

  • 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 Practises

  • 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 Classroom Sessions
    Each session is interactive and informative, featuring case studies, quizzes and projects

       Interact, Learn and Grow
    bsevarsity.com 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 bsevarsity.com. Share your success with the world