Merck spinoff of Organon - thread for all related questions/comments

splasher
splasher SuperUser ✭✭✭✭
Please use the thread to consolidate any/all questions and answers for the Merck spinoff of Organon.
-splasher  using Q since 1996 -  Subscription  -  Win10
-also older versions as needed for testing
-Questions? Check out the  Quicken Windows FAQ list

Answers

  • G. Scott Phillips
    G. Scott Phillips Member ✭✭
    Thanks so much for creating this thread. Could someone please tell me exactly how to enter the Organon spin-off transaction into Quicken? I received 28 shares of Organon and $29.89 in cash. Thanks again!
  • splasher
    splasher SuperUser ✭✭✭✭
    edited June 4
    You will do a "Corporate Securities Spin-Off" transaction.
    Do not create the new security yet, the above transaction will create it.
    The new shares per old share will be .10 (1/10th).
    You will need to wait to do this until someone comes up with the appropriate old and new share prices which have not been published yet.
    The spin-off will generate a fractional share which you will get cash for and you will need to sell that fractional share for the appropriate cash amount (info from your FI).

    The bottom line to this is, patience.  Wait for the numbers and do this once and get it correct.
    Another thing, make a backup before you do this so that if the results aren't correct, you can restore and get back to where before you were doing the spin-off.
    -splasher  using Q since 1996 -  Subscription  -  Win10
    -also older versions as needed for testing
    -Questions? Check out the  Quicken Windows FAQ list
  • splasher
    splasher SuperUser ✭✭✭✭
    edited June 4
    NOTE: I can't stress this enough, you really want to wait for the numbers since the spin-off creates a RtrnCapX and a MiscIncX for Merck and an "Added" shares & basis for Organon for every lot of Merck, in my case that is 35 transactions (lots of reinvested dividends).
    So wait for the correct share prices.
    -splasher  using Q since 1996 -  Subscription  -  Win10
    -also older versions as needed for testing
    -Questions? Check out the  Quicken Windows FAQ list
  • vikingsail
    vikingsail Member ✭✭
    Merck needs to issue the form 8937 which will have all the information you need, note it usually takes about 2 weeks for this form to be issued. See pfizer viatris spinoff for an example.
  • GermanBlueRam
    GermanBlueRam Member ✭✭
    Somehow I hadn't even noticed this in the news, leading up to spinoff. I have 100 shares of MRK and now I have 10 shares of OGN. Per fidelity.com, my cost basis per share in OGN is $36.34. My previous cost basis in MRK was $76.23, and now it is $72.60.
    Quicken for Windows subscription. Quicken user since 1990.
  • splasher
    splasher SuperUser ✭✭✭✭
    Somehow I hadn't even noticed this in the news, leading up to spinoff. I have 100 shares of MRK and now I have 10 shares of OGN. Per fidelity.com, my cost basis per share in OGN is $36.34. My previous cost basis in MRK was $76.23, and now it is $72.60.
    Good info for Fidelity clients in that the basis of Merck is decreased by the amount assigned to Organon, hopefully Edward Jones will finalize their basis #s soon and it lines up with the official Merch/Organon documents.
    -splasher  using Q since 1996 -  Subscription  -  Win10
    -also older versions as needed for testing
    -Questions? Check out the  Quicken Windows FAQ list
  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    edited June 6
    I recently updated my position on the Corporate Spinoff macro-transaction.  They fixed (sometime) a minor glitch and apparently took a step forward on another issue I raised but not wholly to my satisfaction.
    https://community.quicken.com/discussion/7882806/corporate-spinoff-in-r29-9-and-later-editions#latest

    For anyone heading this direction - be sure to have a good backup or copy available first.
    Somehow I hadn't even noticed this in the news, leading up to spinoff. I have 100 shares of MRK and now I have 10 shares of OGN. Per fidelity.com, my cost basis per share in OGN is $36.34. My previous cost basis in MRK was $76.23, and now it is $72.60.
    Your numbers suggest that your cost basis for the 10 shares of OGN became $363.40 and that the MRK 100 shares lost $363 in cost basis.  Those are close but should match exactly.  That is one reason I prefer to talk about the entire lot rather than per share.  

    If you know the two cost basis figures after the spinoff, then there is a fixed ratio between the fair market values (share costs) for the two stocks
    Price(OGN) / Price (MRK) = Cost Basis(OGN) / [Cost Basis(MRK) x Share Ratio]
    In your case:  Price(OGN) / Price (MRK) = 363.40 / [7259.60 x 0.1] = 0.500579
    Choose a price for MRK on 6/3 (say its close of 73.91, the corresponding price for OGN is 0.500579 x that chosen value (36.998).  Using those two values in the data entry window for the Corporate Spinoff should result in the appropriate cost basis values for both stock lots.

    When Merck issues the IRS Form 8937 for this transaction, they likely will offer fair market values to use.  Those values may or may not match with what your brokerage uses.  Your choice on how to deal with it.

    At this point, I can support the use of Quicken's Corporate Spinoff as I show below (using @GermanBlueRam figures).

    The popup form
          

    Should result in three transactions (for a one-lot holding)


    I would choose to delete the second transaction (MiscIncX) and edit the first transaction in-line to get to:


    Note that the Fair Market value on the RtrnCapX transaction has been changed to 369.98 corresponding to the fair market value of the 10 shares of OGN received (36.998 * 10).   

    If you have multiple lots of MRK to begin with, you will need to check that each lot of MRK has been properly decreased and each lot of OGN has been properly created (right cost basis value for each).

    Thanks so much for creating this thread. Could someone please tell me exactly how to enter the Organon spin-off transaction into Quicken? I received 28 shares of Organon and $29.89 in cash. Thanks again!
    Your data and cash info suggest you held about 288 shares of MRK going into this and were due to receive then 28.8 shares of OGN.  Since they did not distribute fractional shares you got 28 shares and 29.89 in cash.  

    You would go through exactly the same process I outlined above with Quicken generating the 28.8 shares of OGN in your account.  Then you would sell the fractional share for the $29.89 cash-in-lieu received.  


  • Caryl
    Caryl Member ✭✭
    When I did the One Step Update on Quicken the other day it added Organon to the three accounts that have Merck. However, it left the cost basis column empty. I looked at the different accounts on the Fidelity website and there is a different cost basis for each one. Should I delete the added Organon on all the accounts and instead use the Corporate Securities Spinn-off?
  • splasher
    splasher SuperUser ✭✭✭✭
    edited June 7
    @Caryl
    Using the transactions downloaded from the financial institution will probably get you the correct QTY of Shares correct, but it will probably not get the Cost Basis and Return of Capital correct for both Merck and Organon.
    If you care about the Basis of both securities, I'd delete any existing transactions for the two since the day of the split along with removing Organon from the security list since the Corporate Securities Spin-off will add it to the list for you (in fact it will complain if it pre-exists).
    -splasher  using Q since 1996 -  Subscription  -  Win10
    -also older versions as needed for testing
    -Questions? Check out the  Quicken Windows FAQ list
  • GermanBlueRam
    GermanBlueRam Member ✭✭
    Good stuff, @q_lurker and @splasher - much appreciated.
    Quicken for Windows subscription. Quicken user since 1990.
  • canoe32
    canoe32 Member ✭✭✭
    edited June 12
    Vanguard has now updated my basis for both Merck and Organon. The total basis for 20 shares of Organon was $3.43 less than Quicken calculated using the closing prices. Time to make a backup copy  and edit Quicken's entries.
  • joev929
    joev929 Member ✭✭
    > @splasher said:
    > You will do a "Corporate Securities Spin-Off" transaction.
    > Do not create the new security yet, the above transaction will create it.
    > The new shares per old share will be .10 (1/10th).
    > You will need to wait to do this until someone comes up with the appropriate old and new share prices which have not been published yet.
    > The spin-off will generate a fractional share which you will get cash for and you will need to sell that fractional share for the appropriate cash amount (info from your FI).
    >
    > The bottom line to this is, patience.  Wait for the numbers and do this once and get it correct.
    > Another thing, make a backup before you do this so that if the results aren't correct, you can restore and get back to where before you were doing the spin-off.
  • joev929
    joev929 Member ✭✭
    Just received paperwork from Shareowner Services with Organon shares, no price per share with a settlement date of 6/2/21. However there was also a letter from Organon which shows this is effective for shareholders of record as of 5/17/21, closing price was $34.10 that day. Would 5/17 be the actual date to use for this spinoff. Also in other paperwork Merck was treating it as "a special dividend," does that enter the picture in any way? Thanks
  • canoe32
    canoe32 Member ✭✭✭
    edited June 12
    I had done the "Corporate Securities Spin-Off" a few days ago using the closing prices, knowing that it might require tweaking later. I had round lots, so at least there was no fractional share to deal with. The "tweaking" was easier than I expected.
  • canoe32
    canoe32 Member ✭✭✭
    edited June 12
    The date 5/17/21 for "shareholders of record" is the date after which, if you bought Merck shares, you would not receive Organon shares. If you held Merck shares on or before that date you would receive Organon shares. It is not the date of the spinoff, which was 6/2/2021. The "special dividend" does not matter to Quicken. 
Sign In or Register to comment.