How to Value a Stock! (Stock Valuation Spreadsheet Tutorial)

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):

I am not a Financial advisor or licensed professional. Nothing I say or produce on YouTube, 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.

[simasb]

Perfect! I love your way of explaining complex things simply with down-to-earth spreadsheets.

[GeorgeHLock]

Hi. Love this, really useful. At 9:30 mins, surely cells K5 and B13 should be different years?

[SamLunser]

Thank you so much for this video. Incredibly helpful and its also super clear and concise!

[careygower]

Great video! Can you explain why you chose a different Discount Rate (9%) for DDM vs 8% for DCF calculations?

[TracingLoL]

Yo bro, I love your video's and I am learning alot.

My only question is, where do you invest on, wich platform?

[mtrindade]

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.

[WiLNorCaL]

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

[NeuroCurieux]

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

[TheListening]

I love your videos, informative, easy to follow! Learned more in a couple days than over the last 6 or 7 years haha

[alfredolamide__]

love your videos, can you do one for banks?

[albertchifoi]

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 !

[mwill]

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

[antoineazar]

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 ?

[Aria.Sterling]

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.

[pietajax]

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!

[murtazahassan]

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

[myles]

where do I find the growth rate projection on yahoo finance?

[AA-njni]

Where can we get the spreadsheet from??

[chipymunk]

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?

[methioswar]

Im realy missing the ROIC metric on the first sheet so i added that one myself. :)