⬇️ Download the Excel for FREE ⬇️ ► https://www.wallstreetprep.com/access... ► Sign up to get emails notifications for my streams and when the excel models are available: https://forms.gle/jMUPmnSp5pvC9sQb6 🖥️Wall Street Prep - Hedge Fund Investing Certification🖥️ ► Use code RARELIQUID to get $300 OFF! ► https://secure.enroll.wharton.wallstr... 👨🏫My 1:1 Banking Mentorship Program👨🏫 ► Our guarantee - secure a $150K+ / year investment banking offer within 180 days! ► Sign up: https://bankingaccelerator.com/ 🎥Related Videos🎥 DCF Beginner's Tutorial: • How to Build a Discounted Cash Flow (DCF) ... Excel Shortcuts for Finance and Modeling: • Top Excel Shortcuts For Finance and Modeli... Private Equity Video Playlist: • Private Equity How to Build an LBO From Scratch: https://youtube.com/live/Q7qNxmxkm8o ⏱Timestamps⏱ 0:00 - Situation Overview 9:05 - Trading Comps 14:37 - Gathering Historicals and Estimates 40:05 - Start of DCF 1:20:48 - WACC 1:34:33 - Mid-Year Convention 1:38:57 - Terminal Value 1:46:34 - Sensitivity Table 1:54:02 - Implied Price Per Share + Price Discussion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 📱Interact With Me📱 ► Instagram: / rareliquid ► TikTok: / rareliquid ► Twitter: / rareliquid ► LinkedIn: / benchon ► Business Inquiries: [email protected] 🔎Disclaimer🔎 All content in this video is for entertainment purposes only. I am not a professional financial advisor and my statements are not to be taken as instructions or directions. In addition, some of the links above are affiliate links, meaning that at no additional cost to you, I may earn a commission if you click through and make a purchase. #valuation #dcf #tsmc #nvidia