Wall Street Prep

Quick Lesson: DCF Model – Build a Discounted Cash Flow Model, Part 2

Learn Online Now

Learn the building blocks of a simple one-page DCF model consistent with the best practices you would find in investment banking. As a side benefit, the DCF is the source of a TON of investment banking interview questions.

(Click here for part 1)

Before We Begin, Download the DCF Template

Use the form below to get the Excel model template to follow along with this lesson. (If you’ve already downloaded the Excel template file from Part 1, you’re all good — this lesson uses the same file).

dl
Submitting ...

Related resources:

Comments
guest
5 Comments
most voted
newest oldest
Inline Feedbacks
View all comments
Fed
Fed
October 8, 2021 9:40 am

You may want to rename row 35 on the DCF exercise tab as it currently shows CapEx rather than PP&E. For anyone not watching your video, they will get to a different conclusion if used as CapEx.

Liability
Liability
December 17, 2020 8:36 pm

What is the difference between the enterprise value in the DCF model versus the enterprise value that is used in LBO models (market cap + net debt)?

Liability
Liability
December 17, 2020 8:08 pm

Thank you for the great lesson!

Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More
X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.