Build a DCF Valuation Model

Learn how to build a "Wall Street quality" DCF valuation model. Includes a complete DCF model in Excel.

4.5
(122 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.

How taking a course works

Discover

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2014
English

Course Description

DCF analysis is both academically respected and widely used on Wall Street as a primary method of valuation. Many finance interview questions specifically test a candidate's understanding of the DCF. The step-by-step modeling course uses a real case study approach and is designed to mimic the experience of an financial analyst.

This course builds on Wall Street Prep's financial statement modeling course to teach trainees how to build a working discounted cash flow (DCF) model in Excel from scratch.

Along the way, you will learn how to estimate the weighted average cost of capital (WACC) in the real world, and build several commonly used approaches to calculating terminal value. Finally, we will use data tables to analyze a broad range of scenarios given different assumptions.

What are the requirements?

The program assumes an introductory knowledge of accounting and corporate finance, as well as proficiency in Excel.

What am I going to get from this course?

At course completion, you will have developed a comprehensive "Wall Street quality" DCF model from scratch.

What is the target audience?

Investment banking professionals and students seeking a lucrative finance career.

Students Who Viewed This Course Also Viewed

SHARE

Instructor Biography

Wall Street Prep was founded in 2003 by a group of JP Morgan investment bankers with a simple goal: To make the “investment banking skill-set” available to anyone who wants to learn it. Each year, our innovative courses are used by over 5,000 professionals and students. Over 150 investment banks, private equity firms, and investment funds use Wall Street Prep to train new and experienced analysts and associates. In addition, over 50 business schools, including Wharton, Oxford, INSEAD, LSE, Kellogg, Booth, MIT, and Cornell use Wall Street Prep to better prepare their students for careers in finance.