Answer a, b and c in a format compatible with excel please

P16-3B On December 31, 2012, Eli Associates owned the following securities, held as long-term investments. Common Stock Trowbridge Co. Holly Co. Oriental Motors Co. Shares 4,000 $100,000 5,00030,000 3,000 Cost 60,000 On this date, the total fair value of the securities was equal to its cost. The securities are not held for influence or control over the investees. In 2013, the following transactions occurred. July 1 Aug. 1 Sept. 1 Received $1 per share semiannual cash dividend on Holly Co. common stock. Received S0.50 per share cash dividend on Trowbridge Co. common stock. Sold 1,500 shares of Holly Co. common stock for cash at $8 per share, less brokerage fees of $300. Oct. 1 Sold 600 shares of Trowbridge Co. common stock for cash at $30 per share, less brokerage fees of $600 Received $1 per share cash dividend on Oriental Motor Co. common stock. Received $0.50 per share cash dividend on Trowbridge Co. common stock. Nov. 1 Dec. 15 31 Received $1 per share semiannual cash dividend on Holly Co. common stock. At December 31, the fair values per share of the common stocks were: Trowbridge Co. $23, Holly Co. $7, and Oriental Motors Co. $19 Instructions (a) Journalize the 2013 transactions and post to the account Stock Investments. (Use the T-account (b) Prepare the adjusting entry at December 31, 2013, to show the securities at fair value. The stock (c) Show the balance sheet presentation of the investment-related accounts at December 31, 2013 form should be classified as available-for-sale securities. At this date, Eli Associates has common stock $2,000,000 and retained earnings $1,200,000