Accounts Receivable Turnover

 
Share

Financial Statement Analysis and Accounts Receivable Turnover

Accounts receivable turnover allows a company to measure whether or not the company is effectively collecting payments on its accounts receivable, or its sales on credit.

A high turnover indicates higher cash basis sales or efficient collections. A low turnover indicates collection problems and possible bad debts.

Most companies do not charge interest on accounts receivable unless the account becomes past due. An extension of credit is then essentially an interest free loan to customers, and not collecting payments on time creates inefficiency and opportunity costs for the company. For example, the company could use the cash to invest the money and earn interest, pay down debt from which the company is incurring interest expenses, or finance growth opportunities instead of having money tied up in accounts receivable.

It is also a business risk that a certain percentage of customers will not pay balances due at all, so measures of uncollectible accounts should be made when it can be reasonably estimated. Estimates are usually based on historical uncollectibles.

Accounts Receivable Turnover Calculation:

Net Credit Sales/Average Net Receivables,
where net average receivables = (beginning net receivables balance + ending net receivables Balance)/2

Net receivables at year-end equal $21,200. Since Sunny Sunglasses Shop started business in January of 2010, there is no beginning accounts receivable balance. Sunny knows that his net credit sales for the year were $70,000.

Plugging the numbers into the formula, we get 6.6.

Accounts Receivable Turnover Example

70,000/10,600 = 6.6
where Average Receivables = (0 + 21,200)/2 = 10,600

Alternatively, businesses may calculate accounts receivable turnover in a two – step process as follows:

Calculating the Average Collection Period

1. Average Sales Per Day = Credit Sales or Total Sales/365
2. Average Collection Period = Accounts Receivable/Average Sales Per Day

Average Collection Period Example

1. Average Sales Per Day = 144,000/365 = $395
2. Average Collection Period = 21,200/395 = 54 Days

The average collection period uses the last known accounts receivable balance for the period.

Average Collection Period and Accounts Receivable Turnover

The average collection period can be translated to accounts receivable turnover by dividing the number of days a year by the average collection period, or 365/54 = 6.8.

Since many companies do not disclose total sales on credit, users of financial statements may use this method to determine accounts receivable turnover using total sales. When comparing turnover ratios, make sure that the same sales type is used when calculating receivable turnovers (credit sales or total sales).

The next step is to add meaning to these numbers by comparing them with the industry averages:

Financial Statement Analysis

Industry Ratios: Accounts Receivable Turnover

Company Accounts Receivable Turnover Days Outstanding
Software Industry 5.8 63 Days
Microsoft 5.3 69 Days
Specialty Retail, Other 23.7 15 Days
Sunglasses Hut Int. (Luxottica Group) 8.2 45 Days
Sunny Sunglasses Shop 6.8 54 Days
S&P 500 14.4 25 Days

Sunny Sunglasses has an average collection period of 54 days after one year of operations. It also has a low accounts receivable turnover ratio compared to its main competitor and especially the industry average. Sunny’s accounts receivable account balance should not be increasing very much over the course of the year if the company is to remain within industry standards.

If Sunny Sunglasses has an Achilles Heel in its profitable operations, it may be the low accounts receivable turnover.

In fact, we can check what the balance of accounts receivable should be throughout the year to stay competitive with industry standards.

Simply use the average collection period above to calculate what the accounts receivable balance should be to stay within a given collection period (e.g. 15 days, 30 days, 45 days, 60 days, or 90 days).

If the Average Collection Period = Accounts Receivable Balance/Average Sales per day,

then Average Sales Per Day x Average Collection Period  = Accounts Receivable Balance.

$395 x Average Collection Period Days  = Accounts Receivable Balance.

# of Collection Days Accounts Receivable Balance
15 Days $6,000
30 Days $12,000
45 Days $18,000
60 Days $24,000
90 Days $36,000

To stay competitive with the industry average for specialty retail of 15 collection days, the accounts receivable balance should be approximately $6,000 with average sales of $395 a day. Greater sales allow for higher receivable balances within the collection time frames.

Sunny should monitor accounts receivable balances during the year, and compare accounts receivable turnover per quarter and per year to ensure turnover does not decrease from period to period.

Back from Accounts Receivable Turnover to the Financial Ratios|Financial Statement Analysis Main Page

Back to the Accounting Terms Main Page

Online Accounting|Business Accounting Home Page

Share

  One Response to “Accounts Receivable Turnover”

  1. These are some great rules of thumb for analyzing accounts receivable. Thanks for the tips!

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)

*