background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for May 2024 for May 2024
:
Private EquityReal Estate Investing
Buy-Side InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for May 2024 is Open
Wall Street Prep

DCF Model, Part 1

Lesson on Building a DCF Model

Last Updated December 6, 2023

Learn Online Now

DCF Quick Lesson: Video Tutorial (2-Part Series)

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 2)

Before We Begin, Download the DCF Template

Use the form below to get the Excel model template to follow along with this lesson:

dl
Submitting...

DCF Model, Part 1

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today
Comments
7 Comments
most voted
newest oldest
Inline Feedbacks
View all comments
Taehwan
February 14, 2022 11:55 pm

Hi! The model template doesn’t open properly. Thnak!

Brad Barlow
February 15, 2022 12:37 pm
Reply to  Taehwan

Hi, Taehwan,

Did you receive the template via email? If so, please reply to the email from which it was sent and ask for another version, then let us know if that does not open.

Brad

James
April 13, 2020 7:45 pm

Thank you!!

Jeff Schmidt
April 13, 2020 8:55 pm
Reply to  James

James:

You’re welcome!

Best,
Jeff

Alan
August 27, 2022 11:23 am

Where is the video for Part 1?

Brad Barlow
August 29, 2022 8:08 am
Reply to  Alan

Hi, Alan,

The link appears to take you to our online DCF course (which begins as a simple one-page DCF), which it seems you have to register for in order to complete the lesson.

BB

Domain
September 14, 2020 11:10 pm

Thanks very much for this! Helped me a lot

Learn Financial Modeling Online

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

Learn More

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.