Discounted Cash Flow | DCF Model Step by Step Guide
Discounted Cash Flow step by step guide using free DCF excel model.
π Get 25% OFF Financial Edge Using Code KENJI25:
RESOURCES:
π» DCF Template for this video:
πΉ Valuation Methods Video:
In this video, we go over how to create a discounted cash flow with the end goal of reaching a companyβs intrinsic value. Through this, we can determine if a companyβs share price is over or undervalued. From free cash flows, to the WACC, to Terminal value, all the technical concepts are explained and applied using the Excel model.
Key steps in this DCF model:
- Forecast the FCF, typically for a 5-10y period
- Calculate the Weighted Average Cost of Capital (WACC)
- Calculate the Terminal Value
- Discount the cash flows to present
- Reach a valuation and calculate an implied share price
LEARN:
π The Complete Finance & Val