Determining cash payments to stockholders The board of directors declared cash dividends totaling $1,500,000 during the current year. The comparative balance sheet indicates dividends payable of $280,000 at the beginning of the year and $130,000 at the end of the year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answer in the question below. mi Open spreadsheet What was the amount of cash payments to stockholders during the year? Round your answer to the nearest dollar $ Excel File Home Insert template Formulas Saved Data Review View 5 Help Tell me what you want to do Arial 10 Paste A A X Cut La copy Format Painter Clipboard 23 B IUR ab A DIMI 1 Unda $. % 8 Font Cond Forma fo Alignment Number D E No A 1 Determining cash payments to stockholders 2 3 DATA 4 Dividends declared 5 Dividends payable at the beginning of the year $1,500,000 Dividends payable at the end of the year $200,000 $130,000 Using formulas and cell references, perform the required analysis, and input your answer into the Amount column Transfer the numeric result for the green entry cell 8 (B11) into the appropriate field in CNOWV2 for grading. 9 10 Amount Formula 11 (Dividends paid to stockholders during the year 12 13 14 15 16 17 18 19 Data + Working Workbook Statistics