Recording Mutual Fund Merger in Money 04 Deluxe

10-30-2006, 06:28 AM

Never mind...

Investigating this further, I dicovered this is a "user error": I sold
this Mutual Fund about a year ago, and since that time LUFZX is no
longer a valid ticker. Probably this mutual fund was merged out of
existence. Not sure exactly, as I am no longer receiving
correspondence from Columbia Funds...

Anyway, please consider this thread closed.

Cal's info certainly helped me to get my Money status to match reality,
so thanks Cal!

Regards, Cuz.

mr_cuzy[at]yahoo.com wrote:
- quote -

> I've put off recording a tax-free Mutual Fund Merger which occured back
> in 2002, mainly because I kept waiting for the next version of MS Money
> to be enhanced to be able to handle this task.
> However, I have migrated through various versions of Money, and I am
> now on Money 2004 Deluxe, but it still doesn't have this functionality.
> Reading over Cal Learner's various posts on this newsgroup I see the
> recommended way to handle this is:
> [In] Money 2003 and 2004... if you do not hold both of the original
> funds and this is a tax-free merger, this way has no disadvantage:
> 1. Do an appropriate split of the fund. You will need to input
> the split ratio a ratio of integers (1 ... 65535). Post the ratio
> you want to achieve.
> 2. In the investment details, change the symbol.
> 3. Change the investment name.
> 4. Add a brief comment to the investment to explain the change.
> However, when I tried this using 100 * NAVs from the old fund (5.91)
> and new fund (9.03) for a ratio of 591 to 903, I see the Quantity and
> Price for each transaction has been adjusted, with the Total amount
> column remaining the same (as I expected), but the final account value
> is not the same:
> Before I entered the split, the Account Value was $4480.00, (758.037
> shares times $5.91 per share), but after the split the Account Value is
> $2932.09 (Money is showing the correct 496.124 shares but still has
> $5.91 per share).
> I updated the ticker symbol for Columbia Utilities Fund (LUFZX) and
> selected Update Prices Online, but I don't see any change. It is still
> showing $5.91/share.
> Any ideas? Thanks, Cuz.

#-1 10-26-2006, 04:42 PM

I've put off recording a tax-free Mutual Fund Merger which occured back
in 2002, mainly because I kept waiting for the next version of MS Money
to be enhanced to be able to handle this task.

However, I have migrated through various versions of Money, and I am
now on Money 2004 Deluxe, but it still doesn't have this functionality.

Reading over Cal Learner's various posts on this newsgroup I see the
recommended way to handle this is:

[In] Money 2003 and 2004... if you do not hold both of the original
funds and this is a tax-free merger, this way has no disadvantage:

1. Do an appropriate split of the fund. You will need to input
the split ratio a ratio of integers (1 ... 65535). Post the ratio
you want to achieve.

2. In the investment details, change the symbol.

3. Change the investment name.

4. Add a brief comment to the investment to explain the change.

However, when I tried this using 100 * NAVs from the old fund (5.91)
and new fund (9.03) for a ratio of 591 to 903, I see the Quantity and
Price for each transaction has been adjusted, with the Total amount
column remaining the same (as I expected), but the final account value
is not the same:

Before I entered the split, the Account Value was $4480.00, (758.037
shares times $5.91 per share), but after the split the Account Value is
$2932.09 (Money is showing the correct 496.124 shares but still has
$5.91 per share).

I updated the ticker symbol for Columbia Utilities Fund (LUFZX) and
selected Update Prices Online, but I don't see any change. It is still
showing $5.91/share.

Any ideas? Thanks, Cuz.

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 merger rmky2k: When fund X merges into fund Y by liquidating Fund X into money value on the day of merger and then reissue Fund Y with different purchase price...	Microsoft Money	1	07-28-2004 05:16 PM
mutual fund merger doug: I have Money 2002 Deluxe & Bus. I recently had 2 mutual funds merge and I cannot figure out how to handle this in the Money program. It tells...	Microsoft Money	6	01-26-2004 06:45 PM
Mutual Fund Merger Kelvin: I read the posting from Oct 03 and followed the suggestion. I completed the ratio as instructed. Problem is now I cannot change the investment...	Microsoft Money	1	01-26-2004 04:25 PM
Recording mutual fund exchange/merger Brent Fidler: I have a mutual fund in my Money 2002 Portfolio that recently exchanged its shares for another mutual fund shares within the family. The fund is...	Microsoft Money	2	10-23-2003 03:05 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode