Financial Modeling: Build a Complete DCF Valuation Model
15,217 students enrolled
Financial Modeling: Build a Complete DCF Valuation Model
The Ultimate Guide to Company Valuation For Aspiring Investment Bankers and Corporate Finance Practitioners
Bestseller
15,217 students enrolled
Created by
365 Careers
Last updated 4/2020
English
English [Auto-generated],
French [Auto-generated]
Current price: $65.99
Original price: $94.99
Discount:
31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
- 4 hours on-demand video
- 115 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Training 5 or more people?
Get your team access to 4,000+ top Udemy courses anytime, anywhere.
Try Udemy for Business
What you'll learn
- • Be able to build a Cash Flow statement
- • Know how to value a company
- • Be able to build a Valuation model from scratch
- • Know how to create a model with multiple scenarios
- • Be able to perform sensitivity analysis
- • Know how to create professional and good-looking advanced charts
Requirements
- Basic Microsoft Excel knowledge
- A high level of concentration
- Basic understanding of Financial Statements
Description
Would you like to learn how to value a company?
Even people who don't have a Finance degree can take this course and learn how to build a complete Discounted Cash Flow Model!
Attention! You will have to go through the videos and the course materials in order to obtain the promised result!
If you want to:
- Improve your Microsoft Excel modeling skills
- Learn how to value a company
- Understand what drives a company's value
Then this course is the right one for you!
What we offer:
- Well designed and easy to understand materials
- Detailed and comprehensible explanations
- Regular course updates
By the completion of this course you will:
- Be able to build a Cash Flow statement
- Know how to value a company
- Be able to build a Valuation model from scratch
- Know how to create a model with multiple scenarios
- Be able to perform sensitivity analysis
- Know how to create professional and good-looking advanced charts
The instructor of this course has extensive experience in Financial Modeling:
- Worked in the Financial advisory unit of a top-tier consulting firm
- Experience in M&A transactions carried out in Italy, Germany, Switzerland and Poland
- Worked in the in-house Mergers & Acquisitions department of one of the largest semiconductor firms in the world
- Financial advisor in multiple M&A deals with sizes ranging from €2 million up to €5 billion
++++++++++++++++++++++++++++++++++++++++++++++++++++++
About the course:
- An unconditional Udemy 30 day money-back guarantee – because we believe in the quality of our content
- No significant previous experience is needed in order to understand the course well and benefit fully from its content
- Unlimited access to all course materials
- Emphasis on learning by doing
- You can always contact us for any clarification free of charge
- Our goal is to take your Valuation skills to the next level
Make an investment that will be well rewarded in terms of career perspectives, positive feedback and personal growth.
Just go ahead and subscribe to this course! Nowadays the job market has become very competitive. If you don't acquire these skills now you will miss an opportunity to separate yourself from others. Don't risk your future success!
Let's start learning together now!
Who this course is for:
- Aspiring Investment Bankers
- Graduates who pursue a career in Corporate Finance
- Professionals who would like to deepen their Valuation skills
Course content
Expand all
75 lectures
04:13:54
+
–
Introduction to Company Valuation
4 lectures
06:45
Preview
01:36
Company valuation - Theoretical framework
10 pages
The investor's perspective
03:12
What drives a firm's value?
01:57
+
–
The technical tools you need when valuing a company
8 lectures
21:56
Calculating Unlevered free cash flows
04:33
Using an appropriate discount factor
03:58
Estimating cost of debt
00:55
Forecasting future cash flows
02:31
Caclulating Terminal value
02:24
Discounting future cash flows
01:44
Calculating Enterprise and Equity value of the firm
01:10
+
–
Learn how to build a Discounted Cash Flow model in Excel - Introduction
4 lectures
11:45
Let's go through the structure of the DCF model we will create in Excel
02:57
A glimpse at the company we are valuing - Cheeseco
01:11
+
–
Forecasting of key P&L items
5 lectures
15:13
Modeling the top line of the financial model
03:56
This is how you can build flexible financial models in Excel
02:16
Modeling other items: Other revenues and Cogs
03:51
Modeling other items: Operating expenses and D&A
02:27
Modeling other items: Interest expenses, Extraordinary Items and Taxes
02:43
+
–
Forecasting of key Balance Sheet items
5 lectures
08:19
How to forecast balance sheet items - The practical and easy to understand way
00:42
A key concept for finance practitioners - the "Days" methodology
01:34
How to use "Days" in order to project the future development of some BS items
02:22
Forecasting Property, plant & equipment, Other assets and Other liabilities
02:21
+
–
Creating clean output sheets
4 lectures
10:41
Excel best practices! Create a good-looking and clean output sheet in your model
02:36
Applying what we learned in practice - Populating the P&L sheet
02:29
This is how you can create a clean output Balance Sheet in your financial model
01:53
Completing the Output BS Sheet For the Historical Period
03:43
+
–
Learn how to calculate Unlevered Free Cash Flows and Net Cash Flows
5 lectures
19:47
Learn how to calculate unlevered free cash flows
03:18
Important! Reconcile UFCF to Net Cash flow
01:53
A very useful lesson! Learn how to calculate cash flows
06:38
The fast and effective way to modify multiple cell references in Excel
04:01
+
–
Calculating present value of cash flows within the forecast period
2 lectures
04:54
Introducing weighted average cost of capital and perpetuity growth rate
01:55
Learn how to find the present value of future cash flows in financial models
02:59
+
–
Calculating continuing value, enterprise value and equity value of the business
2 lectures
03:48
Calculating continuing value and enterprise value of the business
02:21
Final steps! Calculate equity value of the business under consideration
01:27
+
–
Additional analyses accompanying the financial model
5 lectures
12:54
Excel tools in practice - sensitivity analysis for WACC and perpetuity growth
04:40
Excel tools in practice - An application of Goal Seek
01:41
Recap of the financial model with charts and hypothesis testing
04:27
Congratulations! You made it!
02:06
Introduction to Mergers & Acquisitions
15 pages