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 dynamic so you can change your data easily.

The shareholders' equity of HS Corporation includes $280,000 of $1 par common stock and $580,000 par of 7% cumulative preferred stock. The board of directors of HS declared cash dividends of $68,000 in 2018 after paying $28,000 cash dividends in 2017 and $48,000 in 2016