How to Calculate the Intrinsic Value of a Stock like Benjamin Graham! (Step by Step)

[@Dividendology]

*Important Update - I might a slight error on the margin of safety portion of this video. In order to see the correct way to apply a margin of safety, please watch this video: How to Apply a Margin of Safety like Benjamin Graham! (Margin of Safety Explained + Example) kzbin.info/www/bejne/eKrWeItpj8x_fLc

[@aneel139]

as you said, in revised scenario as well, acceptable buy price is less than intrinsic value but how cone its sell option?? or the formula should be current price < acceptable buy price???

[@kk28032]

@@aneel139 correct formula at 15:38 , look at the formula box....

[@dougb8207]

Oh thanks ... been spinning my wheels for half an hour trying to unwind what my discrepancy was! I was going to comment, but you've already found the problem.

[@SonnyBB]

the growth rate express in percentage should be computed as percentage, so the intrinsic value is only around 75

[@metalsir7060]

This video is amazing! nice job! do you know if there is a way to manually calculate your own growth rate pulling the historical data into the sheet? many tks! PS: I made a concatenate function that actually gives the complete yahoofinance link straight into the analysis tab.. easy but effective since you click on the cell and the page magically opens in the right place. scroll down, boom, done.

[@larryyang976]

Great content! Based on this same formula, apple intrinsic value is only $142 as of 02.18.2023. Apparently the growth rate cannot catch up to the corporate bond rate and the eps stays same. Now I understand why these once hot stocks are not hot anymore during inflation. Great formula. Thanks for bringing this to me!

[@MrNintoku]

11:03 I think this is an error since no matter what you have as your Intrinsic and Acceptable buy price as long as the margin of safety is below 100 it will always say Buy. I am assuming here that the comparison should be between current price and acceptable buy price. If Current Price

[@AlejandroDiaz-ll5eq]

this is what i was thinking too. at 13:22 the formula changes for "acceptable buy price" as well but i'm not sure if i'm missing something

[@firsargentum5920]

Yeah, you're right. He should be comparing the estimated intrinsic value to the actual current share price in F26. Also, in reality, you probably wouldn't wait to sell until the stock goes 65% above its intrinsic value. If you sell if it goes say 20% above intrinsic value then the condition should be something like: IF (F26 < F29, “Buy”, IF (F26>(F23*1.2), “Sell”)

[@toddforney5198]

I believe that's correct as well. I also noted that the "Difference" calculation is not used in the buy/sell determination. Perhaps it's just an interesting statistic.

[@brandyharding7692]

@@firsargentum5920 this is to decide rather to buy or not. Once you buy you shouldn’t be looking to sell if you have done your homework for that company.

[@firsargentum5920]

@@brandyharding7692 You can also use it as a guide to sell if you think the rationale for buying not longer holds, one of which could be that the stock has run up too much and has become overvalued. In any case, the substantive point is that the formula he gave for deciding on the Buy decision is wrong - I'm sure the OP understands the math and probably just effectively made a "typo" :)

[@dudemanbrotime-financetech1338]

Finally someone whos not speculating/gambling

[@jle92708]

Investing is speculating to an extent. The bet is to assume the market will realize the value.

[@lucasasselmeier7825]

@@jle92708 speculation Is a term used in investing to distinguish a value approach based on the analysis of a businesses financials. Speculation is reviewing the stock charge and betting that it will go I do agree that investing requires speculation, though taking a value approach and deeply analyzing a business is using realized data to make more accurate predictions. There are no guarantees of course, but there ways to invest that isn’t just placing a bet because you feel like you can make money

[@sheldor73]

@@jle92708 🤣🤣🤣🤣🤣

[@maalikserebryakov]

@@jle92708LOL

[@maalikserebryakov]

@@sheldor73 Whenever I want a good laugh I turn to the stock market community, there is always a large group of court jesters to lighten the mood :)

[@swapnilhirave3354]

Great content. Acceptable buy price must be greater than Current Price for decision on "Buy", as 'Acc. (10:20) Buy price' is factored from intrinsic value itself. Need to correct this in model 1.

[@zaiho1336]

