IIRF Online > Finance & Accounting > Financial Modeling & Analysis > Company Valuation > Company Valuation & Financial Modeling
Company Valuation & Financial Modeling by Udemy
Learn comprehensive financial modeling, forecasting and business valuation techniques for Finance professionals
Course Highlights
- Build a complete valuation model of any company
- Analyze the Annual Report of any company
- Build historical financial statements of any company
- Forecast future financial statements of any company
- Perform valuation analytics on any company
- Undertake sensitivity analysis of a valuation estimate
Skills you will learn!
Curriculum
1 Topic
Course overview
5 Topics
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
9 Topics
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
15 Topics
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
16 Topics
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
11 Topics
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
9 Topics
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
16 Topics
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
16 Topics
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
1 Topic
What have we learnt so far in this course?
13 Topics
What will we learn in this module?
What are we trying to estimate when we say "valuation"?
The two important valuation equations
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
19 Topics
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
7 Topics
What will we 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
2 Topics
Step by step valuation guide
Please provide us your valuable feedback on the course thus far
2 Topics
Quick Recap
Please provide us your valuable feedback
Company Valuation & Financial Modeling
Related Company Valuation Courses
Thank You!
Your review has been submitted successfully.