How to Find the Intrinsic Value of a Stock!

[@keyzerlingii]

Hey! Ive been reading and doing alot of research on investing in stocks the last 2 years. Your video (and I’m only half way thru) made a bigger impact on my learning than any of those books, podcasts, audio books. Your video and the way you are explaining your process made me able to connect my dots. Now that’s value ! Thank you so much! You are a true inspiration and aspiration on how to share, educate and lead.

[@HamishHodder]

Thanks so much! Glad the videos are proving helpful. If you need further help please send me an email and I will be happy to help: [e-mail]

[@cherylcuttineau7916]

A+++ from this retired educator! Easy to understand and follow, breaking down components of each subject, and plenty of examples. For those of you who are newbies and overwhelmed, REPETITION is the mother of all learning. Thank you for the freebies, Hammish--sending you massive energy for wealth and success!

[@bryanc.6532]

Got 0% knowledge on Stock market and have just started to educate myself on how it works. Great content. T'was a big help. More power Hamish!

[@vihangchaudhari]

This video is simplification Phil Town Rule #1 Investing and The intelligent Investor. Thank you so much.

[@WOLF91]

I appreciate this. I've been investing for about 3 years, and this is really good and informative video.

[@ab5526]

Which calculation for the value of intrinsic value is most accurate: 1) DCF(earnings based), 2) DCF (FCF based), 3) projected FCF. Thank you.

[@jennifergonzalez6431]

I've been looking for videos like this for so long. Thank you so so much

[@syamajsreedhar1747]

I'm been investing for an year now and learn most of the days how is that I missed your videos

[@vairammanickam2865]

Hi, the detailed explanation of calculating the buy price of a stock is very useful for the people who are investing in stock market.

[@ZipTrader]

Good Job Hamish. So many people buy into stocks on an emotional basis instead of taking the time to actually calculate and analyze a strategic entry point. Keep it up!

[@HamishHodder]

Absolutely! Thanks for watching.

[@thirdeyegambit]

the spreadsheet dowload keeps saying unable to download file. Need help thanks

[@TuanTran-sl3lv]

Thanks for your video Hamish

[@jv4nderh4m]

This is absolutely fantastic! You're bang on with this Hamish!! Great work!

[@easytorememberuser]

Also we can read Ben Graham's 'Intelligent Investor' book from the 1940's which covers all of these points in more detail.

[@giorgostsiolakis6179]

You make everything sound so simple and understandable man! Thank you! Keep up the good work!

[@KillerBIM1]

The 2021 10 year spreadsheet doesnt have the Buy Zone Calc section along with other sections

[@filipmazur4763]

i wanted to ask about the same thing

[@prabukrishnamurthy3490]

this video deserves infinite likes. thank you.

[@HamishHodder]

you are a legend ✌🏻 thanks for watching

[@HaiTran-fi1uc]

@@HamishHodder Can you send me the spreadsheet to my email @ [e-mail]? Also what do you think of sites like Simply wall st. They also have an analysis on thor industries and are also stating that it is undervalued same as yours.

[@thenewaudi]

Great video, but unable to enter figures, they’re locked in the spreadsheet

[@MapAtlass]

Great content Hamish, thanks for the free education😀

[@nabacov]

You have a such a beautiful flow of words.. keep at it ma man.. & thank you

[@ohvugt9666]

Hi, i couldnt go in the bi zone calculator, is it removed or what happend to that section

[@thebearcouncil8810]

You need to download the old version which is version 2.2.

[@DowsStockTalk]

Excellent content! I will be watching your future videos!

[@bhaveshbhavsar260]

Hi Hamish, The video was very informative. But I couldn't found Buyzone calculator sheet on File. Please advise me how can I access it.

[@charles1722]

Can you please resend the link to the spreadsheet

[@HamishHodder]

www.hamishhodder.com/spreadsheet

[@denni-swan]

@@HamishHodder thank you!!

[@HamishHodder]

@@denni-swan no problem!

[@michaelcloresandersm.d.7050]

Your spreadsheet link shows the old spreadsheet, not the one you use in the video!

[@elhusseintawfik6127]

Hi Hamish, thank you for the informative video, I have a question, should I add the dividend yield to the EPS or remove it from the rate of return as you mentioned, would they give different results?

[@jemryan2921]

how do you estimate the different growth rate? how do you choose which buy price to use considering they correspond to different growth rates?

[@paulraschella2223]

Hi Hamish, enjoy your videos immensely….. very informative!!! Just a question, what is the best free stock screener ???

[@Ritzoid]

Formula @ 5:17

[@valentinorossy7871]

Hamish, im still confusing where i can get the number to determine growth rate?

[@mattzuydam]

You can calculate growth rates of stocks on the wall St website. go to the stock your looking at in financials go to balance sheet scroll all the way down to equities and liabilities open up then scroll down to equity now you can compare the equity growth from 5 years ago. here are calculators to help calculate this. Wrote this before watching video. so it might also be described in the video.

[@satisfyinglook8291]

@@mattzuydam No one can 100% accurately calculate growth, that's an art.

[@satisfyinglook8291]

@@mattzuydam This video is so wrong, Buffett,Munger,Clarman,Pabrai use DCF not this terrible advice!

[@mattzuydam]

@@satisfyinglook8291 Yeah obviously but gives the bloke a rough idea and where to start looking at least. :)

[@csharpsf]

