You keep putting stuff up like this. I’m thinking more and more of that patreon. It’s quality stuff. I’m working on my MBA and you break it down like my professor does but without the huge price tag of tuition.
@Dividendology
Жыл бұрын
Much appreciated! If you end up joining, be sure to join the discord! Would love to have you a part of the community!
@brianborkowski5977
Жыл бұрын
@@Dividendology excellent video. I have subscribed. I am having trouble finding the Growth Rate of 15% that you plugged into the DCF. When I look at the analyst growth rate for Appl via Yahoo Finance, its around 7%. Am I looking in the wrong area underneath the "Analysis" tab
@masterboxxx
6 ай бұрын
Out of 100 videos I've watched, your explanation is by far the best. Thank you for taking the time to create such a clear and concise video and thats coz u walk step by step
@Dividendology
6 ай бұрын
You're very welcome!
@alanden009
Жыл бұрын
Good information. Only thing I would include is a margin of safety. This would be applied to the DCF share price to provide some allowance for error in the equation/market.
@xristaras19971
Жыл бұрын
Can u explain this please ? i found a dcf model with margin of safety but i cant understand what this % is it for. Thanks
@alanden009
Жыл бұрын
Think of the margin of safety % as risk. So for instance a 0% margin of safety would imply that the DCF is 100% accurate and you completely agree with the numbers/outlook of the stock. You would add a "x" % of safety to allow room for error or a buffer in the event the stock/company does not perform as projected/estimated. The actual amount of "x" is really based on your research and personal preference. Generally a low margin of safety could be used for a "safe" stock opposed to a more risky stock. Good rule of thumb is 10% -20%. Essentially, it would tell you to buy the stock at a lower price opposed to the calculated price for the DCF. Buying it at a lower price gives you a higher opportunity to increase your overall gains/profits from the stock. I hope this helps.@@xristaras19971
@TheVital96
8 ай бұрын
Wouldn’t his margin of safety be implied in his anticipated growth rate of 15% instead of the 25.63%?
@Whatmyboy
5 ай бұрын
@@TheVital96that’s what I thought
@nedhenry639
10 күн бұрын
@@TheVital96 no
@SuperTWIY
3 ай бұрын
in other tutoials the year for the calculation of present value (the number behind the ^) of the terminal value is set to the last of the growth years. in this one he seems to use one year after (11)
@daredevil_491
2 ай бұрын
bekwoof hai yeh galat sikha raha
@scurekconsulting
Ай бұрын
What is the difference between Total Debt and Total Liabilities for a company? And why are we using Total Debt in the DCF? Take Monster Energy for example. Total Debt is 29M Yet Total Debt is 1.2B. Huge gap. Why is this? BTW love the videos
@ericanderson7570
Ай бұрын
1) why are there 2 cells for 2021 and why did you put 2020 numbers in 2021 and 2019 numbers in 2020 2) why are you dropping zeroes for cash and cash equivalents, Total debt, and double the number of zeros for shares outstanding?
@imcinema
Жыл бұрын
Good work! Two questions, why do you have 2021 two times on the FCF Growth numbers? And how do you get your first number on FCF growth when the formula is based on the previous year? Thanks!
@SHREYASINGH-mn7oo
12 күн бұрын
its a mistake
@thepickyinvestors
Жыл бұрын
Great video. One thing I think many people struggle with is with getting to that terminal growth value.
@Adrik808
Жыл бұрын
Just use an exit multiple instead and only forecast a 5 year period problem fixed 😂😂
@thepickyinvestors
Жыл бұрын
@@Adrik808 that's pretty much the solution I implemented :)
@utkarshgaikwad2476
8 ай бұрын
You forgot to add a Margin of safety in this calculation
@stefanandreiclim7349
Жыл бұрын
Thank you for the very well explained videos. One question, where can i find the Free Cash Flow? On macrotrends it is not available anymore and on Yahoo Finance and Seeking Alpha only for the last 5 years. Thank you again and keep up the good work :)
@nedhenry639
10 күн бұрын
Look at the 10k of the company for the operating cash flow and the capex. Then subtarct the capex from the operating cash flow and you will get the free cash flow
@AndrewMarriott-c6o
Ай бұрын
Hi. Can a DCF model be used for a company with negative Average growth Rate (e.g., due to an anomalous year in the past), since extrapolating a negative average growth rate out into the future will just ultimately generate a negative equity value (which may not make sense)?
@alexzander42
5 ай бұрын
Hi. Why did you use the 10 as the discount period for terminal value? Most things All other resources I see recommends using the last period (9)
@staceygeez
Жыл бұрын
Thank you so much. You really helped me create something that is real and I actually understand. Unfortunately, I didn't get this from my instructor.
@ARM13491
11 ай бұрын
Hi just a question, did you calculate all numbers in $ 000 ? Does it mean the final DCF price /share should also be multiplied by 1000 to reach at normal numbers ?
@SHREYASINGH-mn7oo
12 күн бұрын
look at the value on the on the financial statement and it will show you
@alistairhopkins9957
11 ай бұрын
Love the video... wonderfully clear and I've finally built a spreadsheet using your formulae, etc. One question: what is the growth rate? is it revenue, cash flow, net profit? How long should you apply it for? 10 years (if the data is available) or 5 years CAGR. As I say, it's a great spreadsheet but without this, I'm all over the place in terms of intrinsic value.
@Dividendology
11 ай бұрын
It should be a free cash flow growth rate. It should be a long term projection
@randall_c_6163
6 ай бұрын
I like to ask what was the purpose of calculate the 25% growth figure if your only going to use 15% is it just for reference that any projection below 25% is within the marginal of safety ?
@armandcharlesngabirano3795
4 ай бұрын
question sir maybe I didn't catch the details very well but I wanted to ask you what is the WACC in the value of WAAC in this example
@aryanjain5576
6 ай бұрын
Hey great video. Just wondering if the shares outstanding is 16.07 Billion, shouldn't equity value be divided by 16070000 to be consistent with the short form you choose? and so the DCF price would be a lot lower?
@mastermt5904
3 ай бұрын
Exactly, feels like he mistaken 16 billion as 16 million
@eo7462
16 күн бұрын
Now, it's 15,2B. Do I then have to divide it by 15200000? Multiply the result by 1000 at the end? If so, then I would arrive at the same result as before. So it makes no difference if I divide by 15200 or 15200000 or not?
@Raqonteur
Жыл бұрын
Excellent video. As a relatively new investor this was something I've been looking for. Simple. Well explained. One question. Using Yahoo Finance (from the Uk) I can't seem to find a figure for total debt. there is current debt and long term debt but no total. is it the total of these two figures or total liabilities or something else altogether?
@FreeAgentChill
11 ай бұрын
I have same problem.
@joseafalvel
Жыл бұрын
You are a master, no more to say, I'm so impressed !!
@Dividendology
Жыл бұрын
thank you!
@gullasjio
14 күн бұрын
My PV of value stay the same, is it this symbol u use as power of value? ^ ?
@luxlucis01
10 ай бұрын
Hi. I'd like to ask you few questions: 1. Why did you use total debt in your calculation? First of all, the company has other form of assets (like long term assets) that can be liquidated to pay off the debt. Isn't it correct to use current debt instead? 2. Why one should use 10 year projection? I have seen 5-7 as well, however the results my differ hugely. Thanks
@zacleongzehao7285
3 ай бұрын
1. Free cash flow (to firm) in the simplest form is the value attributable to debt and equity shareholders. You need to remove the present value of free cash flow attributable debt holders, then you would get the equity value. You cannot use just current debt (debt for next one year) as the free cash flow is attributable to long term debt holders as well. Also, you can’t account for liquidation under this method simply because this method assumes that the company is a going concern ie still functioning. At the simplest form, the liquidation value of the company to equity holders = market value of assets - market value of debt, ie assets net of paying off debt. 2. Typically 5 years for a stable company, but some do 10 years before reaching a constant rate of growth (terminal growth rate/terminal value) for high growth companies so the “drop off” in implied growth rates isn’t too high ie from 30% growth rate in year 5 to 2% terminal growth rate after y5. 😊
@bomar080
10 ай бұрын
I recommend you review your spreadsheet video for possible things to correct, that may be confusing
@khindani
Жыл бұрын
i did a dcf with conservative numbers on google and the lowest price is 220 i got, so it might be ridiculously undervalued
@TheCashFlowChannel
Жыл бұрын
Great video. DCF is my favorite methode. You are constantly getting a lot of views on your videos. Do you have any tips for me? :)
@Dividendology
Жыл бұрын
provide quality content and stay consistent :)
@johnkiin219
Жыл бұрын
Hey QQ, What do you put in as your shares outstanding if your revenue are in the billions but your Shares Outstanding is 400 million, what number do you put into the share outstanding part? Love your videos, keep it up!
@Dividendology
Жыл бұрын
Hey John, you can put in the full values if you want, or you can enter the data another way, for example in thousands. As long as you are consistent with how you enter it, it will work!
@RamiSobhani
27 күн бұрын
what should I do for the growth rate if the free cash flow is negative
@Dividendology
27 күн бұрын
You would likely want to manually adjust your projected future free cash flow!
@hansenz28
7 ай бұрын
Good work! I'm not exactly sure why you cut off the zeroes at the end of Cash and Cash Equivalents, Total debt, and Shares outstanding, could you please explain that?
@Dividendology
7 ай бұрын
As long as you are consistent with the format you input them in (ex: thousands or millions) then it doesn’t matter how you input the data!
@hansenz28
7 ай бұрын
@@Dividendology got it, thanks!
@theoldworldwasbetter
4 ай бұрын
At 8:34, "sum of cash flows", should this include or exclude the terminal value? (Cell K15). You include it in the sum, but in this way we sum up all future cash flows and the terminal value of all future cash flows, and this would seem a duplication of the latter?
@Dividendology
4 ай бұрын
You sum them all. Terminal value would be the sum of future free cash flows past the last year that you calculated.
@nothereyetlost
5 ай бұрын
Yes what does that number tell you when compared to current price?
@Dividendology
5 ай бұрын
If it’s overvalued or undervalued
@junkitwong5466
3 ай бұрын
Mean that the DCF price per share $243.99 is undervalue now ? The price for apple now is $ 189.
@nothereyetlost
3 ай бұрын
@@junkitwong5466 that’s a great underbake at 25%
@ejangelada282
3 ай бұрын
Is it ok to do 5 years instead of 10 year annual free cash flow?
@Vojta.520
7 ай бұрын
Hey, could you guys tell me the difference between this DCF model and a FCFE model? TYSM!!
@anthonyminniti17
Жыл бұрын
Great job, super simple and concise. Thank you very much
@Dividendology
Жыл бұрын
You're welcome!
@THE_YAD
Жыл бұрын
Thank you for the step-by-step process. do you think it can be automated, by entering only the ticker ?
@Dividendology
Жыл бұрын
That may be possible through web scraping! I personally believe that a DCF can be far more accurate with some manual input to project things like growth rates and discount rates though.
@Remon-fh3ic
7 ай бұрын
Hi. Can someone explain me what to fill in if the outstanding shares are; - 104.772B - 9.312B
@justodaverio6710
Жыл бұрын
ANd how do I calculate the perpetual growth rate? Is it the same for every company? I how do I get it? thank you very much for you brillant work
@Dividendology
Жыл бұрын
it will typically be about 2.5%
@justodaverio6710
Жыл бұрын
@@Dividendology thanks. You are brillant man
@williamhuhn7603
Жыл бұрын
how did you add the power when you was setting up the PV of FFCF
@runawaystilton3738
10 ай бұрын
Found it! Shift '6'
@kilotrades803
Ай бұрын
why does my PV of FFCF wind up being the same YoY?
@Firekid144
6 ай бұрын
Thank you!
@analyticsx3
Жыл бұрын
The only confusing part is the equity value / shares outstanding. The scaling is different in each of your cells.
@tudovan8423
2 ай бұрын
Hi, How's about if free cash flow < 0
@subratapal2335
11 ай бұрын
Can you please tell me growth rate which one can I consider like Revenue Growth Rate or Profit Growth Rate ?
@Dividendology
11 ай бұрын
Free cash flow growth.
@brando2118
3 ай бұрын
great vid
@GabrielKLKN
Жыл бұрын
How do I perform a DCF for companies with negative FCF?
@aidanwatkins6185
9 ай бұрын
You don’t, you wouldn’t buy a company that has negative FCF
@TTTT-sj3vz
3 ай бұрын
price to sales
@justinkoehn1343
Жыл бұрын
Thank you for this resource !!
@georgelokko4333
5 ай бұрын
how do you find the growth rate where yyou had 15%
@samdeboer5009
6 ай бұрын
So what about a startup having losses in free cash flow but decreasing on a fast basis. Spreadsheet is giving an error when filling a loss
@Darudo_sandstorm
6 ай бұрын
Yeah I was getting the same problem. I just decided to avoid companies with negative cash flow altogether.
@calebthottukadavil4417
Жыл бұрын
Thank you boss for the video!
@_VlCTOR_
Жыл бұрын
Great video, thank you for sharing
@Dividendology
Жыл бұрын
Thanks for watching!
@BelleDividends
Жыл бұрын
You need to learn the copy-paste function on your computer! Way easier and faster than just typing it in, and error proof.
@brandonflorida1092
25 күн бұрын
Sorry, where was the formula for intrinsic value? Why didn't you give that???
@philochristos
Жыл бұрын
I can't find the free cash flows on macro trends.
@36boys.
Жыл бұрын
how did you come up with 15% growth rate?
@venkkandadai6042
Жыл бұрын
He looked at the current FCF growth rate average of 25% and just qualitatively stated it would be less than that over next 5-10 years, so 15% was just his guess. The growth rate is the most important assumption to the DCF as you are trying to determine how FCF can grow YoY in the future. It’s not an exact number/calculation and is based on an educated guess based on how well you understand the company you are evaluating. The more accurate your future growth rate, the less Margin of Safety you need to apply at the end of your intrinsic value calculation
@justodaverio6710
Жыл бұрын
Would you be so kind as to tell me how to find the growth rate that you name at minute 4:06 in yahoo finance or seeking alpha. Could you give me an example of where I could find it? excuse the question. I mean I go to those pages, but sorry for my difficulties finding the exact place of the ratio, I found that aapl would grow 9.5 % next year, is that ok to put in growth rate?
@Dividendology
Жыл бұрын
if thats how much you think they will grow, then use it!
@justodaverio6710
Жыл бұрын
@@Dividendology ok I understand. And how I do I estimate how much It will grow? I don't know to estimate how much it will grow?
@jamesnguyen2911
9 ай бұрын
@@justodaverio6710 no one can accurately predict the company's future growth rate. You need to do your own research, read other analyses on the stock, do lots of homework to give your "best estimated prediction" of the company's growth rate. This is where things can go wrong.
@robertlaw8510
Жыл бұрын
What does it mean when a company has for free cash flow for a year: 212.08 when their annual revenue is over a billion dollars?
@silverbullitt24
7 ай бұрын
Check the definition of FCE. It is the money left over after paying for cost of operations and capital expenditures
@justodaverio6710
Жыл бұрын
I have analyzed AApl, and the DCF Price per Share: is 1616.63 I think I did it ok, (?)
@Dividendology
Жыл бұрын
sounds like your off by a bit.
@justodaverio6710
Жыл бұрын
@@Dividendology ok, for example: if it says Implied Shares Outstanding 6 2.47B. do I need to put 2470? (I mean, four digits?) or it depends on the digit of the free cash flow?
@jpg_6
Жыл бұрын
Great video! Do really mean that we shall use Cash & Cash equivalent in the calculation? Because in the video you are using Cash, Cash equivalent + short term investments.
@Dividendology
Жыл бұрын
Cash and cash equivalents work, but most short term investments are liquid enough to be included.
@decybelszortkat8204
Жыл бұрын
why 2021 stands for 2020 data (FCF), and 2020 for 2019 ????
@junk8714
Жыл бұрын
I think it represents start of the year 2021 so it has 2020 numbers
@decybelszortkat8204
Жыл бұрын
@@junk8714 thanks, that make sense ;)
@calebthottukadavil4417
Жыл бұрын
Hey boss, I have some money to invest. I don’t know if it is the river time to invest. Cause what if the market falls even more and I could have gotten stocks for an even more undervalued rate. For example meta is currently undervalued at lets say 134 what if falls 3 weeks later to 126. So if you have an idea that the stock market will still be bearish can you tell me a good time to invest ? Thank you boss I appreciate it
@Dividendology
Жыл бұрын
Its nearly impossible to predict short term market fluctuations. That is exactly why calculating intrinsic value and investing for the long term is so important.
@alanmurrell6620
Жыл бұрын
Since it is impossible to predict the market, the only thing you can do, really, if you think it is undervalued, then buy. If it goes down further, then happy days: buy more.
@mohammadhelaluddin7072
Жыл бұрын
What if the free cash flow will be negative
@splinx1819
Ай бұрын
Warren Buffett doesn't use DCF analysis
@Dividendology
Ай бұрын
He does: kzitem.info/news/bejne/qJ531pWpjqKTY4o
@splinx1819
Ай бұрын
@@Dividendology Of course he understands it but he doesn't use it, as Charlie Munger has said... kzitem.info/news/bejne/snuo1I6CbZt3naA
@spaideman7850
5 ай бұрын
16 billion = 16,070?
@leonaskindra179
4 ай бұрын
IN MILLIONS
@herr7979
Жыл бұрын
But cash and equivalent isn’t 62.639.000??same thing for debt , where are the 000 ?
@andrewhodnick6276
11 ай бұрын
What if yahoo finance says N/A for cash and cash equivalents?
Пікірлер: 121