How to Build a Discounted Cash Flow (DCF) | Step-By-Step Guide From Ex-JP Morgan Investment Banker

Подписаться 181 тыс.

Просмотров 230 тыс.

50% 1

In this video, I provide a step by step guide on how to build a Discounted Cash Flow (DCF) model.
⭐ Alto IRA⭐
► Open a crypto IRA & Get $50 for FREE: altoira.grsm.io/rareliquid
👇Download the Templates👇
► tinyurl.com/4w2tnpnw
🚀Sign up for my Courses🚀
► How to get into investment banking: forms.gle/wt4cZrezbxVgNzGUA
► How to get into MBA programs: forms.gle/9yEyycuP7NnQBjue8
► How to research crypto: forms.gle/fvzTKu13pBgPnBMA9
💧rareliquid💧
► Join the rareliquid community: / rareliquid
► My free daily investing newsletter: www.rareliquidnews.com/
► rareliquid careers channel: / rareliquidcareers
🎥Related Videos🎥
Excel Shortcuts for Finance and Modeling: • Top Excel Shortcuts Fo...
Netflix DCF Model: • Netflix DCF Valuation ...
NVIDIA DCF Model: • NVIDIA DCF Valuation M...
Tesla DCF Model: • Is Tesla Stock A Buy? ...
Google DCF Model: • Google DCF Valuation M...
🧑‍🎓Career Resources👩‍🎓
► Buy the resume + cover letter that got me into JPM: rareliquidcareers.com/
► Wall Street Prep (Use code RARELIQUID for 20% OFF!): gv142.isrefer.com/go/rliquid/...
► Books I recommend: amzn.to/3gy28xv
► My filming equipment: a.co/cf97WjW
📱Interact With Me📱
► Instagram: / rareliquid
► Twitter: / rareliquid
► TikTok: / rareliquid
► LinkedIn: / ben-chon-8b0ba34a
► Business Inquiries: ben@rareliquid.com
⏱Timestamps⏱
0:00 - Introduction
1:28 - Alto IRA
3:01 - What is a DCF?
4:12 - The 5 Steps of a DCF
4:36 - Step 1 - Projecting Free Cash Flow
12:51 - Step 2 - Calculating WACC
19:34 - Step 3 - Calculating Terminal Value
23:13 - Step 4 - Discounting back to Present Value
24:16 - Step 5 - Calculating Implied Share Price
27:00 - Advanced Topics
🔎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.
#dcf #valuation #stocks

Опубликовано:

25 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 190

@rareliquid 2 года назад

⭐ Alto IRA⭐ ► Open a crypto IRA & Get $50 for FREE: altoira.grsm.io/rareliquid 👇Download the Templates👇 ► www.dropbox.com/sh/vco01w7g626tc61/AACSqicz-YQUid0RoDPEo8m6a?dl=0 🚀Sign up for my Courses🚀 ► How to get into investment banking: forms.gle/wt4cZrezbxVgNzGUA ► How to get into MBA programs: forms.gle/9yEyycuP7NnQBjue8 ► How to research crypto: forms.gle/fvzTKu13pBgPnBMA9

@cepochukwu Год назад

is EBIAT the same as NOPAT?

@mattiovino3752 2 года назад

Love these follow along videos. Find them very helpful for learning the basics

@julian5094 Год назад

I just want to say thanks for this video. Couldn’t find much on a step by step tutorial DCF. 🙏🏽🚀

@ecccc758 2 года назад

Clean workbook formatting, easy to follow PPT's, and step-by-step instructions. FANTASTIC instruction methodology, thanks for the informative content!

@yannbeko Год назад

Those video are so cool ! Complicated to traduce everything from english to french but it makes me step up. Every step count when you have an objectives

@cameronrobin_ Год назад

This video has been unbelievably helpful! Thanks so much! :)

@rareliquid 2 года назад

⏱Timestamps⏱ 0:00 - Introduction 1:28 - Alto IRA 3:01 - What is a DCF? 4:12 - The 5 Steps of a DCF 4:36 - Step 1 - Projecting Free Cash Flow 12:51 - Step 2 - Calculating WACC 19:34 - Step 3 - Calculating Terminal Value 23:13 - Step 4 - Discounting back to Present Value 24:16 - Step 5 - Calculating Implied Share Price 27:00 - Advanced Topics

@Nick-es8fl 6 месяцев назад

Ada

@Prosnipezzzz1 2 года назад

Ben your literally a gem appreciate all work!!

@user-es6zb5iv3o Год назад

This video was really helpful! Thank you so much.

@elyfal6586 Год назад

Great video, mate. Very well simplified :)

@roydavis1417 2 года назад

Your insights on operating assets and operating liabilities. Your insights into years used to project and even mentioning using 20-30 years at JPMorgan. Also really breaking down the information you value worth projecting or using. All very useful, thank you. This was without a doubt your best DCF video yet. It was explained very well. I was interested in the concept of years used forward, cause really all we're doing is trying to predict a future market cap in todays value. I also realized the market can move rather quickly, so a long projection isn't always going to be the case, it's just simply a way for the calculation to give us a fair idea if we weight it with those years. However with the recession coming those years will likely matter (lol).

@rareliquid 2 года назад

thanks so much for the nice comment!

@Pietsuttaja 2 года назад

Good stuff. Keep em’ comin!

@joshuaalfred8307 2 года назад

5 minutes in. Subscribed. I could immediately tell content is legit. Looking forward to your in-depth video explaining DCF. Everyone else covers a dumbed down DCF, but I want to understand it like the professionals do.

@AJRMediaAgency Год назад

Ofc you have more than 100k subscribers, you are sharing a wealth of knowledge here!

@lorenzo4103 2 года назад

hey Ben, nice video! Would like to see LBOs and Power Point presentation you did at JPM. Ould you do a video about that?

@rareliquid 2 года назад

both of these will be coming soon!

@danielmaher7781 2 года назад

Great video and explanation. FYI you can make your Ticker a 'Stock' Data Type in excel which gives you access to some useful info like market cap, beta, share price etc so you don't need to keep updating manually. Worth giving it a try :)

@adilkhanyeslyambek2955 Месяц назад

Great video, Ben! Keep rocking

@AstronautOtto Год назад

DUDE thank you so much for including the template.

@ronkatayev426 2 года назад

Thanks so much for the video!

@sebastianpolanco6352 Год назад

this has value, thank you!

@alexwedermann3282 Год назад

Thanks for the awesome video!

@videos-qh1gg 2 года назад

Hey Ben, thank you so much for this incredibly insightful video. I have a question though: If the change in networking capital is already negative, don't we add it instead of subtracting? Thanks :)

@alperdokucu1345 Год назад

Thank you! Very helpful.

@khattak1430 2 года назад

Hi rareliquid, this video was highly insightful. please do a video on M&A transaction/modeling as well.

@Tfcistheboss 2 года назад

Loved this.

@y_limit_yourself Год назад

@rareliquid Love your videos thanks for all your help! I'm a bit confused about how you get the projected revenue amounts and rates though, could you clarify where $525,188 and 11.8% are derived from?

@eddierosario1537 Год назад

Man this really does help for us beginners

@user-uf8bk6lk2o 4 дня назад

This is great, thank you so much

@nickstephenson1064 2 года назад

Great video, thanks!

@finnsheehan4590 2 года назад

Hey Ben, any chance you would be able to make a quick video on finding the financials for this model? Great video.

@footlongchen Год назад

thanks for these!

@keedtalktoem3674 2 года назад

Great work, clean and precise on everything. Only thing i would argue on is the TGR being equal to GDP growth. Through my experience i’ve always learned to be conservative when valuing a company and therefore have a TGR usually 1-2% lower than GDP growth

@benadkins7695 7 месяцев назад

If you're generating a return less than or equal to inflation, you wouldn't be purchasing stocks over bonds unless you owned a majority share.

@MCrypto020 Год назад

Love the vid, I just think there is a little mistake when calculating the cost of equity at 16:30. It is a + like u mention later instead of x

@annazaiceva5861 2 года назад

Hey! This is very helpful! Can you pls do the sensitivity analysis and scenario analysis methodology?

@barryaherne215 2 года назад

Nice! DCFs are a little intense for me, so I'll chip away at this over the week ✌️

@lia55lee 9 месяцев назад

thank you for showing this !! how do you make predicions for D&A ?

@parthbhatt1226 2 года назад

Thank you! Please also teach a thorough LBO model

@BNLien 3 месяца назад

Thank you very much for all the useful information, especially the how you answer interview question on DCF. I am wondering if you can do the similar thing with 3 statements models. I have done it but don't know how to put them into words and sumarization. Appreciate your reply.

@RichFlair310 7 месяцев назад

Awesome videos dude! Have been working through your whole channel - congrats on Wharton! Question. In Step 1, why did you project D&A as a % of revenue instead of as a % of CapEx?

