Instructors

Learn from India’s leading Management faculty and Industry leaders

Anjali singh, AVP, Finance Operations, Morgan Stanley

Anjali singh

AVP, Finance Operations, Morgan Stanley

Anjali is a dynamic, enterprising, and assiduous professional with over 6 years of experience in the financial services industry. With the expertise to manage and develop middle-office functions, risk mitigation, operational expertise.

Paras Agnihotri, VP, JPMorgan Chase & Co

Paras Agnihotri

VP, JPMorgan Chase & Co

Having 13+ years of finance experience for multinationals including Oracle, Nomura, Barclays, and JP Morgan Chase, Paras is a computer science graduate developing high-performance industry grade applications using JAVA/Scala stack.

Madhul Agrawal, Assistant Vice President at Citi Bank

Madhul Agrawal

Assistant Vice President at Citi Bank

With 10 years of Experience in Front Office - FIX Support/Client Onboarding & Certification ASPAC/Europe/ US Region, Client Connectivity, SunGard SLC/ SLE, Smart Order Router, trade Floor Support, DevOps He is currently located in Tokyo, Japan.

Shilpi Srivastava, Investment Banking Trainer at DataTrained

Shilpi Srivastava

Investment Banking Trainer at DataTrained

M.B.A. Finance with over 8 years of work experience in the areas of Branch Management, Risk Management & Banking Operations, Client Relationship Management, Team Management, in Banking, Wealth Management & Stock Broking Companies.

Investment Banking Course Syllabus

Best-In-Class content by leading faculty and industry leaders in the form of live sessions, pre-recorded videos, projects, case studies, assignments, and industry webinars.

best investment banking courses

Detailed Syllabus of Investment Banking Course

  • 200+ Hours of content - investment banking program
  • {{$this_course->content_hours}}+

    Hours of content

  • 8 Case Study and Projects - investment banking program
  • 8

    Case Study and Projects

  • 48+ Live Sessions - investment banking certificate programs
  • 48+

    Live Sessions

Comprehensive Curriculum

The curriculum has been designed by faculty from IIMs and Expert Investment Banking Professionals.

200+ Hours of content - investment banking program
{{$this_course->content_hours}}+

Hours of content

8 Case Study and Projects - investment banking program
10

Case Study and Projects

48+ Live Sessions - investment banking certificate programs
48+

Live Sessions

Module 1

Basics of Finance

To learn financial modeling and valuation first of all the learner Should have basic knowledge of corporate finance. So, to fulfill this need the “Basics of Finance” module has been designed so that the leaner can grasp the basics and improve understanding of finance.

  • What is Finance?
  • Three Important Decisions to be Taken in Financial Management
  • Objective of Financial Management
  • Time Value of Money.
Module 2

Introduction to Financial Statements

Most of the financial modeling is based on the three financial statements, Income Statement, Balance Sheet and Cash Flow Statement. This module will introduce the learner to these statements. Also, Ratio Analysis is one of the most used techniques to gauge financial health of the organization. After learning Ratio Analysis, the learner will be able to analyze financial health of any firm.

Income Statement, Balance Sheet, Cash Flow Statement, Interlinkages between the Three Financial Statements, Explanation of Some Important Accounting Terms: Depreciation, Amortization etc., Types of Revenues, Types of Expenses, Ratio Analysis of Financial Statements, Introduction to Annual Report.

Module 3

Basics of Economics

Knowledge of economics (Macro and Micro) is essential for every person who aspires to enter the world of finance. Keeping this in mind, basics of Macroeconomics and Microeconomics will be discussed

Concept of Gross Domestic Product, Inflation, Fiscal Policy, Monetary Policy, Importance of Banking & Cash Reserve Ratio & Statutory Liquidity Ratio.

Concept of Utility, Production function in Short Run and Long Run, Theory of Demand and Supply, Types of Market Structure, Economy, Industry & Company Framework.

Module 4

Introduction to Investment Banking

  • Understanding what investment banking is
  • Recognizing the critical role investment banking plays in the capital formation process.
  • Discovering how investment banking compares with traditional banking.
  • Finding out how investment banking operations make their money.
  • Looking at the different types of investment banks and what they do.
Module 5

Introduction to Financial Modeling and Valuation

