How to Value a Dividend Stock! (Dividend Discount Model for Intrinsic Value Tutorial)

Access Tickerdata and my Spreadsheets: tickerdata.com/
Get a $50 coupon + 7 day free trial to Seeking Alpha: seekingalpha.me/Dividendology
Join my free newsletter! dividendology.substack.com/
In this video, I take you step by step on how to value a dividend stock and how to perform 2 variations of the dividend discount model. Let me know your thoughts in the comments below!
Get up to 12 free stocks now using my link for Webull!:
a.webull.com/i/Dividendology
Social Media (and other fun stuff):
linktr.ee/dividendology
I am not a Financial advisor or licensed professional. Nothing I say or produce on KZbin, or anywhere else, should be considered as advice. All content is for educational purposes only. I am not responsible for any financial losses or gains. Invest and trade at your own risk. Some of the links in the description may be affiliate links.

[@deacydooda2209]

Hey @ Dividendology, how did you calculated the stage 2 growth rate?

[@llew-AZ]

What a great video to show google sheets use in the Dividend community as information tool . I learned allot as a 59 year old man. Thanks!

[@Dividendology]

Glad it was helpful!

[@armandcharlesngabirano3795]

hey sir great tutorial right here do you have materials where we value companies based on assumptions meaning possible case of scenarios. for this case is it possible make an assumption of the growth rate using tools like montecarlo simulation

[@SnrMchS]

Am a big fan of your channel! I just want to ask.. do you use solely the DDM price per share as your guide for your buy price or do you put in a Margin of Safety to it?

[@SnrMchS]

Curious because of course we are merely projecting isnt it right to give let say 10 or 20% MOS for our projections?

[@Dividendology]

I typically use MOS

[@deacydooda2209]

Hey @Dividendology, Can you use the divdend per share growth in seeking aplha for the growth input in the first model, cell F12?

[@Dividendology]

that data should be something you consider for the projection

[@deacydooda2209]

@@Dividendology Is there any definable percentage from seeking alpha or yahoo finance to put in cell f12? Thank you.

[@lucauau]

What are the weakness / strenghts points of this valuation model (in your opinion)? 😊

[@Michele-uv6re]

So for the growth rate projection 8,25% it is your opinion or there is a formula that can help you to calculate it ?

[@Dividendology]

It should be based off of research. There is no formula for it.

[@Hwilly919]

I have a couple quick questions, on the 2-stage dividend discount model, shouldn't you use the yearly dividend payout of $12 rather than $3 when creating the table with the present value? Also for some reason my excel gives me $3 for current, and then $3.08 for years 1, 2, 3, and 4... I used the exact same formula, Dividend Payout/(1+$WACC$)^Year for each column respectively. I am relatively proficient in excel as my work revolves around commercial real estate financial modeling/analysis and I have no idea why this is happening

[@IncomeEmpireYT]

When calculating yearly dividends for year 1 through 4 at the 2 step model, shouldn't you had to use the 3% growth rate? As that's the assumed growth rate looking forward, instead of the 9% being used. (@ around 17:00)

[@gotti1940]

That's what I was thinking too.

[@larry.carlson]

the average growth should be company results growth, or dividend payment growth?? i don't get this.. when checking apple for example, dividend growth is around 4% yearly... so the fair price is super low.... thanks

[@Dividendology]

Dividend growth.

[@timmadley3779]

EXCELLENT VIDEO-THANK YOU

[@Dividendology]

You are welcome!

[@saranggaikwad1559]

how do you access the DDM model on google sheets ?

[@Dividendology]

You can download this one on Tickerdata.com !

[@Hero323]

Good stock valuation tutorial, but let's see your business card.

[@aandeelaandeel4214]

Hey Dividendology, i got a issue. When i made de WACC i have 8% and my growth is 10%, now my DDM Price per share is -X. So you gonna tell me that if WACC > Growth you will have a negative price? Maybe you can help or explaine because now i'm lost. Love the video

[@Dividendology]

In this form of the DDM, it won’t work if the growth rate is higher than the discount rate.

[@lucauau]

@@Dividendologywhat if this is the real scenario? 😮

[@Madchris8828]

Have to watch this when I get the time. Good information

[@bosozoku9183]

Hey can you share the sheet bro?

[@Dividendology]

Yes! It’s on my patreon page. Link in description.

[@tomasbernal7166]

If you have $7,500 would you invest roht etf which would you buy .schd o vgt . I now in long run schd good if you need to grow, Fast .

[@Dividendology]

depends on your goals!

[@maximebolduc8139]

how do you access the DDM model on google sheets ?

[@Dividendology]

Tickerdata.com