Well, I said it once and I'll say it again, you are really good at explaining these formulas using real examples. Funny how you are the only guy on youtube that goes straight to the point in a simple and understandable way.
@Dividendology Жыл бұрын
Thank you!! I always try and provide value!
@piyushi8310 Жыл бұрын
What does it mean when the result of difference is negative nmbr ?
@TheAnthonyWagner4 ай бұрын
What you did was so valuable.. Thanks Bro. I am subscribing
@jesterianestrada8008 Жыл бұрын
Man, sharing your knowledge feels like receiving dividends to my financial brain investment! hahaha. You make seemingly complicated stuffs so simple. You're an awesome teacher☺. I wish you can add some takeaways every end of your videos for scenarios where the method might not apply (such as if a negative output for this one). Also, if you can make for ETF valuation, but i think its always close to NAV? sorry, dummy brain here😅 Nevertheless, your tutorials are so helpful. Thank you so much. Keep making more (sounds demanding)hehehe.
@Dividendology Жыл бұрын
Thank you!! I’ll try and continue to provide insight!
@farahz9552 Жыл бұрын
I have the same question regarding the negative output for this one!
@thearayshow57372 жыл бұрын
I watched this during my work break! This was amazing! Definitely hitting the sub button! Thanks for break in down the dividend discount model 💯
@Dividendology2 жыл бұрын
Glad you enjoyed!
@hp4908 Жыл бұрын
What if WACC minus Average dividend growth is negative? Will the formula still work or does it need an adjustment?
@colinferreira4503 Жыл бұрын
Have you found a solution to this yet? tried it with TGT and it didn't work
@altmile23462 жыл бұрын
Hi, for the dividend discount model, aren't we supposed to use the cost of equity insted of the WACC to find the intrinsic value?
@AA-fb6ni Жыл бұрын
How do you work out the cost of equity?
@TheTitusification Жыл бұрын
@@AA-fb6ni CAPM
@user-ys8dc2ni8z Жыл бұрын
Of course you need cost of equity to value equity xd
@richullingfivefivefive1745 Жыл бұрын
Great video, but I agree, you should use CAPM to asses an adequate discount rate for equity only.
@joaovitorsantiago4286 Жыл бұрын
What formula should I use when the average Growth Rate is higher than WACC? idk what to do
@zacharykeller9725 Жыл бұрын
I wish I knew how to help you, but what stock are you looking at that their growth rate is higher than their WACC
@joshhays9148 Жыл бұрын
I think a dividend discount model will be inappropriate for whatever you’re doing. I would recommend a DCF especially for tech stocks with high evaluations. Companies like Coke are far more mature (cough cough dividends) and investors attracted to the stock due to its steady growth rate and low volatility.
@laubena14545 ай бұрын
You should not use the WACC to discount the dividends of a company, you should use the Cost of Equity! Great video btw :)
@LucyyyQ Жыл бұрын
Thank you so much! you solved the problem I have been stucked for a long time
@anthonykaroussos89152 жыл бұрын
Can you possibly do a video covering how to calculate WACC? Using both the market value of equity and market value of debt?
@Dividendology2 жыл бұрын
That’s a great idea! I’ll add that to my list of videos to make.
@ArturoGarzaID Жыл бұрын
I'm getting an intrinsic value that's like a giant negative number. I'm working on AVGO.
@Dividendology Жыл бұрын
if Dividend growth rate is higher than WACC/discount rate, that happens. There are other forms of the dividend discount model to account for this.
@poojakumari-tk5cp2 жыл бұрын
Thank to explain in easy way
@Dividendology2 жыл бұрын
You are welcome!
@robertmanuelherrero2 ай бұрын
And what happens if the wacc is lower that the Average Growth rate?
@samsonbouillon5107 Жыл бұрын
Hi, can't we just use the CAPM instead of the WACC to calculate the yield expected by the market ?
@michaelabghari23922 жыл бұрын
What do you do If the Average Growth Rate is bigger than WACC?
@Dividendology2 жыл бұрын
This form of the model does not work prosperity if that is the case. There are other forms of the DDM that account for this, I’ll likely make a video on this in the future.
@renojames83 жыл бұрын
Good video dude important stuff!
@sanjivsharma366 Жыл бұрын
Simply the Best!!
@Dividendology Жыл бұрын
thanks!
@jmatuuraj Жыл бұрын
What should I do if the average growth rate is higher than the WACC?
@jmatuuraj Жыл бұрын
like for MSFT - WACC = 8.19% and avg growth rate = 10% giving a negative value for the stock price
@Dividendology Жыл бұрын
there are other forms of the DDM thta can account for this. I'll make a video on this soon.
@user-tu4zb1fg9d Жыл бұрын
If the Dividend Growth is higher than the WACC i get a negative figure
@user-ep8qe2hf7v8 ай бұрын
Hi, I want to know why use WACC but not cost of equity in this video?
@xmarkfilms3 жыл бұрын
Great tutorial, thank you sir
@andyberger33109 ай бұрын
its only working if average growth rate =< WACC, otherwise you get a negative value...
@skylerjohnson14552 жыл бұрын
Thanks!
@poojakumari-tk5cp2 жыл бұрын
Hey
@ivanbosnjak9240 Жыл бұрын
Why would you use WACC in dividend discount model, why not cost of equity?
@afbarnes8 ай бұрын
Is it valid to use WACC as WACC used both cost of equity and debt?
@deeterfly Жыл бұрын
Im confused by the formula to get intrinsic value. The calculation you are using with those exact number is not coming out for me to what you are getting.
@relax238 Жыл бұрын
Can you explain how can the Div. discount model reliably tell us the intrinsic value of a stock? If a company doesn't pay dividends, than according to this formula the stock will have no value???? we are not counting in anything else of the company's earnings.
@robertlaw8510 Жыл бұрын
It didn't work for me. I did it for SCHD and came up with a 2022 dividend total of 2.56 with an average growth rate of 15.53 and 6 for the WACC/Discount Rate gives me a negative intrinsic rate of -31.07. I'm sure that is happening because the average growth rate is less than greater than the discount rate. Does this not work on ETF"s?
@dunalar9454 Жыл бұрын
I really like your channel and cannot wait seeing new guides, but Is there a way automate it when changing the ticker?
@Dividendology Жыл бұрын
I'm looking into this!
@herr797910 ай бұрын
Is it possible a negative number?
@financewithjohnstanton28663 жыл бұрын
Love it!
@user-xt8xg9ko4y Жыл бұрын
What do you do if the dividend payout is different at different points in the year
@Dividendology Жыл бұрын
Just plug in the yearly totoals
@frederickportillo1394 Жыл бұрын
Where do I find WACC with out having to do the math?
@ciph3rwolf3452 жыл бұрын
Cool stuff man. Do you recommend any books to dive deeper into this topic?
@Dividendology2 жыл бұрын
Maybe not specifically on the topic of valuing dividend stocks, but I would recommend “The Intelligent Investor” by Benjamin Graham for any investor.
@Tay234. Жыл бұрын
“For beginners: If the ticker symbol isn’t “O” don’t invest” -Some other guy
@priyakhurana8144 Жыл бұрын
The working is not complete , where is the forecasting of the dividends and then discounting them to find the PV
@bboynava1812 Жыл бұрын
The equation used is an abreviation of an infinite series if dividends that grow at a constant rate and are discounted at a constant rate.
@disloyalmari9163 Жыл бұрын
¿what happend if in 2020 and 2021 the company didnt pay dividends because the had loses?
@Dividendology Жыл бұрын
Definitely take that into consideration. I would probably lower my growth rate projections because of this.
@michellegeronimo75912 жыл бұрын
Hi! can i still use DDM even if the growth rate is sometimes negative?
@Dividendology2 жыл бұрын
When companies have a negative growth rate the DDM will not be a good valuation model. You will have skewed results.
@xmarkfilms3 жыл бұрын
what does it mean when the result of intrinsic value is negative number?
@Dividendology3 жыл бұрын
That can happen when the average growth rate is higher than the weighted average cost of capital, which is one of the fallbacks of the dividend discount model. That is why the dividend discount model is typically used for blue chip dividend stocks.
@xmarkfilms3 жыл бұрын
@@Dividendology noted on this, thank you
@nathanturner6021 Жыл бұрын
Do you need a safety margin for this model? I noticed that you did not use one.
@Dividendology Жыл бұрын
I would suggest using a margin of safety with any valuation model.
@DavidWilliams-cb9ez2 жыл бұрын
Love your videos BTW! A comment/request and a question. When using DD Model do you or should you include a safety margin (say a 15 to 30%) reduction of calculated intrinsic value price? Most models include this but I've never seen this valuation model before so not sure what the norm is here. Next, I've seen your work and you are so capable of building a dynamic model that imports all the data via web scraping. To have a feature like this incorporated into a watch list where we see updated 'fair value" compared to current market price would be HUGE. That is a model I would pay for verses plugging away at Google Sheets and cussing like a sailor when I screw up the formula data. Great job. Subscribed and Liked!
@Dividendology2 жыл бұрын
Hi David! I'm glad you like the videos! Applying a margin of safety to any valuation model is always a wise decision in my opinion regardless of which valuation model is used, although not all investors use a margin of safety. And that is a phenomenal idea for a spreadsheet. I really like this idea. I'm likely going to start looking into ways to make this possible. Give me some time and I'll see what I can do!
@Tra2012 Жыл бұрын
Too good.
@Dividendology Жыл бұрын
Thank you!
@ignacioortega31022 жыл бұрын
what does it mean the 10% difference? How can you know if a stock is over or undervalued, once you know the % difference. is 10% allot or is it little, thus this stock is not overvalued?
@Dividendology2 жыл бұрын
It can really depend on the industry, and it also depends on your level of risk aversion as an investor. Many investors feel comfortable investing in a company if it’s undervalued by 10%, but some investors may only want to invest in companies that are undervalued by about 30 or even 40 percent. If the intrinsic value is greater than the stock price, then the stock is considered undervalued.
@ignacioortega31022 жыл бұрын
@@Dividendology then for a company overvalued, the intrinsic value has to be lower than the stock price I imagine. Thank you for the help!
@dinozhang63682 жыл бұрын
Thanks bud! Would it be possible if the average growth rate is actually higher than WACC? If that's the case what do we have to do?
@Dividendology2 жыл бұрын
It doesn’t happen often, but that is possible. There are other versions of the DDM that can be used in that scenario. I’ll likely make a video on that in the future!
@dinozhang63682 жыл бұрын
@Dividendology I did one on Apple and found that out
@AA-fb6ni Жыл бұрын
@@dinozhang6368 Did you ever manage to find a solution to this? Thanks.
@AA-fb6ni Жыл бұрын
@@Dividendology Could you direct me to this video please? Thanks
@fwayne1947 Жыл бұрын
I just tried to use this model on McDonalds, and the dividend growth rate is higher than the WACC. How do we fix this problem?
@binibibiii2 жыл бұрын
Hi! May I know if this is a zero growth DDM?
@Dividendology2 жыл бұрын
It assumes a constant growth rate!
@binibibiii2 жыл бұрын
@@Dividendology thank you so much ❤️❤️❤️
@chrisc5991 Жыл бұрын
can i do 10 years worth of dividend data?
@Dividendology Жыл бұрын
Use whatever helps you decide on a growth rate!
@purudate404910 ай бұрын
Stop tutoring excel functionality in the midst of an all important topic on Dividend Discunt Model
@davidp252 Жыл бұрын
I couldn't believe how you just glossed over the WACC and how to obtain those numbers. Makes the rest of the content unusable.
@Dividendology Жыл бұрын
I have a video on how to calculate it.
@sdflksdfngbf9793 Жыл бұрын
What if Average Growth Rate is higher than WACC?? Other people are also asking this question, but there hasn't been no answer