I think I figured out what he means. First, the author of the video has a worksheet. Download it. The worksheet has the tab to calculate the growth rate, but you need to input numbers in the "data input" tab. The row that produces the growth rate, is, not surprisingly, "equity" row on row 5 (in input tab.) If you already know that, that's great! I must say I didn't know that for myself, and it took me like 10, 15, minutes to figure out. And where would one get the "equity" figures? In Yahoo Finance, you can go to "Financials" then "Balance sheet." (Oh, and it's the "Shareholders equity." I'm a beginner here for all those shorthand, I guess. I was not sure of that myself for a while. But now I'm positive about that.) But it only gives you 4 years. WSJ gives you 5 years (just Google the stock name and balance sheet.) More than 5 years, I don't know. Hopefully someone else can post here?

[@tomnguyen6940]

Good work! I have been watching your video and series improved over time. Great to have investors like you teaching on KZbin.

[@vin19953]

I know there are no certain things with the market, but when you show an example with specific company and 1 year later the stock is down almost 30%, you're starting to doubt the method a bit. But it looks logic + there is no rule, that once you buy at this price the market would only go up. Let's see what happens in the long run, but for now, I'll pass on that ;)

[@chicoh42]

Can u use this method with a growth company ?

[@thecooperacademy]

Quality video Hamish!

[@HamishHodder]

Thanks Tristan!

[@klnbrkr]

Thank you so much Hamish...

[@Floatnride]

Hamish, I have no idea how I stumbled on your video but it brilliant. You explain things really well. Thank you.

[@HamishHodder]

Thanks for watching James!

[@holdencaulfield2538]

hey Hamish, this video is gold. Thanks for sharing.

[@felixkalle5402]

Hi all, Is there a difference between the return on investment capital and the rate of return?

[@anupriyagupta1329]

Wow loved your video I am currently studying masters of finance but want to study trading as well and your videos are just what I need. I am going to binge watch all of them.

[@alphabeta01]

Great video. Can you include the link to the spreadsheet also. Thanks.

[@E_JB-4513]

Thank you, you explained that extremely well

[@wadapak7622]

Your video is much more valuable than all investing videos i previously watched

[@HamishHodder]

Thank you!

[@basheerjan2462]

Hamish great video. Where can I download the spreadsheet?

[@catherineahonsi4989]

Excellent talk

[@Editnamehere]

Are you using revenue growth rate or equity growth rate?

[@Stain-u9t]

the link to the spreadsheet is not working? Great simple video

[@richleong9029]

Can you please resend the link to the Stock Analysis Spreadsheet thanks

[@josebarba]

Great video Hamish

[@whitedancer5866]

I don't see the calculation tabs from the file in the description link?

[@elibrighton]

I'm following the channel and using the spreadsheet. Great work Hamish. All these numbers are starting to make sense.

[@HamishHodder]

so great to hear Eli!

[@luciaguglielmino8054]

I don't see the spreadsheet could you kindly share?

[@praiserboy9170]

the buys zone calc is no longer on the spreadsheets of yours

[@mohlini1]

What if EPS for the current year is negative, but good company? Thanks for the video mate cheers

[@techmech3191]

hey! the video and investing strategy is awesome but I cant download that spreadsheet

[@petershaw9717]

Hello Hamish. Where do I get the 15-20 year financial data you use in your spreadsheet?

[@corneliussolomon639]

the link to your spreadsheet is not working. please be so kind and send another link that work.

[@brendancrog3398]

is this the DCF valuation?

[@sagarkathaley5371]

Thanks for sharing awesome information. Great Explanations. Appreciations for your work.

[@saurabhshah1810]

Does the spreadsheet works if the EPS is negative?

[@vortac2k9]

FANTASTIC WORK. tHANK YOU VERY MUCH

[@diafaradrame9823]

This video is awesome, I can’t thank you enough. God bless you Hamish.

[@Juan_Hernandez_Jr.]

Thanks for the video. I downloaded the spreadsheet, but it's not the same spreadsheet that you're using in your video.

[@jacknathapat591]

Do you sell that Excel program? Where can I buy it?

[@monjurkarim9661]

simply excellent and probably one of a kind on this type of complex topic which you made so simple. thank you. do you have any video on setting up of technical analysis / chartings etc for better entry and exit signal of stocks?

[@billm6610]

Thank you for posting this video. Deep value here that creates a good base for continued learning. I appreciate you!!

[@arundsouza1183]

Hi Hamish..not able to see the formula due to subtitles..pls can u share the same for future price..thank you.

[@Intothemarket101]

Thank you so much for sharing this useful data! Greatly appreciated!

[@hritikvasuja6250]

intrinsic value formula=div(1-1/(i+1)^n)/(i+1)^n + FV/(i+1)^n where i is rate of 10 year federal note. div=dividend for 1 year n for time period FV= future value of equity

[@chuadventura3482]

The way you describe in this vid is so clear. That has made me more confident to invest in value stock .thank you😻

[@ducrogers302]

have you been able to use the knowledge in this video successfully or unsuccessfully?

[@Sameer-tl1uq]

Fun

[@leanneli3874]

Hi Hamish, could you update the spreadsheet? The version 3 doesn't have the Buy zone calc tab. Also for MAINTENANCE CAPEX, do we use Net PPE value? Is there a single website where we could get all these data for each company?

[@ramonunicruz1629]

Looks like you are not applying Rule of 72 by Phil Town in calculating GROWTH, an author of the book that you recommended in one of your previous video. What is the difference between your formula of growth calculation to that of Phil Town's

[@naveenperera5818]

Well done mate! Youre killing it

[@bugsy007]

I had to update the formula in Cell H8 under the BUY ZONE CALC to =IF(B6H7,"SELL",IF(B6

[@mansi4564]

I can't find the sheet you used on the video, it's not on the description links.

[@kambizkhosrowshahi1763]

Hi, to calculate the future price, why not use free-cash-flow per share instead of eps; and p/fcf instead of p/e? Thanks!

[@Jing34271]

Inside of using EPS, why don't you use FCF (free cash flow) per share?

[@Giezer1984]

Hello Hamish, thanks for your very clear videos. They are very useful! I have one question with your video. In your example you use a $8 dollar EPS (ttm), but lately i has gone to $4,36 (ttm) for THOR. Was using the $8 dollar a bit optimistic? Should we better take an average over several years just like the PE ratio?

[@caseymarsh3261]

How would you suggest we find Sales, EPS, equity and FCF without using quickfs? specifically for nzx and asx? thanks for great video

[@sep69]

Thanks for a very informative video. I've been investing for a few years and wrestling with determining what a good buying price is. Your formulas will sure be a great help. Thanks again ! Subscribed and going to watch your other videos soon.

[@virajshah7656]

I clicked the link. Then opened most of all the Spreadsheets, But None of them had Buy Zone section. Please HELP

[@nishanthpuvanendran543]

Same. Couldn’t find the doc either

[@mustafanurman2250]

Hi Hamish, I still confuse what PE you were using. You didn't show it in the video. Based on the yahoo finance page in the video EPS 8.14 PE 8.21 Growth agreed ad 15% Expected Return agreed on 13.5%, and input all those figures to your formula Fair Value = (EPS * PE * (1+Growth)^10)/(1.135)^10 is not equal to $139.23. The only way to get the result to be $139.23 is by replacing PE with growth =15. CMIIW

[@lucathompson7622]

where did you get all of the equity data from

[@JosiahPilon]

Hi, thanks for your video! I'm having a little trouble using your spread sheet. I'm forwarning you that I'm a complete begininner so this might not be a difficult question. But, when I input the eps, stock price, and required rate of return, nothing happens in the manual buyzone calculator box. What do you think? I really want to be able to value a stock and make an intelligent decision if its worth buying.

[@thenoodler]

How does this formula take into account how much cash or debt a company has?

[@sv4149]

Hi Hamish, the spreadsheet doesn't seem to be up to date. for example the buy zone calc is not on there, and a couple of others as well.

[@kinderzabawki545]

Isn't just easier to estimate the intrinsic value just looking into the stock price chart? And thats it? Instead of guessing the value of factors like company growth, future PE and assuming the numbers like 50% and 15% based on what? If you assume that your company has stable growing EP ratio for last 10 years, can't you just assume the same for the stock price?

[@kllrei81]

how can i calculate the eps ttm value and growth rate when i not able find the rate from the yahoo finance. can give video example on the calculation . can find in the annual report. how to find it ?

[@Romulus2099]

The growth rate we are using, is that the 5 year of will it be a 10yr growth rate as well?

[@gaurav207778]

hi cannot see the buy calculate tab ?? only 4 tabs open in spreadsheet

[@kimberly3816]

When a company has a dividend are you subtracting the dividend yield from the 15% or just assuming a 1.5% dividend paid? Should 13.5% be used for evaluating all companies with a dividend?

[@dimarabinovich]

Well, the valuation of THO is changing. The EPS now is 2.14 dollar. If we take growth of 12%, the future EPS after 10 years will be 6.6 dollar, multiplying pe of 15 and divide by 8 it's 12dollar per share. This is the valuation of the stock for now...

[@ivohahn]

Where can I see / access the spreadsheets?

[@Tito_2202]

How does this compare to dcf/intrinsic value equation? More notably the ben Graham update equation.

[@dellman828]

Hey Hamish, great video, I have two questions, is this formula work for financial companies? Also, what would be the best intrinsic value method, DCF this method and other methods? Thanks

[@marceltawamba]

the spreadsheet you're using in the video can't be found via the link you shared. so the video is hard to follow

[@alxg34]

Just curious, why wasn’t cash flow used? Normally you discount future cash flows instead of using this.

[@138vivek]

What did you mean by equity growth? Gareth I’m retained earnings or the growth in stock price

[@stoneybaloney5514]

you are the GOAT good sir

[@example6978]

how do you find the PE ratio for the past when yahoo finances pe ratio is for the last 12 months only

[@kaustubhjoshi1872]

Where are the links in the description?