PLEASE SHOW EXCEL FORMULAS PLEASE PLEASE

Simon Company's year-end balance sheets tollow. The company's income statements for the current year and one year ago follow. Assume that all sales are on credit: For both the current year and one year ago, compute the following ratios: (1-a) Compute days' sales uncollected. (1-b) Determine If days' sales uncollected improved or worsened in the current year. (2-a) Compute accounts recelvable turnover. (2-b) Determine If accounts recelvable turnover ratio Improved or worsened in the current year. (3-a) Compute inventory turnover. (3-b) Determine if Inventory turnover ratio improved or worsened in the current year. (4-a) Compute days' sales in Inventory. (4-b) For each ratlo, determine If days' sales in Inventory Improved or worsened in the current year