Best Seller Financial Analyst Bootcamp Live Class

Overview

Live Online Classes Curriculum Download Curriculum

• Module 01 – Ratio Analysis - Fundamental Analysis Bootcamp

  How to analyze a company?

  • Common size statements
    • Balance sheet
    • Income statement
  • Internal liquidity analysis
    • Current ratio / quick ratio / cash ratio
    • Inventory turnover
    • Receivable turnover
    • Payables turnover
  • Operating profitability analysis
    • Gross profit margins
    • Operating margins
    • Return on total capital
    • DuPont analysis - Return on equity
    • Extended DuPont analysis
  • Risk analysis
    • Operating leverage
    • Financial leverage
    • Debt to equity ratio
    • Interest coverage ratio
  • Growth analysis
    • Sustainable growth rate
  • Colgate Case Study
• Module 02 – Financial Modeling - Fundamental Analysis Bootcamp

  Introduction to Modeling

  • Introduction to financial modeling
    • Why financial models are used?
    • What skills are needed for financial modeling?
    • General structure and model design
  • Historical data
    • Sources of information
    • Presentation of historical data
    • Analysis of historical data
  • Building the model
  • Core statements

  Projecting Schedules

  • Revenues
  • Costs
  • Fixed asset, capital expenditure, and depreciation schedule
  • Capital lease schedule
  • Amortization schedule
  • Working capital and change in working capital schedule
  • Completion of income statement logic
  • Shareholders’ equity schedule
  • Shares outstanding schedule
  • Individual schedules of inventory, deferred revenue, receivables, and other working capital categories
  • Other long-term items schedule
  • Debt and debt repayment schedule
  • Interest schedule
  • Income tax schedule
  • Schedules of investments and dividends received
  • Details of minority and non-consolidated subsidiaries

  Drivers

  • Income statement drivers
    • Revenues
    • Costs
    • Operating expenses
    • Other income statement items
    • Income taxes
    • Equity income
    • Minority interest 
  • Balance sheet drivers - assets
    • Working capital
    • Cash and cash equivalents
    • Accounts receivables
    • Inventories
    • Fixed assets (PPE, depreciation and net fixed assets)
    • Non-consolidated subsidiaries
  • Balance sheet drivers – liabilities
    • Short term debt
    • Accounts payable
    • Deferred taxes, accrued liabilities, and other current Liabilities
    • Minority interest
    • Equity

  Balancing Act

  • Balancing the balance sheet
    • Calculating cash flow from operations
    • Calculating cash flow from investing activities
    • Calculating cash from financing activities
    • Calculating net cash flows

  CASE STUDY

  • Colgate Case Study
• Module 03 – Business Valuation - Business Valuation Bootcamp

  Valuation Overview

  • Valuation Overview
    • Why valuation?
    • Importance of valuation
    • Valuation approach 
    • Key valuation tools
    • Valuation summary table
    • Key valuation questions
    • Valuation – subjectivity versus objectivity
  • Introduction to discounted cash flow
  • Discounted cash flow
    • Overview of discounted cash flow
    • Steps in a Discounted cash flow (DCF)

  Discounted Cash Flows

  • Free cash flow
    • Valuing a firm using free cash flow to firm (FCFF)
    • Valuing a Firm using free cash flow to equity (FCFE)
    • Suitability of FCFF and FCFE
  • Discounted cash flow projections
    • Sales
    • Operating expenses
    • Depreciation
    • Capital expenditure
    • Income tax
    • Working capital
    • Deferred tax
    • Projections – some questions?
  • Terminal Value
    • Terminal value overview
    • Exit value method
    • Exit multiple exercise
    • Perpetuity growth method
    • Perpetuity growth exercise
    • Terminal value spot check
    • Terminal value concerns

  Discount Rate

  • Discount rate overview
  • Discount rate – cost of debt
    • Yield to maturity method
    • Credit rating method
    • Synthetic rating method
    • Company report method (spot check!)
  • Risks
    • Unsystematic risk
    • Systematic risk

  Capital Asset Pricing Model

  • Introduction to capital asset pricing model (CAPM)
  • Risk-free rate
  • Beta
    • Calculation of regression beta
    • Calculation of bottom-up beta – levered and unlevered beta
    • Beta concern
    • Preferred beta methodology
  • Market risk premium
    • Historical risk premium method
    • Forecast risk premium method
    • Market risk premium: size premium

  DCF Synthesis

  • DCF – present value
    • Discounting
    • Mid-year discounting
    • Valuation
  • Sensitivity analysis
    • FCF and terminal value using growth rate and WACC as inputs
    • Enterprise value using growth rate and WACC as inputs
    • Price/share using growth and WACC as inputs
    • Effect on EPS by changing the value drivers

  Valuation Multiple

  • What is a multiple?
  • Why multiples vary
  • Advantages and disadvantages of Multiples
  • Identifying comparables
    • Operational parameters
    • Financial parameters
  • Equity value
  • Enterprise value
  • Advantages of equity value and enterprise value
  • Introduction to equity value multiples
  • Introduction to enterprise value multiples

  Equity and Enterprise Multiple

  • Calculation of valuation multiples
  • Enterprise value multiples
    • EV/Sales
    • EV/EBITDA
    • EV/EBIT
    • EV/FCF
    • EV/Capacity
  • Equity value multiples
    • P/E
    • P/CF
    • P/BV
    • PEG
    • Dividend Yield
  • Let’s put it together!

  Other Valuation Approaches

  • Asset-based valuation
  • Sum of parts
  • Mergers and acquisitions comparables
  • Replacement cost method
  • Qualitative factors in valuation - management quality
