2. Prepare a spreadsheet that provides all the information to answer the question for HS Corporation about dividends for Preferred and Common stock. Show all three years and the dividends paid for each preferred and common stock. Make it fluid or dynamics so you can change your data easily. (10 points) stock. The boerd of directors of Hs declared cash dividends of $78,000 in 2018 after paying $38,000 cash dividends in 2017 and $58,000 in 2016. The shareholders' equity of HS Corporation includes $380,000 of $1 par common stock and $680,000 par of 7% cumulative preferred Required: Is the amount of dividends common shareholders will receive in 2018? S 20,800