Excel snippet is for question 2. Please include how answers are found so that I may learn how to do it myself for a similar question. And if willing, please feel free to help with questions 3 and 4 as well.

2. Citroen Company provides the following information about its defined benefit pension plan for the year 2021 . a. Prepare a pension worksheet using the provided spreadsheet. b. Prepare the journal entry recording pension expense. 3. Opel Company has a $1,000 bond that is convertible into 10 shares of common stock (par value $10 ). At the time of conversion, the unamortized premium is $50. Please write the journal entry to record the conversion of the bonds. 4. Prior to 2020 , Follswagon Company issued 40,000 shares of 6% convertible, cumulative preferred stock, $100 par value. Each share is convertible into 5 shares of common stock. Net income for 2020 was $1,200,000. There were 600,000 common shares outstanding during 2020