The FINAL Advanced DCF Tutorial WITH EXCEL SHORTCUTS! (Part 3)

Part 2 Video - https://youtube.com/live/z9S9QNosrA4 Part 2 Model - https://rareliquidcareers.com/shop/e4eae6dc-d64c-4e76-a8bb-15a2afb217ff1/ ⬇️ Download the Excel for FREE ⬇️ ► https://www.wallstreetprep.com/access/advanced-dcf-tutorial-with-excel-shortcuts/ ► Sign up to get emails notifications for my streams and when the excel models are available: https://forms.gle/jMUPmnSp5pvC9sQb6 🖥️Wall Street Prep🖥️ ► Use code RARELIQUID for 20% OFF on any course! ► https://gv142.isrefer.com/go/rliquid/rareliquid/ 👨‍🏫My 1:1 Banking Mentorship Program👨‍🏫 ► Our guarantee - secure a $150K+ / year investment banking offer within 180 days! ► Sign up: https://go.bankingaccelerator.com/e74a89da 🧑‍🎓Recruiting Resources👩‍🎓 ► The Resume That Got Me Into JPM - https://rareliquidcareers.com/ ► Wall Street Prep (Use code RARELIQUID for 20% OFF!) - https://gv142.isrefer.com/go/rliquid/rareliquid/ ► Target Test Prep (Use code RARELIQUID15 for 15% OFF!) - https://targettestprep.referralrock.com/l/rareliquid/ 🎥Related Videos🎥 ► Advanced DCF Part 1: https://youtube.com/live/fmoE3H8RjP4 ► Advanced DCF Part 2: https://youtube.com/live/z9S9QNosrA4 ► DCF Beginner's Tutorial: https://youtu.be/nyot7FkYoqM ► Excel Shortcuts for Finance and Modeling: https://youtu.be/oDjhg57XH-A ► Simple LBO Tutorial: https://youtube.com/live/Q7qNxmxkm8o ► Advanced LBO Tutorial: https://youtube.com/live/1ZJsA_tjQNc ⏱Timestamps⏱ 0:00 - Introduction 5:18 - Trading Comps 11:15 - Cleaning up the Model 18:20 - Terminal Value - Perpetuity and Exit Multiple Methods 39:10 - Levering / Unlevering Beta 1:04:24 - Convertible Bonds 1:14:42 - Sensitivity Tables ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 📱Interact With Me📱 ► Instagram: https://www.instagram.com/rareliquid ► TikTok: https://www.tiktok.com/@rareliquid ► Twitter: https://www.twitter.com/rareliquid ► LinkedIn: https://www.linkedin.com/in/benchon ► Business Inquiries: ben@rareliquid.com 🔎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 #financialmodeling #finance