Rockwell Collins (COL) acquired B/E Aerospace (BEAV) in a cash and stock deal. The SEC filing for this merger (form 8937) was found in the Investor Relations area of the Rockwell Collins web site.
This merger is a cash plus stock reorganization, which are becoming more and more frequent in recent years. This is a fully taxable merger with cash. For tax purposes this is treated as a sale of B/E Aerospace for the value of the cash and stock received. Some of the proceeds from the sale (the value of the stock received) is used to purchase Rockwell Collins. All the information below is from the information available from the form S-4/A filed with the SEC and IRS form 8937 posted on the COL web site. The first instructions are for users of the desktop software, Club Accounting 3. Instructions for Myiclub.com users follow later in this document.
1. Sell Transaction
The total merger consideration is $64.4867 per B/E Aerospace share. This is $34.10 in cash and $30.3867 in Rockwell Collins shares (.3101 x 97.99). The opening price of Rockwell Collins on the day after the merger completion date was $97.99. Calculate the total value received for your B/E Aerospace shares by multiplying 64.4867 by the total shares of B/E Aerospace owned.
Total Proceeds = [64.4867 x (# of B/E Aerospace shares owned)] – (Reorganization fee).
For example, if you owned 100 BEAV shares your total proceeds would be (6448.67 – Reorganization fee).
Use the Suspense account to receive the sale proceeds.
Date this transaction 4/13/2017.
2. Transfer Cash Received
Transfer from the Suspense account to the Broker account (or bank if appropriate), all merger consideration cash received from this merger transaction. This will be the amount of the $34.10 per B/E Aerospace share minus any reorganization fee charged. If your Suspense account balance was zero when you entered the sell transaction above, then the balance after transferring the merger cash received will be the total purchase price of the Rockwell Collins shares you received in this merger. For example, if you owned 100 B/E Aerospace shares your cash portion of the merger consideration was $3410.00 – reorganization fee. ([34.10 x 100] –reorganization fee).
3. Buy Transaction
Enter a buy transaction for the number of Rockwell Collins shares entitled to receive in this merger. This will be .3101 x (# of B/E Aerospace shares owned). For example if you owned 100 B/E Aerospace shares then enter 31.01 Rockwell Collins shares purchased (.3101 x 100).
Date the transaction 4/13/2017. The total purchase price will be the amount remaining in the Suspense account, if the Suspense balance was zero when this process was started. The amount should be (30.3867 x # of B/E Aerospace shares owned). For example, if you owned 100 B/E Aerospace shares, then the total purchase cost would be 3038.67.
Choose the Suspense account as the source of funds for the purchase. Save the buy transaction.
4. Fractional Share Sale
The fractional shares received in this merger will likely be sold by your broker.
Enter a Sell transaction for the fractional shares dated 4/14/2017. The share amount will be the NON-whole part of the shares bought in the buy transaction above. For example if you owned 100 B/E Aerospace shares then you entered 31.01 Rockwell Collins shares purchased. You would sell .01 Rockwell Collins shares in this Sell transaction.
The total proceeds will be the cash-in-lieu amount listed on your broker statement.
For Myiclub.com users
Use the Merger with cash security transaction.
Step 1. Choose B/E Aerospace (BEAV) as the merging company and date the transaction 4/13/2017.
Step 2. Select the option Transaction is fully taxable. Enter the following additional information:
Cash per share received: 34.10
Exchange ratio: .3101 to 1
Price per share of new shares: 97.99
Reorganization fee: From your broker statement, if one was charged.
Symbol of new company: COL
Cash received: Cash-in-lieu amount from broker statement.
Other fields should auto-fill from the information already entered.
Note: In Merger with cash transactions, realizedcapital gains and the cost basis of the new shares have a component dependent on the price per share entered in the entry screens. In our experience brokers tend to use the price per share published by the companies on their websites in their guidance to shareholders. If the companies publish guidance with a share price, we use that share price in our instructions to minimize possible differences between the accounting records and broker information. In cases where no guidance is available, we will choose the lower of the opening or closing price on the effective date. Either of these prices is acceptable to the IRS and by choosing the lower price some realized capital gains will be deferred to a later date. However, there is always the chance the price we choose will not be the price chosen by your broker. The gain from the merger and cost basis of the new shares recorded in your accounting records will then differ from your broker information. Because of the lack of detail in the tax code, both our choice and your broker’s choice would be reasonable estimates of market value for the shares received. Your records are NOT incorrect because they differ from your broker. Tax return forms do have specific areas to report these usually small differences. Our tax printer software handles these adjustment entries automatically in the normal operation of the software.