Money: Account Value Is Different from the Sum of Total Column (124841)

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)