Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #5  
Old 12-14-2005, 05:11 AM
Cal Learner
Guest
 
Posts: n/a
Default Re: Return on investment Calc

In microsoft.public.money, SJB wrote:

- quote -

> The thing I am struggling with is that I can't back into the #'s money uses
> on my own. For exmaple, when I take the gain and divide it by the cost basis
> I don't get the gain % money lists on an investment by investment basis.
> However, when I do this for my total portfolio I can make the math work.


Try setting the portfolio to show closed positions, and see if
things improve for you.
- quote -

> Additionally, when I add my appreciation + reinvestments it doesn't add up
> to my gain.
> Is there something that details , or do you know, how the gain and gain %
> are calculated?


  #4  
Old 12-13-2005, 05:30 PM
Myrna Larson
Guest
 
Posts: n/a
Default Re: Return on investment Calc

One of your items is "reinvestment". What is this? If you are reinvesting
dividends, your total cost is original shares * original purchase price PLUS
the cost of shares purchased. If you've reinvested all dividends, that would
be original basis + dividends.

I believe Gain in dollars is calculated as
(sum of market value + dividends *taken in cash*)
- (cost of original shares + cost of shares bought via reinvestment)

Converting that to percent may be problematic: it should be Gain/Basis, but
when you have shares purchased at various times there's a question as to which
shares are included in the Basis.

To figure out what Money's figures (quoted below) mean, we need to see a list
of all of the transactions involving this investment.

On Tue, 13 Dec 2005 08:30:04 -0800, SJB <SJB[at]discussions.microsoft.com> wrote:

- quote -

> I thought it would be helpful to include some account data from one of my
> investments...
> 234.899 shares
> 27,355.11 MV
> 116.54 last
> 99.853 cost
> 5316.38 gain
> 15.7% gain %
> 23,717.98 cost basis
> 4230.72 appreciation
> 1085.66 reinvestment
> so my questions are...
> 1) why doesn't the cost per share x share = cost basis?
> 2) why doesn't the market value - cost basis = gain
> 3) how is gain % calculated?
> "SJB" wrote:
> > I use Money 2004 and recently rebalanced my 401K portfolio. I moved about
> > 10K from one investment to the other and noticed that my "ROI all dates"
> > return decreased by 3% points, even though the current prices of the
> > individual stocks had not moved since the transaction date. Also, my
> > annualized return did not change, as you would expect. Does anyone know

why
> > this would happen

  #3  
Old 12-13-2005, 03:30 PM
SJB
Guest
 
Posts: n/a
Default RE: Return on investment Calc

I thought it would be helpful to include some account data from one of my
investments...

234.899 shares
27,355.11 MV
116.54 last
99.853 cost
5316.38 gain
15.7% gain %
23,717.98 cost basis
4230.72 appreciation
1085.66 reinvestment

so my questions are...

1) why doesn't the cost per share x share = cost basis?
2) why doesn't the market value - cost basis = gain
3) how is gain % calculated?




"SJB" wrote:

- quote -

> I use Money 2004 and recently rebalanced my 401K portfolio. I moved about
> 10K from one investment to the other and noticed that my "ROI all dates"
> return decreased by 3% points, even though the current prices of the
> individual stocks had not moved since the transaction date. Also, my
> annualized return did not change, as you would expect. Does anyone know why
> this would happen

  #2  
Old 12-13-2005, 11:18 AM
SJB
Guest
 
Posts: n/a
Default Re: Return on investment Calc

Thanks Cal.

The thing I am struggling with is that I can't back into the #'s money uses
on my own. For exmaple, when I take the gain and divide it by the cost basis
I don't get the gain % money lists on an investment by investment basis.
However, when I do this for my total portfolio I can make the math work.

Additionally, when I add my appreciation + reinvestments it doesn't add up
to my gain.

Is there something that details , or do you know, how the gain and gain %
are calculated?

Thanks



"Cal Learner" wrote:

- quote -

> In microsoft.public.money, SJB wrote:
> > > 1) Shouldn't my cost basis + gain = the current market value of my

> > holdings....it appears that my current market value = Cost basis +
> > Appreciation. What is the difference between gain and appreciation???

> Dividends. Dividends are real money.
> > > 2) Does anyone know the calculation for the ROI All Dates field (using the

> > MS Money fields).

> http://support.microsoft.com/default...b;en-us;131664

  #1  
Old 12-13-2005, 09:08 AM
Cal Learner
Guest
 
Posts: n/a
Default Re: Return on investment Calc

In microsoft.public.money, SJB wrote:

- quote -

> 1) Shouldn't my cost basis + gain = the current market value of my
> holdings....it appears that my current market value = Cost basis +
> Appreciation. What is the difference between gain and appreciation???


Dividends. Dividends are real money.

- quote -

> 2) Does anyone know the calculation for the ROI All Dates field (using the
> MS Money fields).


http://support.microsoft.com/default...b;en-us;131664
 
Old 12-12-2005, 11:51 PM
SJB
Guest
 
Posts: n/a
Default RE: Return on investment Calc

OK, I'm confused and have a few more questions about the Portfolio View...

1) Shouldn't my cost basis + gain = the current market value of my
holdings....it appears that my current market value = Cost basis +
Appreciation. What is the difference between gain and appreciation???

2) Does anyone know the calculation for the ROI All Dates field (using the
MS Money fields).


"SJB" wrote:

- quote -

> I use Money 2004 and recently rebalanced my 401K portfolio. I moved about
> 10K from one investment to the other and noticed that my "ROI all dates"
> return decreased by 3% points, even though the current prices of the
> individual stocks had not moved since the transaction date. Also, my
> annualized return did not change, as you would expect. Does anyone know why
> this would happen

  #-1  
Old 12-12-2005, 10:02 PM
SJB
Guest
 
Posts: n/a
Default Return on investment Calc

I use Money 2004 and recently rebalanced my 401K portfolio. I moved about
10K from one investment to the other and noticed that my "ROI all dates"
return decreased by 3% points, even though the current prices of the
individual stocks had not moved since the transaction date. Also, my
annualized return did not change, as you would expect. Does anyone know why
this would happen
 

Tags
calc, investment, return
Similar Threads
Thread Forum Replies Last Post
What's wrong with the ROI calc?
Tom Z: Consider the following: 1. on 1/1/05 you put $3000 into an investment account, $1000 goes into a Money Market (MM) and you buy 200 shares of stock...
Microsoft Money 2 07-13-2005 09:06 PM
Investment Return?
David Viles: Hi, I have a problem with my portfolio's YTD return calculation. It is off by about double. In other words, it reads down 0.88% when it is...
Microsoft Money 2 08-24-2004 12:22 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 05:01 PM.