Discounted Cash Flow (DCF) - Model Template

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 shows a sneak peak of the template.

WSO Discounted Cash Flow (DCF) Template

Start Discussion

Popular Content See all

The lighter side of IB! (Hopefully)
+55IBby 1st Year Analyst in Investment Banking - Mergers and Acquisitions">Analyst 1 in IB-M&A
Why aren't Asians/Indians/Middle Eastern considered diversity
+29IBby Intern in Investment Banking - Industry/Coverage">Intern in IB - Ind
The "right" blue in excel
+18REby Portfolio Manager in Real Estate - Commercial">PM in RE - Comm
Leaving New York
+14IBby Intern in Investment Banking - Industry/Coverage">Intern in IB - Ind
Is Finance the back office of society?
+13OFFby 1st Year Analyst in Investment Banking - Industry/Coverage">Analyst 1 in IB - Ind
Do I Count as Diversity?
+12IBby Prospective Monkey in Investment Banking - Mergers and Acquisitions">Prospect in IB-M&A

Total Avg Compensation

October 2020 Investment Banking

  • Director/MD (17) $704
  • Vice President (49) $326
  • Associates (265) $228
  • 3rd+ Year Analyst (36) $168
  • 2nd Year Analyst (147) $159
  • Intern/Summer Associate (137) $141
  • 1st Year Analyst (584) $130
  • Intern/Summer Analyst (559) $82

Leaderboard See all

1
LonLonMilk's picture
LonLonMilk
98.4
2
Jamoldo's picture
Jamoldo
98.3
3
Secyh62's picture
Secyh62
98.2
4
CompBanker's picture
CompBanker
97.9
5
redever's picture
redever
97.8
6
Addinator's picture
Addinator
97.6
7
bolo up's picture
bolo up
97.5
8
NuckFuts's picture
NuckFuts
97.5
9
frgna's picture
frgna
97.5
10
Edifice's picture
Edifice
97.3