Dividends per share 2 Lightfoot Inc., a software development firm, has stock outstanding and dividends distributed as follows: 3 4 DATA 5 Cumulative preferred stock 6 Shares outstanding 46,000 7 Dividend right 1% 8 Par value $110 9 Common stock 10 Shares outstanding 98,000 11 Par value $135 12 Dividends distributed: 13 1st year $40,000 14 2nd year $48,000 15 3rd year $78,000 16 4th year $134,000 17 Using formulas and cell references, perform the required analysis, and input your answers into the Dividends Per Share columns. Transfer the numeric results for 18 the green entry cells (B22:E23) into the appropriate fields in CNOWV2 for grading 19 20 Dividends Per Share 21 1st Year 2nd Year 3rd Year 4th Year 22 Preferred stock $40,000.00 $18,000.00 $78,000.00 $134,000.00 23 Common stock 24 25 Formulas 26 1st Year 2nd Year 3rd Year 4th Year 27 Your answer should be a formula. Your answer should be a formula Your answer should be a formula Your answer should be a formula 28