Analysis Now Includes Spider Graphs

I find it much easier to see and understand graphs and lines rather than a row of numbers next to each other. I have to admit that my investing techniques still needs work. So in an effort to iron out some kinks, I will now implement a spider chart (Excel calls it a radar chart) when I analyze companies.

Here is an example. Note the difference between AeroGrow (AERO) (one of my many mistakes) and Coca Cola (KO).

See what I mean? There is a big difference between looking at notes and thinking about the business and actually receiving a visual representation.

Ratings and Metrics Explanation

The scale is from 0 – 5 where 0 is the worst and 5 is the best. Obviously, the bigger the area in the graph, the better.

A brief definition of the metrics used:

  • Best – 5
  • Good – 4
  • Average – 3
  • Below Average – 2
  • Bad – 1
  • Worst – 0

Under Valued: 5 is extremely undervalued and 0 is overvalued. KO has a fair value so it is 3 for average.

High Growth: 5 is high growth and 0 is no growth. I would say KO has an average to below average growth rate.

Low Risk: 5 is close to no risk and 0 is high risk of losing money. Risk could be in the form of one major customer, high debt, high inventory, unpredictable margins.

Well Managed: 5 is excellent company management with 0 being sleazy managers (Enron, Worldcom)

Good Financial Health: 5 is a company that generates excellent cash and strong balance sheet. 0 is a company with huge debt, overly issuing stocks etc.

Strong Moat: 5 is an impentratable moat with 0 being nothing more than a trickle.

(I think there was little confusion with the graphs by a couple of people. These are just my metrics. The whole point of the graph is to remind myself how I saw the company at that point in time. Just because it may be 90% undervalued, doesn’t make it a good investment. All aspects have to be considered and this is just a reminder not an indicator.

So far, I only have 6 metrics but I may add more if I think they are necessary.

Also, the metrics are what you make it. Everyone has a different perception of risk, health, moat etc so the point is to hopefully bring up ideas which could help you in your own analysis.

Take everything I do and say with a grain of salt.)

Disclosure

No positions in stocks mentioned at time of writing.

[tags] aero, ko, stock analysis[/tags]

More on this topic (What's this?) Read more on Spider, Coca-Cola Company at Wikinvest

You may also be interested in:

  1. Company Assessment, Checklist and Spider Graphs
  2. Stock Research and Analysis: Mastech Holdings (MHH) Part 2
  3. Cash Flow Statement Analysis: AERO
  4. Stock Research and Analysis: Mastech Holdings (MHH) Part 1
  5. SYY: Stock Analysis for Dividend Growth Portfolio

aero, ko, Stock Analysis Print Post Print Post

This post was written by:

Jae Jun - who has written 399 posts on Old School Value.

Value investor following the Old School Graham, Buffett and Fisher school of investing. Follow me on Twitter to receive real time thoughts and updates not available here.

Contact the author

7 Comments For This Post

  1. Miguel Says:

    Great Graphs,

    How do you make these graphs. Very interesting.

  2. Jae Jun Says:

    It’s just a radar graph in excel.
    Just create a table, then create a radar graph with the values. Very easy. :)

  3. Singapore Recession Says:

    what you did is great!
    It provides a helicopter view of a company.
    Like what you said, everyone has different perceptions on these, so it may be better to just it to compare the business against business in similar industry.

    Ren

  4. Tim Says:

    Great way of representing the data!

  5. stockmanmarc Says:

    The visual is a great way to present the data especially using 2 companies like you did in your example

  6. Yuva Says:

    decision is still based on values not based on representation(of any particular shape) right.!? meaning any best case/shape , worst case/shape.. to read quickly without watching details.!?

    Yuva’s last blog post..Low inflation vs. No inflation vs. Deflation

  7. Jae Jun Says:

    The decision is still based on values but the graph tells you what type of company it is. Its a good reference to check once in a while.

    You wouldn’t want to invest in a company that has the shape of aerogrow though.

2 Trackbacks For This Post

  1. Warren Buffett Stock Pick Portfolio | Old School Value Says:

    [...] Coca Cola (KO) [...]

  2. Investment Book Review: Active Value Investing | Old School Value Says:

    [...] part goes through the QVG (Quality, Value, Growth) framework. It’s very much like my own spider graphs, but simplified with three [...]

Leave a Reply

CommentLuv Enabled

Search engine optimization by SEO Design Solutions

32 queries in 0.683 seconds.