New to valuation? Start here.
Learn how to build a full DCF model in Excel from the ground up. In this guided tutorial with CFIās Tim Vipond, youāll gain the skills to confidently estimate company value. This comprehensive financial modeling tutorial covers everything you need: unlevered free cash flows (FCFF), Weighted Average Cost of Capital (WACC), and terminal value assumptions.
Led by Tim Vipond, CEO of Corporate Finance InstituteĀ® (CFI), this step-by-step valuation guide walks you through the full process from DCF valuation theory to share price analysis. Perfect for anyone looking to master financial analysis and company valuation.
In this DCF walkthrough, youāll learn how to:
ā
Forecast Unlevered Free Cash Flow (FCFF) over a 5-year period
ā
Calculate Weighted Average Cost of Capital (WACC) for your discount rate
ā
Estimate Terminal Value using an exit multiple (and understand perpetual growth)
ā
Discount future cash flows back to present value using Excel's NPV/XNPV functions
ā
Derive Enterprise Value and calculate Implied Share Price
By the end of this video, youāll have the tools and understanding to confidently build a fully functional DCF model and apply it in investment banking, corporate finance, or equity research roles. This is an essential skill for finance careers and financial analysts.
Key Topics Covered in This Video:
Discounted Cash Flow (DCF) Valuation Framework
Free Cash Flow Forecasting (FCFF Calculation)
Terminal Value: Perpetual Growth vs. Exit Multiple Method
Using NPV and XNPV in Excel for present value calculations
WACC as the Discount Rate (Cost of Equity, Cost of Debt, CAPM)
Share Price vs. Intrinsic Value Analysis
Financial Modeling Best Practices
Forecasting Income Statement & Unlevered Free Cash Flow Schedule
More from Corporate Finance InstituteĀ® (CFI):
#DCFModel #FinancialModeling #FMVA #Valuation #ExcelFinance #CorporateFinance #FinanceTutorial #WACC #TerminalValue #TimVipond #InvestmentBanking #EquityResearch #FinanceCareers #FinancialAnalysis #CompanyValuation #IntrinsicValue #FreeCashFlow #NPV #XNPV #CFI #ExcelTutorial