Build A Full Discounted Cash Flow Model for a REAL Company
Create a full discounted cash flow valuation model from scratch on Excel.
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/62bffa...
In this video you'll learn to do a full discounted cash flow (DCF) valuation on a real company.
First, we gather all the data. In this case it's the three financial statements from the company's annual report. Second, we begin forecasting the free cash flows. In order to do so, we create revenue projections, as well as a fixed assets schedule and a net working capital projection.
Third, we calculate the WACC, short for the weighted average cost of capital in order to discounted all the future cash flows back to the present value.
Fourth, we calculate the terminal value, which is the value of the company after the forecast period. Then, we discounted the TV and the FCFs to get the enterprise value.
Lastly, we calculate an implied share price by going from enterprise value to equity value, and dividing by the diluted shares outstanding. Finally, we create a sensitivity table to see how chaining the WACC and the growth rate affects our valuation.
LEARN:
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
📊 Get 25% OFF Financial Edge Using Code KENJI25: https://bit.ly/3Ds47vS
SOCIALS:
📸 Instagram - / kenji_explains
🤳 TikTok - https://www.tiktok.com/@kenjiexplains...
GEAR:
📹 My Favorite Books & Gear: https://kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Projecting cash flows
3:28 - Fixed Assets Schedule
5:35 - Calculating Free Cash Flow
15:42 - Calculating the WACC
22:52 - Calculating the Terminal Value
25:12 - Calculating an Implied Share Price
26:34 - Sensitivity Table
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
Watch video Build A Full Discounted Cash Flow Model for a REAL Company online without registration, duration hours minute second in high quality. This video was added by user Kenji Explains 03 July 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 252,711 once and liked it 5.4 thousand people.