The MSN Money cost basis may differ from the Money cost basis in the Portfolio (174999)



The information in this article applies to:

  • Microsoft Money 2007 Deluxe
  • Microsoft Money 2007 Home & Business
  • Microsoft Money 2007 Premium
  • Microsoft Money Deluxe 2006
  • Microsoft Money Premium 2006
  • Microsoft Money Small Business 2006
  • Microsoft Money Standard 2006
  • Microsoft Money 2005 Deluxe
  • Microsoft Money 2005 Premium
  • Microsoft Money 2005 Small Business
  • Microsoft Money 2005 Standard
  • Microsoft Money 2004 Deluxe
  • Microsoft Money 2004 Premium
  • Microsoft Money 2004 Small Business
  • Microsoft Money 2004 Standard
  • Microsoft Money 2003 Deluxe
  • Microsoft Money 2003 Deluxe and Business
  • Microsoft Money 2003 Standard
  • Microsoft Money 2002
  • Microsoft Money 2002 Business & Personal Edition
  • Microsoft Money 2002 Deluxe and Business Edition
  • Microsoft Money 2001
  • Microsoft Money 2001 Business and Personal Edition
  • Microsoft Money 2001 Deluxe and Business
  • Microsoft Money 2000
  • Microsoft Money 2000 Business and Personal
  • Microsoft Money 99
  • Microsoft Money 98
  • Microsoft Money 97
  • MSN Money
  • MSN Money Plus

This article was previously published under Q174999

SUMMARY

MSN Investor and Microsoft Money may calculate different cost basis values for your investments.

MORE INFORMATION

MSN Investor uses FIFO (First In First Out) to calculate the cost basis for your remaining investment shares. Microsoft Money also normally uses FIFO. However, Money can also use Average Cost. Additionally, Microsoft Money 99 and later can also use Lots.

The example in the following table shows the difference between the FIFO and Average Cost accounting methods:

Date Activity Amount Cost Avg. Cost Average Cost Basis FIFO Cost Basis
1/1/97 Buy 10 $10 $10 $100 $100
2/1/97 Buy 10 $20 $15 $300 $300
3/1/97 Buy 10 $30 $20 $600 $600
4/1/97 Buy 10 $40 $25 $1000 $1000
5/1/97 Sell 30 $40 $25 $250 $400


When you use the FIFO accounting method, you sell the first securities you purchased (in this example, the securities you purchased in the first three transactions). The program then uses the earliest cost for the remaining securities to calculate the cost basis (in this example, the program uses the cost for the securities you purchased purchased on 4/1/97).

Money and Investor both use the following formula when they use the FIFO method:

Cost X Amount = Cost Basis

The following example of a FIFO equation uses the information from the previous table:

$40 X 10 = $400

If you configure Money to use the Average Cost method, it uses the following formula:

Avg. Cost X Amount = Cost Basis

The following example of an Average Cost equation uses the information from the previous table:

$25 X 10 = $250

Money 2000 and later versions let you associate a "price" with transfered shares when you use the Add Shares feature. This price, if provided, is used in Money's Cost Basis calculations.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

164450 How to view or add stocks that are purchased at different prices in MSN Money


Modification Type:MinorLast Reviewed:7/14/2006
Keywords:kbinfo kbMoneyInvest kbonline KB174999