💰 Financial Analysis in Excel - Discounted Cash Flow | DCF Model Step by Step Guide

Discounted Cash Flow step by step guide using free DCF excel model. 📈 Take our Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course RESOURCES: 💻 DCF Template for this video: https://view.flodesk.com/pages/61fba6b16114df05454c5067 📹 Valuation Methods Video: https://youtu.be/ZQ8wODESzhs 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 & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🏦 The Investment Banking Program: https://www.careerprinciples.com/career-track/the-investment-banking-program 🚀 All our courses: https://www.careerprinciples.com/all-courses ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ Intro 1:08​ - DCF Steps 2:40​ - Free Cash Flow 6:23​ - WACC 9:35​ - Terminal Value 12:11​ - Discounting Cash Flows 13:45​ - Equity Value 15:05​ - Full DCF Model 19:22​ - Assumptions Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.