Categories
Corporate Finance

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

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://tinyurl.com/advanceddcfp1
► 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 Courses🍎
► How to get into MBA (LIVE): https://liquidmba.com/
► How to get into investment banking (SIGN UP): https://forms.gle/wt4cZrezbxVgNzGUA
► How to get into consulting (SIGN UP): https://forms.gle/MmPxUqur7vBschUu9

🧑‍🎓Career Resources👩‍🎓
► Buy 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/
► TTP (Use code RARELIQUID15 for 15% OFF!) – The BEST GMAT prep resource: https://targettestprep.referralrock.com/l/rareliquid/

🎥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

Watch/Read More