Mô tả

Hey, welcome to our very popular Company Valuation and Financial Modeling online course. 

We are glad to see you visit this course. 

If only we could shake hands!


What is this course about?

In this course, we will teach you the comprehensive skills to undertake the valuation of any company.

We will illustrate the following broad content topics in great detail in this course:

1) Understanding the business model 

2) Preparing the financial statements - income statement, balance sheet and cash flows statement

3) Forecasting the financial statements

4) Discounted Cash Flows based valuation techniques

5) Sensitivities of valuation estimates

It is a very comprehensive course that will teach you the complete skills to perform the valuation analysis of any company.


How is this course useful for YOUR purpose?

Hey, did you watch the promo video? If not, please do. 

This course will help you to stand in good stead for a potential Analyst profile in the following sectors:

  • Investment banking

  • Equity Research

  • Private Equity

  • Asset Management 

  • Consulting / Advisory

Look, the Analyst profile is quite demanding in all of the above jobs.

So your employer will want you to be on ready to work on a real project on Day 1!

Our course does exactly that - we make you job ready for your professional work.

The course provides all the practical training to undertake the role of an analyst in the above sectors.

You can crack your upcoming interviews easily with the learning from this course.

You have lifetime access to the course once you enroll. 

So even if you don't plan to start now, you can still enroll and come back anytime later.



What makes this course different than others?

This course content is unique!

You will learn exactly what you are required to do in your daily work.

You get access to practical real life illustrations of all key skills to be a Analyst with Financial services firms

It is a completely hands-on course.

You need to carry out the illustrations in the course along with the instructor.

We provide you the same set up as the instructor. 

All illustration spreadsheets can be downloaded at your end.

You will feel as if somebody is guiding you step by step in all illustrations.

It is a very practical on the job training for you.

You are going to love our instructor's teaching style. 

He makes it very engaging and fun learning experience.

You will have practice assignments to test your learning from the course

The Practice Assignments are marked with varying difficulty levels - High, Medium and Low.

You will have unlimited access to our support.

Our support team responds to any course queries within 24 hours of your request. 

There are manually edited hand typed captions added on all lectures of this course. 

Feel free to refer to them in case you feel the need.


What are other students saying about this course?

Check our our reviews below.

Read what student Daniel Hughes had to say about this course- 

"Valuable information, Clear explanations, Engaging delivery, Helpful practice activities, Accurate course description, Knowledgeable instructor"

Go to the reviews section below to read more such stories.


What if I do not like the course?

Well, we will be very sad to hear that you did not like the course.

But you are well protected.

You have a 30 day money back guarantee in case you are not happy with the course.

No questions asked.

But we sincerely hope, you will definitely like the course!



What  next?

If there are any doubts, don't hesitate to reach out to us.

Start learning now.

See you inside the course.


Bạn sẽ học được gì

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

Yêu cầu

  • None. We will teach everything from scratch.

Nội dung khoá học

15 sections

Welcome to the course

1 lectures
Course overview
03:46

Module 1: Valuation

5 lectures
What will we learn in this module?
01:25
What is valuation?
02:13
Different schools of thought in valuation of companies
02:39
Application of valuation analyst skills
02:30
End of Module 1
00:19

Module 2: Valuation framework

9 lectures
What will we learn in this module?
00:20
Valuation framework - Step 1 : Business model
01:55
Valuation framework - Step 2: Historical financials
01:18
Valuation framework - Step 3: Forecast financials
01:02
Valuation framework - Step 4: Valuation technique
00:48
Valuation framework - Step 5: Valuation sensitivity
00:57
Valuation as an art and science
00:42
Valuation in the context of a real company
01:26
End of Module 2
00:21

Module 3: Business model of a company

15 lectures
What will we learn in this module?
01:51
Business model - Products
01:34
Business model - Costs
01:32
Business model - Operations
00:51
Business model - Financing
00:49
Business model - Strategy
00:54
Sources of information for capturing the business model of a company
02:15
Downloading Walmart annual report
02:14
Reading through Walmart annual report
05:08
Walmart business model - Products
01:54
Walmart business model - Cost
01:09
Walmart business model - Operations
01:12
Walmart business model - Financing
01:19
Walmart business model - Strategy
02:49
End of Module 3
00:35

Module 4: Financial statements of a company

16 lectures
What will we learn in this module?
01:59
The three key financial statements of any company
02:38
The typical structure of an income statement of a company
02:42
The typical structure of a balance sheet of a company
03:10
The typical structure of a cash flow statement of a company
05:18
Sources of information of the historical financial statements
02:56
Capturing Walmart's historical financial statements from Annual Report
04:28
Download the excel template for this module
00:34
Standardized income statements
05:24
Understanding minority interests
03:00
Standardized income statements - contd.
00:55
Standardized balance sheet
03:25
Capturing Walmart's income statement
04:19
Capturing Walmart's balance sheet
05:08
Conclusion
00:43
End of Module 4
00:33

Module 5A : Financial ratio analysis of a company

11 lectures
What will we learn in this module?
02:17
The five steps to forecasting the financial statements
02:06
Download the excel template for this module
00:34
Calculating revenue growth, COGS margin and SGA margin for Walmart
05:49
Calculating depreciation rate and interest rate for Walmart
05:28
Calculating effective tax rate and minority interests for Walmart
03:19
Calculation of AR, Inventory, PPE and AR ratio for Walmart
07:50
Cash flows statement in Walmart Annual Report
04:48
Re-download the excel template for this module
00:34
Calculating the borrowings and dividend payout ratio for Walmart
03:14
End of Module 5A
00:21

