The Discounted Free Cash Flow (DCF) Model
Originally published: 04/10/2016 15:55
Publication number: ELQ-99104-1
View all versions & Certificate
certified

The Discounted Free Cash Flow (DCF) Model

A full discounted cash flow excel model for a 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


4.3 / 5 (33 votes)

please wait...