|
#5
| |||
| |||
| In microsoft.public.money, SJB wrote: - quote - > The thing I am struggling with is that I can't back into the #'s money uses
Try setting the portfolio to show closed positions, and see if> 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. 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
| |||
| |||
| 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
| |||
| |||
| 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
| |||
| |||
| 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
| |||
| |||
| In microsoft.public.money, SJB wrote: - quote - > 1) Shouldn't my cost basis + gain = the current market value of my
Dividends. Dividends are real money.> holdings....it appears that my current market value = Cost basis + > Appreciation. What is the difference between gain and appreciation??? - quote - > 2) Does anyone know the calculation for the ROI All Dates field (using the http://support.microsoft.com/default...b;en-us;131664> MS Money fields). |
| | |||
| |||
| 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
| |||
| |||
| 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 | |
| |