Instructions: read the problem data and complete the calculations sections. Enter data in the cells and formulas in the yellow cells. I really need the formulas and what cells to times to what cell the first question is 1. Calculate the total dividndns and the per share didivdemds declared on each class of stock for the six years. There were no dividends in arrears on January 1 20122 calculate the avarage annual dividend per share for each class of stock for the six year period 3 if the market Patrice per share for preferred stock is $37.50 per share and $30.00 for common stock calculate the averages annual percentage return on inverstment. Again I really need to know what formulas to use like how to do them and the answer with the formula thank you so much and have a great day!!

\f, a; 8 30:: E asaztotmutm .39 in, _ ,. . omcuogumm. . o:_n> 5a rug-"mm 355m vote?,.mm , 8 min 2.. Sub ~25. s ; .28 a >5:ch Maegan 5. 9s owwnhsag xi 2: \"6 5mm .3 xuoum \"6 32\". 5mm :0 350% $522\". oELma 05 van mugging, _ r is ' .ixiisl x003. :oEEOQ Bis. Ea mmw 08m tor30...... 8H 62%.:an 3 w to vomtanU mm; E5 9: *0 xuoum wccmuao up: can; 53 *0 am .6anqu mEuco'H.