Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Re: Performance Report

[ Message Board ] [ Archives ] [ Search ]

Posted by SPS on April 26, 2007 at 19:41:34:

In Reply to: Re: Performance Report posted by Mark on April 26, 2007 at 18:10:26:

Mark,

From the snapshot I've provided invested amount is 3990, and my account value now is 4378.00. With a $10 fee, appreciation in the Gain column is 378.56. So far so good, here is how I came up with ~9.5% ..

378.56 * 100 / 4000.00 = 9.456%.

I kind of see where you were coming from in terms of %Gain-I. May be it is displaying the average or weighted average of all my funds in that account and the number that it displays (3.66) make sense. However, what I'm looking for here is the performance of that account (or sub-portfolio) which is 9.456%.

I'd like to emphasize that there is only one fund, Fund 3 open in that account. Also, at any point of time there is only one fund in that account. So conceptually I sold Fund 1 at a gain and used that capital to buy Fund 2 and eventually bought Fund 3 selling Fund 2 (for a gain).

May be %Gain-I doesn't give me what I was looking at (?). Is there anything else that could give me the performance of the sub-portfolio based on what I explained above.

Thanks,

- SPS

: : I'm little confused about 'Portfolio Performance' reports. I'll explain this with an example ..

: : Here is a snapshot of the performance report related to one of my accounts:

: : ------------------------------------------------------------------
: : Inv. Name--Beg Value--Invested--Distrib--End value--Gain--%Gain-I
: : ------------------------------------------------------------------
: : Fund 1 | 0.00 | -119.94 | 0.00 | 0.00 | 119.94 | 4.00
: : Fund 2 | 0.00 | -114.58 | -10.00 | 0.00 | 104.58 | 3.35
: : Fund 3 | 0.00 | 4224.52 | 0.00 | 4378.56 | 154.04 | 3.65
: : ------------------------------------------------------------------
: : Account | 0.00 | 3990.00 | -10.00 | 4378.56 | 378.56 | 3.66
: : ------------------------------------------------------------------

: : I'm actually confused with last column (bottom-right) where it shows Account %Gain as 3.66%, which actually should be some where around 9.5%. Am I missing something here?

: : Note: As you can observe from the above snapshot I have sold Funds 1 and 2 and I only have Fund 3 in this account. Also, at any point of time I had only one fund in this account -- meaning, I bought Fund 1 and sold it to buy Fund 2 and after a while sold Fund 2 to buy Fund 3.

: : Thanks in advance,

: : - SPS

: Hi SPS,

: How are you calculating the ~9.5%? You cannot directly calculate the %Gain-I from just the numbers shown in this report. Given that your 3 investments are all between 3 and 4 %, it seems reasonable that the whole account is 3.6%.

: The %Gain-I is:

: (End_Value + Redemptions + Distributed_Distributions - Purchases)/Purchases

: where "Purchases" is the beginning value, plus any money added into the investment/account out of pocket (not including reinvestments).

: If you'd like to delve more into the calculation, you can create a custom report with these fields:

: Value (beginning)
: Purchases (between)
: Reinvested distributions (between)
: Redemptions (between)
: Distributed distributions (between)
: Value (ending)
: %Gain-I (between)

: To get the "Purchases" from the %Gain-I equation you would add the beginning value, purchases, and subtract the reinvested distributions. The "Purchases" in this custom report field includes reinvestments, which aren't included in the %Gain-I's purchases field, which is why they need to be subtracted off. Also, if you paid any commissions this will cause a slight difference.

: Thanks,
: Mark
: --
: Fund Manager - Portfolio Management Software



Replies:


 

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy