Rockwell Collins (COL) and United Technologies (UTX) merger

United Technologies (UTX) acquired Rockwell Collins (COL) in a cash and stock deal. The SEC filing for this merger can be found at the United Technologies web site at: . An IRS form 8937 was not available on the United Technologies web site when these instructions were written.

This merger is a cash-plus-stock reorganization. This is a fully taxable merger with cash. For tax purposes this is treated as a sale of Rockwell Collins 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 United Technologies. All the information below is from the form S-4/A filed with the SEC posted on the UTX web site. The first instructions are for users of the desktop software, Club Accounting 3. Instructions for users follow later in this document.

Sell Transaction

The total merger consideration is $141.3545 per Rockwell Collins share. This is $93.33 in cash and $48.0245 in United Technologies shares (.37525 x 127.98). The closing price of United Technologies on the day the merger completion was announced was $127.98. Calculate the total value received for your Rockwell Collins shares by multiplying 141.3545 by the total shares of Rockwell Collins owned.

  • Total Proceeds = [141.3545 x (# of Rockwell Collins shares owned)] – (Reorganization fee).
  • For example, if you owned 100 COL shares your total proceeds would be (14135.45 – Reorganization fee).
  • Use the Suspense account to receive the sale proceeds. Date this transaction 11/26/2018

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 $93.33 per Rockwell Collins 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 United Technologies shares you received in this merger. For example, if you owned 100 Rockwell Collins shares your cash portion of the merger consideration was $9333.00 – reorganization fee. ([93.33 x 100] – reorganization fee).

Buy Transaction

Enter a buy transaction for the number of United Technologies shares entitled to receive in this merger. This will be .37525 x (# of Rockwell Collins shares owned). For example if you owned 100 Rockwell Collins shares then enter 37.525 United Technologies shares purchased (.37525 x 100).
Date the transaction 11/26/2018. 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 (48.0245 x # of Rockwell Collins shares owned). For example, if you owned 100 Rockwell Collins shares, then the total purchase cost would be 4802.45.
Choose the Suspense account as the source of funds for the purchase. Save the buy transaction.

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 11/27/2018. The share amount will be the NON-whole part of the shares bought in the buy transaction above. For example if you owned 100 Rockwell Collins shares then you entered 37.525 United Technologies shares purchased.
You would sell .525 United Technologies shares in this Sell transaction.
The total proceeds will be the cash-in-lieu amount listed on your broker statement.


For users

Use the Merger with cash security transaction.

Step 1. Choose Rockwell Collins (COL) as the merging company and date the transaction 11/26/2018.

Step 2. Select the option Transaction is fully taxable. Enter the following additional information:

  • Cash per share received: 93.33
  • Exchange ratio: .37525 to 1
  • Price per share of new shares: 127.98
  • Reorganization fee: From your broker statement, if one was charged.
  • Symbol of new company: UTX
  • Cash received: Cash-in-lieu amount from broker statement. Other fields should auto-fill from the information already entered.


In Merger with cash transactions, realized capital 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.