B C D E G Function: SUM; Formula: Multiply, Subtract; Cell Referencing Using Excel to Determine Dividends Paid to Common and Student Work Area Preferred Stockholders Required: Provide input into cells shaded in yellow in this template. Use PROBLEM mathematical formulas with cell references to the Problem or work area as M. Bot Corporation has common stock and cumulative preferred indicated. stock outstanding at December 31, 2022. No dividends were declared in 2020 or 2021. What amount of dividends will common stockholders receive? Total dividend payment in 2022 375,000 11 Preferred stock par value 100 Annual preferred dividend 12 Preferred dividend rate 8% 13 Cumulative preferred stock, Total dividends 14 outstanding shares 10,000 Allocated to preferred stock: 15 Dividends in arrears 16 2020 dividend 17 Common stock dividends 18 19 20 21 22 24 25 26 27 28 30