Question: how to do accounts receivable turnover in excel?
Answer: Accounts Receivable Turnover Ratio = Net Credit Sales / Average Accounts Receivable. Receivable turnover in days = 365 / Receivable turnover ratio. Receivable turnover in days = 365 / 7.2 = 50.69.