Accounting question about trading securities entries

profilemorenito98

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, 2014.

    • 9 years ago
    • 10
    Answer(4)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      e17-7.doc

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      trading_securities_entries.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      prepare_adjusting_entries_with_the_information_provided.docx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      acc_423_week_3_individual_exercises_e17-1_e17-7_e17-12_q_1_and_26.xlsm