Can you do both plz...

YOU MUST SHOW YOUR WORK TO RECEIVE FULL CREDIT (All work must be in excel format. Please be clear and systematic) 1 50 $1,000 bonds with a carrying value of $57,500 are converted into 5,000 shares of $4 par value common stock. The common stock had a market value of $20 per share on the date of conversion. The entry to record the conversion is: (10 points) 2 As of January 2021, Dress For Success Inc. has 5% Preferred stock, $100 par value 10,000 shares issued and outstanding; Common stock, $5 par value, 100,000 shares issued and outstanding.(40 points) $ 60,000 P/F dividend per year 2019 The following dividends were declared and paid in 2020, 2021 and 2022 No dividends were declared and paid $15,000 $40,000 $110,000 2020 2021 2022 a) Assuming the preferred stock were non-cumulative, how much dividends did preferred and common stockholders receive for each year dividends were declared. (15 points) DATE DIVIDEND P/F CIS b) Assuming the preferred stock were cumulative, how much dividends did preferred and common stockholders receive for each year dividends were declared. (25 points) DIVIDEND Total Owed to PF P/F Paid ARREARS c/S DATE 2019 2020 2021 2022 TOTALS *Owed to PF