Dividends per share

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

Open spreadsheet

$\backslash$table$[[,1$st Year,$2$nd Year,$3$rd Year,$4$th Year$],[$Preferred stock $($dividends per share$),$$$,$$$,$$$,],[$Common stock $($dividends per share$),,,,]]$