저자: 미상 · 외국인
요약 보기
브라질 주식 저평가 스프레드시트 v11.0 홍보 영상. Décio Bazin, Benjamin Graham, Peter Lynch PEG, Joel Greenblatt 마법공식 4가지 방법으로 자동 순위를 산출하며, 배당수익률·유동성 등 파라미터 설정과 관심종목/블랙리스트 기능을 소개. 개별 종목 가격 방향 예측 발언은 없음.
다듬은 글
Hey everyone, how's it going? Bringing you the updated version of our spreadsheet of the cheapest stocks on the stock exchange. This spreadsheet is version 11.0. So, if you've already purchased one of the previous versions, you'll receive this new version for free via WhatsApp. And if you purchased through Hotmart, simply log in to your Hotmart account and download this new link, okay?
This spreadsheet keeps updating automatically, so all analyses will always be up-to-date. I'll talk a little bit about the spreadsheet for those who are n't familiar with it. And if you don't already have this spreadsheet and would like to purchase it, I'll leave the link in the video description. So, let's go.
This spreadsheet will analyze all stock market actions using four analytical methods: the formulas of Decio Bazin, Benjamin Graham, Peter Lynch, and the Magic Formula. So, the first analysis is that of Décio Bazin. How does Bazin calculate the ceiling price for a stock? He takes the income paid over the last five years, calculates an average, and divides it by 6%.
After this calculation, it provides the fair value of the stock. So, this spreadsheet will automatically provide a ranking of the stocks that are most undervalued. So, the Sine 3 has a fair value of 42 reais and is currently quoted at 4.39. Petrobras, fair value 116.26, current value 40 reais. So, it's going to be a ranking from the most discounted to the least discounted.
Remember, all this data is updated daily. So, this spreadsheet will automatically pull the last 1,825 days, calculate the average dividends paid during that period, and perform the Décio Bazin calculation to arrive at the fair value. So, this is a very complete, fully automated spreadsheet that will definitely help you a lot when calculating the ceiling price using Bazin's formula.
The other analysis is Benjamin Graham's analysis, which calculates the stock value by taking the square root of the book value per share and the EPS, earnings per share. So he takes the square root of those two values, times 22.5, takes the square root of that equation, and arrives at the correct value, okay?
So here, whenever new financial statements are released to the market, it will calculate the book value per share (BVPS) and earnings per share (EPS) of each company, perform this calculation, and automatically provide you with the fair price. It will also calculate the safety margin. In this spreadsheet, if you look closely, it also shows the average dividend yield for the last five years .
In the previous version, it only showed the dividend yield for the last 12 months, okay? It brings the PVP and also the trend. This trend has been observed over the last 30 days. The third analysis is Peter Lynch's analysis. How does he do the calculation? He takes the company's P/E ratio and divides it by a growth rate.
The growth rate we are using is the average growth rate over the last five years. So here you will also see the companies with the biggest discounts, from the most discounted to the least discounted. It's worth remembering that in Peter Lynch's analysis, companies with a PEG ratio below one are considered undervalued.
Anything above one is considered at its fair value, and anything slightly above two is considered overvalued, so it wouldn't be a worthwhile investment. The fourth and final analysis is that of Joel Greenblatt, known as the magic formula. Here, the author uses EV EBIT and ROIC to generate two rankings.
The companies that score highest in these two rankings end up generating this final ranking, which is from the most discounted companies to the least discounted according to Joel Greenblatt's formula . And here at the end is the blacklist, which are the stocks you don't want to appear in the analyses.
Let's suppose here, let's use this as an example, ah, I'll say that I don't want to watch VBBR, Vibra, okay? I'll put it here. You'll see that it automatically disappeared; it was here on that first line, and then it vanished. If you want to edit it, just delete it and it will come back, okay? Here I've listed some that are registered.
I usually list the common shares here so they don't appear alongside the preferred shares. And in the watchlist column, you can register the assets you want to track. Let's suppose I want to track VBBR3. It will automatically be highlighted in all four analyses, okay? And here you can delete and add the actions you prefer.
Up here is the parameters tab, where you can set the minimum dividend yield, okay? Ah, I just want to see companies that pay above 8%. Okay, you take this, put in 8%, and the spreadsheet will automatically show only the stocks that pay 8%. Daily liquidity, oh, I only want companies with daily liquidity above 1 million.
You put 1 million here. Only companies with daily liquidity above 1 million will appear. Basim rate, you can change that too, and Graham rate, the same thing, you can change that as well. I'll leave it here at the zero setting, so that all companies always appear. When you purchase this spreadsheet, you will be able to make a copy of it.
So, how do I make a copy of this spreadsheet? You will click here on file, make a copy. Once you make that copy, you'll be able to edit all the parameters, okay? And the spreadsheet will continue to update automatically. If you'd like to purchase this spreadsheet, I'll leave the link in the video description.
Payment is a one-time fee, and access is lifetime. If you enjoyed this video, please give it a like and subscribe to the channel. Hugs. I went.
Comments 0