PLEASE PUT IN EXCEL FORMAT

York's outstanding stock consists of 80,000 shares of cumulatwe 7.5% preferred stock with a S5 par value and ako 200,000 shares of common stock whth a $1 par velue Durine its first four years of operation, the corporation declared and paid the following focal cash dividends: Alequired: Determine the amount of dividends paid each vear to each of the two classes of stockholders: preferred and common Compute the totai an