Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Financial Modeling: Build a Complete DCF Valuation Model to your Wishlist.

Add to Wishlist

Financial Modeling: Build a Complete DCF Valuation Model

The Ultimate Guide to Company Valuation For Aspiring Investment Bankers and Corporate Finance Practitioners
4.2 (146 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,861 students enrolled
Created by 365 Careers
Last updated 12/2016
$15 $95 84% off
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • 7 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

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 is the target audience?
  • Aspiring Investment Bankers
  • Graduates who pursue a career in Corporate Finance
  • Professionals who would like to deepen their Valuation skills
Students Who Viewed This Course Also Viewed
What Will I 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
View Curriculum
  • Basic Microsoft Excel knowledge
  • A high level of concentration
  • Basic understanding of Financial Statements
Curriculum For This Course
Expand All 44 Lectures Collapse All 44 Lectures 02:19:16
Introduction to Company Valuation
4 Lectures 06:45

Company Valuation - Theoretical Framework
10 pages

The investor's perspective

What drives a firm's value?
The technical tools you need when valuing a company
8 Lectures 21:56
Calculating Unlevered free cash flows

Using an appropriate discount factor

Estimating cost of debt

Estimating cost of equity

Forecasting future cash flows

Caclulating Terminal value

Discounting future cash flows

Calculating Enterprise and Equity value of the firm
Learn how to build a Discounted Cash Flow model in Excel - Introduction
4 Lectures 11:55

Let's Go Through The Structure of the DCF Model That We Will Create in Excel

A Glimpse At the Company We Are Valuing - Cheeseco
Forecasting of key P&L items
5 Lectures 14:38
Modeling the Top Line of the Financial Model

This Is How You Can Build Flexible Financial Models in Excel

Modeling Other Items: Other Revenues and Cogs

Modeling Other Items: Operating Expenses and D&A

Modeling Other Items: Interest Expenses, Extraordinary Items and Taxes
Forecasting of key Balance Sheet items
5 Lectures 08:38
How to Forecast Balance Sheet Items - The Practical and Easy to Understand Way

A Key Concept for Finance Practitioners - the "Days" Methodology

How to Use "Days" in Order to Project the Future Development of Some BS Items

Forecasting Property Plant & Equipment, Other assets and Other liabilities
Creating clean output sheets
4 Lectures 10:20
Excel Best Practices! Create a Good-looking and Clean Output Sheet in Your Model

Applying What We Learned in Practice - Populating the P&L Sheet

This is How you Can Create a Clean Output Balance Sheet in Your Financial Model

Completing the Output BS Sheet For the Historical Period
Learn how to calculate Unlevered Free Cash Flows and Net Cash Flows
5 Lectures 18:49
Learn How to Calculate Unlevered Free Cash Flows

Important! Reconcile UFCF to Net Cash Flow

A Very Useful Lesson! Learn How To Calculate Cash Flows

Arriving to Actual Net Cash Flow Figures and Performing a Check with Cash

The Fast and Effective Way to Modify Multiple Cell References in Excel
Calculating Present Value of Cash Flows within the forecast period
2 Lectures 04:46
Introducing Weighted Average Cost of Capital and Perpetuity Growth Rate

Learn How to Find The Present Value of Future Cash Flows in Financial Models
Calculating Continuing Value,Enterprise Value and Equity Value of the business
2 Lectures 03:38
Calculating Continuing Value and Enterprise Value of the Business

Final Steps! Calculate Equity Value of the Business Under Consideration
Additional analyses accompanying the Financial Model
5 Lectures 12:51
Excel Tools in Practice - Sensitivity Analysis for WACC and Perpetuity Growth

Excel tools in Practice - An Application of Goal Seek

Recap of the Financial Model with Charts and Hypothesis Testing

Congratulations! You Made It!

Introduction to Mergers & Acquisitions
15 pages
About the Instructor
4.5 Average rating
5,097 Reviews
49,354 Students
15 Courses
Creating opportunities for Business & Finance students

365 Careers is a firm specializing in high-end financial training programs. Our growing list of courses includes Excel (Microsoft Excel for Beginner and Advanced users), PowerPoint, Financial Modeling, Company Valuation, Accounting, Investment Banking, Financial Planning & Analysis, and Job Hunting trainings. Our goal is to provide to our students the practical instruments they will need in order to perform successfully at their future workplace.

Report Abuse