Dividends per share Lightfoot Inc., a software development firm, has stock outstanding and dividends distributed as follows: DATA Cumulative preferred stock: Shares outstanding 42,000 Dividend right 1% Par value $125 Common stock: Shares outstanding 110,000 Par value $160 Dividends distributed: 1st year $33,000 2nd year $58,000 3rd year $74,000 4th year $119,000 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 green entry cells (B22:E23) into the appropriate fields in CNOWv2 for grading