the common stock is selling for $20 per share. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Required: 1. Determine the amount of dividends to be paid to each class of shareholder for each of the following independent assumptions. a. Preferred stock is nonparticipating and noncumulative. b. Preferred stock is nonparticipating and cumulative. Preferred dividends are 2 years in arrears at the beginning of the year. c. Preferred stock is fully participating and cumulative. Preferred dividends are 1 year in arrears at the beginning of the year. Andrews Company