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!
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.
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: hamish@hamishhodder.com
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 Can you send me the spreadsheet to my email @ t.hai46@yahoo.com? 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.
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.
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?
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.
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 ?
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 ;)
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?
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
Hi Hamish, trying to access your analysis spreadsheet to go over the example you presented in this video however i can't enter anything as it is only view status. Can you please grant access.
Hello there. I have dowloaded the "Spreadsheet 2.0" and added all the data on the "Data Input" tab, but on the "9 year" column of the "GROWTH" tab there is no value. Instead it says #NUM! I checked the formula and it seems correct and consistent with the previous columns... you know how to correct this glitch? Thanks!
Was this work for indian stocks also, Because they all are in Rs instead of dollars and if, was the whole historical data be put into the sheet or just the data you have entered; because when I put stock price it automatically convert in dollars and got no results
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
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?
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?
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!
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.
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: hamish@hamishhodder.com
This video is simplification Phil Town Rule #1 Investing and The intelligent Investor. Thank you so much.
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!
Hamish, I have no idea how I stumbled on your video but it brilliant. You explain things really well. Thank you.
Thanks for watching James!
the spreadsheet dowload keeps saying unable to download file. Need help thanks
Hi, the detailed explanation of calculating the buy price of a stock is very useful for the people who are investing in stock market.
I've been looking for videos like this for so long. Thank you so so much
Thanks for your video Hamish
Which calculation for the value of intrinsic value is most accurate: 1) DCF(earnings based), 2) DCF (FCF based), 3) projected FCF. Thank you.
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!
Absolutely! Thanks for watching.
Quality video Hamish!
Thanks Tristan!
Hi, i couldnt go in the bi zone calculator, is it removed or what happend to that section
You need to download the old version which is version 2.2.
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.
this video deserves infinite likes. thank you.
you are a legend ✌🏻 thanks for watching
@@HamishHodder Can you send me the spreadsheet to my email @ t.hai46@yahoo.com? 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.
The 2021 10 year spreadsheet doesnt have the Buy Zone Calc section along with other sections
i wanted to ask about the same thing
Hi Hamish, enjoy your videos immensely….. very informative!!! Just a question, what is the best free stock screener ???
I appreciate this. I've been investing for about 3 years, and this is really good and informative video.
I'm been investing for an year now and learn most of the days how is that I missed your videos
I don't see the calculation tabs from the file in the description link?
Can u use this method with a growth company ?
I don't see the spreadsheet could you kindly share?
Great video, but unable to enter figures, they’re locked in the spreadsheet
Hi Hamish..not able to see the formula due to subtitles..pls can u share the same for future price..thank you.
Hi all,
Is there a difference between the return on investment capital and the rate of return?
the buys zone calc is no longer on the spreadsheets of yours
Your spreadsheet link shows the old spreadsheet, not the one you use in the video!
how do you estimate the different growth rate? how do you choose which buy price to use considering they correspond to different growth rates?
hi cannot see the buy calculate tab ?? only 4 tabs open in spreadsheet
What if EPS for the current year is negative, but good company? Thanks for the video mate cheers
Hamish, im still confusing where i can get the number to determine growth rate?
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.
@@mattzuydam No one can 100% accurately calculate growth, that's an art.
@@mattzuydam This video is so wrong, Buffett,Munger,Clarman,Pabrai use DCF not this terrible advice!
@@satisfyinglook8291 Yeah obviously but gives the bloke a rough idea and where to start looking at least. :)
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?
Are you using revenue growth rate or equity growth rate?
the link to your spreadsheet is not working. please be so kind and send another link that work.
Can you please resend the link to the spreadsheet
www.hamishhodder.com/spreadsheet
@@HamishHodder thank you!!
@@denni-swan no problem!
is this the DCF valuation?
Great video Hamish
This was much more easy to understand then your pal Brandon
Also we can read Ben Graham's 'Intelligent Investor' book from the 1940's which covers all of these points in more detail.
How to get the excel sheet calculator
hey! the video and investing strategy is awesome but I cant download that spreadsheet
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.
I can't find the sheet you used on the video, it's not on the description links.
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.
Does the spreadsheet works if the EPS is negative?
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 ?
where did you get all of the equity data from
I just downloaded the beta spreadsheet for 2020 but there is no tab called buy zone calc....
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!
How does this formula take into account how much cash or debt a company has?
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 ;)
Excellent content! I will be watching your future videos!
the spreadsheet you're using in the video can't be found via the link you shared. so the video is hard to follow
Do you sell that Excel program? Where can I buy it?
Where are the links in the description?
Thanks for the video. I downloaded the spreadsheet, but it's not the same spreadsheet that you're using in your video.
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?
Hello Hamish. Where do I get the 15-20 year financial data you use in your spreadsheet?
I had to update the formula in Cell H8 under the BUY ZONE CALC to =IF(B6H7,"SELL",IF(B6
Can you please resend the link to the Stock Analysis Spreadsheet thanks
I just downloaded the spreadsheet but it does not allow me to add the numbers on it, is on the VIEW only mode. ANy way I can change it?
You make everything sound so simple and understandable man! Thank you! Keep up the good work!
I clicked the link. Then opened most of all the Spreadsheets, But None of them had Buy Zone section.
Please HELP
Same. Couldn’t find the doc either
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
The spreadsheet sheet didn't work. Any advise? I downloaded the 2019 10 year spreadsheet.
the link to the spreadsheet is not working? Great simple video
Inside of using EPS, why don't you use FCF (free cash flow) per share?
how do you find the PE ratio for the past when yahoo finances pe ratio is for the last 12 months only
hey Hamish, this video is gold. Thanks for sharing.
This is absolutely fantastic! You're bang on with this Hamish!! Great work!
Hi Hamish, trying to access your analysis spreadsheet to go over the example you presented in this video however i can't enter anything as it is only view status. Can you please grant access.
You have a such a beautiful flow of words.. keep at it ma man.. & thank you
I cannot get the spreadsheet it does not show where I can get it.
Hamish values are not showing in second table of buy zone...it shows NUM!....can you clarify or is it to be edited...
Where can I see / access the spreadsheets?
Excellent talk
Just curious, why wasn’t cash flow used? Normally you discount future cash flows instead of using this.
Hello there. I have dowloaded the "Spreadsheet 2.0" and added all the data on the "Data Input" tab, but on the "9 year" column of the "GROWTH" tab there is no value. Instead it says #NUM! I checked the formula and it seems correct and consistent with the previous columns... you know how to correct this glitch? Thanks!
i could not download the spreadsheet. could you please resend it???
the spreadsheet won't let me input any figures :( it says view only
Was this work for indian stocks also, Because they all are in Rs instead of dollars and if, was the whole historical data be put into the sheet or just the data you have entered; because when I put stock price it automatically convert in dollars and got no results
Your video is much more valuable than all investing videos i previously watched
Thank you!
How does this compare to dcf/intrinsic value equation? More notably the ben Graham update equation.
Hey guys where can you find the historical data for the PE ratio?
The growth rate we are using, is that the 5 year of will it be a 10yr growth rate as well?
Can i use cash and cash equivalents for FCF?
Thank you so much Hamish...
hello, i downloaded the spreadsheet but i cannot edit on it. I also do not see some of the tabs. Do you have it in excel spreadsheet?
THE BUY ZONE CALCULATOR TAB / WORKSHEET IS MISSING.
I have about 20 businesses on my watchlist and none of them are at my margin of safety. Being patient is difficult.
Holy shit this spreadsheet is insane.
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
What did you mean by equity growth? Gareth I’m retained earnings or the growth in stock price
Hamish great video. Where can I download the spreadsheet?
you are the GOAT good sir
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?
How would you suggest we find Sales, EPS, equity and FCF without using quickfs? specifically for nzx and asx? thanks for great video
what type data we shoud get? company only or group?
Hamish, no such a link below to get the spreadsheet. Where is it?
www.hamishhodder.com/spreadsheet
Thanks, well today the stock is acctualy around 45$, what can you say about it, how should someone act today?
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?