eBook Show Me How ofice 365 Printem Dividends per share Lightfoot Inc, software development form, bas stock outstanding as follows: 50,000 shares of cumulative preferred to stock, 1105 per a 99.000 pares at 5:30 pw common During its first four years of operations, the following amounts were distributed as dividende, first year, 537,000; seconut vew, 348,000 thiet von 580,000, truth 122,000 This information has been collected in the Microsoft Excel Online bile Open the core duhet, verform the required araw, and rout our went to be Oponsoredsheet Determine the dividends per share on each class of stock for each of the four years. Round your answers to the nearest contendere per Ist Year 2nd Year 3rd Year 4th Year Preferred stock (dividende per share) Commonweck (dividende per share) le Home P Search - Insert Draw Page Layout Formulas Data Rave Vw Hal Arial 10 B diting 2 A Dividende pershane Lightfootine a soware development firmos stockoutsanding and dividends darbuted as follows 1305 DATA Cuiere med stock Shares outstanding 7 Dividend right 50.000 . Para Common shock 10 Shes outstanding 11 90.000 Parole 12 Dividends cistole 1120 13 styr 14 $37.000 dy 15 50.000 3rd year 50.000 year $122.000 Using formulas and cell reces, perform the required analysis, and not your into the Dividends Parcourse it for the to green antyceli B22 E23) into the appropriate faids in CNCW2 for grading 19 20 Dividends Perhe 20 na var ver 22 Prem Stock 23 Common ok Farmalar 1 2nd Year 17 BData