PLEASE SHOW EXCEL FORMULA PLEASE PLEASE PLEASE

Simon Company's year-end balance sheets follow. 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 ratlos: (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 tumover ratlo 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