Stock Analysis

I figured I should make it a little easier to see the results of my stock analysis reports by making a new spreadsheet compiling most of the data.  I will keep this as up to date as possible, but since I don't own all of the companies the dividend data might not get updated as quickly as needed.  There are also links to each company's stock analysis post to see the detailed results.



Full Page View

I will start incorporating the fair and high valuation price points based on the average of the historical P/E ratio, dividend yield, and P/S ratio.

7 comments:

  1. Great stock analyses! Surprised you're not in big Pharma though (PFE, MRK) any thoughts on the industry?

    ReplyDelete
    Replies
    1. Andy,

      Thanks! I owned PFE before but I closed the position because I don't really understand the drug trials. There's such a big potential for revenue and earnings to drop for the big drug makers due to patents expiring such is the case with PFE from the last few years. I feel it's too dependent on finding the next big thing. Kind of reminds me of the pure speculative tech companies.

      I prefer to get my healthcare exposure through companies like BAX, MDT, JNJ...of course I only have MDT in my portfolio currently.

      Thanks for stopping by and if there's any company you want me to take a closer look at I'll give it my best shot.

      Delete
  2. Hi

    How did you arrive at the average valuation price of a stock?

    ReplyDelete
    Replies
    1. Anon,

      The average valuation price is just using the average P/E, dividend yield, and P/S ratios of the last 5-10 years and applying to the current years expected numbers. Then I take the average of those 3. The analysis writeups provide much more clarification on the valuation techniques that I use. Thinking about it now, I should probably start incorporating the DCF and DDM models as well by assuming a high growth, average growth and low growth scenarios as well.

      If you have any other questions feel free to ask.

      Thanks for stopping by!

      Delete
  3. Recently, It's a elegant and wonderful website. I like your website surely. Thank's very much for this website. If want more informstion about stock ticker to visit stock quotes
    This stock quote data refers to the last price at which the stock you searched for was traded. This also refers to the price at which you might buy or sell the said stock. In a stock quote, the last price is usually delayed, meaning the data being currently put on display is 15 or 20 minutes old. Latest data can be acquired from financial advisors and brokers.

    ReplyDelete
  4. Wow you obviously know your stuff, while I understand the math behind your analysis I am afraid I am lacking in knowledge of how to use the data to make decisions on what to do with the stocks. Do you have suggestions of where I should start getting a better understanding of when you would buy/hold/sell stocks? I see the course you posted on the main page but I would like to get atleast a small foothold of basic knowledge before I would go looking into a full fledge course.

    look forward to following your journey!

    ReplyDelete
    Replies
    1. NoFuss,

      Investing, especially investment analysis, is as much art as it is science. I'm still pretty bad about timing my purchases as far as the ebbs and flows of security prices move, so I need to learn more about technical analysis to hopefully get better at that. The Ultimate Dividend Playbook by Josh Peters is a good book to give you an overview of the DGI strategy, but as far as exactly when to buy/hold/sell I'm not really sure. Since I'm in it for the long haul and intend to hold forever or until something changes with the company, if it's selling for a price I'm comfortable with through my research then I go on and purchase.

      Thanks for stopping by!

      Delete