This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Premium : Valuation Analysis Skills Bootcamp
Welcome on Board: An Introduction
Live Interactive Sessions
The captain of your Learning journey: Your instructor (1:38)
1: Itinerary of this Journey: Course overview (3:46)
Module 1: Valuation
2: What will we learn in this module? (1:25)
3: What is Valuation? (2:13)
4: Different schools of thought in valuation of companies (2:39)
5: Application of valuation analyst skills (2:30)
6: End of Module 1
Module 2: Valuation framework
7: What will we learn in this module? (0:20)
8: Valuation framework - Step 1 : Business model (1:55)
9: Valuation framework - Step 2: Historical financials (1:18)
10: Valuation framework - Step 3: Forecast financials (1:02)
11: Valuation framework - Step 4: Valuation technique (0:48)
12: Valuation framework - Step 5: Valuation sensitivity (0:57)
13: Valuation as an art and science (0:42)
14: Valuation in the context of a real company (1:26)
15: End of Module 2
Quiz #1: Test your learning of the module
16: Please provide us your valuable feedback on the course thus far
Module 3: Business model of a company
17: What will we learn in this module? (1:51)
18: Business model - Products (1:34)
19: Business model - Costs (1:32)
20: Business model - Operations (0:51)
21: Business model - Financing (0:49)
22: Business model - Strategy (0:54)
23: Sources of information for capturing the business model of a company (2:14)
24: Downloading Walmart annual report (2:14)
25: Reading through Walmart annual report (5:08)
26: Walmart business model - Products (1:54)
27: Walmart business model - Cost (1:09)
28: Walmart business model - Operations (1:12)
29: Walmart business model - Financing (1:19)
30: Walmart business model - Strategy (2:49)
31: End of Module 3
32: Please provide us your valuable feedback on the course thus far
Module 4: Financial statements of a company
33: What will we learn in this module? (1:59)
34: The three key financial statements of any company (2:38)
35: The typical structure of an income statement of a company (2:42)
36: The typical structure of a balance sheet of a company (3:10)
37: The typical structure of a cash flow statement of a company (5:18)
38: Sources of information of the historical financial statements (2:56)
39: Capturing Walmart's historical financial statements from Annual Report (4:28)
40: Download the excel template for this module (0:34)
41: Standardized income statements (5:24)
42: Understanding minority interests (3:00)
43: Standardized income statements - contd. (0:55)
44: Standardized balance sheet (3:25)
45: Capturing Walmart's income statement (4:19)
46: Capturing Walmart's balance sheet (5:08)
47: Conclusion (0:42)
48: End of Module 4
49: Please provide us your valuable feedback on the course thus far
Module 5A : Financial ratio analysis of a company
50: What will we learn in this module? (2:17)
51: The five steps to forecasting the financial statements (2:06)
52: Download the excel template for this module (0:34)
53: Calculating revenue growth, COGS margin and SGA margin for Walmart (5:49)
54: Calculating depreciation rate and interest rate for Walmart (5:28)
55: Calculating effective tax rate and minority interests for Walmart (3:19)
56: Calculation of AR, Inventory, PPE and AR ratio for Walmart (7:50)
57: Cash flows statement in Walmart Annual Report (4:48)
58: Re-download the excel template for this module (0:34)
59: Calculating the borrowings and dividend payout ratio for Walmart (3:14)
60: End of Module 5A
61: Please provide us your valuable feedback on the course thus far
Module 5B: Extrapolating financial ratios of a company
62: Extrapolating the Revenue growth rate for Walmart (4:44)
63: Extrapolating the COGS margin and SGA margin for Walmart (4:35)
64: Extrapolating the Depreciation rate for Walmart (1:13)
65: Extrapolating Interest rate, Effective Tax rate & Minority Interest for Walmart (4:07)
66: Extrapolating AR, Inventory, PPE and AP ratio for Walmart (6:08)
67: Extrapolating short term Borrowings for Walmart (3:19)
68: Extrapolating long term Borrowings for Walmart (5:36)
69: Extrapolating Dividends for Walmart (6:04)
70: BREATHE & PAUSE: End of Module 5B
71: Please provide us your valuable feedback on the course thus far
71: Please provide us your valuable feedback on the course thus far
Module 5C: Forecasting the Income statement and Balance sheet of a company
72: Forecasting future financial statements of a company (0:35)
73: Forecasting the Revenues for Walmart (3:59)
74: Forecasting COGS, Gross Profit and SGA for Walmart (6:05)
75: Forecasting Depreciation and EBIT for Walmart (5:14)
76: Forecasting Interest expense and EBT for Walmart (4:50)
77: Forecasting Taxes, Minority interests and Profits for Walmart (6:57)
78: Forecasting Inventory, AR and other Current assets for Walmart (7:27)
79: Forecasting short term Borrowings for Walmart (2:57)
80: Forecasting AP and other current liabilities for Walmart (3:08)
81: Forecasting Long term borrowings and other liabilities for Walmart (3:01)
82: Forecasting Minority interests for Walmart (2:07)
83: Forecasting Common Equity for Walmart (5:24)
84: Quick Recap of what we have learnt so far (1:12)
85: End of Module 5C
86: Please provide us your valuable feedback on the course thus far
Module 5D: Forecasting the Cash Flows statement of a company
87: Cash flows statement of any company (2:33)
88: Non-cash costs in Cash flow from Operations of Walmart (2:56)
89: Non operating expenses in Cash flow from Operations of Walmart (1:47)
90: Current operating liabilities in Cash flow from Operations of Walmart (3:21)
91: Current operating assets in Cash flow from Operations of Walmart (4:06)
92: Calculating Cash flow from Operations of Walmart (1:25)
93: Cash flow from Investments (1:18)
94: Capital expenditures for Cash flow from Investments of Walmart (4:35)
95: Calculating cash flow from Investments of Walmart (1:57)
96: Borrowings to be repaid in Cash flow from Financing of Walmart (2:59)
97: Interest & Borrowings to be repaid in Cash Flow from Financing of Walmart (2:38)
98: Dividends and Share buy back in Cash flow from Financing of Walmart (2:03)
99: Calculating Cash flow from Financing of Walmart (1:50)
100: Calculating end of year Cash balance of Walmart (4:24)
101: Linking the Cash flows statement with Balance sheet (3:02)
102: End of Module 5D
103: Please provide us your valuable feedback on the course thus far
Quick Recap: What have we learn in this course so far?
104: What have we learnt so far in this course? (3:14)
Module 6A: Valuation technique
105: What will we learn in this module? (1:48)
106: What are we trying to estimate when we say "valuation"? (2:16)
107: The two important valuation equations (1:09)
108: Understanding FREE CASH FLOWS in DCF technique (1:46)
109: Understanding operating cash profits (1:00)
110: Understanding operating cash investments (1:06)
111: Free cash flows are calculated for the future (1:11)
112: Understanding DISCOUNTING in DCF technique (1:01)
113: Understanding the discount rate (1:28)
114: Understanding the present value of explicit cash flows (0:50)
115: Understanding terminal value (2:17)
116: Understanding enterprise value and equity value (0:38)
117: End of Module 6A
118: Please provide us your valuable feedback on the course thus far
Module 6B: Valuation technique application on a company
119: The 5 steps to undertaking the valuation analysis of a company (3:54)
120: Download the excel spreadsheet for this module (0:34)
121: Calculating Earnings Before Interest & Taxes (EBIT) of Walmart (5:07)
122: Calculating post tax Operating profit and Operating cash profit of Walmart (4:44)
123: Calculating Capital expenditures of Walmart (1:57)
124: Calculating Working capital of Walmart (4:49)
125: Calculating total operating cash investments of Walmart (2:12)
126: Calculating the Free Cash Flows to Firm (FCFF) of Walmart (1:20)
127: Calculating Weighted Average Cost of Capital (WACC) of Walmart (5:11)
128: Understanding the concept of DISCOUNTING (2:55)
129: Calculating the present value of FCFF of Walmart (4:46)
130: Calculating the terminal growth rate of Walmart (3:45)
131: Calculating the terminal value or perpetuity value of Walmart (3:53)
132: Calculating the Enterprise value (EV) (1:52)
133: Calculating the consolidated Equity value of Walmart (4:55)
134: Calculating the value of Minority Interests of Walmart (5:02)
135: Calculating the Equity value per share of Walmart (2:50)
136: Calculating the gap in Equity value per share vs current price of Walmart (1:07)
137: End of Module 6B
138: Please provide us your valuable feedback on the course thus far
Module 7: Valuation sensitivity
139: What will we learn in this module? (1:33)
140: Implications of the valuation estimate (1:56)
141: Making the "right" assumptions (2:08)
142: Download the excel spreadsheet for this module (0:34)
143: Calculating the valuation sensitivities to changes in important model inputs (5:49)
144: End of Module 7
145: Please provide us your valuable feedback on the course thus far
VALUATION GUIDE - HAVE IT BY YOUR DESK
146: Step by step valuation guide
147: Your destination is reached: A Quick Recap (2:39)
148: Please provide us your valuable feedback
PRACTICE ASSIGNMENTS - Take this to test your learnings from the course
149: Practice Assignment #1: DIFFICULTY LEVEL - MEDIUM
150: Practice Assignment #2: DIFFICULTY LEVEL - MEDIUM
151: Practice Assignment #3: DIFFICULTY LEVEL - HARD
152: Practice Assignment #4: DIFFICULTY LEVEL - MEDIUM
153: Practice Assignment #5: DIFFICULTY LEVEL - EASY
154: Share your thoughts
65: Extrapolating Interest rate, Effective Tax rate & Minority Interest for Walmart
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock