- Course Overview
Online
₹ 475 3,499
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
certificate availability
certificate providing authority
The syllabus
Welcome to the course
Module 1: Valutaion
- What we will 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 statements 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
- Please provide us your valuable feedback on the course thus far
Module 5D: Frecasting 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
- Interest & Borrowings to be repaid in Cash Flow from Financing of Walmart
- Dividends and Share buy back in Cash flow from Financing of Walmart
- Calculating Cash flow from Financing of Walmart
- Calculating end of year Cash balance of Walmart
- Linking the Cash flows statement with Balance sheet
- End of Module 5D
Quick Recap: What have we learnt so far in this course?
- What have we learnt so far in this course?
Module 6A: ValuatioTecnies
- What will we learn in this module?
- What are we trying to estimate when we say "valuation"?
- The two important valuation techniques
- Understanding FREE CASH FLOWS in DCF technique
- Understanding operating cash profits
- Understanding operating cash investments
- Free cash flows are calculated for the future
- Understanding DISCOUNTING in DCF technique
- Understanding the discount rate
- Understanding the present value of explicit cash flows
- Understanding terminal value
- Understanding enterprise value and equity value
- End of Module 6A
Module 6B: Valuation Technique application on a company
- The 5 steps to undertaking the valuation analysis of a company
- Download the excel spreadsheet for this module
- Calculating Earnings Before Interest & Taxes (EBIT) of Walmart
- Calculating post tax Operating profit and Operating cash profit of Walmart
- Calculating Capital expenditures of Walmart
- Calculating Working capital of Walmart
- Calculating total operating cash investments of Walmart
- Calculating the Free Cash Flows to Firm (FCFF) of Walmart
- Calculating Weighted Average Cost of Capital (WACC) of Walmart
- Understanding the concept of DISCOUNTING
- Calculating the present value of FCFF of Walmart
- Calculating the terminal growth rate of Walmart
- Calculating the terminal value or perpetuity value of Walmart
- Calculating the Enterprise value (EV)
- Calculating the consolidated Equity value of Walmart
- Calculating the value of Minority Interests of Walmart
- Calculating the Equity value per share of Walmart
- Calculating the gap in Equity value per share vs current price of Walmart
- End of Module 6B
Module 7: Valuation sensitivity
- What we will learn in this module?
- Implications of the valuation estimate
- Making the "right" assumptions
- Download the excel spreadsheet for this module
- Calculating the valuation sensitivities to changes in important model inputs
- End of Module 7
- Please provide us your valuable feedback on the course thus far
Valuation Guide: Have it by your desk
- Step by step valuation guide
- Please provide us your valuable feedback on the course thus far
End of course - What did we learn in this module?
- Quick Recap
Instructors
Mr Ashish Agarwal 1
Instructor
Freelancer