I was recently asked to for a copy of the tracking sheet I mentioned in an earlier post. I have uploaded it in the google groups (see here). It is a very simple tracking sheet with intrinsic value for each stock noted in the sheet to prevent me from focussing too much on the current price or cost.


A few key points on how I use the tracking sheet
–        I regularly compare the current price with my estimate of intrinsic value (column B). If the discount (column F) is 30% or more and I have confident about the company, I will add to the holding. Conversly if the stock sells above the intrinsic value, I will start selling.
–        I tend to check the quarterly and annual reports to see if there are any reasons for me to update the intrinsic value of the company (for better or worse).
–        My focus is to ensure that current value of the  portfolio (B19) is at a discount of 30% or higher from the total intrinsic value (B18). This ensures that I am selling overvalued stocks and looking for or buying undervalued ideas. The idea is to ensure that the portfolio does well and there is an upside in the form of undervaluation.
–        I also have dividend for each stock on the spreadsheet. I am not too focussed on it, though I like to track the value for each stock and for the portfolio as a whole.

I use the above spreadsheet to drive my buy/ sell or hold decisions and to anchor my thinking to the intrinsic value, rather than the cost or current price. As you can see, there is nothing fancy about the spreadsheet, its as dumb as it can get.

Disclaimer : Please do not read too much into the stocks listed on the spreadsheet. The above list may not be a true representation of my current holdings.


  1. Puneet Vyas says:

    Hi Rohit,

    You are doing a sterling job with these posts. I’ve learned a lot from your posts.

    Just a quick question : how do you come up with the intrinsic value of a stock? Could you shed a little light on that – is that more of an art than a science. Even small pointers will help.

    Again, thanks for your efforts. Since I have now started analyzing the stocks before investing , I get greater satisfaction when that stock does well. I feel as if I’ve earned it 🙂 This is because of you. Many thanks,


  2. admin says:

    Hi puneet
    thanks for your comment. I have addressed the question of computing intrinsic value of a stock via various posts. i would recommend you to use the search option on the blog and use the key work ‘intrinsic’. in addition, i have uploaded several spreadsheets in the google groups where i have calculated the intrinsic value for the stock
    hope this helps

Leave a Reply