Annette's Accessories had the following stock issued and outstanding at January $1,2019.150,000$ shares of $$1$ par common stock $10,000$ shares of $$50$ par, $8\%,$ cumulative preferred stock On March $5,2019,$ Annette's declared a $ $100,000$ cash dividend to be paid March $31$ to shareholders of record on March $21.$ Required Set up a spreadsheet to calculate the total amount of dividends to paid to preferred and common shareholders under the following alternative situations : a $.$ No dividends are in arrears for preferred shareholders $.$ b $.$ One year's worth of dividends is in arrears for preferred shareholders $..$ Two years $\text{'}$ worth of dividends is in arrears for preferred shareholders d $.$ Instead of a $ $100,000$ dividend $,$ Annette's paid a $ $70,000$ dividend and one year of dividends was in arrears $.$ Spreadsheet Tips The following spreadsheet provides one method of setting up formulas for all possible alternatives $.$ The spreadsheet also reflects the results of requirement a$.$ATC $11-9$ Spreadsheet Assignment Using Excel

Annette's Accessories had the following stock issued and outstanding at January $1,2019.$

$150,000$ shares of $$1$ par common stock

$10,000$ shares of $$50$ par, $8\%,$ cumulative preferred stock

On March $5,2019,$ Annette's declared a $$100,000$ cash dividend to be paid March $31$ to shareholders of record on March $21.$

Required

Set up a spreadsheet to calculate the total amount of dividends to be paid to preferred and common shareholders under the following

alternative situations:

a$.$ No dividends are in arrears for preferred shareholders.

b$.$ One year's worth of dividends is in arrears for preferred shareholders.

c$.$ Two years' worth of dividends is in arrears for preferred shareholders.

d$.$ Instead of a $$100,000$ dividend, Annette's paid a $$70,000$ dividend and one year of dividends was in arrears.