Re: Portfolio Performance Report

[ Q3 01 - Q1 03 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Re: Portfolio Performance Report posted by Mark on November 19, 2002 at 21:11:13:

OK--I follow the explanation and it seems to make sense for the total numbers of a portfolio. However, it gives a distorted view for individual securities. For instance, (in this market especially), it is very possible and likely to have securities where distributions have been re-invested (which to me changes the cost basis;-neglecting long and short term gains)and have the performance report that gains exist while actually the present value of the security minus the total investment shows a loss. There must be a better way to present this in portfolio performance so that the individual security gain or less show up more easily from the total invested plus re-invested distributions. Can it be done via a custom report?
Hi Barry,

: This report is trying to show cash flow in/out of your pocket. Reinvestments
: are included in the ending value, for gain calculations, but the money
: for the reinvestment did not come out of your pocket, so is not included in
: the "Invested" column of this report. The "Gain" is based on how much money
: you started and ended up with in the investment, as well as how much came
: out or went into your pocket. Here are some details on the first columns:

: Beg Value:
: The market value of this investment at the start of the beginning report date.

: Invested:
: Out of pocket contributions made by the investor. The sum of all purchases
: minus all redemptions within the specified date range. (Does not include
: reinvested distributions.)

: Distrib.:
: Sum of any received distributions during date range. Does not include
: reinvested distributions. Includes distributed distributions from the
: starting, through the ending report date.

: End Value:
: The market value of this investment on the ending report date.

: Gain:
: The value gained by this investment for the specified time period.
: (Gain = End Value + Distrib. - Invested - Beg Value)

: Thanks,
: Mark
: --
: Mark Beiley
:
: Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP
: /XP
:

: : Why don't distributions that were re-invested show up as invested? It appears that they show up in the gain column, which then gives a distorted view of gains vs. cost basis. How can a report be set up to give a more accurate picture of gains and invested amount for cost basis?

Replies:

• Re: Portfolio Performance Report Mark 20:06:40 11/25/02 (0)