Скачать
Build a Discounted Cash Flow (DCF) Model in Excel | Step-by-Step Valuation Guide
Автор: Corporate Finance Institute
Загружено: 2025-06-23
Просмотров: 24698
Описание:
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.
📥 Download the Excel DCF model shown in this video: https://corporatefinanceinstitute.com...
📘 Explore CFI's Finance & Valuation Courses: https://cfi.to/uivbX
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):
🎓 Financial Modeling & Valuation Analyst (FMVA®) Certification: https://cfi.to/uivbU
📊 Free Resources: https://cfi.to/uivbV
📈 Explore All CFI Programs: https://cfi.to/uivbW
#DCFModel #FinancialModeling #FMVA #Valuation #ExcelFinance #CorporateFinance #FinanceTutorial #WACC #TerminalValue #TimVipond #InvestmentBanking #EquityResearch #FinanceCareers #FinancialAnalysis #CompanyValuation #IntrinsicValue #FreeCashFlow #NPV #XNPV #CFI #ExcelTutorial
Развернуть
Доступные форматы для скачивания:
Похожие видео
array(20) {
["B7nP6ZX5B54"]=>
object(stdClass)#7044 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "B7nP6ZX5B54"
["related_video_title"]=>
string(63) "DCF Valuation Modeling: From Theory to Practice | Course Module"
["posted_time"]=>
string(23) "1 месяц назад"
["channelName"]=>
NULL
}
["UMYDxmiVin4"]=>
object(stdClass)#7051 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "UMYDxmiVin4"
["related_video_title"]=>
string(97) "Financial Modeling Tutorial | Build a Three-Statement Model in 30 Minutes with CFI CEO Tim Vipond"
["posted_time"]=>
string(25) "2 месяца назад"
["channelName"]=>
NULL
}
["gLULdxrS-CU"]=>
object(stdClass)#7045 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "gLULdxrS-CU"
["related_video_title"]=>
string(51) "Discounted Cash Flow | DCF Model Step by Step Guide"
["posted_time"]=>
string(21) "4 года назад"
["channelName"]=>
NULL
}
["kHH1AN0VvoU"]=>
object(stdClass)#7042 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "kHH1AN0VvoU"
["related_video_title"]=>
string(64) "Scenario & Sensitivity Modeling in Excel | FMVA® Course Preview"
["posted_time"]=>
string(25) "4 месяца назад"
["channelName"]=>
NULL
}
["-4bmmadFrPk"]=>
object(stdClass)#7037 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "-4bmmadFrPk"
["related_video_title"]=>
string(134) "Полное руководство для начинающих по финансовому планированию и анализу"
["posted_time"]=>
string(27) "6 месяцев назад"
["channelName"]=>
NULL
}
["mt5Ve01n_X0"]=>
object(stdClass)#7058 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "mt5Ve01n_X0"
["related_video_title"]=>
string(47) "How to Link the 3 Financial Statements in Excel"
["posted_time"]=>
string(19) "8 лет назад"
["channelName"]=>
NULL
}
["8xu2aEjrj4o"]=>
object(stdClass)#7034 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "8xu2aEjrj4o"
["related_video_title"]=>
string(87) "Оценка будущих денежных потоков для расчетов DCF"
["posted_time"]=>
string(21) "4 года назад"
["channelName"]=>
NULL
}
["nyot7FkYoqM"]=>
object(stdClass)#7054 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "nyot7FkYoqM"
["related_video_title"]=>
string(180) "Как построить дисконтированный денежный поток (DCF) | Пошаговое руководство от бывшего инвестицио..."
["posted_time"]=>
string(21) "3 года назад"
["channelName"]=>
NULL
}
["8F2Y39FqcU4"]=>
object(stdClass)#7039 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "8F2Y39FqcU4"
["related_video_title"]=>
string(44) "Mining Financial Modeling & Valuation Course"
["posted_time"]=>
string(19) "9 лет назад"
["channelName"]=>
NULL
}
["bTfmZmlmLjE"]=>
object(stdClass)#7052 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "bTfmZmlmLjE"
["related_video_title"]=>
string(67) "How to Build a Financial Dashboard in Excel (Step-by-Step Tutorial)"
["posted_time"]=>
string(23) "1 месяц назад"
["channelName"]=>
NULL
}
["LiWMgC2ICDg"]=>
object(stdClass)#7033 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "LiWMgC2ICDg"
["related_video_title"]=>
string(48) "Excel for Finance and Accounting Expert Tutorial"
["posted_time"]=>
string(19) "1 год назад"
["channelName"]=>
NULL
}
["jfcRUzKZZE8"]=>
object(stdClass)#7043 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "jfcRUzKZZE8"
["related_video_title"]=>
string(88) "How to value a company using discounted cash flow (DCF) - MoneyWeek Investment Tutorials"
["posted_time"]=>
string(20) "12 лет назад"
["channelName"]=>
NULL
}
["vMA_pquxrdg"]=>
object(stdClass)#7038 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "vMA_pquxrdg"
["related_video_title"]=>
string(145) "Объяснение анализа дисконтированных денежных потоков (DCF) в сфере недвижимости"
["posted_time"]=>
string(19) "1 год назад"
["channelName"]=>
NULL
}
["OwbiEjINcpA"]=>
object(stdClass)#7035 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "OwbiEjINcpA"
["related_video_title"]=>
string(98) "Discounted Cash Flow (DCF) Analysis for BEGINNERS - How to Value a Stock Using Tesla as an Example"
["posted_time"]=>
string(21) "4 года назад"
["channelName"]=>
NULL
}
["eMuSbHkFIRU"]=>
object(stdClass)#7036 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "eMuSbHkFIRU"
["related_video_title"]=>
string(43) "Sensitivity Analysis for Financial Modeling"
["posted_time"]=>
string(19) "9 лет назад"
["channelName"]=>
NULL
}
["77xkumpio48"]=>
object(stdClass)#7024 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "77xkumpio48"
["related_video_title"]=>
string(152) "Постройте полную модель дисконтированного денежного потока для РЕАЛЬНОЙ компании"
["posted_time"]=>
string(21) "3 года назад"
["channelName"]=>
NULL
}
["9GnwzjV9qS0"]=>
object(stdClass)#7025 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "9GnwzjV9qS0"
["related_video_title"]=>
string(30) "Free Cash Flow: Back to Basics"
["posted_time"]=>
string(21) "3 года назад"
["channelName"]=>
NULL
}
["uoES-70o-Ls"]=>
object(stdClass)#7031 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "uoES-70o-Ls"
["related_video_title"]=>
string(80) "Watch me nail Morgan Stanley's interview question on DCF (Discounted Cash Flow)!"
["posted_time"]=>
string(19) "1 год назад"
["channelName"]=>
NULL
}
["37HErhv0PDw"]=>
object(stdClass)#7032 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "37HErhv0PDw"
["related_video_title"]=>
string(76) "How to Tell When a Stock is Cheap/Expensive (Masterclass in Stock Valuation)"
["posted_time"]=>
string(25) "4 месяца назад"
["channelName"]=>
NULL
}
["Iiq4Sem9GPM"]=>
object(stdClass)#7030 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "Iiq4Sem9GPM"
["related_video_title"]=>
string(0) ""
["posted_time"]=>
string(21) "2 года назад"
["channelName"]=>
NULL
}
}
DCF Valuation Modeling: From Theory to Practice | Course Module
Financial Modeling Tutorial | Build a Three-Statement Model in 30 Minutes with CFI CEO Tim Vipond
Discounted Cash Flow | DCF Model Step by Step Guide
Scenario & Sensitivity Modeling in Excel | FMVA® Course Preview
Полное руководство для начинающих по финансовому планированию и анализу
How to Link the 3 Financial Statements in Excel
Оценка будущих денежных потоков для расчетов DCF
Как построить дисконтированный денежный поток (DCF) | Пошаговое руководство от бывшего инвестицио...
Mining Financial Modeling & Valuation Course
How to Build a Financial Dashboard in Excel (Step-by-Step Tutorial)
Excel for Finance and Accounting Expert Tutorial
How to value a company using discounted cash flow (DCF) - MoneyWeek Investment Tutorials
Объяснение анализа дисконтированных денежных потоков (DCF) в сфере недвижимости
Discounted Cash Flow (DCF) Analysis for BEGINNERS - How to Value a Stock Using Tesla as an Example
Sensitivity Analysis for Financial Modeling
Постройте полную модель дисконтированного денежного потока для РЕАЛЬНОЙ компании
Free Cash Flow: Back to Basics
Watch me nail Morgan Stanley's interview question on DCF (Discounted Cash Flow)!
How to Tell When a Stock is Cheap/Expensive (Masterclass in Stock Valuation)