Lightfoot Inc., a software development firm, has stock outstanding as follows: 36,000 shares of cumulative preferred 1% stock, $150 par and 110,000 shares of $190 par common. During its first four years of operations, the following amounts were distributed as dividends: first year, $34,000; second year, $68,000; third year, $75,000; fourth year, $132,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