@MrJunhaotyco Год назад

Hey buddy, great video! I'm wondering if risk-free rate can be used to replace WACC/discount rates?

@viktorf9617 2 года назад

You are the best, thank you :)

@mafaldeta5575 5 месяцев назад

Thank you for your content

@jordanevans9385 Год назад

Thank you so so much!!

@user-wy8sj7jn8u Месяц назад

I just wanted to say how much I appreciate your commitment to helping traders succeed. Your strategies are so well researched and effective, and your willingness to share them with us without any expectation of payment is truly inspiring. Thank you for being such an amazing teacher and mentor.

@gamerspeed8845 Год назад

Very good video ! Really interesting ! Do you know if a database with historical DCF analysis perform by different analysts exist ? Thanks a lot !

@ricardoaldana2137934 2 года назад

The best, thank you

@EvEnPvP Год назад

Awsome video! How do you automatically get data for a new company into the same excel sheet? Or do you have to do it manually? Thanks

@kevinsuh5313 2 года назад

thank you sir!

@dohlay7766 2 года назад

Hi Ben, thanks a lot for this wonderful video ! I am doing my Masters degree and now quite interested in the wealth management private banking division, what would you recommend to prepare for this position

@RicardoFlores-dc8kz 2 года назад

Awesome! Thank or the video Note: where did u find the Cash and Debt? I search on BS but data does not match.

@thaiphung8357 2 года назад

Can you also do an instruction video for DDM and RI model? Some corporations do not operate in a way other firms do so DCF is not applicable for them. Thanks

@nikobaklanov4455 2 года назад

Hello! Thank you for such a cool video, just one remark you had a mistake on the video with "What is WACC" where you multiplied the risk free rate in the formula instead of adding it as you explained further on.

@Obsessivefilms Год назад

Awesome vid❤

@WasteSecond 2 года назад

I'd love a video on how to calculate the diluted shares outstanding

@rodrigogonzalez2673 2 года назад

Can you do a video of PowerPoint presentation skills and most common shortcuts there as well?

@willfowls2400 Год назад

Great video! Seeing the DCF built out from scratch helps me visualize the process and apply it in practice. Just curious, were estimated revenue growth, EBIT margin, D&A, etc. figures for 2022-2026 based on historical data in the sector? Or was it more of a forward-looking estimate based on sector growth, macroeconomic factors, etc.? Maybe a little bit of both? Any information on estimating forward-looking estimates of revenue growth, future margins, etc. is helpful. Thanks

@freerunner626 9 месяцев назад

great question, just watched the video and I has the same question when I noticed the forecasted revenues being hard coded

@luisfilipesf 2 месяца назад

Hi! Thanks for the video really appreciated. Quick question: how did you make the %growth in revenue and other assumptions?

@JoshuaLam89 Год назад

hi i have some questions, how do you determine the income statement and casflow items from year 2022-2026? And how do you calculate (or get the data) for 'cost of debt', 'risk free rate', and 'market risk premium'? Thanks. Great content.

@louisvilleseche2996 Год назад

Cost of debt is the yield to maturity (or interest rate) that the debt is supplied at, risk free rate is generally the yield to maturity of 10 year T bills, market risk premium is the expected return of the asset minus the risk free rate. Hope this helps

@aryavbothra9662 2 года назад

This is so awesome!! Could you share the template for the DCF with the multiple cases (conservative, base, etc.) as well please? I’ve been struggling with the formatting for so long and it would be a tremendous help. Thanks so much for this whole DCF series, it’s been a lifesaver!!!

@MichaelSmith-fo6qq Год назад

did you ever find it?

@ibonro7778 Год назад

I also want it :)

@milespulvers5858 10 месяцев назад

Where did you get all the projections? Did you calculate them, and if so how, or did you find them from an outside source? Building my own DCF for an application so I'd really appreciate some advice.

@donaldduck4595 2 года назад

Hey Ben, I asked you about 2 weeks ago which keyboard you use. Ever since I got it my wristpain from working 10-12 hours a day went away almost completely. Thank you so much for the recommendation!🙏🏼🙏🏼🙏🏼 Since I still got problems with my right hand, I wanted to ask which mouse you use😃

@ankuryadav5512 2 года назад

Thanks alot for this

@rareliquid 2 года назад

no prob~

@indubitablyyeah338 2 года назад

Thanks man. Kinda forgot how to do this from Business school already 😂. 🍻

@rareliquid 2 года назад

no prob haha

@bhargav1389 2 года назад

