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. stock

Total of portfolio Previous fair value adjustment balance Fair value adjustment—Cr.

December 31, 2013

Cost

$20,000 10,000 20,000

$50,000

Fair Value

$19,000 9,000 20,600

$48,600

Unrealized 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,