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.