please show the excel formulas for answers. Under "paid to preferred" column all answers must include the =MIN function

2 York's outstandiag stock consists of 80,000 shares of noncumulative 7.5% preferred stock with a $5 3 par value and ako 200,000 shares of common stock. With a $1 par value, buring its first four years of 4. operation, the corporation declared and poid the following total cash dividends: 13 required: 14. Defermine the amount of dividends paid each year to each of the two classes of stockholders: preferred and common