Please do in excel

Peck Company purchased Sanno Company common stock in a series of open-market cash purchases from 2022 through 2024 as follows: Sanno Company had 18,000 shares of $20 par value common stock outstanding during the entire period. Retained earnings balances for Sanno Company on relevant dates were The market value per share for Sanno's shares on various dates is Dividends in the amount of $50,000 were distributed by Sanno Company only in 2024. Any difference between implied and book values is assigned to goodwill. Peck Company uses the cost method to account for its investment in Sanno Company. Investments with ownership less than 20% are classified as available for sale securities. Required: A. Prepare the journal entries that Peck Company would record on its books during 2024 to account for its investment in Sanno Company. B. Prepare the workpaper eliminating entries necessary to prepare a consolidated statements workpaper on December 31, 2024