Accounts Receivable Turnover Ratio Calculator

What is Accounts Receivable Turnover Ratio Calculator

The Accounts Receivable Turnover Ratio Calculator is a tool used in finance to measure how efficiently a company is collecting its accounts receivable, which are the amounts owed by customers.

What is the Accounts Receivable Turnover Ratio?

The Accounts Receivable Turnover Ratio is a financial metric that shows how many times a company’s accounts receivable are collected (or “turned over”) during a specific period, typically a year. It’s an indicator of how well a company is managing the credit it extends to its customers and how quickly it is collecting owed funds

Accounts Receivable Turnover Ratio Formulas

1. Net Sales Formula:

$Net Sales = Gross Sales - Refunds/Returns - Sales on Credit$

2. Average Accounts Receivables Formula:

$AAR Formula = \frac{Beginning Accounts Receivable + Ending Accounts Receivable}{2}$

3. Accounts Receivable Turnover Ratio Formula:

$ARTR Formula = \frac{Net Credit Sales}{Average Accounts Receivable}$

4. Accounts Receivable Turnover in Days Formula:

$ART in Days = \frac{365}{Receivable Turnover Ratio}$

Example Calculation:

Assume a company has the following data:

Gross Sales: $1,000,000
Refunds/Returns: $50,000
Sales on Credit: $450,000
Beginning Accounts Receivable: $100,000
Ending Accounts Receivable: $200,000
Net Credit Sales: $500,000

The Net Sales is calculated as:

$Net Sales = 1, 000, 000 - 50, 000 - 450, 000 = 500, 000$

The Average Accounts Receivable is calculated as:

$Average Accounts Receivable = \frac{100, 000 + 200, 000}{2} = 150, 000$

The Accounts Receivable Turnover Ratio is calculated as:

$Accounts Receivable Turnover Ratio = \frac{500, 000}{150, 000} \approx 3.33$

The Receivable Turnover in Days is calculated as:

$Receivable Turnover in Days = \frac{365}{3.33} \approx 109.61 days$

This indicates that, on average, it takes approximately 110 days to collect the receivables.

Factors Effecting Accounts Receivable Turnover Ratio

Net Sales
Average Accounts Receivables
Accounts Receivable Turnover
Accounts Receivable Turnover in Days

Use of the Calculator

The calculator simplifies the process of calculating this ratio by automating the formula. Users just need to input the required financial figures (Net Credit Sales and Average Accounts Receivable), and the calculator will compute the ratio for them.