what formulas wouldni use for the answers ?

G Preferred Shares 80,000 Preferred Dividend 75% Preferred Par Value $5 Common Shares 200,000 Common Par Value $1 D E 2 York's outstanding stock consists of 80,000 shares of cumulative 7.5% preferred stock with 3 a $5 par value and also 200,000 shares of common stock with a $1 par value. During its 4 first four years of operation, the corporation declared and paid the following total cash 5 dividends: 6 7 Year 1 total cash dividends $20,000 Year 2 total cash dividends 28,000 9 Year 3 total cash dividends 200,000 10 Year 4 total cash dividends 350,000 11 12 Required: 13 14 (Use cells A2 to J10 from the given information to complete this question.) 15 Dividend per Number of Par Value per Dividend Preferred Preferred 16 Preferred Share Rate Share Shares 17 Annual Preferred Dividend: Year Total Cash Paid to Paid to Dividends in Dividend Paid Preferred Common Arrears at 18 year-end 19 1 $20,000 20 2 28,000 21 3 200,000 22 4 350.000 23 Totals $598,000 Preferred Dividend