This is a great video; thank you. However, I think there's an error calculating the Acceptable Buy Price using the Margin of Safety (MoS). If a 65% MoS for AAPL is 252.26 (388.09 x 65%), which means we want more protection; then the Acceptable Buy Price = Intrinsic Value - MoS of 65% = 135.83 (388.09 - 252.26 = 135.83). Let's say we would accept less MoS for AAPL, which means we are more confident about the company and accepting less protection. A 35% MoS is 135.83 (388.09 x 35%). So, the Acceptable Buy Price would be 252.26 (388.09 - 135.83 = 252.26). Therefore, a 35% MoS (low MoS) would result in a low Acceptable Buy Price (252.26), and a 65% MoS (high MoS) would result in a much, much lower Acceptable Buy Price (135.83). In contrast, the video shows that a 65% MoS has an Acceptable Buy Price of 252.26.

[@im_gauravg]

Absolutely agree. I think too that Buy Price = Intrinsic Value - (Margin of Safety * Intrinsic Value)

[@jennjenn1273]

Yes, the formula is off.

[@Chino99999]

You are right.

[@isasunasra9910]

Absolutely agree, thanks for pointing out

[@vladpruna95]

Thank you! I was wondering if I've made a mistake because it seemed off

[@sanziocaroli4455]

Just my 2 cents, if growth rate is 17.93%, you have to put 0.1793 in the formula, not 17.93, in other words, if a number is expressed in percent, you have to divide percent.

[@krishnaramachandran7722]

No. 8.5 is % as well as is 4.4 and Y. So it does not matter because both numerator and denominator are inflated by a factor of 100

[@davidoneill4859]

Very helpful, but the Buy/Sell formula should compare acceptable buy price to current price

[@tudovan8423]

Agree with your point

[@thefantorangster2491]

Grahams gormula is fairly accurate, it’s just that 17% growth rate is a redicilous prediction.

[@SonnyBB]

the growth rate express in percentage should be computed as percentage, so the intrinsic value is only around 75

[@obijuan3004]

Great Job! Simple explanations, easy to understand. Now I just have to evaluate 4000 stocks…😊

[@vishwajeetpatel3872]

you can just automate this. as per the formula, you can acutally lookup the EPS and other numbers. Download the Script names you want to analyze, and create a dropdown of the scipts. so everytime you select the script, it will give the IV. should not take more than an hour to create this for all 4000 stocks.

[@zozany120]

@@vishwajeetpatel3872 how do i do this? is there a video explaining the proces?

[@sridevipanyam5759]

AT 10:55 the buy/sell recommendation logic should be if the price of the share is less than acceptable buy price.

[@BenzinioB]

The best explanation of Intrinsic Value of a Stock!

[@Dividendology]

Thank you!

[@husseinalaaref4910]

In the IF statement, the first parameter should be (current price < acceptable buy price) not (acceptable buy price < intrinsic value). Thank you.

[@mikatu]

Thanks a lot. It was very well explained. I also find that the original formula is too agressive. I just think you shouldn't say buy vs sell, because the goal is not being selling stock simply because the market is not there. You should keep your stock if you believe in it. You should put buy vs not buy. To decide if you want to sell you should create a different model, where you incorporate your "pain-level".

[@Dividendology]

Great thoughts. I agree!

[@ozeromd1882]

Video is well explained. But you could have added that Graham did actually implement two warnings in a footnote that Growth Rates are unpredictable and therefore the formula is basically not very meaningful at all.

[@davidroussell5118]

Thank you for this. I've wanted to find a IV calculator for Graham for a while. I now officially have three different methods for calculations!🤣 1. Multiple of earnings 2. Discounted Cash Flow and now 3. Grahams. However, since I follow so much of Graham's teachings I think I'll explore this model.

[@Dividendology]

I’m glad this model helps! Don’t forget about the Dividend discount model as well!

[@philochristos]

When you use these different methods of calculating IV, do they give close to the same results, or are there big differences between them? If there are big differences between them, which method do you think has turned out to be more accurate?

[@azeton128]

This formula is available to literally everybody. You can be more than sure it won’t be working for retail. Not a chance.

[@daktrdre]

