Welcome to the course
  • Course overview
Module 1: Valuation
  • What will we learn in this module?
  • What is valuation?
  • Different schools of thought in valuation of companies
  • Application of valuation analyst skills
  • End of Module 1
Module 2: Valuation framework
  • What will we learn in this module?
  • Valuation framework - Step 1 : Business model
  • Valuation framework - Step 2: Historical financials
  • Valuation framework - Step 3: Forecast financials
  • Valuation framework - Step 4: Valuation technique
  • Valuation framework - Step 5: Valuation sensitivity
  • Valuation as an art and science
  • Valuation in the context of a real company
  • End of Module 2
Module 3: Business model of a company
  • What will we learn in this module?
  • Business model - Products
  • Business model - Costs
  • Business model - Operations
  • Business model - Financing
  • Business model - Strategy
  • Sources of information for capturing the business model of a company
  • Downloading Walmart annual report
  • Reading through Walmart annual report
  • Walmart business model - Products
  • Walmart business model - Cost
  • Walmart business model - Operations
  • Walmart business model - Financing
  • Walmart business model - Strategy
  • End of Module 3
Module 4: Financial statements of a company
  • What will we learn in this module?
  • The three key financial statements of any company
  • The typical structure of an income statement of a company
  • The typical structure of a balance sheet of a company
  • The typical structure of a cash flow statement of a company
  • Sources of information of the historical financial statements
  • Capturing Walmart's historical financial statements from Annual Report
  • Download the excel template for this module
  • Standardized income statements
  • Understanding minority interests
  • Standardized income statements - contd.
  • Standardized balance sheet
  • Capturing Walmart's income statement
  • Capturing Walmart's balance sheet
  • Conclusion
  • End of Module 4
Module 5A : Financial ratio analysis of a company
  • What will we learn in this module?
  • The five steps to forecasting the financial statements
  • Download the excel template for this module
  • Calculating revenue growth, COGS margin and SGA margin for Walmart
  • Calculating depreciation rate and interest rate for Walmart
  • Calculating effective tax rate and minority interests for Walmart
  • Calculation of AR, Inventory, PPE and AR ratio for Walmart
  • Cash flows statement in Walmart Annual Report
  • Re-download the excel template for this module
  • Calculating the borrowings and dividend payout ratio for Walmart
  • End of Module 5A
Module 5B: Extrapolating financial ratios of a company
  • Extrapolating the Revenue growth rate for Walmart
  • Extrapolating the COGS margin and SGA margin for Walmart
  • Extrapolating the Depreciation rate for Walmart
  • Extrapolating Interest rate, Effective Tax rate & Minority Interest for Walmart
  • Extrapolating AR, Inventory, PPE and AP ratio for Walmart
  • Extrapolating short term Borrowings for Walmart
  • Extrapolating long term Borrowings for Walmart
  • Extrapolating Dividends for Walmart
  • End of Module 5B
Module 5C: Forecasting the Income statement and Balance sheet of a company
  • Forecasting future financial statements of a company
  • Forecasting the Revenues for Walmart
  • Forecasting COGS, Gross Profit and SGA for Walmart
  • Forecasting Depreciation and EBIT for Walmart
  • Forecasting Interest expense and EBT for Walmart
  • Forecasting Taxes, Minority interests and Profits for Walmart
  • Forecasting Inventory, AR and other Current assets for Walmart
  • Lecture 79: Forecasting Fixed Assets, Goodwill and Other Long term Assets
  • Forecasting short term Borrowings for Walmart
  • Forecasting AP and other current liabilities for Walmart
  • Forecasting Long term borrowings and other liabilities for Walmart
  • Forecasting Minority interests for Walmart
  • Forecasting Common Equity for Walmart
  • Quick Recap of what we have learnt so far
  • End of Module 5C
Module 5D: Forecasting the Cash Flows statement of a company
  • Cash flows statement of any company
  • Non-cash costs in Cash flow from Operations of Walmart
  • Non operating expenses in Cash flow from Operations of Walmart
  • Current operating liabilities in Cash flow from Operations of Walmart
  • Current operating assets in Cash flow from Operations of Walmart
  • Calculating Cash flow from Operations of Walmart
  • Cash flow from Investments
  • Capital expenditures for Cash flow from Investments of Walmart
  • Calculating cash flow from Investments of Walmart
  • Borrowings to be repaid in Cash flow from Financing of Walmart