How do I properly put the formula/ logic of A/R turnover and Inventory turnover to Excel?

Is the Sales same as Net Credit Sales?

=1249977/226059+544902/2 Company Background: Located in Lethbridge, AB, Rocky Mountain Chinook Products is in a business which manufactures and sells natural products. Its primary activities include selling natural products, as well as doing research and development of environmentally friendly products. E15 272,456.5 x =1249977/226059+544902/2 Calculate the following in the cells indicated (boxed). Current ratio 2019 10.03 Current ratio 2018 0.68 16 A/R Turnover 2019 (in days) These turnover ratios will require long formulas so be careful with the logic you create Inventory turnover 2019 (in days) 17 18 Gross profit margin 2019 8 Gross profit margin 2018 4296 Debt to total assets 2019 0.09 + Financial Analysis - ACFrOgAW DTMP...pdf Rocky Mountain Chinook Products Statement of Operations (Expressed in Canadian dollars) Year ended April 30 2019 Year ended April 30, 2018 1,249,977 (645, 720) 604,257 483,669 (278,883) 204,786 Sales Cost of goods sold Gross margin Sales expenses Salaries and payroll expenses Commission Traveling costs Advertising and promotion Other expenses Total sales expenses Administrative costs Rent Repair and maintenance Office costs Management fees Professional fees Consulting fees Research and development Depreciation 180,699 96,996 21.486 107,202 70,506 476,889 55,047 30.417 1,281 145.254 14,064 246.063 26,766 101,280 15,615 236,331 339,828 441,027 5,928 70.125 34,587 15,297 23,664 216,501 338,331 6,981 1,244,721 627 5.00 Total administrative expenses Finance costs Interest and bank charges Credit card fees Total finance costs Not loss 6,033 41.601 1.986 (1,207,73-4) (2004)