This file is a combination of 2 parts: 1. Price check, in which you can use multiple pricing methods to identify the fair value of the stock price (or company intrinsic value) 2. Financial Health Check, in which you can evaluate multiple criteria of the company from their Financial report like Income Statement, Balance Statement, Cashflow Statement, etc.
***Note: When you access the file, you might see all errors, which means the extension is expired. But don't worry; just make a copy and install the extension, and it will automatically activate the trial for you to use. Then, all formulas will be restored to normal :D.
hello everyone have you ever wanted to buy a stock from the company
that have the durable competitive advantage for 10 or 20
years or at least you want to find a company that have the price
that are undervaluated or at least you just want to know that whether you
should buy the stock from that company whether the price you buy is undervalued
or overvalued so that's it this session is for you and also this
file is also built in for all of you because I am the one
again I am I'm free uh and I am the value
investor I just want you to share this file with all of you because
all of the things I learned from the past and also based on my
experience when I do the investing I just want to share this file with
you and I hope that back again you guys from your knowledge you can
also share back to me so that together we can build this file better
and also can provide better for anyone that want to do the to become
the value investor. Why I decide to do like that?
Just not because I am the one that want to find some uh stock
that I can keep for 10 or 20 years and I think that most
of people don't like this methodology and even like most
of the don't want to have like. Most of people they love to buy
the stock in today and tomorrow they get the high price and then they
sell it. I am not that kind of investor or in a normal term
that I am not the uh technical investor.
Uh that is uh I don't that's why I don't like to look at
to the market. Every day look at to the dashboard every day and to
find and to buy the stock based on the technical uh
candle techniques something like that right.
So that's why I love to do the investing to generate for
me the best invested income or at least I know that if I keep
that stock price. For 10 or 20 years I will gain back after 10
and 20 years and that's why I come out with this file and I
also want to share it with all of you for anyone that also love
to do the investing like that or at least you just want to find
the good price to buy some This is also for you and this
file is combined by two parts and the first part is the price
check that is the thing I think that no matter you are
the value investor or you are the technical investor you always want to
find the good price to buy right so first
part of the example I share to you is the price check to help
you to figure out the yellow spot and also at least to find the
range between the red line and the green line or we can say margin
of safety so that means you want to buy the stock price that
are under value uhm and you want to to get the benefit
from the uh price you buy and the price in the future right or
in another term is that buy the price that are under their fair value
so that when the market reflect the price you will get the benefit
from that and another term is that you want to avoid any
of the company that are over value so that means that the price is
super high and even exceeds their intrinsic or their
fair value so that you don't want to have and the first
part of the excel file is do this for you.
and the second thing is part is based on the Warren Buffet philosophy
and also the thing that I mentioned before durable advantage company
that means I want to use this file to figure out like
what is the durable company that can exist
and also generate the the profit in 10 or 20 years and
I based on the philosophy of Warren Buffet and especially I
based a lot of the knowledge and also build up my file
for that checking based on this book of Warren Buffet.
Uh the interpretation of financial statements.
Of course, this is not his book, this is his uhm doctor-in-law
uh writing down Mary Buffett.
So she uh is the one that quite close to Warren Buffet
and she writes this book and I also based on this book to read
the financial statement like balance statement,
cash flow statement. Income statement and together I built up the excel
file for all of you so that you also can use it to do
the check so that you can decide like you want to buy it or
you want to keep it or not. So this is two part for you.
And as you can see here, uh I will go deeper.
I will dive into the file and to show you how you can identify
the price like this. After the end,
after you input everything here,
you will get the price estimated for you to buy.
And then you will decide whether to buy it or not.
And moreover, when you want to keep to go deep dive into like the
price is too high and whether should I buy it.
So then we will go to the durable company check
like or another term I use here is financial evaluation to decide whether
I want to buy it even this is the at the high price and
this is also the also the method of the buffet because
some like for example for the cork he know that the time he
buy the cork the cork is ah overvalued by the market
and by the most of the professional and also the ah analysis
and also the master investor.
at that time but warren buffet know that the coca cola is
the one that he overvalued but he still buy it why
and this is the one that can answer that of course ah just ah
disclaimer here is that my find is not perfect and also all the calculation
here is just the estimation based on all of the kind of the methodology
I applied to it and also the way that I do the financial evaluation
also based on my knowledge and also based on my experience
so nothing ensure that when you follow this file and when you based
on this calculation or this checklist you will 100%
sure can win the market no I please do not take it
wrong with my file I just want to ensure that you you you can
have this file to help you make a better decision and finally it's all
depend on you so hope to see you again in the next video
so that we can deep dive into how to use the file and what
we can together to build up this file become better thanks a lot and
see you in the next video