The Discounted Free Cash Flow (DCF) Model

Originally published: 04/10/2016 15:55
Publication number: ELQ-99104-1
View all versions & Certificate

The Discounted Free Cash Flow (DCF) Model

A full discounted cash flow excel model for a complete business

by Joseph Andrews

11 reviews1,486 views|Start the discussion!|

assetscomplete businessdcfdiscounted cash flowfinancepresent valuevaluation

Description
Instructions: Change any of the forecasting variables shown in red below and observe the effect on the model's outputs in the section below. To what variable is the business value conclusion most sensitive? To what variable is it least sensitive?

Valuation Model Outputs:
- Present Value of Company Operations
- Market Value of Company Assets

Includes printable output page and detailed DCF model.

Example: "Pie In The Sky Company"

- Joseph Andrews

This business tool includes
1 Excel Model

Joseph Andrews offers you this business tool for free!

download for free

Add to bookmarks

Reviews

Sunny Yan(last updated: 22/09/2018 05:48)
WILLY CAMPOS(last updated: 07/09/2018 17:30)
Eiad Al Saba(last updated: 06/09/2018 07:06)
Peleg Uzi(last updated: 19/08/2018 05:47)
Kiley Hill(last updated: 14/08/2018 21:06)
Edu Marupa Simanjuntak(last updated: 18/07/2018 10:24)
Aheesh Singh(last updated: 06/06/2018 12:33)
Guillem Torner(last updated: 15/05/2018 08:57)
Long Lê(last updated: 01/04/2018 10:28)
Kamilah Collison(last updated: 14/03/2018 11:23)
Mamadou Dr. Bass(last updated: 29/09/2017 09:38)

Any questions on The Discounted Free Cash Flow (DCF) Model?

The user community and author are here to help. Go ahead!

please wait...