Discounted Cash Flow (DCF) - Excel Model Template
Originally published: 20/06/2019 13:23
Last version published: 04/02/2020 15:02
Publication number: ELQ-39198-2
View all versions & Certificate
certified

Discounted Cash Flow (DCF) - Excel Model Template

This is a free excel template for Discounted Cash Flow (DCF) valuation

Description
This free excel spreadsheet contains a Discounted Cash Flow (DCF) model template that allows you to build your own discounted cash flow model for your company with different assumptions. The template has a simple “plug-and-play” format so you can input your own data and formulae to get results.

Discounted Cash Flow is a useful method for estimating the value of a company and evaluating a potential investment. You can use DCF to determine the present value of expected future cash flows using a discount rate. The discount rate is usually the Weighted Average Cost of Capital (WACC). You can find Wall Street Oasis’ model for WACC here: https://www.eloquens.com/tool/4RG9ILwr/finance/wacc-calculators-excel/wacc-calculator-excel-model-template).

As well as DCF, this template includes tabs for the following other elements of a financial model:
• Assumptions
• Income Statement
• Balance Sheet
• Cash Flow Statement
• PPE Schedule
• Debt Schedule
• LBO Modelling
• FCFE Valuation
• PE Returns analysis
• WACC Calculation

If you have any questions about this template, then feel free to reach out to us by starting a discussion below or via direct message here on Eloquens.

Like this model? You are welcome to leave us a review or a rating to show your appreciation!

This Best Practice includes
1 DCF model template excel sheet

Wall Street Oasis offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


4.5 / 5 (11 votes)

please wait...