DCF model
Discounted Cash Flow (DCF) is one of the valuation methods used to estimate the value of an investment based on its future cashflows.
The output of valuation is the intrinsic value of a stock. The intrinsic value is compared with the current market value
1) If Intrinsic value The stock is Overvalued
2) If Intrinsic value > Market value --> The stock is Undervalued
The DCF valuation can be used to asses how the market has Overvalued / Undervalued a company and by what percentage
Created by: MarketXLS
Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Call: 1-877-778-8358
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today
Get started today
