Financial Statement Analysis
 Ratio Analysis of Financial Statements (Formula, Types, Excel)
 Ratio Analysis
 Liquidity Ratios
 Turnover Ratios
 Profitability Ratios
 Profit Margin
 Gross Profit Margin Formula
 Operating Profit Margin Formula
 Net Profit Margin Formula
 EBIDTA Margin
 Earnings Per Share
 Basic EPS
 Diluted EPS
 Basic EPS vs Diluted EPS
 Return on Equity (ROE)
 Return on Capital Employed (ROCE)
 Return on Invested Capital (ROIC)
 Return on Total Assets (ROA)
 Return on Average Capital Employed
 Capital employed Employed
 Return on Average Assets (ROAA)
 Return on Average Equity (ROAE)
 Return on Assets Formula
 Return on Equity Formula
 DuPont Formula
 Net Interest Margin Formula
 Earnings Per Share Formula
 Diluted EPS Formula
 Contribution Margin Formula
 Revenue Per Employee Ratio
 Operating Leverage
 EBIT vs EBITDA
 EBITDAR
 Capital Gains Yield
 Tax Equivalent Yield
 LTM Revenue
 Operating Expense Ratio Formula
 Overhead Ratio Formula
 Capacity Utilization Rate Formula
 Total Expense Ratio Formula
 Efficiency Ratios
 Dividend Ratios
 Debt Ratios
 Debt to Equity Ratio
 Debt Coverage Ratio
 Debt Ratio
 Debt to Income Ratio Formula (DTI)
 Capital Gearing Ratio
 Capitalization Ratio
 Interest Coverage Ratio
 Times Interest Earned Ratio
 Debt Service Coverage Ratio (DSCR)
 Financial Leverage Ratio
 Net Debt Formula
 Leverage Ratios
 Operating Leverage vs Financial Leverage
 Current Yield
 Debt Yield Ratio
 Accounts Receivables Turnover Ratio Formula
 Receivables Turnover Ratio Calculator
 Receivables Turnover Ratio Template
Accounts Receivables Turnover Ratio Formula
Accounts Receivables turnover ratio is another name of this turnover ratio. In this ratio, we will consider the credit sales and the accounts receivables. As you know when a firm sells its goods on credit, it takes a decent time to get paid. The amount that the firm would receive due to credit sales in near future is called accounts receivables.
This ratio is a measure that computes the proportion of how much net credit sales a firm has and how much average accounts receivables the firm is dealing with.
Let’s have a look at the formula –
Recommended Courses
Example of Accounts Receivables Turnover Formula
Here’s a simple example to illustrate Accounts receivables turnover formula.
Gigs Inc. has the following information –
 Net Credit Sales – $500,000
 Accounts Receivables (Opening) – $40,000
 Accounts Receivables (Closing) – $60,000
Find out the Accounts Receivables Turnover Formula.
In the above example, we have all the information available.
First, we will find out the average accounts receivables (net).
 Average Accounts Receivables (net) = ($40,000 + $60,000) / 2 = $50,000.
By using the formula of Accounts receivables turnover, we get –
 Accounts Receivables Turnover= Net Credit Sales / Average Accounts Receivables
 Or, Accounts Receivables Turnover= $500,000 / $50,000 = 10 times.
If we compare the ratio with other companies under similar industry, we will be able to interpret whether this number is efficient or not.
Accounts Receivables Turnover Ratio of Colgate
 Let us calculate the accounts receivables turnover ratio of Colgate.
 Here we have used the assumption that all sales are “credit sales”
 For eg. took the average receivables of 2014 and 2015 (as shown in the image below)
 On an average Colgate’s accounts receivables turnover has been around 10x.
 Higher Receivables Turnover implies higher frequency of converting receivables into cash
Below is a quick comparison of Receivables turnover of Colgate vs P&G vs Unilever
 We note that P&G Receivable turnover ratio is slightly higher than Colgate.
 Unilever’s Receivables turnover is closer to that of Colgate.
source: ycharts
Explanation of Accounts Receivables Turnover Ratio Formula
In the above ratio, we have two components.
 The first component is the net credit sales. We need to keep in mind that here we can’t take the total net sales. We need to separate the cash sales and credit sales. And then we need to deduct any sales return related to the credit sales from the credit sales.
 The second component is average accounts receivables. To find out the average accounts receivables (net), we need to consider two elements – Accounts Receivables (Opening) Accounts Receivables (Closing) and find the average of the two.
Use of Accounts Receivables Turnover Formula
 Accounts Receivables turnover is an efficiency ratio. It is used to see how many times accounts receivables have been collected during a fiscal year.
 A higher Accounts receivables turnover is healthy for a company. It denotes that the time interval between the credit sales and the receipt of money is lower. And that means the firm is quite efficient in collecting the accounts receivables.
 On the other hand, a lower Accounts receivables turnover is not good enough for a company. It indicates that the time interval between the credit sales and the receipt of money is higher. And as a result, there’s always a risk of not receiving the due amount.
 When an investor looks at the Accounts receivables turnover, she needs to know how efficient the firm is in collecting the due amount. If there’s any risk in delaying or not receiving the payment, it may directly affect the cash flow of the company.
Accounts Receivables Turnover Ratio Calculator
You can use the following Accounts Receivables Turnover Ratio Calculator.
Net Credit Sales  
Average Accounts Receivables  
Receivables Turnover Ratio Formula=  
Receivables Turnover Ratio Formula= 


Accounts Receivables Turnover Formula in Excel (with excel template)
Let us now do the same example of the accounts receivables turnover formula in Excel. This is very simple. You need to provide the two inputs of Net Credit Sales and Average Accounts Receivables.
You can easily calculate the accounts receivables turnover formula in the template provided.
You can download this Accounts Receivables Turnover Ratio Template here – Accounts Receivables Turnover Ratio Excel Template
Accounts Receivables Turnover Ratio Video
Recommended Articles
This has been a guide to Accounts Receivables Turnover Ratio formula, its uses along with practical examples. Here we also provide you with Accounts Receivables Turnover Ratio calculator along with downloadable excel template. You may also refer to the following to learn more about Financial Ratios.
Leave a Reply