How to Build a Discounted Cash Flow (DCF) | Step-By-Step Guide From Ex-JP Morgan Investment Banker
Vložit
- čas přidán 30. 07. 2024
- 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
⭐ 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
is EBIAT the same as NOPAT?
I just want to say thanks for this video. Couldn’t find much on a step by step tutorial DCF. 🙏🏽🚀
Clean workbook formatting, easy to follow PPT's, and step-by-step instructions. FANTASTIC instruction methodology, thanks for the informative content!
Love these follow along videos. Find them very helpful for learning the basics
Hey Ben, great video! I noticed a minor correction that might be helpful.
The formula for the cost of equity should not multiply the Risk-Free Rate by Beta.
Instead, the correct formula using the Capital Asset Pricing Model (CAPM) is:
Cost of Equity= Risk Free Rate+β×(Expected Market Return−Risk-Free Rate)
All The Best,
Juv
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
Ofc you have more than 100k subscribers, you are sharing a wealth of knowledge here!
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.
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 :)
This video has been unbelievably helpful! Thanks so much! :)
Ben your literally a gem appreciate all work!!
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).
thanks so much for the nice comment!
⏱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
Ada
Great video, mate. Very well simplified :)
This video was really helpful! Thank you so much.
Great video, Ben! Keep rocking
DUDE thank you so much for including the template.
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.
Hi rareliquid, this video was highly insightful.
please do a video on M&A transaction/modeling as well.
Good stuff. Keep em’ comin!
hey Ben, nice video! Would like to see LBOs and Power Point presentation you did at JPM. Ould you do a video about that?
both of these will be coming soon!
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
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.
Hey Ben, any chance you would be able to make a quick video on finding the financials for this model? Great video.
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 :)
Man this really does help for us beginners
Nice! DCFs are a little intense for me, so I'll chip away at this over the week ✌️
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?
Thanks so much for the video!
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.
this has value, thank you!
This is great, thank you so much
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.
@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?
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!!!
did you ever find it?
I also want it :)
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
Hey! This is very helpful! Can you pls do the sensitivity analysis and scenario analysis methodology?
Thanks for the awesome video!
Loved this.
Thank you! Please also teach a thorough LBO model
Thank you! Very helpful.
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.
Great video, thanks!
Hey buddy, great video! I'm wondering if risk-free rate can be used to replace WACC/discount rates?
Hi! Thanks for the video really appreciated. Quick question: how did you make the %growth in revenue and other assumptions?
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
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
Very good video ! Really interesting ! Do you know if a database with historical DCF analysis perform by different analysts exist ?
Thanks a lot !
Nice and clear explanation, only thing I miss is how we got the approximations of Revenue, CAPEX and Taxes in income statement section.
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😃
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
You are the best, thank you :)
thanks for these!
thank you for showing this !! how do you make predicions for D&A ?
I'd love a video on how to calculate the diluted shares outstanding
Thanks man. Kinda forgot how to do this from Business school already 😂. 🍻
no prob haha
Thank you for your content
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
great question, just watched the video and I has the same question when I noticed the forecasted revenues being hard coded
Can you do a video of PowerPoint presentation skills and most common shortcuts there as well?
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.
Awesome! Thank or the video
Note: where did u find the Cash and Debt? I search on BS but data does not match.
Can you please also make videos on treasury stock method, comparable company analysis and precedent transaction analysis.
Rareliquid what are some better ways to understand what accounts are operating assets and liabilities? THis part gets me so hung up.
Thank you so so much!!
The best, thank you
thank you sir!
Awesome vid❤
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
Hey do you have a Video Where you explain step by step how make the assumptions? Would be awesome
how did you get the revenue for 2022,2024,2025 etc. As in what assumptions did you make to get the different growth rate percentage
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.
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
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 ?
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)
EBIAT is synonymous with NOPAT
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.
How do you find the growth rate on the forecast years ? (for the FCFF)
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+....)?
Hey! You are considering market cap as equity value; Isn't that should be derived from balance sheet equity ?
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?
Thanks alot for this
no prob~
Where exactly did you get the projections for the income statement and cash flow items?
There is a small mistake in the formula in the last line on slide on screen at 16.55.
It should be --> Cost of equity = Risk free rate beta * (expected market return - risk free rate).
Instead of --> Risk free rate beta * (expected market return - risk free rate)
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!
tgr is usually rate of growth of economy and so for US companies, around 2-3%. and wacc is same thing as discount rate!
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
I may have missed it but where do those projected growth values come from?
is there a formula for how you got the projections? how exactly did you get those numbers?
Dear, it was great representation of DCF. Please help me to download the DCF template. I can't download the template from the link.
Liquid, could you do a desk setup video sometime? Introducing your gadgets etc
yup will be doing this in late august or early september
@@rareliquid awesome! Looking forward to it man!
Do mind sharing the slides with the steps and points you used in the video?
the cost of equity formula in the slide has a typo. risk free rate PLUS beta, not TIMES beta.
Is calculating sensitivity analysis important in DCF valuation.
awesome video! i think you could increase the size of your cam, it too small.
Hi, did you ever do a more exhaustive DCF video?
Why isn’t cost of sales and sg&a expenses taken into consideration? Are they optional when valuing a company?
What do you do if a company has negative cashflows?
Thank you Please Make some videos from scratch for financial modeling for college students.😃
Do a review of the show Industry on HBO. Its about IB in the UK
Hello my friend! what program do we use to record the videos?
Please , can u tell me ,bases on what you are doing assumptions in the beginning ? 11.8 % for 2022 ,how did you get this number ?
Formula of CAPM (for the cost of equity) on the ppt is wrong, as correctly stated in the Excel. Minute 16.30
How do you forecast EBIT without using others estimates?
where did you get the %growth rate ? I mean can you estimate it or is it based on the company's/ professional's assumptions ?