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

[@rareliquid]

JOIN MY NEW DISCORD - discord.gg/AHnxBUGTwt ⬇ Download the Excel for FREE ⬇ ► 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: forms.gle/jMUPmnSp5pvC9sQb6 🖥Wall Street Prep - Hedge Fund Investing Certification🖥 ► Use code RARELIQUID to get up to $500 OFF! ► secure.enroll.wharton.wallstreetprep.com/referral/DSczdzDz/s2yqD1GUkwps4u5h 🍎My Courses🍎 ► How to get into MBA (LIVE): liquidmba.com/ ► How to get into investment banking (SIGN UP): forms.gle/wt4cZrezbxVgNzGUA ► How to get into consulting (SIGN UP): forms.gle/MmPxUqur7vBschUu9

[@5555SG]

Finally I can see the keyboard strokes for reference , thanks !

[@kevinsuh5313]

Thank you for your amazing keyboard strokes!

[@QrankChannel]

WACC: Debt should also include the lease liabilities, no? What about short term debt (e.g., revolver, straight loans, etc)

[@TheHipGoat1]

It does in the long run, but if you for example acquire $10m line for credit, you have that capital on hand now, and although you might owe interest, since it isn’t used at that moment, it doesn’t increase liabilities in the short term. When you start utilizing it, thats when it starts becoming a liability

[@QrankChannel]

@@TheHipGoat1 You are referring to the straight loan/revolver, which I gave as an example. IF the company didn’t used the debt yet, I agree but why would a company pay interest on debt you don’t need. So, in reality IF the company has a credit line, is probably somehow used and should be included in the debt calc to the portion taken as the company received cash (assetliability) I still believe the debt considered in the calculation for the WACC and equity value in the video is not correct (read: missing items).

[@jonasaulie4640]

Can you also use sector beta, or sector beta then unlever it and relever it back with the current debt/equity ratio of the company to make it more accurate?

[@s.a.kworld5402]

Hey Ben! Can you make a video on Financial Modelling for beginners with case study. Thanks

[@casperlangvad88]

How do you calculate your estimates for revenue etc?

[@garretduo9299]

Thanks Ben!

[@amospan14]

Thanks Ben! Appreciate you! =)

[@rareliquid]

skip the first minute or so lol had some issues with my streaming software / equipment

[@geoalmaraz9889]

Thank youuuu

[@publiccake]

how does rate cut impact discount factor?

[@salientmedia]

great stuff man, appreciate the effort!!

[@rareliquid]

no prob!

[@filipegomes9394]

when is part 2 releasing?

[@rareliquid]

aiming to release in a few weeks!

[@filipegomes9394]

@@rareliquid Thanks! Great vid, and looking forward to the next one!

[@lvdmaas]

Where did you get the estimates from?

[@Ayush-mn1ec]

did u get the answer to this even im figuring out

[@lvdmaas]

@@Ayush-mn1ec no not yet

[@your-stop-loss-is-my-entry]

factset probably

[@yongsiangchua842]

1:33:13 if you try to achieve your intrinsic value to near the current share price, then what’s the point of doing a DCF? You might as well look at the current share price and just assume the intrinsic value is somewhere near it.

[@henry9293]

No, by doing that you are reverse engineering what the market is pricing in RE: growth rate assumptions etc.. then if you think those assumptions are unrealistic you can use that to make an investment decision. Charlie munger 'always invert'

[@mathislanckriet9452]

ALT H 6

[@AymaneMani-m5j]

ebitda bull shit earnings RIP Charlie munger