
Discounted Cash Flow (DCF) models
What is Discounted Cash Flow?
Discounted cash flow analysis is one of the most important methods to accurately estimate the value of an asset via applying the concept of the time value of money (TVM). Primitive forms of discounted cash flow analysis have been used since ancient times but have since undergone significant development. This was sparked by the Wall Street Crash of 1929 and the need to have a reliable method for the valuation of stocks. It was not until, Irving Fisher and John Burr William’s published their texts, The Theory of Interest (1930) and The Theory of Investment Value (1938) that the discounted cash flow analysis was formally documented.
A high-level overview of the process of conducting a discounted cash flow analysis firstly involves estimating the future incoming and outgoing cash flows. After this is completed, discounting these flows is required which is usually calculated by using the Weighted Average Cost of Capital (WACC). The completion of both these steps yields the net present value (NPV). Ultimately, the aim of a discounted cash flow analysis is to calculate the financial benefit undertaken from a potential investment and if it is worth pursuing considering the cost of investment.
The detailed outline of the Discounted Cash Flow process:
Step 1: Forecast the Expected Cash Flow: This would involve forecasting the expected cash flow based on the business’s income tax rate, net operating profit margin, incremental working capital requirement, company’s revenue growth rate and fixed investment requirement.
Step 2: Estimate the Discount Rate: The next step would involve estimating the WACC (Weighted Average Cost of Capital), which is the discount rate.
Step 3: Calculate the Value of the Corporation: This step would involve using the WACC to discount the expected cash flows to get the Cash Flow from Operations (CFO).
Furthermore, the WACC is used to calculate the residual value. This is added with short term assets to get the value of the corporation.
Step 4: Calculate Intrinsic Stock Value: This step involves subtracting the company’s liabilities such as debt to receive common equity. This value then should be divided by the amount of stock outstanding to receive the intrinsic stock value.
If you’d like to know more about Discounted Cash Flow Analysis, have a read of Investopedia's article
Where can I find Discounted Cash Flow DCF Excel Model Templates?
For companies considering to analyse it’s investments, the Eloquens catalogue provides a variety of Discounted Cash Flow DCF Excel Models and templates designed and built by professionals and professors where all you need to do is to input the required values. The Discounted Cash Flow DCF Model Template automatically calculates the rest for you. You can also build and self-publish your own model and template on Eloquens directly. Learn more
Last downloaded
- 3 minutes agoPowerful, flexible, reliable and friendly financial models in minutes214 remove_red_eyeDiscussfree
by Jose Corona
- 7 minutes ago
Leveraged Buyout LBO Model - DCF
A comprehensive LBO model in excel of business acquisition2,096 remove_red_eyeDiscussfreeby Amit Tandon
- 11 minutes ago
Discounted Cash Flow (DCF) Analysis with IRR and NPV
Several spreadsheets that can be used for the analysis of a real estate investment from various perspectives11,611 remove_red_eye2 chat_bubble - 4 hours ago
Discounted Cash Flow (DCF) Model
A step by step Discounted Cash Flow Analysis Tutorial (DCF model)27,686 remove_red_eye25 chat_bubble - 6 hours ago
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.11,706 remove_red_eyeDiscussfreeby Firmex
- 8 hours ago
Two-Stage Free Cash Flow for the Firm (FCFF) Discount Model
Value a firm with two stages of growth on the basis of free cashflows to firm884 remove_red_eyeDiscuss - 14 hours ago
Two-Stage Dividend Discount Model
A dividend discount model for firms with two stages of growth785 remove_red_eyeDiscuss - 18 hours ago
DCF Valuation Model Template
This template provides you with a foundation to build your own discounted cash flow model with different assumptions.905 remove_red_eyeDiscussfreeby CFI
- 21 hours ago
Discounted Cash Flow (DCF) Excel Model
This DCF Excel Model provides a rough guide to which discounted cash flow model may be best suited to your firm.1,123 remove_red_eye1 chat_bubble - 21 hours ago
Free Cash Flow for the Firm (FCFF) Stable Growth Excel Model
An Excel FCFF Excel Model to Value a stable firm on the basis of free cashflows to firm.646 remove_red_eyeDiscuss - 23 hours ago
Discount Cash Flow Template in Excel
This is a discounted cash flow (DCF) template with income statement, balance sheet, FCF calculation & FV calculation.257 remove_red_eyeDiscussfreeby Andrew Han
- 23 hours ago
Business Valuation Excel Model with Economic Value Added
Business and investment valuation model with economic value added (EVA) calculations.962 remove_red_eyeDiscuss - 23 hours ago
Discounted Cash Flow (DCF) Model Template + Instructions
Learn how to build a simple DCF Model aligned with Investment Banking best practices.476 remove_red_eyeDiscuss - 23 hours ago
The Discounted Free Cash Flow (DCF) Model
A full discounted cash flow excel model for a complete business1,338 remove_red_eyeDiscuss - 1 day ago
Valuation: Free Cash Flow to Firm (FCFF) vs Free Cash flow to Equity (FCFE) Excel Model
Excel Valuation model that reconciles FCFF (Free Cash Flow to the Firm) and FCFE (Free Cash Flow to Equity)4,661 remove_red_eyeDiscuss - 1 day ago
Calculating Discounted Cash Flow in Excel
This video takes you through a DCF Excel model to show you how to calculate Discounted Cash Flow.680 remove_red_eyeDiscussfreeby Finance Walk
- 2 days ago
"La Doria" Excel Valuation Model
Valuation Model of La Doria (public company)36 remove_red_eyeDiscuss - 2 days ago
Discounted Cash Flow (DCF) Model (Academic Quality)
A simple DCF model serving as an academic exercise to understand how financial modeling works.1,420 remove_red_eyeDiscussfreeby Joshua Wong
- 2 days ago
Three-Stage Dividend Discount Model
Value the equity in a firm with three stages of growth1,632 remove_red_eyeDiscuss - 2 days ago
Discounted Cash Flow (DCF) Excel Model Template
Discounted Cash Flow Model provide an estimated investment return by discounting future cash flows to a present value.762 remove_red_eyeDiscuss
Full catalog
Discounted Cash Flow (DCF) Model
A step by step Discounted Cash Flow Analysis Tutorial (DCF model)27,686 remove_red_eye25 chat_bubbleDiscounted 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.11,706 remove_red_eyeDiscussfreeby Firmex
Discounted Cash Flow (DCF) Analysis with IRR and NPV
Several spreadsheets that can be used for the analysis of a real estate investment from various perspectives11,611 remove_red_eye2 chat_bubbleValuation: Free Cash Flow to Firm (FCFF) vs Free Cash flow to Equity (FCFE) Excel Model
Excel Valuation model that reconciles FCFF (Free Cash Flow to the Firm) and FCFE (Free Cash Flow to Equity)4,661 remove_red_eyeDiscussLeveraged Buyout LBO Model - DCF
A comprehensive LBO model in excel of business acquisition2,096 remove_red_eyeDiscussfreeby Amit Tandon
Discounted Cash Flow (DCF) Model (Academic Quality)
A simple DCF model serving as an academic exercise to understand how financial modeling works.1,420 remove_red_eyeDiscussfreeby Joshua Wong
DCF Valuation Model Template
This template provides you with a foundation to build your own discounted cash flow model with different assumptions.905 remove_red_eyeDiscussfreeby CFI
The Discounted Free Cash Flow (DCF) Model
A full discounted cash flow excel model for a complete business1,338 remove_red_eyeDiscussBusiness Valuation Excel Model with Economic Value Added
Business and investment valuation model with economic value added (EVA) calculations.962 remove_red_eyeDiscussDiscounted Cash Flow (DCF) Excel Model
This DCF Excel Model provides a rough guide to which discounted cash flow model may be best suited to your firm.1,123 remove_red_eye1 chat_bubbleProperty Valuations Modeling
Simple Property Valuation Model showing the 3 primary methods for valuing property assets with an interactive visual.2,099 remove_red_eyeDiscuss$9.50by Lance Rubin
Abercrombie & Fitch Valuation Model
A full PDF of an Excel Valuation Model created for fundamental analysis of Abercrombie & Fitch ($ANF) in 2006690 remove_red_eyeDiscussfreeby Lindsay Meyer
Mergers and Acquisitions (M&A) Financial Excel Model
A complete financial model for mergers and acquisitions (M&A). Includes DCF, accretion/dilution, sensitivity, much more.1,323 remove_red_eyeDiscuss$97.00by CFI
DCF (Discounted Cash Flow) Excel Monte Carlo Simulation Model
A simplified DCF (Discounted Cash Flow) Monte Carlo Simulation model in Excel609 remove_red_eyeDiscussfreeby Hans Ensing
DCF Model with Bear and Bull Scenarios in Excel
A DCF model built for public equity valuations, with a bull and bear scenario analysis to evaluate upside/downside risk1,232 remove_red_eyeDiscuss$20.00by Colin Ferrian
Discounted Cash Flow (DCF) Excel Model Template
Discounted Cash Flow Model provide an estimated investment return by discounting future cash flows to a present value.762 remove_red_eyeDiscuss- Have a DCF Excel Model Template?
Your DCF Excel Model
Publish your model
Learn more about digital publishing
Most popular Discounted Cash Flow (DCF) expert author Channels (last 30 days)
Prof. Aswath Damodaran
Professor at NYU Stern School of Business
1Business-Valuation.net
Experts in DCF and LBO modelling.
2CFI
Corporate Finance Institute® (CFI) - Official provider of the Financial Modeling & Valuation Analyst (FMVA)™
3Henry Sheykin - Financial Models
Best Practice Industry Specific Financial Model Templates built on business niche research and ready to Pitch Investors
4Amit Tandon
Excel & VBA, Promoter - GlobaliConnect
5Firmex
Deals can be complicated, your data room shouldn’t be.
6Prof. Norm Miller PhD
Professor & Chair in Real Estate Finance @ University of San Diego
7Dheeraj Vaidya CFA FRM
Co-founder & CEO @ eduCBA & founder of WallStreetMojo
8Business Spreadsheets
Purpose built models for financial analysis
9Wall Street Prep
Preparing students and professionals for careers in Investment Banking and Corporate Finance.
10Projectify
Financial Modelling Solutions
11Lance Rubin
CEO & Founder of Model Citizn and professional financial modeler and trainer for FMI
12financialmodeling.org
CFI Financial Modeling Competition & World Championships
13Fin-Wiser Advisory
Financial & Operational Advisory Specialist
14Street Of Walls
The mission is to help you get a job on Wall Street!
15Hans Ensing
Managing Director Syleus and Partners
16Jason Varner
Smarthelping.com - Freelancer - I make my living working in Excel and G-sheets.
17Finance Walk
Teaching basic concepts that give you strong foundation in finance.
18Eduardo Martínez Pérez
Corporate Finance at NORGESTION
19Joseph Andrews
Related categories
Valuation Models
Investment Banking
Private Equity
Corporate Finance
Mergers & Acquisitions (M&A)
Leveraged Buyout (LBO)
Real Estate Finance
Scenario Analysis
Financial Projections -
Cash Flow
Industry Specific Financial Models
Economic Value Added
Monte Carlo Simulation
Bank Financial Models
Financial Markets
Cost Analysis
Capital Budgeting
Finance
IPO (Initial Public Offering)
Net Present Value (NPV)
Any questions on Discounted Cash Flow (DCF)?
The user community is here to help. Go ahead!