DO NOT ANSWER IN NUMBERS ONLY EXCEL FORMULAS PLEASE!

York's outstanding stock consists of 80,000 shares of noncumulative 7.5% preferred stock with a $5 par value and also 200,000 shares of common stock with a $1 par value. During its first four years of operation, the corporation declared and paid the following total cash dividends: 3 Required: 4 Determine the amount of dividends paid each year to each of the two classes of stockholders: preferred and common