I need help this excel sheet question and also formulas sheet too

A B C D F G 2 3 Parnevik Company hnd the following securities in its investment portfolio on December 31, 2017 (all securities werd purchased in 2017): Shares Total Cost Anderson Co. common stock 3,000 $ 58,500 Munter Ltd. common stock 10,000 580,000 King Company preferred stock 6,000 255,000 9 Other information concerning the company's investments follows Fair Value Adjustment mocount balance at 12/31/2017 (credit) 10,100 In 2018, Parnevik completed the following securities transactions Sale of Anderson common stock on January 15 Selling price per share Number of shares sold Fees associated with the sale 22.00 3,000 2,150 Purchase of Castle common stock on April 17 Purchase price per share Number of shares purchased Fees associated with the purchase 33.50 1,000 1,980 25 On December 31, 2018, the market prices per share of these securities were: Munter Ltd. King Co. Castle Co 61.00 40.00 29.00 30 31 In addition, the accounting supervisor of Parnevik told you that, even though all these securities have readily 32 determinable fair values, Pamevik will not actively trade these securities because the top management intends to hold 33 them for more than one year. 35 Instructions: Do not show "cents in amounts 36 (a) Prepare the entry for the security sale on January 15, 2018 37 38 C alculation of vain or loss on sale of investments: P17-5 + Instructions: Do not show "cents in amount (@) Prepare the entry for the security sale on January 15, 2018 Calculation of gain or loss on sale of investments: Sale proceeds from selling Anderson shares Fees associated with the sale Net proceeds from the sale Cost of Anderson shares Gain or loss on the sale The amounts in the journal entry below must be linked to the above computation. Debit Credit Jan. 15 53 (b) Prepare the journal entry to record the security purchase on April 17, 2018 Security purchased: Castle common stock Calculation of total purchase price: Purchase price of Castle common stock Fees associated with the purchase Total cost of investment Debit Apr. 17 05 (0) Compute the unrealized gains or losses and prepare the adjusting entry for Pamevik on December 31, 2018 All information must be entered using cell addresses. The "Cost" amounts in the following table should not be entered as negative numbers. Equity Portfolio December 31, 2018 Unrealized Gain Falt P17-5 + Ready BIU Merge & Cer A1 B C D securny parcmescu. Cu O SIEK Calculation of total purchase price: Purchase price of Castle common stock Fees associated with the purchase Total cost of investment Debit Credit or. 17 (c) Compute the unrealized gains or losses and prepare the adjusting entry for Pamevik on December 31, 2018 All information must be entered using cell addresses. The "Cost" amounts in the following table should not be cntered as negative numbers. Equity Portfolio-December 31, 2018 Unrealized Fair Gain Securities Cost Value (Loss) Total portfolio Remember, crec Fair value adjustment required at 12/31/2018 Debit Credit