15:43 =IF(I30

[@jordanjacobson1119]

Thank you, thought I was going mad

[@davidvose2475]

You need to apply some discipline on the units of the parameters in the model. For example, g is a %. It's better to plug in 0.1793 in Excel and format as %. A reality check - is a stock really worth $388 when it generates $5.11 per year?

[@travelledfar]

For UK users, prefix the ticker with LON: and divide current price by 100 (p)

[@brandyharding7692]

I use 1.5 growth and have a table based on the average of the top 10 stocks in that industry divided by 2.

[@kegomania]

Warren Buffet doesn't use this. He uses a version of this that uses free cash flow. He doesn't like to use earnings because EPS can be manipulated by management.

[@FakeSparrow-lu5ih]

What is the formula or what is the name of it, pls let me know, thanks

[@kegomania]

@FakeSparrow-lu5ih unfortunately it's a well kept secret by anyone who has the formula. They're unique to the individual depending on the formula. I suggest really diving in and learning as much as you can about the topic. But on our levels, his quote "buy good companies and do nothing" works well.

[@kegomania]

@@FakeSparrow-lu5ih research "discounted free cash flow (DCF)"

[@FakeSparrow-lu5ih]

​@@kegomania thanks

[@canuk688]

probably worth stress testing that growth rate, tapering everything you can is worth seeing what the model implies as value

[@Bullishbtc007]

Hi great video, just Quick question, why the growth rate (2g) in the formula not in the percentage ( 17.93%). Thanks

[@keith7411]

It's funny that the entire valuation is based on "expected growth rate over 5 years" which is forecast by a group of investors. My concern is that there is a massive reliance on other people's idea on the shares future value. Would have thought that this reliance defeats the entire point of the valuation. Can anyone confirm how this 5 year growth rate is calculated by the brains trust?

[@esechromechrom4647]

This changes completely the valuation. I think it should be in %.

[@jumboegg5845]

3 years later, current price AAPL is $220.91 USD

[@anxheloripa449]

I think there is a mistake or im confused lol. Your acceptable buy price is .65*Intrinsic value. Which means that the buy price is always lower than intrinsic. So your last sell will always say "BUY". Shouldnt you compare to current price?

[@fluffyscruffy]

If the Growth Rate is a percentage, shouldnt it be listed in decimals? i.e. 0.1793?

[@scarabonyx3565]

The video is misleading, but there are some who will believe it.

[@antilogism]

That threw me too. I need to read the book I guess. Another factor in the text?

[@tommybahamas40]

Very good video to understand the Intrinsic value of a stock and other important points to keep in mind before buy/ sell of stocks

[@reybigcena]

You are a legend. Probably the most useful video I have seen in the last 5 years.

[@Dividendology]

thank you!!

[@sethcharles3811]

Your lessons help me improve my trading strategy. Thank you for your expertise and experience!

[@andychavez]

In your formula for checking if the stock is buy or sell in 10:43, the answer will always be BUY because always will F29 be less than F23 because F29 is a product of percentage(Margin of error) to the F23. Is this formula really correct?

[@Dividendology]

See the pinned comment! Thanks!

[@tswop9430]

For revised formula, I think the comparison is incorrect. On this one it states to compare Acceptable Price to Current price. Original formula compared acceptable buy price to Intrinsic Value. Both equations should yield a BUY

[@sunchaserw1477]

Listening to what you teach here is way better and more productive than sitting in a finance class for the whole year. Magnificent!

[@Dividendology]

Thank you so much!!

[@matthewsamuels-pb8fn]

I just followed these steps and the acceptable buy price is 69.00 and the intrinsic value is 106.15. The current price is 195.71 and the valuation says to buy. Someone please explain why I would buy if the acceptable price is lower than the current price

[@bluesunproductions9079]

This is good, but the intrinsic value is only part of the decision. It really is only used to determine the buy price by buffet There are several other factors he talked about when making a determination on whether to buy a stock or not. I would also be careful about using future growth projections. That number can distort the IV greatly.

[@siddharthpandey8516]

Amazing playlist! Has exactly what I am looking for, thank you!

[@EgressFromStress]

Good evening. I have a question...is the 8.5 or 4.4, and the growth rate percentages? I noticed a lot of growth rates are in percentages. For instance one growth estimate was 101.42 % So do I have to change that to 1.0142? Also, your examples, are 8.5 percentages? If they are do I need to change them to .085 or .044? i am really excited about this formula but just am confirming...especially with the growth estimate of 101.42...does that need to be changed or not. Thanks so much.

[@sachseo.5530]

Had the same observation. Multiplier i think should be 0.1793 instead of 17.93?.

[@nicholasmichael3823]

Thank you for the video! This helps me a lot! I have a question. If I am doing the calculations with a company that has a negative EPS, and I, therefore, get a negative intrinsic value, what should I do? This seems to throw off my results

[@leonuno7716]

yeah in the same situation

[@abdulrahmanpasha8436]

Hi that’s was very helpful just one confusion I guess you have done a minor mistake in IF formula.

[@sanyasin56]

Hi! Just some questions out of curiosity. Why multiple average yield of bonds and divide current yield? I just want to know in what sense exactly this calculation is 'the' intrinsic value. By the way, Great lesson for beginner! Thank you! 😄

[@nagamo_5368]

I was thinking the same thing

[@lcmlcm2460]

Best explanation I’ve seen on KZbin so far. I probably will have to watch this a few times but I appreciate it.

[@Dividendology]

Thank you!

[@TheSkg2011]

The video is great and I thank you for your hard work. However, the formula for to Buy/Sell condition is a bit confusing; an acceptable buy price should compare with the current price column I believe. I have watched this video several times. Let me know what you think.

[@NeuroCurieux]

I think you are correct, while copying the formulas on my own spreadsheet, based on the formulas the acceptable buy price should always be less than intrinsic value, hence always a buy What we want to know is: Is the CURRENT price an acceptable price to buy

[@webmoneyschool9065]

But I think you MEANT to say Buy/Sell - Current Price is less than Acceptable Buy Price the Buy you said the opposite....let me know please P.S. why would you randomly go margin of safety 65% - you meant to go 1-Difference - Am I Right!?

[@tbone50515]

When the intrinsic value is less than the current stock price does the formula still work?

[@m.fazlurrahman5854]

INTRINSIC VALUE is nothing but perceived value. In this formula “ the next five year’s value” is a projected variable; therefore it comes with +- 5% error variance. So the model is as good as one’s “crystal ball” estimates.

[@nbrown6648]

Agree with your statement, and would take it further than +-5% in terms of error variance. As the market is quite chaotic, the projected growth by analysts over the next 5 years is only slightly better than a wild guess.

[@cherokeejack7757]

I should have learned this a long time ago, but I don’t recall call this in my 1969 Business management class. Good work!

[@krishnaramachandran7722]

Prof Damodaran aka Dean of valuation has a different method. The safety margin appears to be a random number and defeats the whole purpose of calculating the intrinsic value.

[@danielchristmaslee]

I applied the formulas to a few securities in today's market and ... everything is a sell. 🤦‍♂Is anything a buy after applying the formulas in this video? Can someone provide an example because I feel like I might have missed something in my spreadsheet even after considering the pinned comment. 😭

[@tomsmyth421]

Goodness. Buffett literally, every time he is asked questions about calculations regarding intrinsic value, specifically says he doesn’t use spreadsheets and formulas.

[@Apeiron242]

I wish this video explained what these terms mean and why they're relevant. Do you have any back testing data on these models?

[@TheYellowshuttle]

Best step by step walk through of intrinsic value calculation I've seen so far! Thanks for sharing.❤️💎 Can the bond yields be replaced by other safety instruments - say FD etc?

[@Dividendology]

Thank you! As for your question, I would have to look closer into that to find out.

[@lio298]

Great Job!!!! Thank you and very good luck with your channel. Keep up with sharing good content

[@elijahrombado334]

Thank you for making coding so much simpler.

[@Dividendology]

Glad it was helpful!

[@blubb2514]

10:46 you make the buy or sell if statement: if the acceptable buy price is less than the intrinsic value buy else sell. But you calculated the acceptable buy price by multiplying 0.65 with the intrinsic value. Shouldn't it be: If current price is equal or smaller than acceptable buy price buy else sell??? I was very confused here. The way you put the buy/sell together it will always want to buy.

[@Dividendology]

Error. see the description! :)