Module 5B: Extrapolating financial ratios of a company

9 lectures
Extrapolating the Revenue growth rate for Walmart
04:44
Extrapolating the COGS margin and SGA margin for Walmart
04:35
Extrapolating the Depreciation rate for Walmart
01:13
Extrapolating Interest rate, Effective Tax rate & Minority Interest for Walmart
04:08
Extrapolating AR, Inventory, PPE and AP ratio for Walmart
06:08
Extrapolating short term Borrowings for Walmart
03:19
Extrapolating long term Borrowings for Walmart
05:36
Extrapolating Dividends for Walmart
06:04
End of Module 5B
00:21

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

16 lectures
Forecasting future financial statements of a company
00:35
Forecasting the Revenues for Walmart
03:59
Forecasting COGS, Gross Profit and SGA for Walmart
06:05
Forecasting Depreciation and EBIT for Walmart
05:14
Forecasting Interest expense and EBT for Walmart
04:50
Forecasting Taxes, Minority interests and Profits for Walmart
06:57
Forecasting Inventory, AR and other Current assets for Walmart
07:27
Lecture 79: Forecasting Fixed Assets, Goodwill and Other Long term Assets
05:46
Forecasting short term Borrowings for Walmart
02:57
Forecasting AP and other current liabilities for Walmart
03:08
Forecasting Long term borrowings and other liabilities for Walmart
03:01
Forecasting Minority interests for Walmart
02:07
Forecasting Common Equity for Walmart
05:24
Quick Recap of what we have learnt so far
01:12
End of Module 5C
00:10
Please provide us your valuable feedback on the course thus far
00:25

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

16 lectures
Cash flows statement of any company
02:33
Non-cash costs in Cash flow from Operations of Walmart
02:56
Non operating expenses in Cash flow from Operations of Walmart
01:47
Current operating liabilities in Cash flow from Operations of Walmart
03:21
Current operating assets in Cash flow from Operations of Walmart
04:06
Calculating Cash flow from Operations of Walmart
01:25
Cash flow from Investments
01:18
Capital expenditures for Cash flow from Investments of Walmart
04:35
Calculating cash flow from Investments of Walmart
01:57
Borrowings to be repaid in Cash flow from Financing of Walmart
02:59
Interest & Borrowings to be repaid in Cash Flow from Financing of Walmart
02:38
Dividends and Share buy back in Cash flow from Financing of Walmart
02:03
Calculating Cash flow from Financing of Walmart
01:50
Calculating end of year Cash balance of Walmart
04:24
Linking the Cash flows statement with Balance sheet
03:02
End of Module 5D
00:18

Quick Recap: What have we learn in this course so far?

1 lectures
What have we learnt so far in this course?
03:14

Module 6A: Valuation technique

13 lectures
What will we learn in this module?
03:14
What are we trying to estimate when we say "valuation"?
02:16
The two important valuation equations
01:09
Understanding FREE CASH FLOWS in DCF technique
01:46
Understanding operating cash profits
01:00
Understanding operating cash investments
01:06
Free cash flows are calculated for the future
01:11
Understanding DISCOUNTING in DCF technique
01:01
Understanding the discount rate
01:29
Understanding the present value of explicit cash flows
00:50
Understanding terminal value
02:17
Understanding enterprise value and equity value
00:38
End of Module 6A
00:21

Module 6B: Valuation technique application on a company

19 lectures
The 5 steps to undertaking the valuation analysis of a company
03:54
Download the excel spreadsheet for this module
00:34
Calculating Earnings Before Interest & Taxes (EBIT) of Walmart
05:07
Calculating post tax Operating profit and Operating cash profit of Walmart
04:44
Calculating Capital expenditures of Walmart
01:57
Calculating Working capital of Walmart
04:49
Calculating total operating cash investments of Walmart
02:12
Calculating the Free Cash Flows to Firm (FCFF) of Walmart
01:20
Calculating Weighted Average Cost of Capital (WACC) of Walmart
05:11
Understanding the concept of DISCOUNTING
02:55
Calculating the present value of FCFF of Walmart
04:46
Calculating the terminal growth rate of Walmart
03:45
Calculating the terminal value or perpetuity value of Walmart
03:53
Calculating the Enterprise value (EV)
01:52
Calculating the consolidated Equity value of Walmart
04:55
Calculating the value of Minority Interests of Walmart
05:02
Calculating the Equity value per share of Walmart
02:50
Calculating the gap in Equity value per share vs current price of Walmart
01:07
End of Module 6B
00:22

Module 7: Valuation sensitivity

7 lectures
What will we learn in this module?
01:33
Implications of the valuation estimate
01:56
Making the "right" assumptions
02:08
Download the excel spreadsheet for this module
00:34
Calculating the valuation sensitivities to changes in important model inputs
05:49
End of Module 7
00:19
Please provide us your valuable feedback on the course thus far
00:25

VALUATION GUIDE - HAVE IT BY YOUR DESK

2 lectures
Step by step valuation guide
00:17
Please provide us your valuable feedback on the course thus far
00:43

End of the course - What did we learn in this course?

2 lectures
Quick Recap
02:39
Please provide us your valuable feedback
00:44

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.