Merger/acquisition

[oyz79]

I manually imported historical transactions and have an issue with a Q/CTL merger on 4/1/11. Q shareholders received .1664 shares of CTL stock.

I held 1235 shares of Q purchased on 1/11/11 and they were exchanged for 205 shares of CTL + $20.68. I also held 203 CTL shares at the same time, resulting in a total number of 408 shares of CTL.

All 408 CTL shares were sold on 4/11/11. How would I update the data register to reflect this merger? It currently shows a balance of -205 shares of CTL and 205 shares of Q in the register, when in fact I hold neither as of 4/11/11.

[Mark]

Hi oyz79,

Since you owned 1235 shares of Q and the payout is .1664 for 1 you would end up with 205.504 shares of CTL due to your Q shares. In your Q investment, record a split with a ratio of 205.504 for 1235. Also record a sell of 0.504 shares for $20.68. This will leave your Q investment with the 205 shares. Change the name/symbol on your Q investment to CTL. You now have 2 investments, one with 205 shares, and one with 203 shares. To record the sell of 408 shares, you could either record a sell of 205 in one investment and 203 in the other, or you could transfer the shares from one Q investment to the other, and then sell all 408 shares out of the 2nd investment. I would probably not record the transfer, and just record 2 sells, one for 205, and one for 203.

[oyz79]

How/where would I manually record the split for Q?

[Mark]

Hi oyz79,

In the Data Register select the investment, and choose "Splits" for the "Data Type", and then press "New...". Another way is to right mouse click on the investment in the Portfolio Editor, and choose "Investment Data / Split...".