[@madhukareunny7614]

with the current corporate AAA BOND yeild of 4.6 does your forumula explained still work?

[@djchaynes]

Thats true.. Because every stock is overvalued

[@motinbar5]

Need to calculate the value of the company's assets and cash versus its value in current shares

[@StarsandWifes]

Well , you can Always adjust the Model to the Price you Look for….

[@MurthyMurthy-wb7nx]

Your investment is equal to prise * time* rate of interest devideded by hundred is equal to your interest out put ,, devidents only account pay only

[@brysonmoore7596]

Thank you for actually showing how to calculate it

[@shak_Fu]

Hello @Dividendology. Could you please reveiw your formula here for buy/sell versus your video posted on margin of safety buy/sell formula and clarify. You use current

[@Dividendology]

See pinned comment

[@RepairApp]

This is really well explained. Have you created one where you compare an individual stock intrinsic value to just buying an 8% ETF rather than bonds. They weren't around in Graham's time, otherwise I'd think he'd use this higher earning option to compare.

[@marctyson326]

I think revised is more realistic. Good video

[@knufia2595]

It would be more useful and important to explain the formula and its variables: Why do I divide by Corporate Bonds Interest Rate? Why do I multiply by average corporate interest rate? Why do I use a margin of safety? Why is the earnings per share important for the price evaluation? (Diminishing returns in the future I guess, but I came here to learn this) What do other Models differently and why? Do I differentiate between growth and value stock? What if the growth rate is negative? Are you sure you can add P/E and growth rate together? One is a ratio, the other is a percentage value. Like this it is more like an excel tutorial, which is also important, but I watched the video and I still don't know HOW an intrinsic value is calculated. Rant aside: I like your every video about finance that is calm and without spreading FOMO. 👍

