Re: performance reports & column totals

[ Message Board ] [ Archives ] [ Search ]

Posted by Mark on March 21, 2007 at 10:48:12:

In Reply to: Re: performance reports & column totals posted by chris on March 21, 2007 at 09:18:49:

: Mark - sorry I wasn't more clear in my question. The columns to the left do total correctly. What I'm referring to are the columns to the right of the divider, %Gain-I, %Gain-V, Yield. For example, portfolio has 4 investments with %Gain-I of

: beg value end value gain %Gain-I

: 4,678.51 4682.41 3.90 .08
: 8,753.31 8,774.62 21.30 .24
: 8,426.90 8,774.62 346.46 4.11
: 122,492.08 122,341.41 -150.67 -.12

: 144,350.80 144,571.81 221.00 .15 totals

: I don't understand why the # is .15 instead of 4.31.

:
: Thanks, again.

Hi Chris,

The numbers to the right of the divider are all percentages, and those don't directly add up. The portfolio based percentages are calculated by summing up the value components for all the investments, and then calculating the percentage for the portfolio. You can think of these as being value weighted, so not all of them add fully, they add proportional to the value of the investment.

As a simple example, if you had a %Gain of 10% on a $100 investment, and a 1% gain on a $10,000 investment, the portfolio %Gain will be much closer to 1% than 10%. It will not be 11%.

Thanks,
Mark
--
Fund Manager - Portfolio Management Software

Replies: