| | |||
| |||
| Hi again, I think I discovered what's happening. But another question came up. When I'm selling the units, Money is asking which method I want to use (First-in-First-Out, i.e. FIFO, or the best method between FIFO/Average Cost method). Since the fund price increased since the first time I bought unit, I believe that Money used the FIFO. Since Money is using the FIFO method, the program is selling my cheapest shares, thus my average cost is going up. But my new question is... Because Money is selling the cheapest shares, my capital gain is thus higher, which means that I will pay more taxes. So is it really the best method? I guess because my average cost went up as well, my future sell of shares will have a higher average cost and thus a lower capital gain. Can I switch from one method to the other as much as I want? My tax advisor will know that, but maybe someone here knows. Thanks. "Stageman" wrote: - quote - > Hi, > I'm buying a mutual fund on a monthly basis. I recorded accuratly all > transactions in Money. In one of the investment report where you can find the > average basis cost (important if you use the average basis method for tax > calculations), I was always able to match the average with a good old Excel > spreadsheet. > Now, I just sold a few units of the fund. When I entered the transaction, > Money asked me which method I would like to use: I chose the average basis > cost. > According to the IRS.gov web site, for the "Remaining shares: The average > basis of the shares you still hold after a sale of some of your shares is the > same as the average basis of the shares sold." > For a tax purpose, your capital gain is the number of shares sold, times the > difference of the selling price minus the average cost basis. > After I entered the selling transaction, if I go back to the investment > report to look at the average basis cost, the average went up! > So my first question is: Does anyone understand what's going on here? > My second question is: Is there a way to find details about how Money did > the calculation for my specific case? Or for a general example? > Thank you. |
|
#-1
| |||
| |||
| Hi, I'm buying a mutual fund on a monthly basis. I recorded accuratly all transactions in Money. In one of the investment report where you can find the average basis cost (important if you use the average basis method for tax calculations), I was always able to match the average with a good old Excel spreadsheet. Now, I just sold a few units of the fund. When I entered the transaction, Money asked me which method I would like to use: I chose the average basis cost. According to the IRS.gov web site, for the "Remaining shares: The average basis of the shares you still hold after a sale of some of your shares is the same as the average basis of the shares sold." For a tax purpose, your capital gain is the number of shares sold, times the difference of the selling price minus the average cost basis. After I entered the selling transaction, if I go back to the investment report to look at the average basis cost, the average went up! So my first question is: Does anyone understand what's going on here? My second question is: Is there a way to find details about how Money did the calculation for my specific case? Or for a general example? Thank you. |
| Tags |
| fund, mutual, selling, shares |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Recording a consolidation fund transaction in a mutual fund. SS: How do you record the transaction when you have mutual funds that combine (a consolidation) I have a Scudder IRA and last year they closed one of... | Microsoft Money | 1 | 01-20-2006 11:16 PM | |
| Mutual fund exchange of shares Elizabeth: I have a number of investments in one account. Within that account, I want to show an exchange of shares from one mutual fund to another, i.e.,... | Microsoft Money | 3 | 01-11-2006 01:48 PM | |
| selling shares in Microsoft Money 2002 Chad: When I try to sell the shares of an investment in my portfolio, Money tells me that my selling will make the share balance negative at some point... | Microsoft Money | 2 | 12-02-2003 10:39 PM | |
| Problem selling shares ?? weird Apothecon: I'm trying to enter a sale of shares in an investment account.I get the message "this action will lead to a negative share balance at some... | Microsoft Money | 1 | 11-12-2003 03:53 AM | |
| M2004: Can a money market fund be changed to regular mutual fund? Aloke Prasad: My retirement plan (TSP for Govt employees) used a system of providing quarterly valuations. I handled this by creating an investment called CFund... | Microsoft Money | 4 | 08-26-2003 01:36 AM | |
| Thread Tools | |
| Display Modes | |
| |