Financial Statement Analysis
- Ratio Analysis of Financial Statements (Formula, Types, Excel)
- Ratio Analysis Advantages
- Ratio Analysis
- Liquidity Ratios
- Cash Ratio
- 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
- Current Ratio vs Quick Ratio
- Bid Ask Spread
- Liquidity vs Solvency
- Liquidity Risk
- Altman Z Score
- 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)
- ROIC vs ROCE
- 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
- Capital Gains Yield
- Tax Equivalent Yield
- LTM Revenue
- Operating Expense Ratio Formula
- Overhead Ratio Formula
- Capitalization Rate
- 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 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 –
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.
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.
|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
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.