Financial Statement Analysis
- Ratio Analysis of Financial Statements (Formula, Types, Excel)
- Ratio Analysis Advantages
- Ratio Analysis
- Liquidity Ratios
- Cash Ratio
- Cash Ratio Formula
- Quick Ratio
- Quick Ratio Formula
- Current Ratio
- Current Ratio Formula
- Acid Test Ratio Formula
- Defensive Interval Ratio
- Working Capital Ratio
- Working Capital Formula
- Net Working Capital Formula
- Changes in Net Working Capital
- Cash Flow from Operations Ratio
- Cash Reserve Ratio
- Operating Cycle Formula
- Current Ratio vs Quick Ratio
- Bid Ask Spread
- Liquidity vs Solvency
- Solvency Ratios
- Equity Ratio
- Capital Adequacy Ratio
- Liquidity Risk
- Altman Z Score
- Turnover Ratios
- Inventory Turnover Ratio
- Accounts Receivable Turnover
- Accounts Receivables Turnover Ratio
- Accounts Payable Turnover Ratio
- Days Inventory Outstanding
- Days in Inventory
- Days Sales Outstanding
- Average Collection Period
- Days Payable Outstanding
- Cash Conversion Cycle
- Cash Conversion Cycle (CCC) Formula
- Fixed Asset Turnover Ratio Formula
- Debtor Days Formula
- Working Capital Turnover Ratio
- Profitability Ratios
- Profitability Ratios Formula
- Common Size Income Statement
- Vertical Analysis of Income Statement
- Profit Margin
- Gross Profit Margin Formula
- Gross Profit Percentage
- Operating Profit Margin Formula
- EBIT Margin Formula
- Operating Income Formula
- Net Profit Margin Formula
- EBIDTA Margin
- Degree of Operating Leverage Formula (DOL)
- NOPAT Formula
- 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 Sales
- ROIC Formula (Return on Invested Capital)
- Return on Investment Formula (ROI)
- ROIC vs ROCE
- ROE vs ROA
- Cash on Cash Return
- 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
- Unit Contribution Margin
- Revenue Per Employee Ratio
- Operating Leverage
- EBIT vs EBITDA
- Capital Gains Yield
- Tax Equivalent Yield
- LTM Revenue
- Operating Expense Ratio Formula
- Overhead Ratio Formula
- Variable Costing Formula
- Capitalization Rate
- Cap Rate Formula
- Comparative Income Statement
- 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 Asset Ratio Formula
- Coverage Ratio
- Coverage Ratio Formula
- Debt to Income Ratio Formula (DTI)
- Capital Gearing Ratio
- Capitalization Ratio
- Interest Coverage Ratio
- Times Interest Earned Ratio
- Debt Service Coverage Ratio (DSCR)
- DSCR Formula (Debt service coverage ratio)
- Financial Leverage Ratio
- Financial Leverage Formula
- Degree of Financial Leverage Formula
- Net Debt Formula
- Leverage Ratios
- Leverage Ratios Formula
- Operating Leverage vs Financial Leverage
- Current Yield
- Debt Yield Ratio
- Solvency Ratio Formula
What is Accounts Receivable Turnover?
Accounts Receivable Turnover Ratio is an efficiency ratio which indicates how times a company is able to collect its average receivables in a given period. Providing a line of credit is one thing, but collecting this ‘interest-free loan’ from the debtors is another.
Accounts Receivable Turnover ratio estimates a firm’s effectiveness with which it collects the credit from its debtors.
Calculate Accounts Receivable Turnover Ratio
Accounts Receivable Turnover ratio is calculated by dividing the net credit sales with by the average accounts receivable. It is to be noted that net credit sales are considered instead of net sales; the reason being that net sales include cash sales as well, but cash sales do not fall under credit sales.
- Accounts Receivable Turnover Ratio Formula = (Net Credit Sales) / (Average Accounts Receivable)
- Net Credit Sales = Gross Credit Sales – Returns (or Refunds)
Accounts Receivable Turnover Example
Suppose, in the year 2010 a company had a gross credit sale of $1000,000 and $200,000 worth of returns. On the 1st of January 2010, the accounts receivable were $300,000 and that on 31st December 2010 were $ 500,000
Based on the above information:
- Average Accounts Receivable = (3,00,000 + 5,00,000) / 2 = Rs. 4,00,000
- Net Credit Sales = 10,00,000 – 2,00,000 = 8,00,000
- Accounts Receivable Turnover Ratio = 8,00,000 / 4,00,000 = 2
Form the above example, the turnover ratio is 2, which means that the company is able to collect its receivables twice in the given year or once in 182 days (365/2).
In other words, when a credit sale is made, it will take the company 182 days to collect the cash from the sale.
Interpretation of Accounts Receivable Turnover Ratio
- Usually, the higher turnover ratio is preferred as it indicates the company’s efficiency to collect its receivables.
- A higher ratio means that the company is collecting cash more frequently and/or has a good quality of debtors. This in turn means the company has a better cash position, indicating that it can pay off its bills and other obligations sooner. Many times, the accounts receivable turnover are posted as collateral for loans, making a good turnover ratio essential.
- At the same time, a high turnover ratio may also mean that the company transacts mainly in cash or has a strict credit policy.
- A lower ratio may mean that either the company is less efficient in collecting the creditor has a lenient credit policy or has a poor quality of debtors.
- Looking at just the number (turnover ratio), doesn’t give the complete picture. It is better to check for the turnover ratio trends over the years to assess the true collecting efficiency of the companies. Many prudent analysts analyze if the company’s ratio is affecting its earnings. It is also useful to compare the turnover ratios of two companies in the same industry.
Accounts Receivables Turnover Ratio of Colgate
- Now that we have seen how to calculate the asset turnover ratio, let us see how the turnover ratio is for Colgate.
- We have assumed here that all the Sales on Colgate’s Income statement is Credit Sales.
- The following image shows the calculation of average receivables turnover of 2014 and 2015
- Colgate’s accounts receivables turnover has been high at around 10x for the past 5-6 years.
- Higher Turnover implies higher frequency of converting receivables into cash
How is Colgate accounts receivables turnover ratio as compared to P&G and Unilever?
- We note that P&G Receivable turnover ratio of around 13.56x is higher than that of Colgate (~10x)
- Unilever’s Receivables turnover is closer to that of Colgate.
Precautions While Using Accounts Receivable Turnover Ratio
As an investor, care should be taken how the company has calculated the turnover ratio. Many firms consider gross credit sales rather than net credit sales. This can be misleading if attention is not paid.
Also as stated above, the average accounts receivable turnover are calculated by taking only the first and last months into consideration. This may not give the correct picture if the accounts receivables turnover has drastically varied over the year. To overcome this shortcoming, one can take the average over the whole year i.e. 12 months instead of 2.
This has been a guide to Accounts Receivables Turnover Ratio. Here we discuss accounts receivables turnover ratio calculation, its interpretation along with practical examples of Colgate and its comparables. You may also refer to the following articles to learn more about Financial Ratios.