Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #5  
Old 04-04-2006, 12:30 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How to show actual realized gain from ETF's w/ dividends

In microsoft.public.money, Crabby Gator wrote:

- quote -

> OK, so it looks like I was indeed entering the dividends incorrectly.
> My follow-up question is this:
> How do I automate their entry? I get a dividend every month and I don't
> see a way to have the investment transactions recur every month.


You cannot schedule a dividend in Money as you do a those scheduled
transactions.

Does your financial institution offer downloads of transactions?
That's what I like.

- quote -

> I initially set them up in "Bills & Deposits" because they recur every
> month and it made sense at the time.
> Finally, along the same lines, how would one enter capital gains
> distributions? I don't see any "actions" that would correspond to that in
> the investment transactions menu.


If the investment is set up to be a mutual fund, there should be
such a choice in the drop-down list. You may have to scroll down to
see the whole list. If there is no such choice, you may have set up
the investment as a stock. If so, some remedial action is in order.

- quote -

> Would that be more appropriately entered as a cash transaction in the cash
> register of the account? In other words, should capital gains
> distributions be counted toward a particular investment's performance?


I think the transactions in the transactions register are much
better in that regard.

  #4  
Old 04-04-2006, 12:11 AM
Crabby Gator
Guest
 
Posts: n/a
Default Re: How to show actual realized gain from ETF's w/ dividends

Cal Learner-- MVP <via_newsgroup[at]please.tnx> wrote the following:

- quote -

> In microsoft.public.money, Crabby Gator wrote:
> > > Sorry, yes i was looking at the portfolio view.

> > "ROI all dates" appears as the abbreviated column header for "Total
> > Return all dates": i had the columns sized narrowly.
> > > Anwyay, the value that is currently being reported is merely the current

> > market value over the initial purchase price.
> > There seem to be other "total return" columns to choose from ... perhaps
> > i have the dividend payouts miscategorized?

> To enter the dividends, enter them into the Investment Transactions
> register with a Dividend or ReinvestDividend transaction as
> appropriate.
> If dividends are entered right, you should see the Dividend
> transactions when you click the [+] in front of the investment name.


OK, so it looks like I was indeed entering the dividends incorrectly.
My follow-up question is this:

How do I automate their entry? I get a dividend every month and I don't
see a way to have the investment transactions recur every month.

I initially set them up in "Bills & Deposits" because they recur every
month and it made sense at the time.

Finally, along the same lines, how would one enter capital gains
distributions? I don't see any "actions" that would correspond to that in
the investment transactions menu.

Would that be more appropriately entered as a cash transaction in the cash
register of the account? In other words, should capital gains
distributions be counted toward a particular investment's performance?

Thanks!!

CbG
  #3  
Old 04-01-2006, 01:26 AM
David Arnstein
Guest
 
Posts: n/a
Default Re: How to show actual realized gain from ETF's w/ dividends

I have Money 2006, but I suspect that your version is similar enough.

First, make sure you enter all your dividends in the Money account
register for your brokerage.

Then, use Money's "Reports" menu. Select the report for "investment
performance by investment type." Customize it as you wish. As far as I
can tell, the resulting report does take both price appreciation and
dividends into account. It presents a total return and and annualized
return, plus a few other figures.
--
David Arnstein | Have fun with your spams:
arnstein+usenet[at]pobox.com | http://www.bluesecurity.com
  #2  
Old 04-01-2006, 12:32 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How to show actual realized gain from ETF's w/ dividends

In microsoft.public.money, Crabby Gator wrote:

- quote -

> Sorry, yes i was looking at the portfolio view.
> "ROI all dates" appears as the abbreviated column header for "Total Return
> all dates": i had the columns sized narrowly.
> Anwyay, the value that is currently being reported is merely the current
> market value over the initial purchase price.
> There seem to be other "total return" columns to choose from ... perhaps i
> have the dividend payouts miscategorized?


To enter the dividends, enter them into the Investment Transactions
register with a Dividend or ReinvestDividend transaction as
appropriate.

If dividends are entered right, you should see the Dividend
transactions when you click the [+] in front of the investment name.

  #1  
Old 04-01-2006, 12:20 AM
Crabby Gator
Guest
 
Posts: n/a
Default Re: How to show actual realized gain from ETF's w/ dividends

Cal Learner-- MVP <via_newsgroup[at]please.tnx> wrote the following:

- quote -

> In microsoft.public.money, Crabby Gator wrote:
> > Has anyone figured out how to show the actual ROI and gain from ETF's
> > that pay monthly dividends?
> > Example: I purchase 100 shares of XYZ at $10.00/each on 01/01/2005
> > Every month it pays a dividend, say $0.10/share so i get $10/month as
> > cash at the end of 2005, the share price is $15/share and i've made $120
> > in dividends. The ROI in Money (2004) seems to be based solely on the
> > share price increase,

> "ROI"? Where are you looking? At the Portfolio? What does the column
> heading say?
> > > So, is there a way to have it figure in the dividends?

> Configure in the Total Return (TR) columns into the portfolio view.
> They should include the effect of dividend transactions.



Thanks for the reply.

Sorry, yes i was looking at the portfolio view.
"ROI all dates" appears as the abbreviated column header for "Total Return
all dates": i had the columns sized narrowly.

Anwyay, the value that is currently being reported is merely the current
market value over the initial purchase price.
There seem to be other "total return" columns to choose from ... perhaps i
have the dividend payouts miscategorized?

I have scheduled monthly deposits to capture the payouts, and created a
payee named after the fund, and categorized it as investment income,
dividends. I realize now that there is no way for money to know how to
associate these deposits with the investment entry in the portfolio.
Can you tell me how to reclassify these deposits? Or is there another
recomended way to handle dividends from stocks or ETFs.

Thanks!!!!

CbG

 
Old 03-31-2006, 11:34 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How to show actual realized gain from ETF's w/ dividends

In microsoft.public.money, Crabby Gator wrote:

- quote -

> Has anyone figured out how to show the actual ROI and gain from ETF's that
> pay monthly dividends?
> Example: I purchase 100 shares of XYZ at $10.00/each on 01/01/2005
> Every month it pays a dividend, say $0.10/share so i get $10/month as cash
> at the end of 2005, the share price is $15/share and i've made $120 in
> dividends. The ROI in Money (2004) seems to be based solely on the share
> price increase,


"ROI"? Where are you looking? At the Portfolio? What does the column
heading say?

- quote -

> So, is there a way to have it figure in the dividends?

Configure in the Total Return (TR) columns into the portfolio view.
They should include the effect of dividend transactions.

  #-1  
Old 03-31-2006, 11:04 PM
Crabby Gator
Guest
 
Posts: n/a
Default How to show actual realized gain from ETF's w/ dividends

Has anyone figured out how to show the actual ROI and gain from ETF's that
pay monthly dividends?
Example: I purchase 100 shares of XYZ at $10.00/each on 01/01/2005
Every month it pays a dividend, say $0.10/share so i get $10/month as cash
at the end of 2005, the share price is $15/share and i've made $120 in
dividends. The ROI in Money (2004) seems to be based solely on the share
price increase,

So, is there a way to have it figure in the dividends?

Thanks,
CbG
 

Tags
actual, dividends, etf, gain, realized, show, w or
Similar Threads
Thread Forum Replies Last Post
Incorrect Realized gain/loss in money '02 reports
Kevin: After inputing my investment info into money, i went to look at some of the reports that it provides. On one of my inv. it shows a realized gain of...
Microsoft Money 1 11-20-2004 10:19 AM
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
Realized gain / basis
- Bobb -: How to "not display" old info ? In my normal use of Money 2001,2004 , I do not care about "realized gain" from years ago. For Money, the basis...
Microsoft Money 7 01-16-2004 11:38 PM
Dividends and interest don't show up as income
Dave Schwartz: How come when I look at my portfolio on the Portfolio Window, not all of my dividends, interest, reinvested dividends, and such don't show up as...
Microsoft Money 2 11-17-2003 12:23 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 06:06 PM.