Palmer Enterprises has an inventory conversion period of 50 days, an average collection period of 35 days, and a payables deferral period of 25 days. Assume that cost of goods sold is 80% of sales.
a. How many times per year does Palmer Enterprises turn over its inventory?
Please show all work/formulas in excel