• Module 04 – Mergers & Acquisitions - Mergers & Acquisitions Bootcamp
  • Overview of Mergers & Acquisition
  • Purchase Price Calculations & Sources
    • Purchase Price Calculations
    • Sources & Uses of Funds
  • Financial Statements
    • Purchase Price Allocation
    • Proforma Opening Balance Sheet Format
    • Proforma P&L Forecast
    • Proforma NI & EPS
    • Proforma Balance Sheet Actuals & Forecast
    • Working Capital Calculations
    • Proforma Statement Completion
    • Preparation of Proforma Cash Flow Statement
    • Debt Repayment Schedule
  • Accretion & Dilution Calculations
  • Synergies and Assumptions
    • Synergy Assumptions
    • Synergy Calculations
  • Sensitivity Analysis
  • Summary
• Module 05 – Leveraged Buyout - Leveraged Buyout Bootcamp
  • Overview of Leverage Buyout
  • Transaction Assumptions
    • Transaction Assumptions
    • Debt Assumptions
    • Sources & Uses of Funds
  • Projecting Schedules
    • Revenue Built-up
    • Cost Sheet
    • Working Capital Management
    • Depreciation & Amortization
  • Linking to Financial Statements
    • Linking to Income Statement
    • Linking to Balance Sheet
    • Linking to cash Flow Statement
  • Shareholder’s Equity & Debt Schedule Calculations
    • Shareholder’s Equity Schedule
    • Debt Schedule
    • Completing the Missing Links
  • IRR & Sensitivity Analysis
• Module 06 – Private Equity - Private Equity Bootcamp
  • Overview of Private Equity
  • PE Structure
    • Basic Structure
    • Deal Structuring
    • Pre and Post Money
    • Effective Share Price
  • PE Strategies
    • Venture Capital
    • Growth Capital
    • Leverage Buyouts
    • Private Equity Investments
  • PE Fund
    • General Partner
    • Parallel Funds
    • Feeder Funds
    • Capital Commitments
    • Distribution Waterfall
    • Carried Interest and Catch Up
    • Claw Back
    • Fund Fees
    • Fund Expenses and Marketing
    • Fund Closing and Fund Term
  • Building the Model
• Module 07 – Venture Capital - Venture Capital Bootcamp
  • Lifecycle of Venture Capital
  • Company Valuation and Money Valuation
    • Structure
    • Pre and post Money Calculation
    • Capitalization Table
  • Calculating Investor Return
    • Calculating Investor Return
  • Return Analysis & Total Equity Valuation
    • Return Analysis
    Total Equity Valuation
  • IRR Calculation
    • Internal Rate of Returns Calculation
    • Free Cash Flow Calculations