Discounted Cash Flow (DCF) - Excel Model Template

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!