Company Valuation & Financial Modeling

Course Curriculum

Chapter 1: Welcome to the course

Lecture 1: Course overview

Chapter 2: Module 1: Valuation

Lecture 1: What will we learn in this module?

Lecture 2: What is valuation?

Lecture 3: Different schools of thought in valuation of companies

Lecture 4: Application of valuation analyst skills

Lecture 5: End of Module 1

Chapter 3: Module 2: Valuation framework

Lecture 1: What will we learn in this module?

Lecture 2: Valuation framework – Step 1 : Business model

Lecture 3: Valuation framework – Step 2: Historical financials

Lecture 4: Valuation framework – Step 3: Forecast financials

Lecture 5: Valuation framework – Step 4: Valuation technique

Lecture 6: Valuation framework – Step 5: Valuation sensitivity

Lecture 7: Valuation as an art and science

Lecture 8: Valuation in the context of a real company

Lecture 9: End of Module 2

Chapter 4: Module 3: Business model of a company

Lecture 1: What will we learn in this module?

Lecture 2: Business model – Products

Lecture 3: Business model – Costs

Lecture 4: Business model – Operations

Lecture 5: Business model – Financing

Lecture 6: Business model – Strategy

Lecture 7: Sources of information for capturing the business model of a company

Lecture 8: Downloading Walmart annual report

Lecture 9: Reading through Walmart annual report

Lecture 10: Walmart business model – Products

Lecture 11: Walmart business model – Cost

Lecture 12: Walmart business model – Operations

Lecture 13: Walmart business model – Financing

Lecture 14: Walmart business model – Strategy

Lecture 15: End of Module 3

Chapter 5: Module 4: Financial statements of a company

Lecture 1: What will we learn in this module?

Lecture 2: The three key financial statements of any company

Lecture 3: The typical structure of an income statement of a company

Lecture 4: The typical structure of a balance sheet of a company

Lecture 5: The typical structure of a cash flow statement of a company

Lecture 6: Sources of information of the historical financial statements

Lecture 7: Capturing Walmart's historical financial statements from Annual Report

Lecture 8: Download the excel template for this module

Lecture 9: Standardized income statements

Lecture 10: Understanding minority interests

Lecture 11: Standardized income statements – contd.

Lecture 12: Standardized balance sheet

Lecture 13: Capturing Walmart's income statement

Lecture 14: Capturing Walmart's balance sheet

Lecture 15: Conclusion

Lecture 16: End of Module 4

Chapter 6: Module 5A : Financial ratio analysis of a company

Lecture 1: What will we learn in this module?

Lecture 2: The five steps to forecasting the financial statements

Lecture 3: Download the excel template for this module

Lecture 4: Calculating revenue growth, COGS margin and SGA margin for Walmart

Lecture 5: Calculating depreciation rate and interest rate for Walmart

Lecture 6: Calculating effective tax rate and minority interests for Walmart

Lecture 7: Calculation of AR, Inventory, PPE and AR ratio for Walmart

Lecture 8: Cash flows statement in Walmart Annual Report

Lecture 9: Re-download the excel template for this module

Lecture 10: Calculating the borrowings and dividend payout ratio for Walmart

Lecture 11: End of Module 5A

Chapter 7: Module 5B: Extrapolating financial ratios of a company

Lecture 1: Extrapolating the Revenue growth rate for Walmart

Lecture 2: Extrapolating the COGS margin and SGA margin for Walmart

Lecture 3: Extrapolating the Depreciation rate for Walmart

Lecture 4: Extrapolating Interest rate, Effective Tax rate & Minority Interest for Walmart

Lecture 5: Extrapolating AR, Inventory, PPE and AP ratio for Walmart

Lecture 6: Extrapolating short term Borrowings for Walmart

Lecture 7: Extrapolating long term Borrowings for Walmart

Lecture 8: Extrapolating Dividends for Walmart

Lecture 9: End of Module 5B

Chapter 8: Module 5C: Forecasting the Income statement and Balance sheet of a company

Lecture 1: Forecasting future financial statements of a company

Lecture 2: Forecasting the Revenues for Walmart

Lecture 3: Forecasting COGS, Gross Profit and SGA for Walmart

Lecture 4: Forecasting Depreciation and EBIT for Walmart

Lecture 5: Forecasting Interest expense and EBT for Walmart

Lecture 6: Forecasting Taxes, Minority interests and Profits for Walmart

Lecture 7: Forecasting Inventory, AR and other Current assets for Walmart

Lecture 8: Lecture 79: Forecasting Fixed Assets, Goodwill and Other Long term Assets

Lecture 9: Forecasting short term Borrowings for Walmart

Lecture 10: Forecasting AP and other current liabilities for Walmart

Lecture 11: Forecasting Long term borrowings and other liabilities for Walmart

Lecture 12: Forecasting Minority interests for Walmart

Lecture 13: Forecasting Common Equity for Walmart

Lecture 14: Quick Recap of what we have learnt so far

Lecture 15: End of Module 5C

Lecture 16: Please provide us your valuable feedback on the course thus far

Chapter 9: Module 5D: Forecasting the Cash Flows statement of a company

Lecture 1: Cash flows statement of any company

Lecture 2: Non-cash costs in Cash flow from Operations of Walmart

Lecture 3: Non operating expenses in Cash flow from Operations of Walmart

Lecture 4: Current operating liabilities in Cash flow from Operations of Walmart

Lecture 5: Current operating assets in Cash flow from Operations of Walmart

Lecture 6: Calculating Cash flow from Operations of Walmart

Lecture 7: Cash flow from Investments

Lecture 8: Capital expenditures for Cash flow from Investments of Walmart

Lecture 9: Calculating cash flow from Investments of Walmart