How to Value a Stock! (Stock Valuation Spreadsheet Tutorial)
Access Tickerdata and my Spreadsheets: tickerdata.com/
Get a Huge discount to Seeking Alpha: seekingalpha.me/Dividendology
Join my free newsletter! dividendology.substack.com/
In this video, I take you step by step on 4 different ways to value a stock, and give you step by step tutorial on how to use my stock valuation spreadsheet. Let me know your thoughts in the comments below!
Social Media (and other fun stuff):
linktr.ee/dividendology
I am not a Financial advisor or licensed professional. Nothing I say or produce on KZread, 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.
Пікірлер: 54
Perfect! I love your way of explaining complex things simply with down-to-earth spreadsheets.
Hi. Love this, really useful. At 9:30 mins, surely cells K5 and B13 should be different years?
Thank you so much for this video. Incredibly helpful and its also super clear and concise!
@Dividendology
2 ай бұрын
Glad it was helpful!
Great video! Can you explain why you chose a different Discount Rate (9%) for DDM vs 8% for DCF calculations?
Hello mate. Congrats on your work. Love your spreadsheets! Quick question:does it work with other markets? Let’s say Brazil stock market for example. Or only US stocks? Cheers.
@5_aturn
5 ай бұрын
Won't always find the stocks automatically but I found out that if you add the market in front of the stock name it usually does end up working. (So for me, with Dutch stocks I would add AMS: and then the stock name right after)
@jakeruth5781
5 ай бұрын
I recommend using Stock Unlock it handles everything
Yo bro, I love your video's and I am learning alot. My only question is, where do you invest on, wich platform?
Greetings. Really enjoy your videos, so much excellent content. Question.. SCHD is your biggest core position, and pays very well. Why wouldn't someone just invest in SCHD instead of all those individual positions you have. SCHD diversifies in most of the same companies you have in your portfolio plus more...as well as sector diversity. Have you compared your return vs SCHD? since you started your div portfolio.. Just wondering why I would go through your process instead of letting SCHD do it for me.. Thanks so much.. WiL
We can see the limits of DDM: based on data you should pick a reasonable 10% growth rate, but in that case r-g = -1…. Also in this model you select Wacc=9% but it was 8.5% for DCF I think sticking with DCF BUT with different scenarios is the best guesstimate we can get
Hi ! Would anybody know how to add canadian stock tickers in the Spreadheet ? An example would be when I want Telus with ticker T (TSE), I get AT&T (NYSE) instead. Thank you !
@Dividendology
2 ай бұрын
This page will explain how!: tickerdata.com/exchanges
Definitely appreciate the videos I have understood the value of dividends since a teenager biggest mistake has been not spending my money on stocks instead of the of a young person
@mwill4786
5 ай бұрын
I’m only 25 by the way
You sir are a legend!
isnt 8% discount rate you apply in DCF already account to margin of safety? I apply 12-15% for any company i invested in, if I added 10-20% on every stock I analyze, I will be lucky to find one in a year.
I love your videos, informative, easy to follow! Learned more in a couple days than over the last 6 or 7 years haha
@Dividendology
5 ай бұрын
Great to hear!
love your videos, can you do one for banks?
@Dividendology
2 ай бұрын
Yes! I have one for banks!
Hey, love your content and best wishes for your goals. There's something I'm having a hard time understanding. The projected growth rate is applied annually on each FFCF, however 2023 is a year that has already undergone growth. Why do we still account the projected growth on it in the FFCF row ?
@Dividendology
5 ай бұрын
meant to update that to be 2024! I'll correct that.
@antoineazar7546
5 ай бұрын
@@Dividendology Thank you for the quick reply !
Hi, great videos. Can you please also make videos for web scrapping of Yahoo Finance and Finviz cause your previous video formulas are not working now, cause lots of things have changed? keep uploading Videos!!
@Dividendology
19 күн бұрын
I use the tickerdata add on in google sheets to auto import the data now! Tickerdata.com
@murtazahassan3601
19 күн бұрын
@@Dividendology I like that as well, but If you help with any of the free platforms it would be much of a relief. Thank You!
Where can we get the spreadsheet from??
@jakeruth5781
5 ай бұрын
Stock Unlock is going to provide all of this without the hassle it's worth checking out
where do I find the growth rate projection on yahoo finance?
Is the Cash and Cash Equivalents a truncated field? You only put 111,262. I am doing a DCF of JnJ and they have 25.51 Billion. So in this field I would put 25,510,000?
Awesone video! Could you please explain why you use 111,262 instead of 111,262,000? I saw in your other answer that if you apply the same metrics it will be fine, but I dont see where or if you use this factor 1000 on sum of FCF? Keep up the good work!
@brandontomczak2953
2 ай бұрын
Did you get an answer for this?
@piet123ajax
2 ай бұрын
@@brandontomczak2953 no but I found out that yahoo finance draws FCFs in thousands (so that should just be divided by 1000 again)
Great video
@Dividendology
5 ай бұрын
Thanks!
Im realy missing the ROIC metric on the first sheet so i added that one myself. :)
@Dividendology
5 ай бұрын
Good call!
do one on aap
I downloaded this from you patreon page just now 23rd jan 2024, my spreadsheet is missing 2023 tab for the discounted cash flow model. Is there an updated version i can download ?
@Dividendology
5 ай бұрын
Yes there is! DM on patreon and I'll help you out! :)
@derekdunn8678
5 ай бұрын
i sent a message through Pateon, not sure if you got it. :) @@Dividendology
Just subscribed!
@Dividendology
5 ай бұрын
Thanks!!
the only updated stock valuation worksheet is dated feb 23, 2023. Please provide an updated worksheet which includes 2023
@Dividendology
4 ай бұрын
just posted
Unfortunately, hype matters more than fundamentals. Prices go way up first long before the companies make any money on what is being hyped.
@Dividendology
5 ай бұрын
Hype moves prices short term. Fundamentals move prices long term.
@OldLion64
5 ай бұрын
@@Dividendology Agree. Still cant tell when to get in based on valuations and fundamentals though. Skyrockets on hype then flattens out. Costs dividend investors twice as much capital to invest
MSFT P/E is 35.63 and annual EPS of 9.81 it is extremely overvalued at the moment like most big teck. Look at MSFT Net Debt forecast for the coming years, it paints a very scary picture.
@Dividendology
5 ай бұрын
This is not an analysis of MSFT. As I stated many times, This is an example. I didn’t use the numbers I would’ve actually used to analyze MSFT.
@luckybaba1026
5 ай бұрын
I understand it's a video about how to value a stock and I appreciate your spreadsheet and you make great videos but using an example with wrong numbers gives a false image of the stock you picked for the video. Thank you for all the great videos you make, it helps a lot of people.