taksimentMandoliverBakeAssignmentSessionLocatori progresse Book 4 Show Me How Omce 365 From Dividends per share Lightfootine, software development firm, tres stock outstanding as follows: 50.000 shares of cutive preferred 1 stock, 5105 putand 99,000 shares of 5120 per common During its first four years of operations, the following amounts were distributed as dividends first year, 137,000, second year. 348,000 thieve, 500,000 fourth w. 1122000 This information has been collected in the Microsoft Excel Online e Open the spreadsheet perform the red yes, and input your answers in the question below Open spreadsheet Determine the dividends per share on each class of stock for each of the four years. Round your answers to the nearest centre dividends are paid in a given year, unter "o" 1st Year 2nd Year 3rd Year 4th Year $ Preferred stock (dividends per share) 5 | Common stock (dividends per share) 2:8