This module will help the learner to understand some of the important background knowledge of valuation. The learner will get a taste of the Financial modeling and valuation in this module which will be of immense help in the coming modules.

Basics of Financial Modeling, Philosophical Basis of Valuation, Biases in Valuation, Sources of Uncertainty, Sources of Complexity, Approaches to Valuation: Discounted Cash Flow and Relative Valuation

Module 6

Basic to Advanced Excel

Performing financial modeling is a skill which is best done in excel. To increase the speed, accuracy and presentability of the financial models basic and advanced knowledge of MS Excel is of paramount importance. So, the sophisticated and basic tools in MS Exel will be explained in this module.

Using keys instead of mouse in excel, Cell Freeze, Row Freeze, Column Freeze, Using conditional formatting, Simple excel formulas as sum, product etc, VlookUp/H look up, CAGR Calculation, Transpose function, Pivot Tables, IRR Calculation, XIRR Calculation, Cell Referencing, EMI calculation, Sum if, Count if, Sumifs, SumProduct Functions, Sensitivity Analysis, Scenario Analysis, Goal Seek, Correlation, Regression, Variance, Index and Match, If and Match, Offset with Choose, XNPV.

Module 7

Microsoft PowerPoint

  • Learn how to create slides, use Themes, and apply colour schemes
  • Master how to format text, colours, and bullets
  • Create maximum impact slides by inserting and editing pictures in your slides
  • Learn how to include transition and animation effects
  • organize and manage your slides using PowerPoint’s View options
Module 8

Discounted Cash Flow Valuation

Discounted Cash Flow method is a very sophisticated method of valuation and learners will be exposed to this method by taking data from a real company.

Introduction, Components of DCF, Estimating Cash Flows, Valuing Firm with DCF, Unlevering Beta and Firm Valuation, Forecasting Cash Flows.

Case Study 1 (a): Valuation of Maruti Suzuki Ltd. using Discounted Cash Flow Method.

Description of the case study: In this case study students will learn how to calculate the enterprise value of Maruti Suzuki using one of the most popular methods of corporate valuation, Discounted Cash Flow (DCF) technique. Students will learn to prepare a forecasted income statement, forecasted balance sheet and forecasted cash flow statement

Module 9

Cost of Capital

You cannot use the Discounted Cash Flow technique for valuation without calculating the Cost of Capital. So, learners will be taught to practically calculate the cost of various components of capital like debt and equity.

Introduction, Defining Cost of Capital, Opportunity Cost of Capital, Mode of Financing, Sources of Funds, Cost of Debt, Cost of Debt and Tax Advantage, Determining Cost of Debt, Synthetic Credit Rating, Cost of Equity ke, Weighted Average Cost of Capital.

Case Study 1 (b) Valuation of Maruti Suzuki Ltd. using Discounted Cash Flow Method.

Students will also learn to calculate the Weighted Average Cost of Capital as well which is a key input in DCF valuation. This part will help us in completing the Discounted Cash Flow Module.

Module 10

Relative Valuation

Relative Valuation takes into account how the market has valued similar companies to the company we are trying to value. This technique is more market oriented and is widely used in Equity Research and Valuation.

Introduction, Steps in Comparable Analysis, Equity Value, Enterprise Value, EBITDA, Gross Profit Margin, Growth Metric, Credit Profile and Precedent Transaction Analysis.

Case Study 2: Relative valuation of Tata Motors Ltd.

Description of the case study: When there is a need to quickly calculate the value of a company, relative valuation technique is often the first choice. Through this case study students will learn the art of relative valuation in detail.

Module 11

Start Up Valuation

The present era is the era of startups. Now, you cannot blindly used the valuation techniques like Discounted Cash Flow or Relative Valuation to calculate the value of startups. So, this module will be about how to do financial modeling of a start up and how we can calculate its value.

Introduction, Convertible Debt for Start-Ups, Equity Series Round, Pre- and Post-Money Valuations, Future Dilution, Option Pool, Preferred Stock and Liquidation Preference

Case Study 3: Valuation of Uber: A startup which has made a mark

Description of the case study: Uber, which is one of the most successful start up will be valued in this case study. A startup company has different business dynamics so the valuation method needs to be tailored specifically to value them. This case study will throw light on the right method to calculate the value of a startup.

