Тёмный

How To Calculate Intrinsic Value UPDATED (Stock Market Investing) 

Investing with Tom
Подписаться 46 тыс.
Просмотров 34 тыс.
50% 1

​‪@theinvestingwithtompodcast‬:
RU-vid - / @theinvestingwithtompo...
Apple, Spotify, Google Podcasts - theinvestingwi...
Follow me on Instagram:
/ investingwithtom
Follow me on Twitter:
/ tominvesting
Contact me:
investingwithtom@gmail.com
Sign up for any Sharesight subscription below and get four months free (33% discount):
www.sharesight...
Get $20NZD when you deposit $100NZD or more with Hatch:
hatch.as/Inves...
Sign up for TIKR to easily analyse and visualise 15+ years of detailed financial data:
tikr.com/tom
Access an extended 14 day free trial of Simply Wall Street:
simplywall.st/...
Download the valuation spreadsheet below:
docs.google.co...
Enjoy :)
Disclaimer:
I am not a financial adviser. This video is for education and entertainment purposes only. Seek professional help before making any investment decision.​

Опубликовано:

 

6 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 123   
@mariaryan-mr1lq
@mariaryan-mr1lq 4 месяца назад
Hit 200k today. Thank you for all the knowledge and nuggets you had thrown my way over the last months. Started with 17k in last month 2024.
@tim.morris77
@tim.morris77 4 месяца назад
Wow that's huge, how do you make that much monthly?
@khatty1989-H
@khatty1989-H 4 месяца назад
I'm 48yrs and have been looking for ways to be successful, please how?
@mariaryan-mr1lq
@mariaryan-mr1lq 4 месяца назад
Honestly speaking, I will continue to trade and stick to Juliana Heidi daily analysis and guides as long as it works well for me..
@darrenmoore-xx5rc
@darrenmoore-xx5rc 4 месяца назад
For real? I'm super excited. Juliana heidi strategy has normalized winning trades for me also. and it's a huge milestone for me looking back to how it all started😀
@toulahen-sd6zk
@toulahen-sd6zk 4 месяца назад
More awesome T.A. with mrs juliana heidi! Keep driving those Bullas! 68K BTC? Oh Yeah. Cheers, Mate🤩'
@devbhojak7273
@devbhojak7273 Год назад
Thanks bro, especially for attaching spreadsheet.
@InvestingwithTom
@InvestingwithTom Год назад
My pleasure :)
@toxichelix2340
@toxichelix2340 Год назад
high invensting with Tom. you are brilliant, for around 8 months ago i did a big valution of 100s of companies and your videos has managed to help me a lot. the company i ended up buying is been doing really well i am up 80% in it
@InvestingwithTom
@InvestingwithTom Год назад
Good exercise to do, though I'm not sure I understand 100 companies well enough to value them confidently! Thanks for the kind words, but I take no responsibility - you did the work ;)
@lunchinvesting
@lunchinvesting Год назад
"Trying to be approximately right rather than precisely wrong" Loved it!
@InvestingwithTom
@InvestingwithTom Год назад
Thanks! Not sure who I stole that from, but I like it too :)
@jeremynewell9903
@jeremynewell9903 Год назад
​@@InvestingwithTomThat's a Munger quote
@siggiAg86
@siggiAg86 Год назад
@@InvestingwithTomKeynes
@ncaastar340
@ncaastar340 Год назад
Correct, John Maynard Keynes first said it @jeremynewell9903 @@siggiAg86
@sorry4all
@sorry4all 2 месяца назад
​@@siggiAg86Shakespeare
@jatinrai659
@jatinrai659 Год назад
I did valuation of google around a month back and came up with 90-100 dollar value. Pretty much i followed the similar approach. Difference being 8% discount rate (~government bond rate here in India), more conservative forecasts and for terminal value calc i again used 8% discounting (~12x multiple) on 10th yrs FCF At last, pls keep up the good work. I enjoy watching your videos
@InvestingwithTom
@InvestingwithTom Год назад
Very cool, thanks for sharing! I appreciate the kind words :)
@danienishanov738
@danienishanov738 Год назад
this is a great starting framework, thanks a lot Tom. will appreciate if you could from time to time make videos like this with gradually more complicated sheets that will take in to consideration more parameters, like building on it, purely for learning, not for stock tips or anything like that.
@cocoarecords
@cocoarecords Год назад
Really like how you explain things instead of jumping straight into them. Subbed
@JustInvestToday
@JustInvestToday Год назад
thanks for the spreadsheet! great vid
@InvestingwithTom
@InvestingwithTom Год назад
Thanks!
@henrymichal8522
@henrymichal8522 Год назад
Very good video Tom. Something we should have in our armoury before we lay down our cash. Thanks again mate.
@InvestingwithTom
@InvestingwithTom Год назад
No problem 👍
@mikeandrews745
@mikeandrews745 Год назад
Can you do a video on the intrinsic value of dividend stocks?
@techie1818
@techie1818 4 месяца назад
Thanks for this video and the spreadsheet! One of the better ones I have watched. For FCF, how do we know what a "typical" year is? There are many line items under OCF and I can see how the company manipulates these numbers for any specific year. I could see the possibility of hefty one-time spends for CapEx as well.
@RoBearTheBrave
@RoBearTheBrave 3 месяца назад
GREAT VIDEO. Thanks for the awesome info!
@Threecommaaclub
@Threecommaaclub Год назад
What are some of the plugins you use for the excel spreadsheet
@InvestingwithTom
@InvestingwithTom Год назад
Not sure if plugin is the correct term or not, but just the 'stocks' feature built into excel
@andremooney
@andremooney Год назад
Great content lets do more of these.
@InvestingwithTom
@InvestingwithTom Год назад
Thank you :)
@BG-mw5pt
@BG-mw5pt 3 месяца назад
thank you tom for this great analysis. one thing i'd say is probably not accurate to consider the growth of stock based compensation at the same rate as FCF. usually stock based compensation is related to revenue, so if a company plans to increase revenue by 10% annually, they might pay out 5% of that in stock based compensation. what i'm saying is FCF grows at a different rate than SBC. you're not wrong in your analysis for google or apple, but for smaller companies, this model will greatly skew the numbers towards negative growth, which is not feasible. also, your discounted column F is constant from F8... something off there?
@winstonburke6187
@winstonburke6187 Год назад
Thanks! Tom your channel is very helpful.
@InvestingwithTom
@InvestingwithTom Год назад
Glad to hear. Thanks very much for the super thanks!
@joegriffiths1991
@joegriffiths1991 10 месяцев назад
Hi Tom. Should we be forecasting the stock based comp out for the 10 years as an estimate or just for year 1 as you have in your calculation. Thanks
@ameetbhat1883
@ameetbhat1883 Год назад
Tom excellent video as always...
@janoz06
@janoz06 Год назад
Excellent video Tom thanks
@InvestingwithTom
@InvestingwithTom Год назад
Thanks!
@peterrowlinson3201
@peterrowlinson3201 Год назад
Hi Tom, great video, easy to follow. Sorry I'm a bit of a novice but my question is that your spreadsheet handles billions. The scenario I'm looking involves hundreds of thousands on the cash flow and compensation, and millions for the net cash and shares outstanding. How do I adjust the table to represent these amounts accurately in a share price. Any guidance would be great. Thanks
@jonnycash6474
@jonnycash6474 Год назад
Thanks Tom really appreciated mate!
@donals38
@donals38 Год назад
Thanks Tom for spreadsheet much appreciated 👍
@InvestingwithTom
@InvestingwithTom Год назад
My pleasure!
@katiatzo
@katiatzo Год назад
Excellent ! Thank you!
@biggles5633
@biggles5633 8 месяцев назад
A great video, thank you.
@lincolnallen9355
@lincolnallen9355 Год назад
Thank you Tom for the descriptive video on stock valuation using the DCF model. Great idea to include the margins of safety ranges at the bottom of the calculation.
@vidya014
@vidya014 11 месяцев назад
The best margin of safety is the Growth itself.
@vidya014
@vidya014 11 месяцев назад
Randomly assigning any %, let's say 50%, as MOS is not rational and kind of brainless idea. MOS shall be derived from the inferiority of the high debts or inferiority of the low economic ratio.
@vidya014
@vidya014 11 месяцев назад
MOS, Margin of Safety, made simple: Entry Price = Intrinsic Value * (100% - MOS) Approach 1: MOS = D/E * 100% If: D/E = 1.00 MOS = 100% (equivalent to don't buy) D/E = 0.50 MOS = 50% D/E = 0.25 MOS = 25% D/E = 0.00 MOS = 0% or Approach 2: MOS = [1 - 1÷(1+D/E)] * 100% If: D/E = 1.00 MOS = (1-1÷(1+1.00))×100 = 50% D/E = 0.50 MOS = (1-1÷(1+0.50))×100 = 33.33% D/E = 0.25 MOS = (1-1÷(1+0.25))×100 = 20% D/E = 0 MOS = (1-1÷(1+0.00))×100 = 0% But Intrinsic Value = ?
@vidya014
@vidya014 11 месяцев назад
Approach 3: MOS = ( 2÷ROIC/WACC - 1 ) * 100% If: ROIC/WACC = 1 (no economy spread) MOS = 100% (=don't buy) ROIC/WACC = 1.25 MOS = 60% ROIC/WACC = 1.50 MOS = 0.3333% ROIC/WACC = 2 MOS = 0% But Intrinsic Value = ?
@vidya014
@vidya014 11 месяцев назад
Approach 3 is highly recommended. Approach 3 can still be refined I believe, but currently my brain is jammed.
@Sss-o6u
@Sss-o6u 8 месяцев назад
hey bro thank you for the content but for finding the inartistic value u had multiple videos with different approach or one that doesn't use free cash flow and each one gives different value if u where to choose one and stick to it would u choose the one mentioned in this video thank you again
@mahmutmereyem4582
@mahmutmereyem4582 Год назад
Please make a more in depth video about valuation with dcf
@KojiCT
@KojiCT 5 месяцев назад
if you do that for stock comp, then one should do the same for buybacks/dividends?
@keanuzeller5008
@keanuzeller5008 Год назад
Hey Tom, thanks for the great videos. As far as i know Alphabet reports the share based compensation in their cost of revenue section. Since the FCF calculation is based on the net earnings that cost is already included. If you subtract share based compensation on FCF, your subtracting it twice, which in Alphabets case would strongly impact the present value in a negativ way Greatings from switzerland.
@InvestingwithTom
@InvestingwithTom Год назад
Hey there, SBC is quite clearly added back to net income on the cash flow statement to arrive at cash from operations (which then flows through to FCF), so I still believe subtracting it as I've done in the video is the correct treatment. Thanks for watching/commenting :)
@zanexie981
@zanexie981 Год назад
@@InvestingwithTom You're simply not understanding what he is saying. I think OP meant that SBC is already taken into account as an expense on the P&L statement thus giving a lower net income. So by deducting SBC off from Net income you are effectively subtracting its effect twice. Although tbh, just substracting SBC is a lazy way to take into account the effect of SBC, but SBC is indeed added back for a reason on the cash flow statement.
@InvestingwithTom
@InvestingwithTom Год назад
@@zanexie981 I see. Will try get my head around this over the weekend. Thanks for raising it!
@yiannidalakas3514
@yiannidalakas3514 Год назад
Thank you for the video Tom. I have a question regarding free cash flow. If you calculate your expected return based on your estimate of future free cash flow, this assumes that all free cash flow is returned to shareholders in the form of dividends. How do you handle the situation when free cash flow is used for acquisition, debt reduction, buybacks etc. ? Each of these options produce different returns, for you the investor. A video on this topic would be great, because it's quite a long question. Regards.
@InvestingwithTom
@InvestingwithTom Год назад
Yeah, it's a good question and probably too complicated (for me at least!) for a spreadsheet. I've grown to appreciate how much capital allocation makes a difference though. I don't tend to do much maths on it personally, other than make sure I'm clear I understand management's plans in this area before going into an investment
@yiannidalakas3514
@yiannidalakas3514 Год назад
@InvestingwithTom I haven't seen much literature on it either, which is quite surprising. This is the only theoretical factor that would account for the divergence between owner's earnings produced and actual return achieved. I may propose this as a research topic when I do my postgraduate studies.
@alarak5474
@alarak5474 Год назад
My personal philosophy is that if I believe that any free cash flow that immediately isn't returned to the shareholders, should be used by the company to produce more cash in the future. If I don't believe the company will do that, I won't invest.
@Bhavinp
@Bhavinp Год назад
This may not be the best way to view it and it would depend on management competence but cashflow that isn’t returned to shareholders stays in the business and provided the ability to generate more future cashflow. This could be captured in the terminal value since increased cashflow will increase the terminal value. If you expect cash to be reinvested in the business, you can account for it in the growth rate too without getting too optimistic. You’re generally going to only give the business a high growth rate if the company is reinvesting capital and not distributing all of its free cashflow. Debt reduction can increase cashflow over time and strengthen the balance sheet which might demand a higher terminal value. Acquisitions can increase cashflow or be the driving force for your expected growth rate. Share buybacks would be the reverse of the share dilution that Tom has on his sheet. If buybacks are expected to outpace stock compensation, a negative number there would help with the calculation but this is hard to predict for most businesses, especially when you’re looking out 10 years.
@aryaaimagh
@aryaaimagh Год назад
Hi Tom, The FCF you are using is only for Equity holders, since FCF is derived from net income where interest payment has already been paidout. Can you please explain why are you adding back cash and deducting total debt in the end and then afterwards divide by number of outstanding shares(equity holders) ?
@GGG-mn4qw
@GGG-mn4qw 6 месяцев назад
Hi, your videos are amazing, thank you! just one question, you mentioned that you follow someone`s guidelines and his book but I can not hear the name and the subtitles are not helping so can you please share the name of the person that you mentioned in the video? I heard the name of Phil Town but not the second name that you mentioned at 08:30.
@InvestingwithTom
@InvestingwithTom Год назад
Thanks for watching! Be sure to subscribe for more, and feel free to download the spreadsheet template via the link in the video description :) **Important note** I’ve had a few good comments about whether or not it’s correct to be subtracting SBC from FCF, since it’s already expensed on the income statement, then added back on the cash flow statement to get to operating cash flow. Surely adjusting for it again is double counting? It seems there are varying opinions on this between different analysts and valuation professors etc. Here’s a good article laying about both sides of the argument: www.wallstreetprep.com/knowledge/stock-based-compensation-treatment-dcf-almost-always-wrong/ Subtracting free cash flow as I’ve done in the video is more conservative and essentially treats SBC as if if were a cash cost, and will give a lower intrinsic value result. But, you could easily argue it’s TOO conservative. For companies will little to no SBC, you should get the same result either way 🙂
@Dylan-cr5ub
@Dylan-cr5ub 11 месяцев назад
Hey Tom if my company doesn't have stock-based compensation on Yahoo Finance what should i do?
Год назад
I'm almost getting nostalgic when I see that thumbnail! Is part 1 still your most successful video of all time?
@InvestingwithTom
@InvestingwithTom Год назад
Sure is ;)
@1m2ogaming
@1m2ogaming Год назад
Can you make a video about ROIC,ROE,ROA,ROCE and how they impact the returns.
@lukevandeleur7095
@lukevandeleur7095 6 месяцев назад
Great explanation! One question though, why is there only an adjustment for net cash/(debt) and no adjustment for other classes on the balance sheet such as PPE or trade receivables/payables?
@sumanthasaha61
@sumanthasaha61 Месяц назад
The other adjustments you are talking about are included in the free Cash Flow formula. I don't know how Yahoo calculates Free Cash Flow. But the widely used formula is : EBIT(1- Tax%)+ Depreciation + Non Cash Items - Capex- Change in Working Capital. The PPE is covered in Capex and Receivables/ Payables are Covered under Working Capital.
@anurajthanapadathcharu8886
@anurajthanapadathcharu8886 Год назад
If you use discounted cashflow year 1 $43 and use rule of 72. 1st 4 year $86 @ 15%+ next 6 years 43 @10% 86+43= 129 and use 10x129 = 1290 would that calculation work?
@amitagarwal2
@amitagarwal2 Год назад
What is the growth rate referring to? At 5:20 Is that sales growth, cash flow growth or something else?
@JordanLadouceur-pf4nc
@JordanLadouceur-pf4nc 6 месяцев назад
Hey Tom, I’m having a really hard time using your calculator.. I keep getting ridiculous outputs.. is there any information you can offer to help with this?
@alabais8379
@alabais8379 Год назад
Great video!!! Is it possible for you to share this spreadsheet? I’d like to examine it more closely. I didn’t quite get where the stock based compensation is plugged into calculations.
@InvestingwithTom
@InvestingwithTom Год назад
Link in the description :)
@geetakarmani9407
@geetakarmani9407 3 месяца назад
Can i have excel sheet please..
@adambalcar2863
@adambalcar2863 Год назад
Hi, where can I find stock based compensation except yahoofinance? Thanks
@NicolaWinters
@NicolaWinters Год назад
Hey just found your channel and subscribed. Great content!
@InvestingwithTom
@InvestingwithTom Год назад
Awesome, thank you!
@tanner9956
@tanner9956 6 месяцев назад
There’s so many ways to actually calculate a businesses intrinsic value it all depends on what the business is and how your looking at the company
@jimgrant1776
@jimgrant1776 7 месяцев назад
Determining an intrinsic value is not the objective. The objective is to invest in securities that will produce favorable rates of returns. After the determination of an intrinsic value, how do you determine the rate of return on the price appreciation of the stock. (Without that, what is the point?) And, if you determine the intrinsic values of 2 stocks, how do you decide which one to buy? Suppose one is expected to produce a return of 5% and the other 20%. How will you know?
@musaabsi
@musaabsi Год назад
How often we should change expected cash validation for example as in thr case of BABA it changes to be fairly to overvalued within 3 months or so with no clear reason which i fine difficult to understand
@grahamchester2683
@grahamchester2683 Год назад
Tom Thanks for sharing the valuation template. It was good to go through the model. I noticed that the model doesn’t include the impact for dividends. Cheers Graham.
@ThomasDenais
@ThomasDenais 4 месяца назад
Thanks for sharing your file. What growth rate is it for the 5 years and ten years? Revenue, earnings per share, cash flow growth rate?... Same question for the 5 next growth rate on Yahoo finance? What growth rate are we talking about? Thanks
@mikeandrews745
@mikeandrews745 Год назад
How did you get the Excel template to automatically change the stock? Like when you switched from google to apple and it automatically adjusted the share price?
@tylerminix2028
@tylerminix2028 Год назад
We consider stock based compensation but not stock buybacks?
@InvestingwithTom
@InvestingwithTom Год назад
SBC is a cost that isn't captured by FCF. Buybacks, dividends etc. are decisions about how the cash is then allocated. It has a real impact over time of course, but I don't really want to get into the business of how many shares the company might or might not be able to retire in a spreadsheet - too many moving parts. Approximately right > precisely wrong ;)
@archangel5410
@archangel5410 7 месяцев назад
Why is the cash discount in year 10 10% shouldn’t it be 50%
@danbuffington75
@danbuffington75 10 месяцев назад
I've given up on 10 year growth rates. Just use 5 and life is simpler for me. One double is 5 years at 15%. Less mental gymnastics.
@MrLievore
@MrLievore 3 месяца назад
What if the year 0 free cash flow is negative?
@sumanthasaha61
@sumanthasaha61 Месяц назад
Take the average/ Median of last 3 year FCF.
@Crews_i_Mean
@Crews_i_Mean 10 месяцев назад
I'm getting an "Unknown Function '_FV' " error when using the template. Idea why that may be?
@farminteam6500
@farminteam6500 Год назад
Why don't you use WACC as a discount rate? I think buffet does it
@InvestingwithTom
@InvestingwithTom Год назад
He does not - answered this in a recent Q&A :)
@ErikM528
@ErikM528 Год назад
Shame on you Tom. You clearly haven't been following Monish's commandments, "Thou shall not use excel" 🤣
@InvestingwithTom
@InvestingwithTom Год назад
Haha my bad ;)
@tombrady4977
@tombrady4977 Год назад
LOL so you bought the golden goose Alibaba or the digital Warren buffets at Tencent. The you are lost 😂😂😂😂😂his circle of competence is the empty set.
@anurajthanapadathcharu8886
@anurajthanapadathcharu8886 Год назад
If you use discounted cashflow year 1 $43 and use rule of 72. 1st 4 year $86 @ 15%+ next 6 years 43 @10% 86+43= 129 and use 10x = 1290 would that calculation work.
@mapp0v0
@mapp0v0 Год назад
Tom how can you value BRN? No revenue. But unknown prospects. Hint it is more than zero.
@InvestingwithTom
@InvestingwithTom Год назад
Same process - how much cash will they produce in future, discounted back to today. The challenge is having any level of confidence at all in your FCF estimates!
@vidya014
@vidya014 6 месяцев назад
Forecasting growth rate is like forecasting the lottery number.
@stefand5472
@stefand5472 Год назад
You did Not Put the current buybacks into account
@Bigagoo
@Bigagoo Год назад
I have a real hard time adhering to Monish's commandment "thou shalt not use excel spreadsheets."
@Threecommaaclub
@Threecommaaclub Год назад
Video starts at 3:16
@SpeedbirdHeavy
@SpeedbirdHeavy Год назад
It starts at 00:00
@Eline_Meijer
@Eline_Meijer Год назад
Monish Pabrai is a very average investor and his historical returns are around 7%-11% YoY. Its funny that you mention him but have no idea how bad of an investor he is.
@InvestingwithTom
@InvestingwithTom Год назад
No, I'm familiar with his results
@tofuckmybutt
@tofuckmybutt Год назад
Hi tom, the current share price cell, 52 week high, and 52 week low cells say error, also the stock ticker wont work. I read the directions but I do not have excel and cannot find stock in data tab on sheets. What do you reccomend to fix this. Thanks!
Далее
Superinvestor Flops: Horsehead goes to zero!
15:51
Просмотров 4,6 тыс.
Warren Buffett: How To Analyze a BALANCE SHEET
8:27
Просмотров 481 тыс.
MARGIN OF SAFETY SUMMARY (BY SETH KLARMAN)
15:22
Просмотров 147 тыс.