In microsoft.public.money, Myrna Larson wrote:

- quote -

I never was able to see that symptom in the Portfolio where I was
looking. I also have not found a "YTD return (in dollars)". I think
you may have been looking at the "Performance by investment account"
report or other report. I do see a difference in the "Return for
Period" column for your example between Money 2006 (says
120.00=wrong) and Money 2007 (says 60.00=right).

I have this same problem in 05 but on the portfolio screen with valuation as
the view. Did you ever find the solution. I asked my question above and
someone indicated to use buy instead of reinvest. This solved the problem,
but it isn't really true as I am not buying, I am reinvesting.



"wnmoore[at]bellsouth.net" wrote:

- quote -

Unfortunately, I want to see my dollar gain YTD on my investments. The only
reports I can see which will do that are the ones in the Reports section.
As soon as I enter dividends, the dollar returns YTD are wrong. I think
Microsoft should correct this glaring error with a program patch. In the
meantime, I'm uninstalling Money 2006, and using the 2004 version.

Nate Moore

"Myrna Larson" <anonymous[at]discussions.microsoft.com> wrote in message
news:uu32p1hb5packg0niecqt552ion0u2064m[at]4ax.com...
- quote -

FWIW, the numbers on the Portfolio Manager screen are correct. Maybe one of
the views there will be sufficient. Unfortunately, I haven't found one that
let's you specify a starting date, as you can with the Performance reports.

On Thu, 1 Dec 2005 07:28:42 -0500, "William Moore" <wnmoore[at]worldnet.att.netwrote:

- quote -

I just upgraded from Money 2004 to Money 2006 and am having the same problem
with the Performance by Investment Account report. In the Return for the
Period column, the stated dollar amount is twice what it should be. I came
to this forum to find a fix or work-around. Money 2004 handled the data
correctly. I regularly use the report that now incorrectly reports dollar
return. If I can't find a fix, I'm going back to Money 2004.

Nate Moore

"Myrna Larson" <anonymous[at]discussions.microsoft.com> wrote in message
news:t5mno1hp7v0633v3jmffdu7rp2ar29p9sv[at]4ax.com...
- quote -

In microsoft.public.money, Mark wrote:

- quote -

D'oh!!! I missed entered the date on the AAtest case. That explains
it.



- quote -

The reason that the annualize number was different is because you used Jan
31 as the initial Buy date for aatest. Try changing it to Dec 31 (as it is
for bbtest).

-Mark

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:bkjno1dpq4sgbp1uk2rj27h4vhvdvkqck8[at]4ax.com...
- quote -

If you talk to MS, tell them it would also be nice if they learned how to
handle Return of Principal transactions when calculating rate of return. Right
now, they ignore them, so I can have an investment that shows a positive
dollar return and a negative annualized rate of return. That makes the program
look a bit ridiculous, no?


On Mon, 28 Nov 2005 22:21:56 -0600, via_newsgroup[at]please.tnx(Cal Learner--
MVP) wrote:

- quote -

I hope you, as a Money MVP, may have a bit more luck than I have had in
convincing MS that these are bugs, they need fixing, and the long-standing
presence of these bugs reflects poorly on Money and on MS's attitude toward
the product.

On Mon, 28 Nov 2005 22:21:56 -0600, via_newsgroup[at]please.tnx(Cal Learner--
MVP) wrote:

- quote -

In microsoft.public.money, cndesu wrote:

- quote -

In Myrna's example, what would you want the Gain to be?

Sorry, it's not the Portfolio Manager screen. It's a couple of the reports.

(1) Performance by Investment Account: the column that shows $120 is entitled
Return for Period. The % Rate of Return is 5.66%, Annual % Return is 6.00%.

(2) Performance by Investment Type: Return for Period is again $120, but now
the Annual % Return is 6.62% !!

(3) Portfolio Manager correctly shows a gain of $60, TR/All 5.7%, Ann return
6.6%.

I can't believe they really have multiple routines for calculating these
values, but it sure looks that way.


On Mon, 28 Nov 2005 21:34:33 -0600, via_newsgroup[at]please.tnx(Cal Learner--
MVP) wrote:

- quote -

In microsoft.public.money, Cal Learner-- MVP wrote:

- quote -

I created aatest as a stock, and you had specified mutual fund in
Money 2007 Premium. I went back and duplicated the test for a fund
named bbtest.

While the numbers I posted for Gain and TR YTD work out the same, an
anomaly stands out: The "Ann. ret." column shows 6.6% for the bbtest
(mf) and aatest shows 3.4%. That 3.4% number is clearly low. Those
transactions are represented in aabb.qif below.

I duplicated the tests again, this time creating aa2test as a stock,
and bb2test as a mutual fund. Instead of Reinvest Dividend, I did a
Dividend and a Buy separately. Those transactions are represented in
aabb2.qif below.

Here is a QIF for the investments if somebody wants to duplicate
this in a test file without typing the transactions:

==========================begin AABB.QIF================
!Type:Invst
D01/31'04
T1,000.00
NBuy
Yaatest
I10
Q100
^
D12/31'04
T1,000.00
NBuy
Ybbtest
I10
Q100
^
D03/15'05
T20.00
NReinvDiv
Yaatest
I10
Q2
LDiv Income
^
D03/15'05
T20.00
NReinvDiv
Ybbtest
I10
Q2
LDiv Income
^
D06/15'05
T20.00
NReinvDiv
Yaatest
I10
Q2
LDiv Income
^
D06/15'05
T20.00
NReinvDiv
Ybbtest
I10
Q2
LDiv Income
^
D09/15'05
T20.00
NReinvDiv
Yaatest
I10
Q2
LDiv Income
^
D09/15'05
T20.00
NReinvDiv
Ybbtest
I10
Q2
LDiv Income
^
==========end AABB.QIF============================

================begin aabb2.qif=========================
!Type:Invst
D01/31'04
T1,000.00
NBuy
Yaa2test
I10
Q100
^
D12/31'04
T1,000.00
NBuy
Ybb2test
I10
Q100
^
D03/15'05
T20.00
NDiv
Yaa2test
I
Q
LDiv Income
^
D03/15'05
T20.00
NBuy
Yaa2test
I10
Q2
^
D03/15'05
T20.00
NDiv
Ybb2test
I
Q
LDiv Income
^
D03/15'05
T20.00
NBuy
Ybb2test
I10
Q2
^
D06/15'05
T20.00
NDiv
Yaa2test
I
Q
LDiv Income
^
D06/15'05
T20.00
NBuy
Yaa2test
I10
Q2
^
D06/15'05
T20.00
NDiv
Ybb2test
I
Q
LDiv Income
^
D06/15'05
T20.00
NBuy
Ybb2test
I10
Q2
^
D09/15'05
T20.00
NDiv
Yaa2test
I
Q
LDiv Income
^
D09/15'05
T20.00
NBuy
Yaa2test
I10
Q2
^
D09/15'05
T20.00
NDiv
Ybb2test
I
Q
LDiv Income
^
D09/15'05
T20.00
NBuy
Ybb2test
I10
Q2
^
================end aabb2.qif=========================

In microsoft.public.money, Myrna Larson wrote:

- quote -

I created an investment named aatest. I entered the transactions
using your example. I show Gain=$60 and Price Appreciation shows
blank=0.

TR YTD shows 5.7%. Is that the column you are using?




- quote -

I am seeing the same thing in US Money 2006. Reinvested dividends are not
handled correctly. Enter the following transactions:

12/31/2004 Buy 100 shares of a mutual fund [at] $10.00 = $1000.00
03/15/2005 Reinvest dividend of $20, share price $10.00, = 2 new shares
06/15/2005 Reinvest dividend of $20, share price $10.00, = 2 new shares
09/15/2005 Reinvest dividend of $20, share price $10.00, = 2 new shares
11/28/2005 Share price $10.00, share balance 106 shares, value $1060.00

Income for the period is $60.00. Price appreciation = 0.

In Portfolio Manager, look at the YTD return (in dollars), Money says it's
$120. It seems to be disregarding the additional investment of $60.

I calculate the dollar return as

[Sum of Outflows] - [Sum of Inflows] + Current value, i.e.

$60 - ($1000 + 60) + ($1060) = $60

It's a good thing one can export a report to Money and do the calculations
correctly!

On Mon, 28 Nov 2005 13:20:03 -0800, cndesu <cndesu[at]discussions.microsoft.comwrote:

- quote -

Actually I have Money 2004 Canadian version
--
Chanikya


"Cal Learner-- MVP" wrote:

- quote -

Purchases is I put money and bought. Which exactly means I payed forit.
Reinvestment is RSP plans(in Canada) the dividend is not paid directly to me
but instead they(portfolio managers) reinvest in fund by buying more shares
or units. there by I hold more number of units and the amount is market value
multiplied by total number of units which is more now.
But actually all funds do not have dividends but instead just float on
market value, which is changing. What I put money is just called purchases.
So now I wanted to know how much I gained means ( total market value amount
minus total purchase value) which I wanted.

--
Chanikya


"Cal Learner-- MVP" wrote:

- quote -

In microsoft.public.money, cndesu wrote:

- quote -

What is the difference, in your eyes, between purchases and cost
basis?



- quote -

Reinvested dividends are purchases. Dividends are real money, and
they are part of gain.



There is a Price Appreciation column that you can add in in the
later versions. It does not include dividends in the calculations.
It does include the price gain on shares that you bought by
reinvesting dividends, however.

I see the gain in investment acccount is current market value plus income
minus costbasis. Now here the cost basis includes the reinvestment
transactions also. But instead is there any way to track actual "gain" which
is market value plus income minus the purchases( and not costbasis). I wanted
to know actual or realtime income I am making by putting money and how the
market shows on amount in money(dollars) not in units as it contains
reinvested units also.
--
Chanikya