Cart 0
Discounted Cash Flow (DCF) Valuation model - Example and Template in Excel
dcf excel template
dcf model excel
dcf valuation
discounted cash flow analysis example
discounted cash flow example
discounted cash flow excel
discounted cash flow valuation
discounted cash flow valuation excel
discounted cash flow valuation template
Partial preview

Discounted Cash Flow (DCF) Valuation Model

Easily estimate the value of a Business by reusing this Discounted Cash Flow (DCF) Valuation Model Template. The Excel Template was created by ex-Deloitte & McKinsey Consultants and Venture Capitalists. Don’t reinvent the wheel. Download this Template in a couple of clicks.

Content Details

Expand all
I. A DCF Valuation Model Template in Excel including:
  1. An Income Statement
  2. A Cash Flow Statement
  3. A Balance Sheet Statement
  4. A Discounted Cash Flow Model
  5. Many Formulas to automatically calculate the Unlevered Free Cash Flow, the WACC, and Terminal Value
  6. A real life example
  7. 3 scenarios with adjustable assumptions automatically impacting the Financial Statements and Valuation
  8. Links between the 3 Financial Statements and the DCF Model
II. A Step by Step Tutorial:
  1. Estimate the Total Unlevered Free Cash Flow
  2. Calculate the Total Net Present Value
  3. Calculate the Weighted Cost of Capital
  4. Calculate the Terminal Value
  5. Calculate the Total Valuation

Additional features

Customer reviews

4.98 out of 5 stars (855 votes)

Write a review >
  • “Very easy to use even if I'm everything but a financial guru”

    Kaylee Mercer
    Entrepreneur

  • “Very comprehensive with both the EBIDTA and PERPETUITY methods that you can use depending on your situation”

    Hassan Cook
    MBA Student

  • “Was able to quickly evaluate the value of my business. A lot better and professional than what my accountant initially did”

    Tony Ryder
    Startup CEO

  • “The formulas included in the Excel Template do most of the job. Great!”

    Indi Viaranne
    Senior Manager

  • “Very good. Thanks for sharing”

    Greg Lamash
    MBA Professor

  • “It basically does what it says it does”

    Sean Mareno
    Junior Analyst

Did you know?

The average daily rate of a McKinsey consultant is $4,000? A lot more expensive than purchasing our Business & Consulting Toolkits.

4.98 out of 5 stars (855 Votes)