Discounted Cash Flow (DCF) Model Template

Build DCF models with different assumptions

Patrick Curtis

Reviewed by

Patrick Curtis

Expertise: Private Equity | Investment Banking


January 31, 2022

Download WSO's free Discounted Cash Flow (DCF) model template below!

This template allows you to build your own discounted cash flow model with different assumptions.

The template is plug-and-play, and you can enter your own numbers or formulas to auto-populate output numbers. The template also includes other tabs for other elements of a financial model.

According to the WSO Dictionary,

"A Discounted Cash Flow or DCF is one of the most important methods used to value a company. A DCF is carried out by estimating the total value of all future cash flows (both inflowing and outflowing), and then discounting them (usually using Weighted Average Cost of Capital - WACC) to find a present value of that cash."

A screenshot below gives you a sneak peek of the template.

Discounted Cash Flow (DCF) Model Template

DCF Modeling Course

Everything You Need To Master DCF Modeling

To Help you Thrive in the Most Prestigious Jobs on Wall Street.

Learn More

More Resources:

We hope this template helps you excel at your job! Please check out the following additional resources to help you advance your career:

DCF Model Template.xlsx 117.08 KB117.08 KB