[@lucasasselmeier7825]

The title states how to! There are plenty of deep dives on the why, look up warren buffet on productive assests and calculating intrinsic value

[@bitharkcryptochannel2150]

My autistic brain will try to make sense of it. Let's just go left to right. - EPS > Earnings per share is kind of like the current state of the company in this example. Please note that with a negative EPS this formula will give wacky results. if growth rate is also negative, it will give a false positive result!!! - P/E 8.5 > This also kind of serves like basis. ( I think the way it is used like this is: with growth rate, the EPS usually increase, but also stock price. Stock price and earnings affect P/E. If we add growth rate to the default 8.5, we get a very large ""P/E"", from which this formula guesses a future stock price) - 2*Growth Rate > I guess the idea to multiply the projected growth rate, is because there is no real way to make a forward projection of 10+ years. I think it should also be noted that you cannot see this as company will continue to grow at the projected 5 years avarage. I think the idea really is more like for a timeframe of 20-30 years or so. - Average yield on Corp Bonds > If in history the average yield on Corp Bonds is 4.4, this more or less means that companies need to atleast outpace this %, because they pay it to Bond holders. - Current yield on Corp Bonds > If the current yield is lower that the average historical yield, the company is more or less borrowing money at a discount. If the current yield is higher, the company borrows money at a premium. Please note: yield on bonds have some relation with both inflation and interest rates. It tells something about the current economic situation and monetary policy, compared to historical average trend. It is an external factor that influences the company - In my opinion the growth component is a bit eyeballing short term, but I'm quite sure it will provide an indication long term. De safety margin is to be used here, for example a startup can have a very fast growth, which may not be sustainable. While long lasting companies may have a slower growth, yet stable. Let's make an easy example. Ticker EXAMPLE.The current stock price is $10. This company has no projected growth. The EPS is 1$. 1 * 8.5 * 4.4 / 2.8 (~ yield july 2022) = $13.35 (Intrinsic value). ---> Because current stock price is $10, the company is undervalued Fantasy very high yield example: 1 * 8.5 * 4.4 / 7.8 (fantasy yield) = $4.79 (Intrinsic value) ---> Company is severly overvalued just my 2 cents

[@milwaukeetweed4843]

Shouldn't the buy sell "if" function be based on the margin of safety rather than intrinsic value?

[@Esotericaaa]

Today is Sept 1, 2023, Current yield of Corporate AAA bands 4.66. I am looking into AAPL, current price $189.46, next 5 yrs growth 6.36%, EPS 5.96, calculated intristic value $119.21, acceptable buy price $77.49. But since acceptable buy price is less than intristic value, the suggestion is "Buy". Why? The stock is over-valued at the moment, right? Wouldn't I have to wait until it drops below the intristic value? So perhaps, if the acceptable buy price is less than the current price.... Second example, NVAX, has negative EPS as well as negative growth. Current price $8.21, EPS -7.1, growth in next 5 years -69.60%. because of negative/negative, the intristic value jumps to a whooping $897.17. However, this is a nice video, explains Graham model in an easy to understand manner, but adjust it to your own margins. I really like that google sheets can pull the information directly from the finance page.

