What a year 2009 was? At the beginning of the year, the stock market was trying to find how deep the abyss was. Every other participant in the equity market was trying to run away like there was no tomorrow. Fast forward to second half of the year. The story changed and now the stock market is trying to find its peak. It was in true sense a roller coaster ride.
When the equity market goes up like it did in later part of the year, it gives a false sense of confidence in our abilities to pick stocks. Irrespective of what one thinks, any company stock you had touched in second of 2009, it has zoomed. It really did not matter which company stock it was! Lately, I have seen quite a bit of emails trying to point me towards how the stocks that I negated (or did not pick?) have zoomed up and made them money. I do feel happy for everybody who made good money in 2009. I wish you had shared those winners with readers of this blog. We all want to make money here. Right? Continue reading rest of this article…
In an earlier post, I mentioned that I use XIRR as one of the metrics for measuring the individual stocks performance in my portfolio. In simple terms, XIRR is the interest rate you would need to make the same money from any interest bearing account (with same investments). While XIRR can be extended at portfolio level, in today’s post, I am only discussing how I use XIRR at individual stock level.
I have pulled out one excel sheet [copy is in my toolbox at TIP-Stock-Tracker] as a representative example for this discussion. The primary notion behind this excel sheet is to keep records and track the performance. It is not intended “to model an automated tracker” or “to perform any automated calculation across the board”. Except XIRR, I have used only few basic math formulas like addition, subtraction, divisions, multiplication, and percentages. In order to understand the formula, I suggest to use formula auditing tool bar (which will show arrows to linked cells) to understand the formulas. This excel is segregated into different regions.
Continue reading rest of this article…
Measuring Progress – XIRR as Personal Rate of Return
In this context, I use few different monitoring and/or performance metric. Earlier, I have talked about yield on cost as one metric to determine cash flow (or dividends) received from my original investments. YOC is a very good metric to measure the growth of your dividend based cash flow over a period of time. However, it has a drawback. It does not take into account the variability of capital invested. The price of the stock does not remain static. It keeps changing over a period of time.
Continue reading rest of this article…