Microsoft KB Archive/124841

= Money: Account Value Is Different from the Sum of Total Column =

Article ID: 124841

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Money 2004 Deluxe Edition
 * Microsoft Money 2003 Deluxe Edition
 * Microsoft Money 2002 Standard Edition
 * Microsoft Money 2001 Standard Edition
 * Microsoft Money 2000 Standard Edition
 * Microsoft Money 99 Standard Edition
 * Microsoft Money 98 Standard Edition
 * Microsoft Money 97 Standard Edition
 * Microsoft Money 2000 Business & Personal Edition
 * Microsoft Money 98 Deluxe Edition
 * Microsoft Money 98 Financial Suite Edition

-



This article was previously published under Q124841



SUMMARY
The Investment Register (or the Investment Details window in Money 3.x) contains a Total column and an Account Value box. The number in the Account Value box is the current cash value of all of your investments for the selected accounts; it is not the sum of the Total column. The Total column uses the following equation to display the amounts that were paid for the individual investments:

For Buys (Total = Price x Quantity + Commission)

For Sells ( Total = Price x Quantity - Commission)



MORE INFORMATION
The number in the Account Value box is the quantity of all of the investments multiplied by their respective current prices. So, for example, if you bought 100 shares of stock in the Widget Company at $1 per share, in a New investment account, the Total column would say $100 and the Account Value box would display the value $100. If you buy 100 more shares of the Widget Company stock at $2 per share, the account value would not equal the sum of the cost of the two investments. The Total column would have the values of $100 and $200, but the Account Value box would read $400. The Account Value box is taking the 200 shares you now own and multiplying them by the current stock price of $2 per share. So, the number in the Account Value box is the amount that you would receive if you sold all the shares you own at their current prices.

The following table shows the Account Register (or Investment Details window) with the above example implemented.   Investment               Activity   Price    Quantity   Total -

Widget Company Stock     Buy         $1       100       $100 Widget Company Stock     Buy         $2       100       $200

Account Value (200 x $2)   $400 NOTE: If the account has an associated cash account, this amount will be add to the total:

Total = ([Price X Quantity] + Associated cash account)

Additional query words: money2004 money97 money98 money99 money2000 money2001 money2002 money2003 match wrong equal add dolly

Keywords: kbhowto kbmoneyinvest kbprb KB124841

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.