[@willpope302]

Initially, the formula that you used for the Buy/Sell price stated to buy the stock if it's acceptable buy price was less than the intrinsic value. But, in your revised formula, the acceptable buy price remained less than the stock's intrinsic value. Therefore, it appears that you must have changed the variable from the IF() statement in your revised formula from being the "intrinsic value" to being the "current price". I would greatly appreciate some clarification; but regardless, thank you for the video!

[@Dividendology]

See pinned comment

[@willpope302]

@@Dividendology My apologies, I just saw the pinned comment. Regardless, It wasn’t a big deal at all and I fixed it immediately after noticing the mistake. Thanks again for the video & information, I’ve already incorporated it into my interactive dashboard!

[@Dividendology]

Great!

[@d.kleiser9514]

Thanks for the fine video. If 4.4% was used by B. Graham as the average AAA corporate bond rate, how old is that, and should it be updated and if so how? Thanks...

[@miraclemaxicl]

two years have passed. AAPL is trading at $195. buying at $145 would have been a good idea. looks like the sweet stop for model parameters are somewhere between the original and the revised

[@schzx14]

You did a good job in your video. But I’m from the future. November, 2023 to be exact. And for Verizon, selling short will make you rich. For Apple, buy it and hold until my time. Glad I was able to help you past humans. These lessons remind me of what Lou Rukeyser would say after getting wildly differing estimates of future markets from his guests. Paraphrasing: “One thing is certain, some of them will be wrong”.

[@SeniorDonCarlo]

Nice and easy explanation that I do like together with the excel hints - thanks for that. But I’m struggling with the content itself. My questions/notes: 1. can you please share the source for the revised version that you used? Would be interesting to see, now Just like that looks a bit randomly 2. Unfortunately you didn’t explain how to deal with the PE ratio - how to distinguish a no-growth stock and a growth Stock and what Number should be used in certain situations. There is no detailed explanation needed, but at least it should have been mentioned somehow 3. if the 4.4 average yield was so stable and good to use it’d be good to explain why this is the case / why the ratio of the yields is even needed in this formula. A link or source would be good enough 4. you should/could have stated that it’s also important to know which EPS is used. You automatically used the TTM which is one (maybe good) option but not necessarily a good forecast. Overall by watching the video I’m unfortunately not feeling confident enough to follow your model. Would be great to get feedback, thanks!

[@tomstevelt9641]

How do you suggest dealing with negative EPS or negative Growth? For example, currently BA and DOW.

[@RadioDjinn]

How buybacks factor in? I mean, that's the main force the keeping those companies' stock price afloat.

[@TheEihklusivKrossi]

Question: Y value is easy to track for US Markets. How do we find Y value for non-US markets? TIA

[@rollinwifdabigboys13]

So his formula uses the phrase current yield of AAA corporate bonds in the sense that it’s not actually that? C/MKT price of the bond is what it should be I think because everything else your using is a recent value. Using that formula also better incorporates what todays interest rates are. I feel like this formula is missing a lot tbh

[@EgressFromStress]

I did what you told me to do, and Amazon's buy price is $89.52 the acceptable buy price is $4.40, and its saying to buy. This doesn't make sense. I tried what you said twice. Any advice?

[@Dividendology]

watch my video on margin of safety! Linked in the description.

[@joseantoniocanorosas]

GREAT VIDEO! You earned a new subscriber, THANK YOU!! 👍

[@PersonalFinancesExplained]

Thanks for the formula it's very helpful, but how do you modify the buy sell rating to check that the acceptable buy price is above the current price?

[@cv2cv]

If you are going to calculate A GROWTH company, do you just ignore the P/E ratio in the calculate?

[@RicardoSilvaMadeiraSkateOutros]

Thanks for your video! What if the formula contains one negative number, per example the growth rate expected for the stock. In that scenario you will have a negative intrisic value, which is impossible...what should we do?

[@Dividendology]

negative growth rates are not healthy for companies. I would advise you stay away.

[@rickfanta4323]

