%24 %23 AutoSave H UnitllILabAssignment Question8 Protected View O Search (Alt+Q) Off Home Insert Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can...

Extracted text: %24 %23 AutoSave H UnitllILabAssignment Question8 Protected View O Search (Alt+Q) Off Home Insert Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing :X v fx Function: SUM; Formula: Multiply, Subtract; Cell Referencing D E B. C. F. H. Function: SUM; Formula: Multiply, Subtract; Cell Referencing B Using Excel to Determine Dividends Paid to Common 4 and Preferred Stockholders Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work 5 PROBLEM 6 M. Bot Corporation has common stock and cumulative 7 preferred stock outstanding at December 31, 2022. No 8 dividends were declared in 2020 or 2021. area as indicated. What amount of dividends will common stockholders receive? Total dividend payment in 2022 $ 375,000 11 Preferred stock par value Annual preferred dividend 12 Preferred dividend rate 8% 13 Cumulative preferred stock, Total dividends 14 outstanding shares Allocated to preferred stock: 15 000 0 Dividends in arrears 16 2020 dividend Common stock dividends 18 21 22 23. 24 25 26 32 Enter Answer Ready 144 & %24 5. 09 3. 08.