Please make a video on advance topics as well. It kind a gives clear picture of DCF model otherwise learning part by part would be very confusing.

@arnaudlouispotard8645 Год назад

How do you find the growth rate on the forecast years ? (for the FCFF)

@yashmaurya3679 2 года назад

Can you please also make videos on treasury stock method, comparable company analysis and precedent transaction analysis.

@WeSnapple Год назад

Rareliquid what are some better ways to understand what accounts are operating assets and liabilities? THis part gets me so hung up.

@itsgoingtobelegenwaitforit8741 Год назад

Hey do you have a Video Where you explain step by step how make the assumptions? Would be awesome

@jeancarlojimenezcondori8574 6 месяцев назад

Thanks for Sharing. I liked it. I ve seen a theory where incorporate two concepts : SA( Surplus assets) and M ( Minority) to calculate Equity Value. What can you tell me about this ? Thanks in advance

@lucasbanega_ Год назад

Thanks for sharing your knowledge in these kind of video. It's very useful! I have a question. How can I calculate the TGR? And, can I replace the WACC with a discount rate? For example, 15% instead of the Wacc. Thanks!

@rareliquid Год назад

tgr is usually rate of growth of economy and so for US companies, around 2-3%. and wacc is same thing as discount rate!

@Nicolas-qr6xy 2 года назад

Where exactly did you get the projections for the income statement and cash flow items?

@LordikCZ 2 года назад

Nice and clear explanation, only thing I miss is how we got the approximations of Revenue, CAPEX and Taxes in income statement section.

@benjaminli3808 Год назад

I may have missed it but where do those projected growth values come from?

@jaredyu2000 4 месяца назад

Thanks!

@rareliquid 4 месяца назад

No problem!

@egesoysal6032 2 года назад

Hello Ben I live in Turkey. In here,right now, there is a huge enflation ( over %150) in this situation people always says you can’t use DCF model because you can’t predict future growth by looking historical datas. Is it true ? Or do you have any suggestion to make projection ?

@keithleyjarvis5663 2 года назад

Do mind sharing the slides with the steps and points you used in the video?

@Reza_Audio Год назад

4:40 I guess in the first line of FCF calculation, you need to put operating income instead of EBIT while they are not the same, so the first line which will be NOPAT is calculated from Operating Income*(1- Tax rate)

@MaxxingMoney Год назад

EBIAT is synonymous with NOPAT

@BigA678 2 года назад

Do a review of the show Industry on HBO. Its about IB in the UK

@sriram181 11 месяцев назад

9:55 hey , how did you arrive at the projected growth in revenue figures and projected growth in EBIT figures ? Was that a product of some calculation or was that a general assumption?

@rkt3898 Год назад

Where do I get TGR for calculating Terminal Value? Why can't I apply the difference in growth between year 2025 and year 2026? Please help

@youtubepremium2421 2 года назад

Love your vids. My one question however is, how does a retail investor such as myself gain access to analyst forecasts for financial metrics? Bloomberg and FactSet are way out of my budget. Would appreciate it if you could share any alternatives which are more viable for retail investors such as myself. Thank you.

@regansun1629 2 года назад

You could also just forecast with your own assumptions based on historical data.

@bhargav1389 2 года назад

Is calculating sensitivity analysis important in DCF valuation.

@Bens_ant_world Месяц назад

Hi, did you ever do a more exhaustive DCF video?

@viratverma3616 Год назад

Hey Ben, I have questions, why at @9:28 to get projected revenue why have you did this =previous (1+growth rate)? I want to know why we are adding one here (1+....)?

@atursunov225 Год назад

Dear, it was great representation of DCF. Please help me to download the DCF template. I can't download the template from the link.

@milapthakor3320 8 месяцев назад

Hey! You are considering market cap as equity value; Isn't that should be derived from balance sheet equity ?

@dixonyamada6969 Год назад

the cost of equity formula in the slide has a typo. risk free rate PLUS beta, not TIMES beta.

@nev6250 2 года назад

Liquid, could you do a desk setup video sometime? Introducing your gadgets etc

@rareliquid 2 года назад

yup will be doing this in late august or early september

@nev6250 2 года назад

@@rareliquid awesome! Looking forward to it man!

@dimitrismarinosmantziagris9158 Год назад

Hello my friend! what program do we use to record the videos?

@jamescurran1491 Месяц назад

16:35 I think there is a mistake. Cost of equity should be RFR + beta x (equity risk premium) if you're using CAPM. You have it multiplied by the RFR, not added to.