Discounted Cash Flow Model Template

A fully customizable excel model to match your needs, and use as a starting point or as a full DCF tool for valuation.

dcffinancefree cash flow projectionsinvestment analysisinvestment bankingvaluationwacc

Description
Don't waste hours creating your own discounted cash flow model.

Discounted cash flow (DCF) is used to estimate the attractiveness of an investment opportunity. DCF analysis uses future free cash flow projections and discounts them (most often using the weighted average cost of capital) to arrive at a present value, which is used to evaluate the potential for investment. If the value arrived at through DCF analysis is higher than the current cost of the investment, the opportunity may be a good one.

Instructions
1: Input the valuation date, discount rate, perpetual growth rate, and tax rate.
2: Forecast the company's key financials and calculate the corresponding free cash flows.
3: Discount the Projection Period and Terminal cash flows to the present using the discount rate.
4: The sum of future cash flows determines the aggregate value of the business today.

- Firmex Team

This business tool includes
1 Excel Model

Firmex offers you this business tool for free!

Download for free

Discuss

Reviews

  • Katwere James(last updated: 19/11/2017 08:29)
    Good DCF Template
    Really helpful excel model
  • Zhou Song(last updated: 13/10/2017 08:22)
  • Alfonso Cioffi(last updated: 12/10/2017 20:22)
  • Long Lê(last updated: 08/10/2017 05:18)
    Very well-organized template
    Just have a quick look at it. Simple and easy to follow
  • Mamadou Dr. Bass(last updated: 29/09/2017 09:38)

Any questions on Discounted Cash Flow Model Template?

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

please wait...