Cortive fancial statement dans of Tyler, Inc. Follow # TA w Year Instructor 1. Create a horontally of the income Statement in a new Excel spreadsheet 2. Det vertical analysis of the Balance Sheet for 2016 and 2015, Please use the same prehet credintruction. You can either put this on a new tab of the tortadorast or you can put it below the income Statement, Compute the following rates using the data on both the income Statement and the Balance Sheet. These should be on the same icel spreadieet either on a new tab or leted below the statements a. Current ratio bentory turnover Day's sales in inventory d. Accounts receivable tumover e Day's sales in receivables 1.Grow profit percent 4. Write a short surmary of how this company improved or did not improve from 2015 to 2016. Please use information from the horizontal analysis, vertical analysis and ratio analysis to support your opinion. This should be done on the same Excel spreadsheet 5. Save your spreadsheet as Module assessment followed by your last name Module assessment Pace) 6. Attach the file to the Learning Assessment submission page rece Tec 1. Market price of Tyler's common stock: $84.32 at December 31, 2016, and $51.75 at December 31, 2015 2. Common shares outstanding: 10,000 during 2016 and 9,000 during 2015 and 2014. 3. All sales are on credit. Cortive fancial statement dans of Tyler, Inc. Follow # TA w Year Instructor 1. Create a horontally of the income Statement in a new Excel spreadsheet 2. Det vertical analysis of the Balance Sheet for 2016 and 2015, Please use the same prehet credintruction. You can either put this on a new tab of the tortadorast or you can put it below the income Statement, Compute the following rates using the data on both the income Statement and the Balance Sheet. These should be on the same icel spreadieet either on a new tab or leted below the statements a. Current ratio bentory turnover Day's sales in inventory d. Accounts receivable tumover e Day's sales in receivables 1.Grow profit percent 4. Write a short surmary of how this company improved or did not improve from 2015 to 2016. Please use information from the horizontal analysis, vertical analysis and ratio analysis to support your opinion. This should be done on the same Excel spreadsheet 5. Save your spreadsheet as Module assessment followed by your last name Module assessment Pace) 6. Attach the file to the Learning Assessment submission page rece Tec 1. Market price of Tyler's common stock: $84.32 at December 31, 2016, and $51.75 at December 31, 2015 2. Common shares outstanding: 10,000 during 2016 and 9,000 during 2015 and 2014. 3. All sales are on credit
