Using Financial Modelling for Analysis and Valuation + Certificate Program on Investment Banking

Sale price Rs.28,320.00 Regular price Rs.37,760.00

Shipping calculated at checkout.
Basic Info : Using Financial Modelling for Analysis and Valuation + Certificate Program on Investment Banking
Level : Advanced
Commitment  : 8 Days + 15 days
Language : English
Schedule Date : 27th Jan 2024

What will I learn?

 At the end of this course you will:

  • Understand Income Statement, Balance Sheet, Cash Flow Statement
  • Learn scheduling & techniques
  • Learn important concepts required in valuation
  •  Understand how to work with balance sheet components
  • Learn how to value investment projects under conditions of uncertainty
  • Acquire essential financial modeling skills.
  • Be able to assess the credit quality of companies and gain thorough understanding of the M&A process from target company identification to funding strategies and deal structuring.



  • This training program will help you develop the complete set of desk-ready skills relevant to Investment Banking.
  • Based on a sound conceptual understanding of the fundamental principles of finance, we teach you how to use the tools and techniques to get the job done.


Curriculum -  Using Financial Modelling for Analysis and Valuation

Trading Psychology

  • 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

Curriculum - Certificate Program on Investment Banking

  • Introducing Investment Banking

  • How Investment Bankers Sell Companies

  • Role of Investment Banking in Mergers and Acquisition

  • How Investment Banking Is Used in Leveraged Buyouts

  • Finding Data - Document and reports.

  • Making Sense of Financial Statements

  • Perfecting the Financial Ratios for Investment Banking

  • Sizing up the Industry.

  • Understanding Stocks and Focusing on Past Transactions.

  • Applying Investment Banking to Fixed Income

  • Doing a Discounted Free Cash Flow Analysis

  • Structuring a Leveraged Buyout.

  • Determining The Strength Of A Company’s Return On Equity

  • Return on Equity

  • Knowing the rules

    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