Module 12

Merger & Acquisition along with LBO.

Merger and Acquisitions are happening very frequently these days as firms join hands or takeover their competitors. The financial modeling of the deal of merger and acquisition will be taught. Also, LBO which is a very unique technique to takeover a company has been used in the past by firms and investors have either made or lost a lot of money as the result of LBO. So, LBO financial modeling will be discussed in which all the important aspects of LBO will be covered.

Introduction, Purchase Price and Stock Payment, Pro Forma Balance Sheet and Valuation of Target with Multiples.

Introduction, LBO Economics and LBO Valuation.

Case Study 4: Merger Modeling of Vodafone and Idea Cellular Ltd.

Description of the case study: To combat the threat of Jio, Vodafone and Idea joined hands through merger. All the modeling aspects of this merger will be covered in this case study.

Case Study 5: Leveraged Buyout (LBO) of Hilton Hotels

Description of the case study: Hilton Hotels LBO has gone into the history books as being one of the most successful LBO's in corporate history. This case study will be focused on spreadsheet modeling of the LBO.

Module 13

Financial Management of Start Ups

  • Cash Flow Management
  • Raising Capital
  • Debt Financing
  • Equity Financing
  • The sale and Revenue Model
  • COGS Model
  • Advertising Model
  • Cost of sales and Marketing Model
  • Cost of Development of Product and making profits

Case Study

Case Study 1 (a) & 1 (b):

Discounted Cash Flow Valuation of Maruti Suzuki Ltd.

Case study overview: This case study will teach you how to value India's largest passenger car company, Maruti Suzuki India Ltd (previously Maruti Udyog Ltd), which accounts for over 50% of the local car market. Discounted Cash Flow valuation will be used. The company sells everything from the Maruti Alto to the Ritz, Swift, Wagon R, DZire, SX4, and Grand Vitara. SMC owns 56.37% of the company's shares. The company manufactures and sells cars and parts (automobiles). The company also manages fleets and finances pre-owned cars. The company's Consolidated Total Income dropped 2.04% to Rs 29,918.40 Crore for the quarter ending 31-12-2022. Income of Rs 30,541.70 Crore, increasing 26.87% from last year's same period. 23,581.20 crores in revenue.

Case Study 2

Tata Motors Ltd. relative valuation.

Case study overview: Automaker Tata Motors Ltd. runs Automotive and Other Operations. The Automotive area includes vehicle development, design, manufacture, assembly, finance, and sales of parts and accessories. This case study teaches relative valuation of Tata Motors Ltd.

Case Study 3

Uber valuation: A successful start-up

Case study overview: Uber Technologies Inc.'s (UBER) rapid expansion and ongoing controversy make it one of the decade's most intriguing companies. The 2009 ride-sharing software changed transportation and became the world's highest-valued private startup. On May 9, 2019, Uber went public. Uber remains a big ride-sharing company despite its struggles. Uber announced $1.1 billion in net profits, $3.9 billion in sales, and 1.5 billion journeys on its network in Q2 FY 2021.

Case Study 4

Vodafone-Idea Cellular merger modeling.

Vodafone and Idea certainly benefited from their merger. The two largest telecom companies merged horizontally. This merger cost $23 billion. Both corporations said the synergy would be cost-effective, so they merged. Annual savings could reach 14,000 crores. Capital and operating costs would be saved. Vodafone India and Idea had far lower market shares than Bharti Airtel and Reliance Jio. Jio revolutionised telecom. 400 million subscribers, 35% customer market share, and 40% revenue market share for the merged corporation. This case study covers merger financial modeling.

Case Study 5

Hilton Hotels LBO

In an all-cash LBO for $26 billion, Blackstone Group took Hilton Worldwide (then Hilton Hotels Corporation) private, financing $20.5 billion (78.4%) with debt and $5.6 billion with equity.Blackstone paid $47.50 for Hilton's common stock. Blackstone owned hotels and resorts such The Boulders, Boca Raton, and La Quinta in 2007. Hilton was paying investors roughly 20% at the time. To grow internationally and enhance margins, it needed a hospitality partner like Blackstone. This case study teaches LBO modeling.