Can someone help me?

Has to be in excel.

You have been provided with the December 31, 2023 Trial Balance for Raf Repairs, a computer repair company, but the following selected transactions during the fiscal year ended December 31,2023 , have not yet been recorded. a. Issued 15,000 shares of $20 par common stock at $30, receiving cash. b. Issued 4,000 shares of $80 par preferred $1 stock at $100, receiving cash. c. Issued $500,000 of 10 -year, 5% bonds at 104 , with interest payable semiannually. d. Declared a quarterly dividend of $0.50 per share on common stock and $1.00 per share on preferred stock. On the date of record, 100,000 shares of common stock were outstanding, no treasury shares were held and 20,000 shares of preferred stock were outstanding. e. Paid the cash dividends declared in (d). f. Purchased 8,000 shares of treasury common stock at $33 per share. g. Declared a $1.00 quarterly cash dividend per share on preferred stock. On the date of record, 20,000 shares of preferred stock had been issued. h. Paid the cash dividends to the preferred stockholders. i. Sold, at $38 per share, 2,600 shares of treasury common stock purchased in (f). j. Recorded the payment of semiannual interest on the bonds issued in (c) and the amortization of the premium for 6 months. The amortization is determined using the straight-line method. Ch. 15 Transactions: k. Purchased 4% bonds issued by Pioneer Corp. as an available-for-sale investment for $300,150. I. Purchased 40,000 shares of Transy Co.'s common stock directly from the founders for $24 per share. Transy has 125,000 shares issued and outstanding. m. Received \$27,500 dividend from Transy Coa. investment in (1). n. Purchased $90,000 of Crimson Inc. 10-year, 5% bonds, directly from the issuing company, at their face amount plus accrued interest of $375. The bonds are a held-tomaturity investment. o. Received interest of $6,000 from the Pioneer Corp. investment in (k). p. Sold Pioneer Corp. bonds with a face value of $40,020 for $45,000, realizing a gain of $4,980. q. Accrued interest for 3 months on the Crimson Inc. bonds purchased in (n). r. Transy Co. reported total earnings of $240,000. Raf Repairs recorded its share of Transy Co. net income using the equity method. s. The Pioneer Corp. bonds have a fair value of $253,630 on December 31, 2023. Valuation Allowance for Avallable-for-Sale Investments had a balance of zero on January 1, 2023. Your assignment: 1. Journalize the above transactions. 2. Prepare the below-listed financial statements. Note that you'll need to adjust the provided trial balance by your journal entries in (1). You will be graded on formatting of the statements. Please refer to prior chapters in your book for examples (Ch. 1, 4, 6, 13) a. Income statement for the year ended December 31, 2023. b. Retained earnings statement for the year ended December 31, 2023. c. Balance sheet as of December 31, 2023