Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Financial modeling: Build a DCF equity valuation model

Name: Financial modeling: Build a DCF equity valuation model
Rating: 3.8 (36 reviews)

Financial modeling: Learn to do business valuation of any company using the DCF valuation technique

Created byAshish Agarwal

Last updated 8/2026

English

What you'll learn

Build a DCF equity valuation of a company
Calculating Free Cash flows
Calculating WACC
Enterprise valuation vs Equity valuation
Terminal value driver formula
Valuation sensitivity to assumptions

Course content

4 sections • 30 lectures • 1h 23m total length

Introduction1:49
Learn the fundamentals of company valuation using discounted cash flow analysis and build a high-level DCF equity valuation model in Excel, including sensitivity analysis.
What is valuation? How does it compare with price of a stock?2:09
In this lecture, we ll understand the difference between price of a stock and the value of a stock.
What does DCF help to estimate?2:58
What are cash flows?4:56
For which time periods do we need to estimate cash flows?1:44
What is discounting?2:31
Explore discounting in dcf valuation by converting future cash flows to present value using the discount rate, and learn how wacc, the weighted cost of debt and equity, is calculated.
How to apply discount rate to cash flows to estimate value?2:19
What is terminal value?1:12
Learn how to estimate terminal value in a DCF model by applying terminal growth to the last explicit cash flow, then compute value using free cash flow, WACC, and g.
Final calculations0:47

What did we learn so far?2:45
Revisit DCF basics—free cash flow to the firm, weighted average cost of capital, and terminal value—and apply a five-year, Excel-based valuation exercise to estimate a private firm's share price.
5 step process to carry out Discounted Cash Flow valuation1:38
Download the excel template0:03
Please download the excel template attached here.
Lets look at the data4:55
Use the management forecasts to calculate five-year free cash flows and value a private company with the discounted cash flow method, using WACC and terminal value for per-share valuation.
Step 1a: Calculating EBIT5:47
Step 1b: Calculating post tax operating cash profits5:52
Step 1c: Calculating capex5:50
Learn to calculate free cash flow to the firm by accounting for capital expenditures and working capital, using the capex rule: closing minus opening fixed assets plus depreciation.
Step 1d: Calculating operating cash investments3:10
Step 1e: Calculating FCFF2:52
Step 2a: Calculating WACC6:15
Concept of compounding3:06
Step 2b: Calculating Present Value of FCFF4:12
Step 3: Calculating Terminal Value4:33
Step 4: Calculating Enterprise Value0:58
Calculate enterprise value by summing the present value of future cash flows, the present value of the terminal value, using the WACC discounting method, yielding about 74 million.
Step 5: Calculating Equity value per share1:40
Subtract the 2015 debt from enterprise value to derive equity value, then divide by total outstanding shares to obtain the per-share value.

Requirements

None. We will teach everything from scratch.

Description

Welcome to our very crisp Financial modeling: Build a DCF equity valuation model course.

We are glad to meet you. If only we could shake hands!

Are you wondering how is this course going to be useful to you?

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

If you are looking to learn how to make an equity valuation model, then this course will prepare you for the job.

Look, the valuation jobs are high paying jobs.

So your prospective employer will want you to be on a client project on day 1.

Our course does exactly that - we make you job ready for your prospective project / daily work.

What makes our course different from others?

Our course content is unique - you learn exactly what you are required to do in your daily work.

We will value a large US company and compare the value with the current trading price.

You get 2 hours of crisp synthesized practical real life illustrations of all concepts.

You will be carrying out the real life illustration along with the instructor.

Same set up as the instructor. All illustration spreadsheets are shared.

It's almost like as if somebody is guiding you in person to carry out the various analysis.

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

He makes it very engaging and fun learning experience.

You will have practice assignments / course challenges with varying difficulty levels to test your learning from the course.

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

And of course, the price is competitive.

What will you learn in this course?

Learn to do a Discounted Cash Flow valuation of any company.

A standardized valuation model to cover all sectors.

You can watch the FREE course previews in the CURRICULUM section.

Read through the entire CURRICULUM section if you can.

All modules with details of lectures are provided.

What next?

Well, we sincerely hope to see you inside the course.

We wish you well and good luck.

Still confused? Don't hesitate to reach out.

Who this course is for:

Financial analysts
Business analysts
Venture capitalists
Private Equity professionals
Startup entrepreneurs
Equity Analysts
Finance Managers
Investment Bankers

Financial modeling: Build a DCF equity valuation model

What you'll learn

Explore related topics

Course content

Conceptual understanding of Discounted Cash Flow valuation9 lectures • 20min

Practical illustration of Discounted Cash Flow valuation15 lectures • 54min

Sensitivity Analysis1 lecture • 7min

So what did we learn in this course?5 lectures • 3min

Requirements

Description

Who this course is for: