Originally published: 04/10/2016 15:55
Publication number: ELQ-99104-1

The Discounted Free Cash Flow (DCF) Model

A full discounted cash flow excel model for a complete business

by Joseph Andrews

33 reviews1,743 views|Start the discussion!|download for free

finance valuation present value assets dcf discounted cash flow complete business

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 Best Practice includes
1 Excel Model

Joseph Andrews offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews

- 4.3 / 5 (33 votes)
  - 64%
  - 21%
  - 6%
  - -
  - 9%
- Rate this Downloadable Best Practice
  Write a review
Tamer H. Alsayed , CMA, MBA, CFM(last updated: 17/08/2021 06:03)
Maksym Strelets(last updated: 25/09/2020 21:24)
Wael Attallah, MBA(last updated: 21/09/2020 17:53)
Adib Basbous(last updated: 10/09/2020 07:53)
Italo Morales(last updated: 09/09/2020 08:18)
Jahoras Victor Naibaho(last updated: 01/05/2020 22:24)
Alain Kalubi(last updated: 21/10/2019 13:22)
Hesham Mokhiemer, MBA, CMA, CTP, Cert(last updated: 07/09/2019 08:46)
Grigoriy Zakharov(last updated: 07/07/2019 13:13)
Choi Tony(last updated: 13/06/2019 01:18)
Hafizal Aziz(last updated: 30/04/2019 08:18)
CA Gaurav Jain(last updated: 30/04/2019 05:57)
Tarun Sodvadiya(last updated: 30/03/2019 20:05)
Osama Sulieman(last updated: 21/02/2019 19:03)
UMA PANDEY(last updated: 14/02/2019 08:09)
Danny Tan(last updated: 20/01/2019 13:37)
Sriram S(last updated: 04/01/2019 11:11)
Ron Jnr(last updated: 08/11/2018 22:29)
George Frank(last updated: 25/10/2018 19:18)
Teman Galau(last updated: 17/10/2018 09:29)
Abdelrhman Alaa ,CMA Candidate(last updated: 12/10/2018 10:20)
MOHAMMED NASEER(last updated: 08/10/2018 17:44)
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)