Dividends per share

Lightfoot Inc., a software development firm, has stock outstanding as follows: $33,000$ shares of cumulative preferred $1\%$ stock, $$150$ par and $90,000$ shares of $$180$ par common. During its first four years of operations, the following amounts were distributed as dividends: first year, $$26,000$; second year, $$55,000$; third year, $$78,000$; fourth year, $$130,000.$ This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.