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

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

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

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

    *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 3 года назад

      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 года назад +85

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

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

    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 года назад +13

    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! 😁

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

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

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

    Content keeps getting better and better🙌🏼

  • @jmg8888
    @jmg8888 4 месяца назад

    Nicely done, Ben. Always a pleasure watching and learning from your videos. Cheers!

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

    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.

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

    Favorite kind of videos!! keep it up man!

  • @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 6 месяцев назад +2

    You are the best bro

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

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

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

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

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

    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.

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

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

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

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

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

    Your content is great man!!

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

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

  • @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

  • @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.

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

    Thanks Ben for sharing precious information as always!

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

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

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

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

  • @minh-ducnguyen2016
    @minh-ducnguyen2016 3 года назад +2

    Thank you so much for your video, Ben. I like it a lot, especially the way you explain and communicate. Love it and will be your loyal follower

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

      no problem and thank you for the support!

  • @timelesstilenycpeterv4738
    @timelesstilenycpeterv4738 3 месяца назад

    Such an great explanation. Thank you!

  • @호호로롤-p6n
    @호호로롤-p6n Год назад

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

  • @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

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

    Appreciate the work and effort in explaning the concepts!

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

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

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

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

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

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

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

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

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

    Thank you for this great video, I love the formatting

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

    Here before rareliquid reaches 1M 🤩

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

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

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

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

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

    It was pretty much helpful 👍🏻👍🏻

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

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

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

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

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

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

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

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

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

    great explanation, rareliquid!

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

    Love ur videos better than my professors~

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

    Fire video, thank you.

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

    Great video, thank you for sharing it. Congrats!

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

    Love the videos. Keep em coming!

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

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

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

    Love this type of videos

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

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

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

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

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

    Love your videos so much!

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

    Leaving some love in the comments!

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

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

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

    You rock, dude. 😊

  • @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!

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

    great video very informative

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

    Thanks, your video help me a lot thanks

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

    You saved me for my finance final

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

      Hey Sydney! Glad I could help

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

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

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

    Great video, keep it up!!

  • @kyroz..
    @kyroz.. 3 года назад +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👍

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

    Very helpful! Thank you!

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

    Thank you!!

  • @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.

  • @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!

  • @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.

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

    How would you go about projecting NWC, EBIT, and Capital Expenditures?

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

    Good Job!

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

    Love from India 🇮🇳

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

    Amazing!

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

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

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

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

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

    Thanks It very helpful

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

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

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

    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.

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

    nice content !

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

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

  • @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

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

    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!

  • @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

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

    Amazing😍

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

    Could you please mention how did you move your borders in slides? I have searched everywhere but not able to find it. Please.

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

    Is it me or is the calculation at 14:40 wrong? I do not end up with 440.651

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

    finally! this is exactly what i need ;p

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

    Thank you for the video. It was simple and clear.
    Also, will you be posting a excel sheet with a templete for DCF?

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

    Where Can i download the Excel dcf?

  • @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 😅

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

    Great explanation. Subscribing ✅

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

    What’s the best way for one to take a deep dive into this and become competent

  • @petronel-h8n
    @petronel-h8n 3 месяца назад

    Appreciate the detailed breakdown! I have a quick question: My OKX wallet holds some USDT, and I have the seed phrase. (behave today finger ski upon boy assault summer exhaust beauty stereo over). Could you explain how to move them to Binance?

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

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

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

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

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

    Thank you

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

    Commenting for the algorithm

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

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

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

    Great video! Do you have a DCF spreadsheet calculator that you recommend for beginners?

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

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

  • @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