Nice work. 1) Do you have a source for the revised model? 2) For high growth stocks like AAPL, it would be good to experiment with smaller growth rates (e.g. half? Some worst case historical rate) to see the impact of recessions

[@saulpizarro4684]

Apple is not high growth

[@noway2708]

@@saulpizarro4684 just answer the question

[@tomsmyth421]

Rick will lose his money because he thinks he’s buying a little ticker symbol and that he can forecast “growth rates”.

[@Danseleicus]

How do you factor in stock splits? Assuming there hasn’t been any stock splits, wouldn’t the results be quite different?

[@gerap7537]

Why do we put the growth rate in normal number instead of putting it in percentage? I mean, why we put 17.93 intead of 17.93% on the formula?

[@jmfishing4934]

For some reason, my IF function is not working appropriately and I have tried several times with both of your examples. Any recommendations?

[@39lloydb]

I don't see any calculation using the current price? So if the current price is higher than the intrinsic value and the acceptable price, you still should buy based on the acceptable price being lower than the intrinsic value?

[@MortezaNurcheshmeh]

great video! just the Buy/Sell part did not make sense. at 10:44, you mentioned if the acceptable price is lower than the intrinsic value (which always will be the case after applying the safety margin) then buy. Guess it should be if the acceptable price is higher than the current price then you should buy.

[@Dividendology]

see pinned comment

[@Irishprice1]

Quick question for anyone with more grey matter upstairs than myself: ------------ They Buy/Sell formula seems to only look at acceptable buy price vs. intrinsic value. What if the current price is higher than acceptable buy price, but still lower than intrinsic value. Is there a way to use a formula (IFS for example) to list buy if: - Acceptable buy price is below intrinsic value AND - current price is belowe acceptable buy price ???

[@paulollerhead941]

You sir, have lots of intrinsic value. This is perfect, thank you

[@Dividendology]

Wow, thank you!

[@micheledaly9166]

Good video with no unecesary bs

[@souravkumar1051]

How frequently do you have to update the data this formula to determine whether it is acceptable to buy or sell? Weekly? Monthly? Daily?

[@schwingtrader6101]

Very helpful, 65% margin of safety is crazy. Gotta be careful with growth rates…AAPL will not be growing 17% annually over the next 5 years so getting accurate data is crucial. Best to look at multiple sources and average them.

[@martinkjeldsen6370]

its 65% of the intrinsic value ie 35% margin of safety in the example, he is just phrasing it incorrectly

[@Dimitris_1987]

Your margin of safety should be applied on the numbers of the equation. No way Apple has 18% growth the next years, it’s way different than the logic, I would apply a conservative 6-8% there. Also, I would adjust the current bonds a bit higher, let’s say 3% to take into account inflation and rate hikes.

[@Pyramidalist]

There is something missing in your system: ... its just red/green ... whats about gray (hold)? And you did not explain the cause of 65%. And whats about free cash flow in this model?

[@JinNani224]

What do you do when a stonk has negative EPS?

[@thuy-tienle860]

Thank you for the instructional video. Very helpful. Is the growth rate coming from EPS, P/E or something else?

[@jaiminsanghavi3575]

Academic formula for growth rate is retention ration * ROE ... Retention Ration is 1 - Dividend Yield

[@ferydoonh5128]

Hello, Thanks for the very interesting topic. According to the ChatGPT the value should be calculated by this formula: Intrinsic Value= SQRT ( (22.5 * EPS over last 3 to 5 years)/ 10-Year Treasury Yield) What do you mean about it? Regards

[@mihnic0504]

I’ll be adding this model to my spreadsheets. Subscribe

[@Dividendology]

Thanks!

[@JacobSheldrake]

Why wouldn't we want to purchase shares if the acceptable buy price is below the current price? I also thought your IF statement was comparing the acceptable buy price and the intrinsic value not current price? Is nobody else super confused by this? The first example has 252.26

[@davidcunningham2074]

The growth rate is also very optimistic!

[@kevinm7734]

Perhaps he could have zoomed into the screen or even mentioned the actual values he was inputting so we could have followed better.

[@silkeschulz5754]

Great Video! Maybe make a video on potential investments in this current market that would fetch substantial profit, been coming across articles on bloomberg, business insider etc about folks raking in $200K averagely in 6weeks using some sophisticated strategy and I'd love to know how.