- Видео 33
- Просмотров 75 877
ValueLytics
Дания
Добавлен 14 авг 2022
I believe that finding true value in investments is of paramount importance and that this will ensure generation of future wealth. Therefore, this channel focus on making stock screening and calculation of stocks intrinsic value easy accessible by using automated google spreadsheets utilizing several classic intrinsic valuation methods.
Gain access to my stock portfolio tracker, stock screener, intrinsic valuation spreadsheets and my monthly updated watchlist at the Patreon link below!
Disclaimer: I am not a Financial advisor or a licensed professional. I'm just a random guy on RUclips interested in stock analysis and investment. Nothing I say or produce on RUclips, or anywhere else, should be considered as financial advice. All content is for knowledge sharing and educational purposes only. Always do your own due diligence and stock analysis.
Gain access to my stock portfolio tracker, stock screener, intrinsic valuation spreadsheets and my monthly updated watchlist at the Patreon link below!
Disclaimer: I am not a Financial advisor or a licensed professional. I'm just a random guy on RUclips interested in stock analysis and investment. Nothing I say or produce on RUclips, or anywhere else, should be considered as financial advice. All content is for knowledge sharing and educational purposes only. Always do your own due diligence and stock analysis.
Is Incyte Corporation a Great Buy? | Intrinsic Valuation |
In this Stock Analysis, we perform an intrinsic valuation of the biopharmaceutical company Incyte Corporation (INCY) in order to find the company's intrinsic values and analyze if the company is currently trading at a discount.
What is your thoughts on this stock? Let us know in the comments below!
The stock screener and the intrinsic valuation tool are available at my Patreon page: www.patreon.com/user?u=78318634
Disclaimer: I am not a Financial advisor or a licensed professional. I'm just a random guy on RUclips interested in stock analysis and investment. Nothing I say or produce on RUclips, or anywhere else, should be considered as financial advice. All content is for knowledge sharing a...
What is your thoughts on this stock? Let us know in the comments below!
The stock screener and the intrinsic valuation tool are available at my Patreon page: www.patreon.com/user?u=78318634
Disclaimer: I am not a Financial advisor or a licensed professional. I'm just a random guy on RUclips interested in stock analysis and investment. Nothing I say or produce on RUclips, or anywhere else, should be considered as financial advice. All content is for knowledge sharing a...
Просмотров: 390
Видео
Stock Analysis of Abbott and Abbvie | Intrinsic Valuation |
Просмотров 2967 месяцев назад
In this Stock Analysis, we perform an intrinsic valuation of the two Dividend Kings Abbott Laboratories (ABT) and Abbvie Inc. (ABBV) in order to find the companies intrinsic values and analyze if the companies are trading at a fair value here in 2024. What is your thoughts on either of these Dividend Kings? Let us know in the comments below! The stock screener and the intrinsic valuation tool a...
How to Calculate a Stocks Intrinsic Value Using Peter Lynch's Fair Value | Google Sheets Tutorial |
Просмотров 4,4 тыс.7 месяцев назад
In this tutorial I will demonstrate how you can easily create an automated Google Spreadsheet for calculating the Peter Lynch Dividend Adjusted Fair Value for a given Stock and how this value can be recalculated to the company's Intrinsic Value. Link to my Patreon page: www.patreon.com/user?u=78318634 #googlesheets #PeterLynch #IntrinsicValue #Stockanalysis #Fairvalue
Is this a good time to buy Tesla or Toyota? | Intrinsic Valuation |
Просмотров 2127 месяцев назад
In this Stock Analysis, we perform an intrinsic valuation of the two companies Tesla (TSLA) and Toyota Motors Corporation (TM) in order to find the companies intrinsic values and analyze if the companies are trading at a fair value here in 2024. What is your thoughts on either of these two hyped defensive stocks? Let me know in the comments below! The stock screener and the intrinsic valuation ...
Step by Step Tutorial to Calculate a Stocks Intrinsic Value Using Grahams Valuation in 6 Minutes
Просмотров 4,3 тыс.7 месяцев назад
In this tutorial I will demonstrate how you can easily create an automated Google Spreadsheet for calculating the intrinsic value of a company using the formula invented by Benjamin Graham and made popular by the book, "The Intelligent Investor." This formula has since been used by many famous investors, including Warren Buffett. Link to my Patreon page: www.patreon.com/user?u=78318634 #googles...
Is 2024 a Good Time to Buy Eli Lilly or Novo Nordisk? | Intrinsic Valuation |
Просмотров 4,9 тыс.7 месяцев назад
In this Stock Analysis, we perform an intrinsic valuation of the two pharmaceutical companies Eli Lilly (LLY) and Novo Nordisk (NVO) in order to find the companies intrinsic values and analyze if the companies are trading at a fair value here in 2024. What is your thoughts on either of these two hyped defensive stocks? Let me know in the comments below! The stock screener and the intrinsic valu...
How to Choose a Stock with Confidence
Просмотров 1287 месяцев назад
📈 Ready to elevate your investing game? In this exclusive deep dive, we unlock the mysteries of intrinsic valuation models, providing you with a comprehensive guide to making informed investment decisions. From Discounted Cash Flow (DCF) and Graham's Valuation to Peter Lynch's Dividend-Adjusted Fair Value, Comparable Company Analysis, and the Dividend Discount Model - we cover it all! 🔍 Join us...
This could be a Hidden Gem! | Intrinsic Stock Analysis of Verizon and Vodafone |
Просмотров 707 месяцев назад
In this Stock analysis we perform a head-to-head stock analysis of the two companies Vodafone Group (VOD) and Verizon Communications (VZ) in order to find the companies intrinsic values and analyze which company that might represents the best buying opportunity. What is your thoughts on either of these two telecom stocks? Let me know in the comments below! The stock screener and the intrinsic v...
Data Cleaning | Google Sheets Tutorial |
Просмотров 5657 месяцев назад
In this tutorial I will demonstrate how you can easily clean data imported to Google Spreadsheet using the functions; SUBSTITUTE, LENS, MID and FIND. Stock Screening and Valuation Tools are available at my Patreon: www.patreon.com/user?u=78318634 #Datacleaning #datacleansing #tutorial #googlesheets #webscraping
Intrinsic Stock Valuation of Caesars Entertainment Inc And Betsson AB
Просмотров 3557 месяцев назад
In this Stock analysis we perform a head-to-head stock analysis of the two companies Caesars Entertainment Inc (CZR) and Betsson (BETS-B) in order to find the companies intrinsic values and analyze which company that might represents the best buying opportunity. What is your thoughts on either of these AI stocks? Let me know in the comments below! The stock screener and the intrinsic valuation ...
Intrinsic Stock Valuation of Alibaba and Amazon
Просмотров 1 тыс.8 месяцев назад
In this Stock analysis we perform a head-to-head stock analysis of the two companies Alibaba (BABA) and Amazon (AMZN) in order to find the companies intrinsic values and analyze which company that might represents the best buying opportunity. What is your thoughts on either of these AI stocks? Let me know in the comments below! The stock screener and the intrinsic valuation tools are available ...
Intrinsic Stock Analysis of Sanofi and Johnson & Johnson
Просмотров 1768 месяцев назад
In this Stock analysis we perform a head-to-head stock analysis of the two companies Sanofi (SNY) and Johnson & Johnson (JNJ) in order to find the companies intrinsic values and analyze which company that might represents the best buying opportunity. What is your thoughts on either of these AI stocks? Let me know in the comments below! The stock screener and the intrinsic valuation tools are av...
Intrinsic Stock Analysis of Google and IBM
Просмотров 1558 месяцев назад
In this Stock analysis we perform a head-to-head stock analysis of the two companies Google (GOOGL) and IBM (IBM) in order to find the companies intrinsic values and analyze which company that might represents the best buying opportunity. What is your thoughts on either of these AI stocks? Let me know in the comments below! The stock screener and the intrinsic valuation tool are available at my...
The Genius of Warren Buffett: Lessons in Work and Investing
Просмотров 115Год назад
In this video, we dive into the life and work of one of the greatest investors of all time, Warren Buffett the Oracle of Omaha. From his humble beginnings in Omaha, Nebraska, to his rise as the CEO of Berkshire Hathaway, we explore the key moments in his life that shaped his philosophy and approach to investing. But this video isn't just about Warren Buffett's investing genius - it's also about...
Benjamin Graham the Father of Value Investing
Просмотров 124Год назад
In this video, we will take a deep dive into the life of Benjamin Graham, who is widely considered as the father of value investing. Benjamin Graham was born in London in 1894 and later immigrated with his family to New York. He graduated from Columbia University in 1914 and started his career on Wall Street as a financial analyst. He quickly rose through the ranks and became a partner at the p...
Web Scraping Data from FinViz.com | Google Sheets Tutorial |
Просмотров 6 тыс.Год назад
Web Scraping Data from FinViz.com | Google Sheets Tutorial |
Is it Time to Buy Eli Lilly or Novo Nordisk? | Intrinsic Valuation |
Просмотров 2 тыс.2 года назад
Is it Time to Buy Eli Lilly or Novo Nordisk? | Intrinsic Valuation |
Is Johnson and Johnson (JNJ) a Buy? | Intrinsic Valuation |
Просмотров 3062 года назад
Is Johnson and Johnson (JNJ) a Buy? | Intrinsic Valuation |
How to Create a Commodity Tracker in Google Spreadsheets | Tutorial |
Просмотров 10 тыс.2 года назад
How to Create a Commodity Tracker in Google Spreadsheets | Tutorial |
How to Import Data from Stock Indexes to Google Spreadsheets | Tutorial |
Просмотров 4,8 тыс.2 года назад
How to Import Data from Stock Indexes to Google Spreadsheets | Tutorial |
Stock Analysis of Intel (INTC) | Intrinsic Valuation |
Просмотров 3892 года назад
Stock Analysis of Intel (INTC) | Intrinsic Valuation |
Stock Analysis of Verizon Communications inc. (VZ) | Intrinsic Valuation |
Просмотров 9142 года назад
Stock Analysis of Verizon Communications inc. (VZ) | Intrinsic Valuation |
Is Google (GOOGL) currently trading at a discount? | Stock Analysis |
Просмотров 4462 года назад
Is Google (GOOGL) currently trading at a discount? | Stock Analysis |
Web Scraping Data from Yahoo Finance | Google Sheets Tutorial |
Просмотров 12 тыс.2 года назад
Web Scraping Data from Yahoo Finance | Google Sheets Tutorial |
Stock Analysis of IBM | Intrinsic Valuation |
Просмотров 1792 года назад
Stock Analysis of IBM | Intrinsic Valuation |
How to Create a Stock Screener using Google Finance | Tutorial |
Просмотров 6 тыс.2 года назад
How to Create a Stock Screener using Google Finance | Tutorial |
Stock Analysis of 3M (MMM) | Intrinsic Valuation |
Просмотров 1,2 тыс.2 года назад
Stock Analysis of 3M (MMM) | Intrinsic Valuation |
How to Change the Preferred Language in Google Sheets | Tutorial |
Просмотров 12 тыс.2 года назад
How to Change the Preferred Language in Google Sheets | Tutorial |
Is Sanofi (SNY) a buy now? | Intrinsic stocks valuation of Sanofi |
Просмотров 6092 года назад
Is Sanofi (SNY) a buy now? | Intrinsic stocks valuation of Sanofi |
fantastic it worked !!
I was so fucking frustrated haha thank you so much 🙏
No problem :)
You made my day!! Big thanks
NP - glad you could use it 😃
It doesnt work now buddy, how to fix it?
lly also has negative free cash flow according to some data
This cache... Thank you
NP :)
It doesn't work
Genius
Why some BETA of some stocks is not fetched?
Good question! Are they US stocks or international stocks?
how do you create screener by % change or price without mentioning one specific stock, but screen all stocks.
I don't think that is possible with google sheets. I tried once to add all 500 stocks from S&P500 and it ended up only loading less than 1/3 of the data. So at least I don't know how to do it 😉
I don't know why I cant get it I check many time that its the same as what your doing. What I wanted to use this it for was Exchange: NYSE and also Country: USA on either Finviz CNBC MarketWatch Yahoo, google. only managed to get it to work on Yahoo intermittently :(
Currently Juni.2024 I'ts table 10.
Thanks for the update - they keep changing it 🙂
How to import div data from other site...like tradingview
Hmmm I don't know about tradingview. I have never used it. But I have 3 tutorials on how to import data from Yahoo finance, google finance and FinViz.com. Maybe you can use some of those as inspiration :)
ি ও ী
Nice
Thank you :)
Perhaps you can add FCFE and FCFF as oppose to DCF for analysis.
An interesting idea 🙂
Your analysis is childish
Care to elaborate?
can you look at LVS, based on the Graham and Peter Lynch models, LVS looks to be in the fair value range.
Thanks for the suggestion. I will take a look at it as soon as I have time :)
when i use this with a non dividend stock like AMZN, I get some errors as it is searching for a dividend but doesn't fine one. I guess some additional coding needs to be done to allow it to analyze a non dividend stock?
Yes you are correct. You can use the IFERROR function before substitute and then add ,"-" after *1 and before the final parenthesis. this should fix the issue :) This way it will just show a - instead of an error and this allow the calculations to to take place.
@@valuelytics worked, respect.
Awesome!
Thank You :)
Does not work with the UK exchanges, even after using prefix/suffix L. LSE. LSE: and L: . US centric again
ピタットハウスに手付金を持ち逃げされて困ってます。
What is your thoughts on this stock and do you think it is trading at a discount as the data suggest?
Can you use the US Corporate bond yield for a European stock like Bettson in the Graham formula?
Thanks - that is a really good question. By having the current an average yield in the equation Graham makes the intrinsic value of the company dependent on the return one could otherwise get by buying into AAA US bonds. So one could argue that it would make sense to change this for the Swedish government bond instead. However, I would assume that the PE for a Swedish company without growth could also be slightly different. So is it 100% accurate to use the exact same equation on a Swedish stock, maybe not. But that is also why I use a high (25-50%) margin of safety in the end. A 50% margin of safety should more that cover the uncertainties the AAA bonds could introduce :)
dont work formula
Which part of the formula do not work?
👍👍
Thank you :)
can you do similar tutorial but using dcf valuation model pls
Yes, that is in the pipeline 🙂But a automatic spreadsheet for a DCF model is a bit more complicated to create. So it will therefore take some time to finalize the video. If you need one now, I have an automated spreadsheet with 5 intrinsic valuation models (including the DCF) available at my Patreon page. The link is in the description.
What is your thoughts on either of these two Dividend Kings? Let us know!
Thank you for the wonderful educational video. What is the best way to download all S&P500 stocks, with limited price value of ($30.00 to $60.00) on my spreadsheet? I appreciate very much for any help.
Thanks, I'm glad you found value in it😀 I think the best way to do that would be to get a list of all S&P500 tickers (you can get that on Wikipedia) and then import the stock data for each stock and thereafter filter the data. You can probably also use a script for this, but that is not something I have tried.
Thank you very much.
NP 😊@@nassersharafeddin2193
Another good tutorial!
Great tutorial 👍🏻
What is your favorite way to find the value a stock?
Im loading up on NVO, it will be the 1st 1T€ company
It is currently the biggest company in EU and the 13th most valuable company in the world. It will be interesting to see where it goes from here :)
They just aquired Catalent and partnered with Nvidia, the next 2-3 years and amycretin will make it a monster@@valuelytics
Why do u think that?
@@Viv8ldi Lots of reasons to post here, but mostly the success of Ozempic and the new GLP-1 drugs.
What is your thoughts on either of these two stocks? Do you think Tesla could be a good buy for the long-run? Let us know!
What is your favority method for picking the right stock?
What is your thoughts on either of these two stocks? Could Vodafone be a great buy for the long run? Let us know!
I have bought Eli Lilly couple days ago and now I lost almost 100$… do you think I should hold it or sell it because it‘s really high rated?
Thanks for your question :) I am not a Financial advisor, so I would not give advice to buy or sell any stock. But as you say Eli Lilly is really high rated at the moment compared to the intrinsic value. Therefore, it will probably depends on how long time you aim to hold the stock. Short-term I don't see much upside. But it is a good company (both companies are), so it could be fine for the long-term.
I got both stocks due to the two companies almost got the monopol for weight loss medicine and diabetes medicine. Novo Nordisk also seems to have new weight loss medicine to take over for the current medicine. Both companies will have a huge sales growing in the coming years and all over the world.
Agreed, but I think the current valuations also take that into account - Eli Lilly is trading at a P/E of over 130, which is really high. I think Novo's new pill for weight loss treatment could be a game changer compared to the current treatment with pen injections.
Both will have sales growing like crazy until 2032. The calculation does not take that into account.
Thanks for your comment. I agree in your first statement - both companies will have sales growing like crazy. However, both Grahams Valuation and Peter Lynch valuation takes that into account by incorporating a yearly growth rate of 20% and 50% for the two companies. The DFC model incorporates a yearly free cash flow growth of 20% and 30% going 9 years into the future (2033). So I think that the expected sales growth are taken into account :)
Interesting
Thanks, I'm glad you found it interesting :)
Great video. It looks like Eli Lilly is way to expensive at the moment, but I would have to take a closer look at Novo Nordisk as it is a great and interesting company.
Thanks :)
What is your thoughts on either of these two hyped defensive stocks? Let us know!
I just looked at their Q4-23 financials and ran some assumptions for a fair value assessment... The FCF for AMZN has been very volatile in recent quarters due to major capital expense projects.... there are a few different ways to interpret the future of AMZN's FCF. I looked at analyst estimates of their EPS going forward five years and they were well above 20% per year growth. Given what I think and trying to stay on the conservative side of things, here are my assumptions and results: Base Year FCF: 26B FCF Growth (first 5, years 6-20, perpetual): 19%, 8%, 2% Share Issuance (5 years, perpetual): 1.5%, -0.5% Margin of Safety: 25% Fair Value Price/sh at discount rates 5%, 10%, 15% and 20%, respectively: $270, $85, $50, $35 Since the current price is $177/sh, I see the expected (safe) return being only 7%-8%. To me, this isn't a great opportunity at the current price... And they have taken on a lot of debt, their FCF pipeline has question marks due to the capital intensivity. On the other hand, I can easily set the assumptions to derive an expected return of 9-10% ($30B FCF base, 22% NFY/ 10% medium term growth, +1% NFY shares growth and -1% perpetual share buybacks, 20% MOS). All that to say, it would take fairly wild assumptions to see Amazon returning Fair Value expected return of >15% at this price. 6/8 Pillars, 15/21 Subpillars.
If you would like a copy of the Intrinsic Stock Valuation Tool then click on the link 👇 where you can get access to this 🙂 www.patreon.com/user?u=78318634 And what is your thoughts on either of these stocks? Would one of them be a good buy for the long run?
If you would like a copy of the Intrinsic Stock Valuation Tool then click on the link 👇 where you can get access to this 🙂 www.patreon.com/user?u=78318634 And what is your thoughts on either of these stocks? Would one of them be a good buy for the long run?
If you would like a copy of the Intrinsic Stock Valuation Tool then click on the link 👇 where you can get access to this 🙂 www.patreon.com/user?u=78318634 And what is your thoughts on either of these stocks? Would one of them be a good buy for the long run?
If you would like a copy of the Intrinsic Stock Valuation Tool then click on the link 👇 where you can get access to this 🙂 www.patreon.com/user?u=78318634
If you would like a copy of the Intrinsic Stock Valuation Tool then click on the link 👇 where you can get access to this 🙂 www.patreon.com/user?u=78318634 And what is your thoughts on either of these stocks? Would Abibaba be a good buy for the long run at its current stock price?
i initiated a position in BABA, waiting until after earnings to either add more or do covered calls on what I currently have.
@@grahamjervis7176 It will be very interesting to see which way it will move after earnings the 14 of May. Im crossing my fingers for a positive outcome :)
How did you find table 9?
Trial and error. But it might be table 10 now. FinViz update their webpage reguarly so for some reason the table number cycles between 9 and 10. If 9 don't work try 10 :)
Brokie
Thanks for the comment! Investing time in stock analysis to go from Brokie to Stonkie 😄📈💰