Discounted Cash Flow (DCF) Model Template

Build DCF models with different assumptions

Author: Austin Anderson
Austin Anderson
Austin Anderson
Consulting | Data Analysis

Austin has been working with Ernst & Young for over four years, starting as a senior consultant before being promoted to a manager. At EY, he focuses on strategy, process and operations improvement, and business transformation consulting services focused on health provider, payer, and public health organizations. Austin specializes in the health industry but supports clients across multiple industries.

Austin has a Bachelor of Science in Engineering and a Masters of Business Administration in Strategy, Management and Organization, both from the University of Michigan.

Reviewed By: Patrick Curtis
Patrick Curtis
Patrick Curtis
Private Equity | Investment Banking

Prior to becoming our CEO & Founder at Wall Street Oasis, Patrick spent three years as a Private Equity Associate for Tailwind Capital in New York and two years as an Investment Banking Analyst at Rothschild.

Patrick has an MBA in Entrepreneurial Management from The Wharton School and a BA in Economics from Williams College.

Last Updated:October 6, 2023

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

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:

Attachment Size
DCF Model Template.xlsx 117.08 KB 117.08 KB