Advanced DCF Tutorial WITH EXCEL SHORTCUTS! (Ex J.P. Morgan Investment Banking Analyst)

JOIN MY NEW DISCORD - https://discord.gg/AHnxBUGTwt ⬇️ Download the Excel for FREE ⬇️ ► https://www.wallstreetprep.com/access/advanced-dcf-tutorial-part-1/ ► 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 up to $500 OFF! ► https://secure.enroll.wharton.wallstreetprep.com/referral/DSczdzDz/s2yqD1GUkwps4u5h 👨‍🏫My 1:1 Banking Mentorship Program👨‍🏫 ► Our guarantee - secure a $150K+ / year investment banking offer within 180 days! ► Sign up: https://go.bankingaccelerator.com/283346a4 🎥Related Videos🎥 ► DCF Beginner's Tutorial: https://youtu.be/nyot7FkYoqM ► Excel Shortcuts for Finance and Modeling: https://youtu.be/oDjhg57XH-A ► Advanced LBO Tutorial: https://youtube.com/live/1ZJsA_tjQNc ► Simple LBO Tutorial: https://youtube.com/live/Q7qNxmxkm8o ► Private Equity Video Playlist: https://www.youtube.com/playlist?list=PL71QplJWp1Rrm0dkWjjIY2cf4jTYSU0t2 ⏱Timestamps⏱ 0:00 - Introduction 9:00 - Revenue Build 24:40 - EBIT Build 41:07 - Taxes and Cash Flow Items 52:45 - DCF 1:02:15 - WACC 1:13:15 - Mid Year Convention 1:19:10 - Terminal Value 1:24:08 - Diluted Shares Calculation 1:32:43 - Calculating Implied Share Price ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 📱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