I have to apologize to the board, and the people involved. I was so preoccupied with other issues the last couple of days that I let a thread go on for 15 posts or more, with people struggling to understand how to calculate their portfolio returns to allow for money added or removed from the investing portfolio.
The method I recommended in the Knowledgebase is so incredibly simple, logical, and easy to understand that it will take you just a single read through to understand completely. It’s trivially easy to use. Here it is. Again, I’m sorry I was so preoccupied with other things and didn’t give it to Jim and to you all earlier. And please read the Knowledgebase!
And this is OT, so please email me off-board if you have any questions or comments.
Here’s how to calculate your overall returns ignoring cash flow in or out. Say you start the year with $14,000. You want to equate that with 100% and calculate gains and losses from there. So you ask yourself “What number (factor) would I multiply $14,000 by to get 100?”
By simple arithmetic we have 14000 x F = 100
And thus F = 100/14000 = .0071428
Sure enough 14,000 x .0071428 = 100
Now say three weeks later you have $14,740 and you want to see how you are doing, you multiply that number by .0071428 and you get 105.3 (so you are up 5.3%). If you don’t add or subtract money, that factor will work for the whole year.
Now say you add $2300 of fresh money, but you don’t want that to screw up your estimate of how well you are doing.
You add the $2300 to the $14,740 and get $17,040 which is your new balance that you are investing with. That’s your new starting point. It doesn’t affect how you’ve done up to here. You haven’t suddenly done better because you added money. You can’t still multiply by .0071428 because you’d get 121.7 and it would look as if you were up 21.7%, when you are really only up 5.3%.
So you need to change your factor to make it smaller so it will still reflect just the 5.3% gain you’ve made so far. You figure: “What would I multiply my new balance ($17,040) by to get 105.3, to reflect my 5.3% gain so far this year?”
F x 17,040 = 105.3
F = 105.3/17,040 = .0061795
And that’s your new factor. If you multiply it by 17,040, sure enough you get 105.3. Now you continue to see how you will do for the rest of the year.
If a little later you are at $18,000, you multiply 18,000 by .0061795 and you get 111.2, so you know that your investing is now up 11.2% for the year.
Same, if you take money out. You don’t want it to look as if you lost money. You calculate a new factor so you start from the same percentage where you were.
On January 1st of the next year, you write down how you did for the year to keep a record, and start over at 100 for the next year.
That’s all it is. Simple as that.