Accounting question about trading securities entries
There is a question that I need to solve in Excel.On December 21, 2013, Bucky Katt Company provided you with the following information regarding its trading securities.Investments (Trading)Clemson Corp. stock Colorado Co. stock Buffaloes Co. stockTotal of portfolio Previous fair value adjustment balance Fair value adjustmentCr.December 31, 2013Cost$20,000 10,000 20,000$50,000Fair Value$19,000 9,000 20,600$48,600Unrealized Gain (Loss)$(1,000) (1,000)600(1,400) 0$(1,400)During 2014, Colorado Company stock was sold for $9,400. The fair value of the stock on December 31, 2014, was Clemson Corp. stock$19,100; Buffaloes Co. stock$20,500.(a)Prepare the adjusting journal entry needed on December 31, 2013. (b) Prepare the journal entry to record the sale of the Colorado Company stock during 2014. (c)Prepare the adjusting journal entry needed on December 31,