Microsoft KB Archive/129967

From BetaArchive Wiki
Knowledge Base


Money: How Cost Basis Is Calculated on Portfolio Value Report

Article ID: 129967

Article Last Modified on 1/19/2007



APPLIES TO

  • Microsoft Money 2004 Deluxe Edition
  • Microsoft Money 2003 Deluxe Edition
  • Microsoft Money 2002 Deluxe Edition
  • Microsoft Money 2001 Standard Edition
  • Microsoft Money 2000 Deluxe Edition
  • Microsoft Money 99 Standard Edition
  • Microsoft Money 98 Standard Edition
  • Microsoft Money 97 Standard Edition
  • Microsoft Money 98 Deluxe Edition
  • Microsoft Money 98 Financial Suite Edition



This article was previously published under Q129967

SUMMARY

The "Portfolio Value by Investment Account" report in Microsoft Money (the Investment Market Value Report in Money 3.0) calculates the cost basis of investments. Money determines the cost basis by adding the amounts spent to purchase the investment and the purchases made when reinvesting dividends, and subtracting the cost basis returns from any sell transactions.

MORE INFORMATION

Sell transaction returns are based on the IRS standard of First In First Out (FIFO) unless particular lots are specified (in Money 99 and Money 98). The price of sell transactions is not considered in calculating the Cost Basis portion of the Market Value Report.

For example, if you purchase 100 shares of Stock A at a price of $25 on 1/1/94. At this point, your Cost Basis is $2500.

On 12/31/94 you receive a reinvested dividend of 1 share at $26. At this point, your Cost Basis is $2526.

On 1/1/95, you purchase 100 more shares of Stock A at a price of $27. Your Cost Basis is $5226.

You sell 100 shares on 4/1/95 for $30. According to the FIFO standard, the original 100 shares will be used in calculating the original Cost Basis. $2500 will be subtracted from your Cost Basis of $5226 to leave you with an adjusted Cost Basis of $2726.


Additional query words: money2004 121902 money97 money98 money99 money2000 money2001 money2002 money2003 dolly

Keywords: kbinfo kbmoneyinvest KB129967