Analysis Explained

Here are the explanation for the data that I collect and the key figures that I am extracting.

Key Figures

P/E (the P/E is based on the last years earnings from the annual report and the price is from the date when I analyse the stock. I love when this value is below 10)
P/B (I like to look at Price/Book since I want to buy 1 euro of stock for ideally 50 cents! So I want this value to be below 1.)
P/E*P/B, <22.5 (This is a formula from Graham and anything below 22.5 is a strong buy!)
P/S (Price/Sales might give a branch indication)
E/S (Earnings/Sales will be branch oriented but also shows how heavy costs they have)
E/B (Earnings/Book... I do not look at this)
ROE, % (The return on equity meaning how well does the company transform the shareholders equity into profit, ok is above 10, 15 is good, any value above 20 is great and well above 20 is excellent)
Book/Debt (To see how much in trouble they are)
Exp Growth, % (this value I add myself usually similar to the calculated CAGR)
CAGR, % (I try to go five years back and see the revenue back then and today and then I calculate the yearly growth since then)
Lynch 3Y of G (Peter Lynch easy formula to buy stock if the P/E of stock is below its expected 3 year growth then it is a strong buy also indicates when one should start to think about selling)
P/E=8.5+2*G (Grahams formula that indicates what the P/E of a company should be if much less then it is a strong buy on the company)
R&D / E, % (Someone once said that 40% of a companies earnings 5 years from now are coming from products currently being developed. Don´t know if that is true or not but being a researcher myself I can see some truth to it and therefore want to measure the technology companies according to this one. Already now I can say that I was very surprised by some results that came out)
Stock Yield, % (want to see dividend I am getting. I like dividends!)
Yield/Earning, % (Are they sending out more money than they earned? If so where did that come from and how many years can they do that before they must borrow money to keep up with the high dividends?)

Collected Values

Currency (only to keep track of what it is in)
Price, Share (the stock price that day. I will indicate that for the stock when I publish the table)
Shares, M (the amount of shares in the company)
Sales, M (The sales or revenue that they had)
Sales, Share (Sales they had per share)
Earnings per Share (EPS, is last years profit per share)
Book, M (the book value of the company)
Book, Share (how much that is per share)
Debt, M (the debt that the company has)
R&D, M (the research they are making)
V(tn) (The coming three things are for the CAGR calculation, V(tn) is final year sales, V(t0) is the "first year" sales and then tn-t0 to get the amount of years involved for the calculation.
V(t0)
tn-t0
Dividend (the money they pay out)
Comment (usually this is for me complaining on how they use a broken financial year or only full year. I also mentioned if the analysis was requested etc.)

 

No comments: