please solve & prvide the excel formulas to get each answer (or just the equations)

2 York's outstanding stock consists of 80,000 shares of cumulative 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