Re: Portfolio Performance Report

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

In Reply to: Re: Portfolio Performance Report posted by Barry Smith on November 25, 2002 at 15:13:05:

Hi Barry,

The custom report has many different fields to choose from, so I think you
can find what you're looking for. When choosing the custom fields you can
choose the "Help" button to see a description of all the available fields.
If you have any questions on any, or are looking for something that isn't
there please let me know. You may also want to make use of the feature
to memorize your report, once you get it how you like it.

Thanks,
Mark
--
Mark Beiley

Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP
/XP

: 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: