Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #2  
Old 09-11-2004, 04:12 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: GAIN column in Money 200x

In microsoft.public.money, - Bobb - wrote:

- quote -

> I have M2001 and M2004 -- Problem in simple terms:
> I put 100,000 in money market account : over time - get 3,000 interest.
> By now I've reinvest it all - except 8000.
> In Money - on the line for that money market account it shows:
> Value Gain %Gain
> $8,000 $3,000 37.5
> It's not a 37.5 gain - it WAS a total of a 3% gain - a few years ago.


OK. Looking again. I see your point better. I misunderstood the
first time.

You put in $8000. You reinvest interest/dividends over time of
$3000. You now have $11000, which you say is not a gain, because you
think gain means "capital gain". In fact, you might even consider
the term "capital gain" to be redundant. You would not be the first.

But others think that dividends and interest are real money, and
that a gain is not limited to capital gain.

The solutions for you are twofold. Look at the investment details.
There is it includes an annual % return that you might find useful.
But the most important one for you is to customize the portfolio
view and remove the Gain Column. In its place Add the Price
Appreciation column. You will notice that when you select a
potential column to Add or Remove, a description will appear
explaining the meaning. You may find others that you want to Add or
Remove. The Save or SaveAs.



- quote -

> How can I clear that out so that it doesn't show a gain - it's actually
> reinvested dividends - and those have been moved around. I tried to sell it
> all / buy it back thinking that it may adjust my cost basis. I know what it
> IS showing - how to get it to NOT show as a gain - I really just want it as
> cash - but Money doesn't like that when it reconciles to my statement.
> And I DO want to see that column (for all of my other stuff)


You can have both. What you can't do is to rename the Price
Appreciation column to Unrealized Capital Gain.

You might find the Taxes-> CapitalGainsEstimator to be useful in
exploring the effects of selling off various lots.

  #1  
Old 09-11-2004, 01:13 AM
- Bobb -
Guest
 
Posts: n/a
Default Re: GAIN column in Money 200x

- quote -

> I also suspect you may not have your MMF defined as a MMF. It is OK
> to have it defined as a mutual fund, as long as you use a fixed $1
> value.


All of the money markets are setup as money markets ...
Fid Cash Reserves
Treasury Money Marlet
Select Mobey Market
Vanguard Money Market etc - all = money markets in the Category column.

Don;t others have this same problem ?

another example - in my IRA money market .. years old ..
have received $2000 in interest:
<technically the MMkt account is worth $2000 more , so it IS an increase in
value . but I don't consider it a GAIN, since I bought it all at $1 and it
is still $1 - that's my problem vs Money's view
Currently in my Money market account , I have $6 - yet with $2000 interest,
it shows a $2000 gain and 54,565% gain.
Follow down the columns and those numbers are added into my portfolio gains.




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

> In microsoft.public.money, - Bobb - wrote:
> > I have M2001 and M2004 -- Problem in simple terms:
> > I put 100,000 in money market account : over time - get 3,000 interest.
> > > By now I've reinvest it all - except 8000.

> > In Money - on the line for that money market account it shows:
> > > Value Gain %Gain
> > > $8,000 $3,000 37.5
> > > It's not a 37.5 gain - it WAS a total of a 3% gain - a few years ago.

> Look at the transactions for your MMF. There should only be Buy,
> Sell, Dividend and ReinvestDividend transactions IMHO. A convenient
> way to see the transactions is to right-click the holding in the
> Portfolio. Select SeeInvestmentActivities.
> > > How can I clear that out so that it doesn't show a gain - it's actually

> > reinvested dividends - and those have been moved around. I tried to sell

it
> > all / buy it back thinking that it may adjust my cost basis. I know what

it
> > IS showing - how to get it to NOT show as a gain - I really just want it

as
> > cash - but Money doesn't like that when it reconciles to my statement.
> > > And I DO want to see that column (for all of my other stuff)

> I also suspect you may not have your MMF defined as a MMF. It is OK
> to have it defined as a mutual fund, as long as you use a fixed $1
> value.



 
Old 09-10-2004, 02:56 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: GAIN column in Money 200x

In microsoft.public.money, - Bobb - wrote:

- quote -

> I have M2001 and M2004 -- Problem in simple terms:
> I put 100,000 in money market account : over time - get 3,000 interest.
> By now I've reinvest it all - except 8000.
> In Money - on the line for that money market account it shows:
> Value Gain %Gain
> $8,000 $3,000 37.5
> It's not a 37.5 gain - it WAS a total of a 3% gain - a few years ago.


Look at the transactions for your MMF. There should only be Buy,
Sell, Dividend and ReinvestDividend transactions IMHO. A convenient
way to see the transactions is to right-click the holding in the
Portfolio. Select SeeInvestmentActivities.


- quote -

> How can I clear that out so that it doesn't show a gain - it's actually
> reinvested dividends - and those have been moved around. I tried to sell it
> all / buy it back thinking that it may adjust my cost basis. I know what it
> IS showing - how to get it to NOT show as a gain - I really just want it as
> cash - but Money doesn't like that when it reconciles to my statement.
> And I DO want to see that column (for all of my other stuff)


I also suspect you may not have your MMF defined as a MMF. It is OK
to have it defined as a mutual fund, as long as you use a fixed $1
value.

  #-1  
Old 09-09-2004, 11:46 PM
- Bobb -
Guest
 
Posts: n/a
Default GAIN column in Money 200x

I have M2001 and M2004 -- Problem in simple terms:
I put 100,000 in money market account : over time - get 3,000 interest.

By now I've reinvest it all - except 8000.
In Money - on the line for that money market account it shows:

Value Gain %Gain

$8,000 $3,000 37.5

It's not a 37.5 gain - it WAS a total of a 3% gain - a few years ago.

How can I clear that out so that it doesn't show a gain - it's actually
reinvested dividends - and those have been moved around. I tried to sell it
all / buy it back thinking that it may adjust my cost basis. I know what it
IS showing - how to get it to NOT show as a gain - I really just want it as
cash - but Money doesn't like that when it reconciles to my statement.

And I DO want to see that column (for all of my other stuff)

Thanks.
Bobb


 

Tags
200x, column, gain, money
Similar Threads
Thread Forum Replies Last Post
"Gain" column not working on Portolio page
Steve: After entering all our various brokerage accounts, I can't figure out why the "Gain" column for one of the accounts is appearing as blank--even...
Microsoft Money 1 04-27-2004 12:44 AM
Money 2004 calculates gain wrong
John: Problem Description: The problem I'm having with the Money 2004 Delux program is that the investments routine which calculates capital gain or...
Microsoft Money 2 02-27-2004 07:52 PM
Investment Gain Less Dividends
Lloyd: I see that the "%Gain" column in the Investment Portfolio includes dividends earned. Is there a Portfolio Column selection that provides the...
Microsoft Money 2 01-27-2004 06:39 PM
Money pct gain
beclem3 \(removethis\) @cox.net: In the portfolio view in col. '%gain' what does 'Big%' mean. I want to know HOW big, not that it IS big!... This is the 'Annual gain' column where...
Microsoft Money 1 12-02-2003 05:03 AM
Money 98 gain
Mary: Why is the performance report showing a gain on an investment in which I actually have a loss. For example Cost 1000 Div Reinvestment 773...
Microsoft Money 1 10-13-2003 12:49 AM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 01:37 AM.