Discounted Cash Flow (DCF) Analysis for BEGINNERS - How to Value a Stock Using Tesla as an Example

Поделиться
HTML-код
  • Опубликовано: 29 авг 2024

Комментарии • 221

  • @rareliquid
    @rareliquid  3 года назад +96

    *As I mentioned in the video, here are some further explanations of some of the concepts I brought up:*
    *Capital Expenditures (CapEx)* - Cash you spend on Plant, Property, and Equipment (PP&E). So Apple spends $100 million on a new office building, that's $100 million of Capital Expenditures. CapEx is NOT found in your income statement because they are usually really large one-time expenses and the income statement tries to capture expenses that occur regularly. Instead, the costs of CapEx are depreciated over time (see below).
    *Depreciation & Amortization (D&A)* - In the CapEx example, if Apple bought a new building for $100 million and that building had a "useful life" of 20 years, the annual D&A would be $100 million / 20 = $5 million a year. D&A IS found in your income statement either embedded into COGS or Operating Expenses. D&A allows you to fairly deduct CapEx spend over a period of time but it's not actual cash that you're spending (instead the actual cash was a one-time payment in CapEx).
    *Net Working Capital (NWC)* - For a DCF, this is your current OPERATING assets (i.e. excludes cash, includes assets like inventory, accounts receivable, etc.) minus your current OPERATING liabilities (i.e. excludes debt, includes accounts payable, deferred revenue, etc.). Standard definition for NWC is just current assets minus current liabilities but there's a difference for the DCF. NWC looks at the regular cash inflows and outflows from a company's day to day operations.
    *WACC Formula* - As a reminder, this is your (% of equity * cost of equity) + (your % of debt * cost of debt * (1 - Tax rate)). % of equity means [equity value / (equity value + debt)]. cost of equity is found through the CAPM formula (risk free rate + beta * market risk premium). % of debt is [debt / (debt + equity value)]. You multiply the debt part times 1 - tax rate because interest payments are tax deductible.
    💰Get Free Money💰
    ► Coinbase - Get $10 in Free Bitcoin: coinbase.com/join/chon_df?src=ios-link
    ► Moomoo - Get 2 Free Stocks: j.moomoo.com/005RTE
    ► Webull - Get 2 Free Stocks: act.webull.com/invite/share.html?inviteCode=5gwmzRWoEVWd
    ► Schwab - Earn up to $500: www.schwab.com/public/schwab/nn/refer-prospect.html?refrid=REFERBYVYKMZ6
    ► Blockfi - Get up to $250: blockfi.mxuy67.net/Keje6z
    ► Audible - 30 Day Free Trial (Unlimited Audio Books!): amzn.to/3u8aBLq

    • @tilloberto
      @tilloberto 3 года назад

      Hey Ben, thanks for all the explainations. I was wondering whether JPM really uses CAPM model and not a more advanced one as other tier 1 banks. It seems too simple to me :D Keep up the good work!

    • @qwertz9501
      @qwertz9501 2 года назад

      i am missing an explanation of the following term: cost of debt
      would highly appreciate it.

    • @lukebarmakian3200
      @lukebarmakian3200 2 года назад +2

      @@qwertz9501 cost of debt (i think) would be the interest rate that theyre paying on debt, its like how much its costinf them to borrow money.

  • @aaronlazarus3828
    @aaronlazarus3828 3 года назад +78

    I took a 9hr course on DCF and you cleared my problems in 18mins. Thank you so much

  • @hualaina6172
    @hualaina6172 3 года назад +88

    Hi Ben, I am a year-one LSE student. So many of our students are trying to get into investment banking and it's really nice of you to provide free contents. Thank you so so so so so so much!

  • @qualityballer414
    @qualityballer414 3 года назад +11

    It is crazy how helpful this channel has been for me over the past couple months. From learning about a career in investment banking a few months ago to helping me prepare for a finance quiz I have tomorrow… The high quality of your videos isn’t going unnoticed and I don’t doubt this channel will really blow up soon!

  • @jasonang3528
    @jasonang3528 2 года назад +6

    Your explanation is incredibly amateur-friendly and is definitely interesting that it made me watch the entire thing at 2.30am in the morning. Really appreciate your dedication and knowledge and I am excited to watch your other videos and those upcoming ones! 😁

  • @tmdngs
    @tmdngs 3 года назад +50

    This was extremely helpful! I’d love more basic corporate finance videos and examples. Looking forward to your next vid🙂

  • @newyorkgumgum9960
    @newyorkgumgum9960 3 года назад +42

    Interviewer: Walk me through a DCF
    Me: hold my rareliquid subscription

    • @rareliquid
      @rareliquid  3 года назад +1

      LOL

    • @richieg.3192
      @richieg.3192 3 года назад +1

      Interviewer: What's the best method for calculating Terminal Value?
      Ben: Perpetuity Growth Method is without a doubt the absolute best method
      Interviewer: Why?
      Ben: It's the only method I've used.

  • @Lofibootleg
    @Lofibootleg 3 года назад +14

    Thank you for the really clear explanation! Would like to see more in-depth dive into case studies using excel :))

  • @Jackmunropickleball
    @Jackmunropickleball 2 года назад +2

    Really helpful. I’m 17 trying to get into this and your channel is so helpful

  • @antoniaplans2890
    @antoniaplans2890 3 года назад +2

    DUDE I needed this like last week!! The struggles I had at work trying to figure this out 😂😂

  • @aguamenti1000
    @aguamenti1000 2 года назад +2

    Thanks so much! Super helpful in preparing for a corp fin interview - concise and to the point. Also thanks for including text boxes - makes it much easier to write down notes 😊

  • @kamilraimov312
    @kamilraimov312 2 месяца назад +2

    You are the best bro

  • @SL-yy4mn
    @SL-yy4mn 3 года назад +5

    Leaving some love in the comments!

  • @jordanm8542
    @jordanm8542 2 года назад

    Started watching back your live stream of how to build one of these models. Extremely helpful. Have been looking for a while around this topic, however have found your walk through on the live stream and explanation in this video to be one of the best ive found. Appreciate it.

  • @davidlegeros1914
    @davidlegeros1914 2 года назад

    Thank you for clarifying the concepts of DCF and WACC. it is very helpful to a non-business student earning an MBA.

  • @AC-ke3ui
    @AC-ke3ui 3 года назад +2

    Content keeps getting better and better🙌🏼

  • @mrbonbonist
    @mrbonbonist 3 года назад +5

    You should do a series of videos making in-depth models for trending stocks. Oh and thanks I really enjoyed your video.

  • @Isabella-hd5ek
    @Isabella-hd5ek 2 года назад

    Very helpful! I really like that you added explanation and how you use the DCF model at work .

  • @francescopici4104
    @francescopici4104 3 года назад +2

    Favorite kind of videos!! keep it up man!

  • @bryce6985
    @bryce6985 2 года назад

    This is higher quality that the materials I was given at Uni.

  • @truongthevinh8926
    @truongthevinh8926 3 года назад +2

    Thanks for sharing Ben. I'll be greatful if you do a series about finance for beginners😍

  • @thomasrichalot2517
    @thomasrichalot2517 3 года назад +2

    Thanks Ben for sharing precious information as always!

  • @nycbankers1427
    @nycbankers1427 2 года назад +2

    This is amazing bro as a trader this gives you an edge when it comes to trading and valuations thanks a lot brother

  • @hansandinvestments3990
    @hansandinvestments3990 3 года назад +2

    Nice and simple breakdown. Great job. This would be useful for people who are learning

  • @PrimeHarbor
    @PrimeHarbor 3 года назад +1

    I’ve been waiting for this. Thank you for doing ittttt

  • @Aintnerd
    @Aintnerd 3 года назад +1

    Thanks for sharing. Very articulated piece

  • @hoanghieptran5460
    @hoanghieptran5460 3 года назад +1

    really appreciate this content. looking forward to future contents like this

  • @calebsmith5963
    @calebsmith5963 2 года назад

    Man, that General Electric comment did not age well at all. But I appreciate what you were trying to say. :)

  • @santiagoparra5047
    @santiagoparra5047 3 года назад +1

    absolutely clear! Could u plz make M&A transactions on the next one?

  • @sergecanepa1971
    @sergecanepa1971 2 года назад

    great informative videos and appreciate the added video effects you do to make it more appealing

  • @TheLogicman1
    @TheLogicman1 3 года назад +2

    Thank you for this! Super helpful and useful- loving the IB insights.

  • @user-rd6en5vx6y
    @user-rd6en5vx6y Год назад

    Thank you, This video is very helpful, I'll learn many thing from your channel

  • @leokal457
    @leokal457 3 года назад +2

    Really good video! Very informative and easy to understand.
    But i realised that i really have to up my finance english skills. Some definitions you gave were a little fast for me. But thats not your fault!

  • @rickylin5561
    @rickylin5561 3 года назад +1

    Hi I'm recently getting my 1st year Finance classes started in GWU, I'm really nervous and stressful but after learning from your video at least I can have a little bit more confidence on prep for what I will learn in the upcoming classes!
    Thank you for YOUR useful content!

  • @wolfgangi
    @wolfgangi 2 года назад +1

    Eyyyyyy glad to see my fellow bear. Go Bears! , instant sub.

  • @chenchen5222
    @chenchen5222 2 года назад

    Love your teaching!!! so simple and clear :)

  • @elkor2792
    @elkor2792 2 года назад

    Really great video! I personally look at forecasting and DCF as two different parts of an analysis

  • @michaelphonevilay8597
    @michaelphonevilay8597 3 года назад +1

    Thank you for this great video, I love the formatting

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

    do you have any eli5 videos? so many concepts and steps are confusing, fast and non intuitive. a detailed breakdown of this would be really helpful!

  • @adamabdul2594
    @adamabdul2594 2 года назад

    Appreciate the work and effort in explaning the concepts!

  • @inakastories23
    @inakastories23 2 года назад

    This is helpful...assisted me in my home work

  • @joaolucaas__
    @joaolucaas__ 2 года назад +1

    Your content is great man!!

  • @foyg5967
    @foyg5967 2 года назад

    Love from India 🇮🇳

  • @frederikgarde1331
    @frederikgarde1331 3 года назад +1

    Where Can i download the Excel dcf?

  • @killmills
    @killmills Год назад +1

    yo could you do a dcf or how you would value stocks that operate at a loss like coinbase?

  • @athanasiusliau74
    @athanasiusliau74 3 года назад +1

    Here before rareliquid reaches 1M 🤩

  • @kyroz..
    @kyroz.. 2 года назад +1

    Very valuable content! I'm trying to go into IB but it's hard if you're 29 yo with no prior exp in that field. My goal is to get an internship (doesn't have to be in a BB oder top tier bank) and I'm trying to increase my chances by completing an IB course on udemy. Keep going with your content! I like them, new sub here👍

  • @trido4936
    @trido4936 3 года назад +3

    Commenting for the algorithm

  • @abhisheksingh8265
    @abhisheksingh8265 2 года назад +1

    Request to also put up This kinda series on LBO you did for 6.1 Bn deal

  • @hyehyunpark530
    @hyehyunpark530 Год назад

    You are super helpful! Thank you so much for this!

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

    You rock, dude. 😊

  • @exodus3243
    @exodus3243 2 года назад

    Great Video! Even that i am advanced in this field, i kind of enjoyed the explanation. More of that !!👍

  • @opheliewang5317
    @opheliewang5317 2 года назад

    Very clear explanation, extremely helpful ! thanks a lot ~~~~

  • @jberczi6
    @jberczi6 3 года назад +3

    How do you determine how many years to project out and discount back? The difference between choosing like 5 and 10 can be massive

    • @rareliquid
      @rareliquid  3 года назад

      usually if it’s a company with a lot of growth potential then 10 years if it’s more stable then 5 years

  • @asishjp3296
    @asishjp3296 3 года назад +1

    It was pretty much helpful 👍🏻👍🏻

  • @walterchow6368
    @walterchow6368 3 года назад

    Good video, very helpful for my group work haha, thanks

  • @tkceedits2377
    @tkceedits2377 3 года назад +2

    Can you teach us other valuation methods like ratios and other stuff.

  • @sydneybarzakay9123
    @sydneybarzakay9123 2 года назад +1

    You saved me for my finance final

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

      Hey Sydney! Glad I could help

  • @Robay146
    @Robay146 3 года назад

    Thanks for this! You're a good teacher! 👍🏾

  • @johnjohn2914
    @johnjohn2914 3 года назад

    Love ur videos better than my professors~

  • @nicholasfenelon5785
    @nicholasfenelon5785 Год назад

    great video very informative

  • @augustusg857
    @augustusg857 2 года назад

    I would of lover to seen you use the exit multiple. And fcf gives us market value too, I've seen ppl use a terminal multiple times the fcf to get market cap.

  • @prashantchapagai6294
    @prashantchapagai6294 2 года назад

    Brother, you are doing such a great thing. Thank you so much. i would like to request you to bring some more videos on financial analysis. if you are free then please try to make details explanation with some examples in excel.

  • @andrewphillips1026
    @andrewphillips1026 3 года назад +1

    Love the videos. Keep em coming!

  • @TheZeignacio
    @TheZeignacio 3 года назад

    Great video, thank you for sharing it. Congrats!

  • @hermoinegrangerful
    @hermoinegrangerful 3 года назад +1

    great explanation, rareliquid!

  • @GraysonKYC
    @GraysonKYC 2 года назад

    i guess the crypto startup use similar valuation model now. it's a great explanation to a outsider like me who is currently trying to propose a valuation for fundraising event. thanks a lot

  • @edoardofurlan6284
    @edoardofurlan6284 2 года назад

    very useful video. My question is based on what you make your assumptions ?

  • @accountsequity5587
    @accountsequity5587 3 года назад +1

    Love this type of videos

  • @geddees
    @geddees 2 года назад +1

    Fire video, thank you.

  • @mastermindmaheshwari4095
    @mastermindmaheshwari4095 Год назад

    Thanks It very helpful

  • @warrenhenning8064
    @warrenhenning8064 2 года назад

    So this is really just a way of making a spreadsheet that appears to justify what you already believed. You just need to fudge the numbers to get whatever answer you want. Fiendishly clever.

    • @rareliquid
      @rareliquid  2 года назад +1

      yes you can always adjust as you would like but it's still a helpful analysis because it shows you what you need to believe to get to a certain valuation

  • @MrOtavioAFF
    @MrOtavioAFF 10 месяцев назад +1

    Thank you!!

  • @SuperJinming
    @SuperJinming 3 года назад +1

    Love your videos so much!

  • @Winston0Boogie
    @Winston0Boogie 2 года назад

    Just found you. Please give more content so we can continue to learn to invest lol

  • @darkshinigami9438
    @darkshinigami9438 2 года назад +3

    Hello, just discovered and subscribed to your channel 😉 you mentioned DCF applied to biotech companies. Could you please share one of such DCF? I am working in a pharma company and I am very interested in this topic, thank you very much

  • @Unknowledgeable1
    @Unknowledgeable1 Год назад

    5:21
    8:08 cf. Stable top line rev
    Enterprise value means the same thing as intrinsic value?
    'Relatively predictable'

  • @TechVHD
    @TechVHD 3 года назад

    Before picking colleges what was your second and third school you almost went to? Which was your dream?

  • @qwertz9501
    @qwertz9501 3 года назад +1

    thanks more then a lot (= keep up the grind: its unique

  • @yugandharardekar1112
    @yugandharardekar1112 3 года назад +1

    Great video! Would really appreciate if you could also make some videos on LBO analysis and other valuation methods.

    • @rareliquid
      @rareliquid  3 года назад +1

      i did post about comparable comps already but probably won’t do one on lbo or precedent transactions because they’re not really relevant for most retail investors

  • @barryaherne215
    @barryaherne215 3 года назад +1

    I made it nearly all the way to the end until you put it all together - fractions, formulae and accounts gave me PTSD from doing algebra, maths and accounting in school, and my brain went into lockdown and noped right outta there; I think I'm doomed to fail!
    I went and re-watched the suggested video about valuing a company, and if I took everything in, I think I have a noob question: in every example (around the 7:00 min mark here/the whole other video in its entirety), the companies used are solid, for lack of a better word. Can you use any of these methods to value high-growth stocks where they're not making money, taking out loans, etc to get a good idea of how to value them? It doesn't seem like it's appropriate with DCF, but I'm still a little unsure about the other scenario. Or is this an entirely different video altogether? I hope my question makes sense....

    • @rareliquid
      @rareliquid  3 года назад +1

      yes as i mentioned really high growth companies or cash flow negative companies can be analyzed with a DCF as long as there is confidence that those companies will eventually generate positive cash flow. back at jpm i did 20-30 year DCFs for biotech companies that didn't even have any products on the market and in those scenarios you use a probability weighted valuation to value the company (which is another topic)

    • @barryaherne215
      @barryaherne215 3 года назад +1

      @@rareliquid - Awesome, thanks for the clarification! If it's worth your time, I wouldn't mind seeing you do a sample like you did at JPM (or just put it on the list!).
      Cool video overall. I'm an absolute idiot when it comes to numbers, formulae, etc, so it's gonna take a whole load more time with me to come to grips with DCFs, but I want to learn 😅

  • @qwertz9501
    @qwertz9501 2 года назад

    i am missing an explanation of the following term: cost of debt
    would highly appreciate it.

  • @KateTLe
    @KateTLe 2 года назад

    Thank you

  • @fredericostuckenbruck2458
    @fredericostuckenbruck2458 Год назад

    Excelent viseo. a pity it was so fast. please elaborate more in other videos and please speak slower so that foreigners can understand you better. Thank you for this video

  • @am-197
    @am-197 2 года назад

    Bro please make a video on the topic of investment bank analyst interview questions and his clearrful answers humble request you to
    and i am from india

  • @byronli9655
    @byronli9655 2 года назад

    Mans taught a whole unit in my finance major in under 20mins 🫡🫡

  • @sarasa4302
    @sarasa4302 3 года назад +1

    Very helpful! Thank you!

  • @dannykataw7684
    @dannykataw7684 3 года назад

    Great content and love the animations in your presentation. "Off-White vibes"

  • @olzhasabdramanov1698
    @olzhasabdramanov1698 3 года назад +2

    Good Job!

  • @isaacgoldin4998
    @isaacgoldin4998 Год назад

    Hey Ben, quick question. Where do assumptions come from? You said that almost all assumptions will be wrong but I doubt that IB analysts input random numbers there. Are the assumptions derived from various findings in the 10-Ks?

  • @PELBTOR
    @PELBTOR 3 года назад

    Thanks, your video help me a lot thanks

  • @user-bx2kd7jt8t
    @user-bx2kd7jt8t 3 года назад

    Damn bro wanna be my tutor 😂🤣 studying this in uni rn 👏😎

  • @yeeen123
    @yeeen123 3 года назад

    Can u also show us how u get the figures to calculate? Like which page which line of Yahoo Finance for eg... Sorry need some hand holding, if not i can't link theory to practical.. Towards the end... what is cash, why not same as free cash flow? Debt is Total Debt?

  • @stockmarkettipsbykarankapa5172
    @stockmarkettipsbykarankapa5172 Месяц назад

    Amazing😍

  • @renrustandi
    @renrustandi 3 года назад

    Waiting for the advanced DCF Model :)) Thanks a lot

  • @rodelparate169
    @rodelparate169 2 года назад

    Please do the three financial statements from scratch, Ben.

  • @alwynjohn-thesimpleinvesto4730
    @alwynjohn-thesimpleinvesto4730 3 года назад +1

    Great video, keep it up!!

  • @justinroadhouse952
    @justinroadhouse952 2 года назад +1

    How did you calculate the change in revenue % under change in NWC?

  • @Youzarzif
    @Youzarzif 3 года назад

    Can you do more examples and analysis of companies? Like a top down analysis of Ali Baba stock and then a DCF on it. Thanks!

  • @abhyudayarajpurohit3484
    @abhyudayarajpurohit3484 Год назад

    nice content !