Investment Gain Calculation Wrong

Hello -

I've had a problem with 1 investment in my 401k for some time now. 3/4 of
the funds I'm in calculate the Gain/Loss accurately but 1 does not.

MS Money 2007 Deluxe v 16.0.120.1303

The fund is showing:
Coast Basis: 2334.42
Market Value: 2234.51
Gain: 1811.03
% gain: 77.58%

This should really be a LOSS - as much as I'd like Money's math to work.

Any clue on how to solve this?

Cal
Sat May 10 14:01:40 CDT 2008

In microsoft.public.money, Ryan A wrote:

>Hello -
>
>I've had a problem with 1 investment in my 401k for some time now. 3/4 of
>the funds I'm in calculate the Gain/Loss accurately but 1 does not.
>
>MS Money 2007 Deluxe v 16.0.120.1303
>
>The fund is showing:
>Coast Basis: 2334.42
>Market Value: 2234.51
>Gain: 1811.03
>% gain: 77.58%
>
>This should really be a LOSS - as much as I'd like Money's math to work.
>
>Any clue on how to solve this?

I recommend that you configure to not use the "%Gain" column.
There are so many useful columns available in the Portfolio, and
for me "%Gain" is not one.

The main difference between % Gain and Total Return All (TR all)
appears to differ if sales have been made. Both appear to take
dividends into account.

If showing sold securities, %gain can go negative ... buy at 100,
sell at 1, big negative.

test buy 100 at $10.00
Sell 99 at $10.10
%gain says 100% TR All says 1%

So, to reiterate, get rid of %gain and use the TR columns.

Hank
Sat May 10 14:15:56 CDT 2008

Ryan A wrote:
> Hello -
>
> I've had a problem with 1 investment in my 401k for some time now. 3/4 of
> the funds I'm in calculate the Gain/Loss accurately but 1 does not.
>
> MS Money 2007 Deluxe v 16.0.120.1303
>
> The fund is showing:
> Coast Basis: 2334.42
> Market Value: 2234.51
> Gain: 1811.03
> % gain: 77.58%
>
> This should really be a LOSS - as much as I'd like Money's math to work.
>
> Any clue on how to solve this?
Maybe it was originally entered wrong. How about deleting and
re-entering the investment,

Hex
Sun May 11 09:17:01 CDT 2008


Not quite the same but similar.
I am using Money deluxe 2008 and the $ gain will not calculate correctly in
my case where I transferred an account from Vanguard to Fidelity. The
dividends that were paid while at Vanguard are not added in the gain.
I called in for support and after interminable e-mai and phone
conversations, it was a polite "tough luck".

good luck

Mark
Mon May 12 13:55:17 CDT 2008

Dividends, Interest, Capital Gains transactions?
Money's definition of Gain includes such "income"

-Mark


"Ryan A" <RyanA@discussions.microsoft.com> wrote in message
news:4B64389E-1F2A-4380-AF3E-DF383F9F7B8D@microsoft.com...
> Hello -
>
> I've had a problem with 1 investment in my 401k for some time now. 3/4 of
> the funds I'm in calculate the Gain/Loss accurately but 1 does not.
>
> MS Money 2007 Deluxe v 16.0.120.1303
>
> The fund is showing:
> Coast Basis: 2334.42
> Market Value: 2234.51
> Gain: 1811.03
> % gain: 77.58%
>
> This should really be a LOSS - as much as I'd like Money's math to work.
>
> Any clue on how to solve this?

Aviator
Mon May 12 15:21:01 CDT 2008

Mark, where can one find the definition of the investment terms used in
Money? Specifically, I seeking information about what the columns are
calculated.

Thanks in advance...

"Mark" wrote:

> Dividends, Interest, Capital Gains transactions?
> Money's definition of Gain includes such "income"
>
> -Mark
>
>
> "Ryan A" <RyanA@discussions.microsoft.com> wrote in message
> news:4B64389E-1F2A-4380-AF3E-DF383F9F7B8D@microsoft.com...
> > Hello -
> >
> > I've had a problem with 1 investment in my 401k for some time now. 3/4 of
> > the funds I'm in calculate the Gain/Loss accurately but 1 does not.
> >
> > MS Money 2007 Deluxe v 16.0.120.1303
> >
> > The fund is showing:
> > Coast Basis: 2334.42
> > Market Value: 2234.51
> > Gain: 1811.03
> > % gain: 77.58%
> >
> > This should really be a LOSS - as much as I'd like Money's math to work.
> >
> > Any clue on how to solve this?
>
>

Mark
Mon May 12 16:10:29 CDT 2008

Go into the View settings in the Portfolio Manager, and "customize current
view" then look at the Portfolio columns. There's a "column description" for
each of the available columns.

There's also a KB article on how Money calculates Gain, etc:

http://support.microsoft.com/kb/176334/en-us

As for other "investment terms" there's a glossary in Money's help: Help -
Money Glossary

-Mark

"Aviator" <Aviator@discussions.microsoft.com> wrote in message
news:C8FA5536-D9DB-472F-8904-F302CB86861D@microsoft.com...
> Mark, where can one find the definition of the investment terms used in
> Money? Specifically, I seeking information about what the columns are
> calculated.
>
> Thanks in advance...
>
> "Mark" wrote:
>
>> Dividends, Interest, Capital Gains transactions?
>> Money's definition of Gain includes such "income"
>>
>> -Mark
>>
>>
>> "Ryan A" <RyanA@discussions.microsoft.com> wrote in message
>> news:4B64389E-1F2A-4380-AF3E-DF383F9F7B8D@microsoft.com...
>> > Hello -
>> >
>> > I've had a problem with 1 investment in my 401k for some time now. 3/4
>> > of
>> > the funds I'm in calculate the Gain/Loss accurately but 1 does not.
>> >
>> > MS Money 2007 Deluxe v 16.0.120.1303
>> >
>> > The fund is showing:
>> > Coast Basis: 2334.42
>> > Market Value: 2234.51
>> > Gain: 1811.03
>> > % gain: 77.58%
>> >
>> > This should really be a LOSS - as much as I'd like Money's math to
>> > work.
>> >
>> > Any clue on how to solve this?
>>
>>