Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #1  
Old 02-28-2007, 04:30 PM
John A. Gallagher
Guest
 
Posts: n/a
Default Re: YTD Total Return Calculation - Can Someone Explain?

Nope. There are no dividends/distributions on ESO's.

I did some off-line calculations on YTD Total Return for the full portfolio
and believe the following:

1. The ESO's seem to be excluded in the overall calculation - regardless of
the fact that they had a return. In this case, their return was negative.
(This explains why I had an actual loss while Money showed a positive
return). They showed N/A for the full 2006 period as well as the current
period.
2. The money fund may be a little different. There has been no return yet
entered for the year. I do not know why it shows N/A rather than 0% however.
(It did show a positive percent for the full 2006 period.)

Money's definition for "Total Return - YTD" follows:
"Current market value plus income, minus beginning market value, divided by
beginning market value"

It says nothing about excluding any stock types (such as options). The only
reason I can see for N/A would be if "beginning market value" was 0 (cannot
divide by 0). In all cases the market value on 12/31/06 was a non-zero
value and, in fact, was positive as well.

The only thing I can presume is that they are excluded strictly because of
their stock type, i.e. they are options with no original cost basis.
However, there vesting date is well before last year, i.e. there has been a
valid market value for some time.

John G.

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

> In microsoft.public.money, John A. Gallagher wrote:
> > I am using MS Money 2007 and was just looking at my Portfolio Manager. For
> > the year, I have lost money - yet the YTD Total Return still remains
> > positive for my total portfolio.

> Would dividends/distributions explain that difference?
> > > When I added YTD Total Return as a column, I noticed that a number of

> > positions - particularly in-the-money employee stock options and money
> > funds - have N/A as the YTD Total Return. Are these items simply excluded
> > from all calculations (i.e. both as a base value for last years's end and
> > for current value) to arrive at the YTD Total Return? If so, why? (Clearly
> > they had a market value at EOY 2006 and a different one now.)
> > > Can someone explain?


 
Old 02-28-2007, 12:55 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: YTD Total Return Calculation - Can Someone Explain?

In microsoft.public.money, John A. Gallagher wrote:

- quote -

> I am using MS Money 2007 and was just looking at my Portfolio Manager. For
> the year, I have lost money - yet the YTD Total Return still remains
> positive for my total portfolio.


Would dividends/distributions explain that difference?


- quote -

> When I added YTD Total Return as a column, I noticed that a number of
> positions - particularly in-the-money employee stock options and money
> funds - have N/A as the YTD Total Return. Are these items simply excluded
> from all calculations (i.e. both as a base value for last years's end and
> for current value) to arrive at the YTD Total Return? If so, why? (Clearly
> they had a market value at EOY 2006 and a different one now.)
> Can someone explain?

  #-1  
Old 02-27-2007, 10:57 PM
John A. Gallagher
Guest
 
Posts: n/a
Default YTD Total Return Calculation - Can Someone Explain?

I am using MS Money 2007 and was just looking at my Portfolio Manager. For
the year, I have lost money - yet the YTD Total Return still remains
positive for my total portfolio.

When I added YTD Total Return as a column, I noticed that a number of
positions - particularly in-the-money employee stock options and money
funds - have N/A as the YTD Total Return. Are these items simply excluded
from all calculations (i.e. both as a base value for last years's end and
for current value) to arrive at the YTD Total Return? If so, why? (Clearly
they had a market value at EOY 2006 and a different one now.)

Can someone explain?

John G.

 

Tags
calculation, explain, return, total, ytd
Similar Threads
Thread Forum Replies Last Post
Annualized Return Calculation Formula
Geoffrey Zhu: Hi, Does anyone know how Money calculates Annulized return? Thanks, g
Microsoft Money 4 03-30-2007 04:12 AM
Total Return Calculation
Jeff M: I've been looking at my end of year returns using Money 2007 and am trying to understand the numbers. I read in other posts in this group that...
Microsoft Money 2 01-03-2007 01:38 PM
Incorrect return calculation in Money
Hal C: I have an unusual investment which money shows as having a negative return when in fact it is positive. Take this simplified example: 1 Jan 2000...
Microsoft Money 1 02-06-2004 04:15 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:33 PM.