profile image
Could you perhaps explain which functions you use for this in Excel or from where you get your calculation bases?
2
profile image
@Hannes_SK hi...so my methodology is an adaptation from various sources. Among other things, it is based on books about the method of Warren Buffet and Phil Town (Rule#1). The whole thing is based on the 4 M's. Meaning....I invest in my satellite positions only in companies that have a meaning for me. This is the very individual part of the consideration. Moat...The moat that can be measured by many factors, so to speak. What kind of moat do we have? How deep is it? Can it be fundamentally proven? Management....who is the CEO? How long has he been there? Does he treat his company as if it were the family's only property for 100 years? These are the questions I ask myself at this point Margin of Safety (MOS)...at what discount can I buy the company compared to the MSRP determined. Usually this is 50%. To good last I analyze the respective financial statements of the last 10 years and check the listed ratios, so that these correspond to my requests and over the last few years are steady or growing. This then results in a forecast for the growth of EPS on a number of years (usually it is 10 years as an investment basis). Then the question arises how much this future EPS is worth today and with which MOS I can acquire this... I hope this explanation helps you further.... Maybe I will explain my methodology in more detail...if there is interest. It is my current approach and I am open for discussion. Because that's what we here at Getquin draw our insights from to make better investment decisions, isn't it? The exchange with others is important in this respect.
8
profile image
@Mi-t-chel Sure, just make a separate post about it. I have heard about the methodology, but I would be interested in the functional basis for it in Excel.
6