Recording a merger where new shares are issued?

#4 05-23-2007, 09:51 PM

In microsoft.public.money, 911DAVE wrote:

- quote -

> Thank you, Cal. Actually I am in Canada but I'll check out those Big Box
> stores for any deals of the sort you mentioned.
> I did find a workaround on the Microsoft site and it involved using the
> Return of Capital transaction. Curiously it did not affect the % annual
> compound return. If you cosider the spin-off as a dividend it does affect
> the %annual return.
> Any thoughts on this apparent anomaly?

As anomalies go, it is middling.

- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, 911DAVE wrote:
> > > > This solution looks promissing, Sir, but when I am in the account register
> > > the only options I have under "More Investing Tasks" are
> > > - transfer and account
> > > - record a split
> > > Do I need to tweak another setting somewhere?
> > > Perhaps you are using Standard vs Deluxe or Premium.
> > > If you are in the US, you might consider Money 2007 Deluxe. You can
> > get a fairly inexpensive retail disk at Sams, Walmart, Costco and
> > probably more places without rebate.
> > > > > > > > > "Cal Learner-- MVP" wrote:
> > > > > > In microsoft.public.money, 911DAVE wrote:
> > > > > > > > I was holding 185 shares of TCPL. TCPL merged with NOVA. After the
> > > > > merger I was awarded 37 new shares of NOVA (based on a 1 for 5
> > > > > consolidation). I continued to hold the 185 shares of TCPL but, after the
> > > > > merger unit value of each share was, of course, lower.
> > > > > > > > > The company issued a statement deeming the "Adjusted Cost Base"' of the
> > > > > newly issued NOVA shares [at]27.85 each.
> > > > > > > > > How should I represent this transaction in Money 2006?
> > > > > > > > > > > Keep an extra copy/backup of your file in case you want to undo
> > > > something.
> > > > > > > You could try a Spin-off, which is what you are describing. A bug
> > > > might make this not work.
> > > > > > > From an account register,
> > > > MoreInvestingTasks-> RecordASpecialActivity-> RecordASpin-off
> > > > > > > Answer the questions. If it crashes Money, you will want to do
> > > > something else. You should still be able to open Money if it
> > > > crashes, but just not have the spinoff implemented. If it does not
> > > > crash, that would be nice.
> > > > > > > Spin-off works better in Money 2007, but that has its own bug if you
> > > > used Buy transactions (which would be the normal case vs AddShares).
> > > > That bug has a workaround tho. The Money 2007 workaround is to make
> > > > a compensating transaction in the cash transactions register.
> > > > > > >

#3 05-23-2007, 09:19 PM

Thank you, Cal. Actually I am in Canada but I'll check out those Big Box
stores for any deals of the sort you mentioned.

I did find a workaround on the Microsoft site and it involved using the
Return of Capital transaction. Curiously it did not affect the % annual
compound return. If you cosider the spin-off as a dividend it does affect
the %annual return.

Any thoughts on this apparent anomaly?

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, 911DAVE wrote:
> > This solution looks promissing, Sir, but when I am in the account register
> > the only options I have under "More Investing Tasks" are
> > - transfer and account
> > - record a split
> > Do I need to tweak another setting somewhere?
> Perhaps you are using Standard vs Deluxe or Premium.
> If you are in the US, you might consider Money 2007 Deluxe. You can
> get a fairly inexpensive retail disk at Sams, Walmart, Costco and
> probably more places without rebate.
> > > > "Cal Learner-- MVP" wrote:
> > > > In microsoft.public.money, 911DAVE wrote:
> > > > > > I was holding 185 shares of TCPL. TCPL merged with NOVA. After the
> > > > merger I was awarded 37 new shares of NOVA (based on a 1 for 5
> > > > consolidation). I continued to hold the 185 shares of TCPL but, after the
> > > > merger unit value of each share was, of course, lower.
> > > > > > > The company issued a statement deeming the "Adjusted Cost Base"' of the
> > > > newly issued NOVA shares [at]27.85 each.
> > > > > > > How should I represent this transaction in Money 2006?
> > > > > > > > Keep an extra copy/backup of your file in case you want to undo
> > > something.
> > > > > You could try a Spin-off, which is what you are describing. A bug
> > > might make this not work.
> > > > > From an account register,
> > > MoreInvestingTasks-> RecordASpecialActivity-> RecordASpin-off
> > > > > Answer the questions. If it crashes Money, you will want to do
> > > something else. You should still be able to open Money if it
> > > crashes, but just not have the spinoff implemented. If it does not
> > > crash, that would be nice.
> > > > > Spin-off works better in Money 2007, but that has its own bug if you
> > > used Buy transactions (which would be the normal case vs AddShares).
> > > That bug has a workaround tho. The Money 2007 workaround is to make
> > > a compensating transaction in the cash transactions register.
> > > >

#2 05-05-2007, 10:30 PM

In microsoft.public.money, 911DAVE wrote:

- quote -

> This solution looks promissing, Sir, but when I am in the account register
> the only options I have under "More Investing Tasks" are
> - transfer and account
> - record a split
> Do I need to tweak another setting somewhere?

Perhaps you are using Standard vs Deluxe or Premium.

If you are in the US, you might consider Money 2007 Deluxe. You can
get a fairly inexpensive retail disk at Sams, Walmart, Costco and
probably more places without rebate.

- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, 911DAVE wrote:
> > > > I was holding 185 shares of TCPL. TCPL merged with NOVA. After the
> > > merger I was awarded 37 new shares of NOVA (based on a 1 for 5
> > > consolidation). I continued to hold the 185 shares of TCPL but, after the
> > > merger unit value of each share was, of course, lower.
> > > > > The company issued a statement deeming the "Adjusted Cost Base"' of the
> > > newly issued NOVA shares [at]27.85 each.
> > > > > How should I represent this transaction in Money 2006?
> > > > > Keep an extra copy/backup of your file in case you want to undo
> > something.
> > > You could try a Spin-off, which is what you are describing. A bug
> > might make this not work.
> > > From an account register,
> > MoreInvestingTasks-> RecordASpecialActivity-> RecordASpin-off
> > > Answer the questions. If it crashes Money, you will want to do
> > something else. You should still be able to open Money if it
> > crashes, but just not have the spinoff implemented. If it does not
> > crash, that would be nice.
> > > Spin-off works better in Money 2007, but that has its own bug if you
> > used Buy transactions (which would be the normal case vs AddShares).
> > That bug has a workaround tho. The Money 2007 workaround is to make
> > a compensating transaction in the cash transactions register.
> >

#1 05-05-2007, 10:13 PM

This solution looks promissing, Sir, but when I am in the account register
the only options I have under "More Investing Tasks" are
- transfer and account
- record a split
Do I need to tweak another setting somewhere?

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, 911DAVE wrote:
> > I was holding 185 shares of TCPL. TCPL merged with NOVA. After the
> > merger I was awarded 37 new shares of NOVA (based on a 1 for 5
> > consolidation). I continued to hold the 185 shares of TCPL but, after the
> > merger unit value of each share was, of course, lower.
> > > The company issued a statement deeming the "Adjusted Cost Base"' of the
> > newly issued NOVA shares [at]27.85 each.
> > > How should I represent this transaction in Money 2006?
> > Keep an extra copy/backup of your file in case you want to undo
> something.
> You could try a Spin-off, which is what you are describing. A bug
> might make this not work.
> From an account register,
> MoreInvestingTasks-> RecordASpecialActivity-> RecordASpin-off
> Answer the questions. If it crashes Money, you will want to do
> something else. You should still be able to open Money if it
> crashes, but just not have the spinoff implemented. If it does not
> crash, that would be nice.
> Spin-off works better in Money 2007, but that has its own bug if you
> used Buy transactions (which would be the normal case vs AddShares).
> That bug has a workaround tho. The Money 2007 workaround is to make
> a compensating transaction in the cash transactions register.

05-05-2007, 09:37 PM

In microsoft.public.money, 911DAVE wrote:

- quote -

> I was holding 185 shares of TCPL. TCPL merged with NOVA. After the
> merger I was awarded 37 new shares of NOVA (based on a 1 for 5
> consolidation). I continued to hold the 185 shares of TCPL but, after the
> merger unit value of each share was, of course, lower.
> The company issued a statement deeming the "Adjusted Cost Base"' of the
> newly issued NOVA shares [at]27.85 each.
> How should I represent this transaction in Money 2006?

Keep an extra copy/backup of your file in case you want to undo
something.

You could try a Spin-off, which is what you are describing. A bug
might make this not work.

From an account register,
MoreInvestingTasks-> RecordASpecialActivity-> RecordASpin-off

Answer the questions. If it crashes Money, you will want to do
something else. You should still be able to open Money if it
crashes, but just not have the spinoff implemented. If it does not
crash, that would be nice.

Spin-off works better in Money 2007, but that has its own bug if you
used Buy transactions (which would be the normal case vs AddShares).
That bug has a workaround tho. The Money 2007 workaround is to make
a compensating transaction in the cash transactions register.

#-1 05-05-2007, 09:06 PM

I was holding 185 shares of TCPL. TCPL merged with NOVA. After the
merger I was awarded 37 new shares of NOVA (based on a 1 for 5
consolidation). I continued to hold the 185 shares of TCPL but, after the
merger unit value of each share was, of course, lower.

The company issued a statement deeming the "Adjusted Cost Base"' of the
newly issued NOVA shares [at]27.85 each.

How should I represent this transaction in Money 2006?

Similar Threads
Thread	Forum	Replies	Last Post
Recording Merger Bryan: I've a merger that the wizard doesn't completely handle. BAC & MBNA merged. BAC gave 1:2 shares + some cash. They paid CASH-LIEU for fractional...	Microsoft Money	1	02-14-2006 07:51 PM
recording company merger help fj: I am fairly to Money, as I had been using Quicken from way back ( I think that Version5 was my first). My latest version was Quicken 99(Canadian),...	Microsoft Money	3	07-24-2004 08:47 PM
Recording stock merger Bernie: How do I treat a stock merger in Money 2004? My X number of shares of stock A have been replaced with Y number of shares in stock B.	Microsoft Money	2	05-18-2004 01:32 AM
recording merger with combination cash & shares Don: I owned Company A stock. Its shares were merged into Company B. The terms of the merger were that for each share of company A, I received ..1906...	Microsoft Money	9	01-27-2004 01:44 AM
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