Create a full discounted cash flow valuation model from scratch on Excel.
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/62bffa6d7edfa6aa840e1fc2

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/courses/finance-valuation-course
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
📊 Get 25% OFF Financial Edge Using Code KENJI25: https://bit.ly/3Ds47vS

SOCIALS:
📸 Instagram - https://www.instagram.com/kenji_explains/
🤳 TikTok - https://www.tiktok.com/@kenjiexplains?lang=en

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.