i need help with this problem, thank you.

Dividends per share Uhoot in a software development firm has to outstanding as follows: 49,000 shares of cumulative preferred stock, sua parand 96.000 shares of 5140 per mon. During its first four years of operations, the following amounts were distributed as dividend first year. 537.000 second yes, 550,000; third yn 579.000; fourth year, 5116,000. This informations been collected in the Microsoft acel One Open the spreadsheet perform the regured anys, and input your answers in the question below. TH Doon ashed Determ the vided pet share on each das ofte for each of the four years. Hound you to the nearest cent. I no videos are paid anyone 1 Year 2nd Year Sird Year 4th Year Preferred tack vidende one vi per D E Dividends per share Lightfoot Inc, a software development firm, has stock outstanding and dividends distributed as follows: $110 DATA Cumive preferred Stock Shares outstanding 49,000 Dividend night 15 Par value Common stock Share outstanding 96,000 1 Par value $140 2. Dividends distributed 1st your $37.000 4 2nd yo $50.000 15 3rd year $70,000 16 $116.000 12 Using formulas and cell references, perform the required analysis, and input your answers into the Dividends Per Share columns. Transfer the numeric results for the 10 green entry cells (622 23) into the appropriate fields in CNOWV2 for grading 19 20 21 Dividends Per Share 1 Year 22 Pred to 2nd Year and Year 4th Year 2) Corona 24 Formulas