How to Analyze and Improve Debtors Turnover Ratio / Collection Period?

Debtors turnover ratio, also called accounts receivable turnover ratio, is a ratio that is used to gauge the number of times a business is able to convert its credit sales to cash during a financial year.  Collection period is the time taken by the company to convert its credit sales to cash. Both these ratios indicate the efficiency factor of the company in collecting receivables from its debtors and the speed at which they are able to do it. These two ratios are largely used to indicate the liquidity position of the company along with its efficiency with which operates. It also reflects the power the company has to dictate credit terms.

Formula for Calculating Debtor’s Turnover Ratio

Debtor’s Turnover Ratio = Net Credit Sales / Average Debtors

Here, ‘net credit sales’ is considered because cash sales generate immediate cash. Also, net credit sales mean total credit sales less sales returns if any.

Average Debtors is the average of opening debtors and closing debtors. However, in certain cases, it may be required to consider only current year as the company may have gone for a new product, geographical expansion etc. which may cause debtors to deflate if an average is taken. (Note: bills receivables will also form part of debtors for the said calculation)

Formula for Calculating Average Collection Period

Average Collection Period = Number of days / Debtor’s turnover ratio

Usually, 360 days are taken into the calculation for calculating the number of days. This ratio is expressed in terms of the number of days and represents the length of time taken to convert debtors to cash.

Let us analyse the ratios with an example so as to provide a key understanding of the topic.

Analysis with an Example of Debtors Turnover Ratio/ Average Collection Period:

Credit sales                          =             $ 5,000,000

Sales returns                       =             $ 1,400,000

Opening Debtors                =             $ 400,000

Closing Debtors                  =             $ 500,000

Opening bills receivables  =             $ 100,000

Closing bills receivable      =             $ 200,000

Average Debtors = ($ 400,000 +$ 500,000) / 2

                                  = $ 450,000

Average Bills = ($ 100,000 +$ 200,000) / 2

                                  = $ 150,000

Debtor’s Turnover Ratio               = Net Credit Sales / Average of Debtors and bills

= ($ 5,000,000 – $1,400,000) / ($ 450,000 + $ 150,000)

                                                = 6 times

Average Collection period = Number of days/ Debtor’s turnover ratio

    = 360 / 6 = 60 days

A debtor’s turnover ratio of 6 times means that on an average; the debtors buy and payback 6 times in a year. So we can assume that 6 times a year means once every two months which is nothing but the average collection period of 60 days. The credit sales get converted to cash 60 days from the date of sale on an average basis.

So ideally a higher debtor’s turnover ratio and lower collection period are what a company would want. A lower collection period would mean faster conversion of credit sales to cash. One can say that lower the average collection period higher the efficiency of the company in managing its credit sales and vice versa. Higher debtor’s turnover ratio indicates faster turnaround and reflects positively on the liquidity of the company. The faster collection would keep the company having cash to pay off its creditors and thereby reduce the working capital cycle for a better

So ideally a higher debtor’s turnover ratio and lower collection period are what a company would want. A lower collection period would mean faster conversion of credit sales to cash. One can say that lower the average collection period higher the efficiency of the company in managing its credit sales and vice versa. Higher debtor’s turnover ratio indicates faster turnaround and reflects positively on the liquidity of the company. The faster collection would keep the company having cash to pay off its creditors and thereby reduce the working capital cycle for a better working capital management.

A higher debtor’s turnover ratio is one of the key considerations among others when companies look to avail working capital loans from banks. A faster cash conversion will facilitate banks with comfort while lending to companies with lower collection period.

For now, we know that a higher debtor’s turnover ratio and a lower collection period is beneficial to a company let us see how a company can improve the said ratios.

How to Improve Debtor’s Turnover Ratio / Average Collection Period?

Defined Credit Policies

Design and document clear credit policies and encourage adherence of the same to reduced instances of delays in collection. A frequent revisit and modification of the policies will help adjust to the new environment.

Collection Efficiency

Increase efficiency of the collections from debtors; some of it can be done by a dedicated team force. Insisting for a post-dated cheque, timely reminders etc. can help in aiding faster collection.

Offer Discounts For Early Payments

Designing discount structure for debtors who pay earlier than the credit period sanctioned will motivate some debtor’s payments to clear faster. The discounts can be designed keeping in mind the business’ return on investment or cost of short-term liability.

Reward Timely Payments

rewarding debtors who have a history of timely payments will ensure timely or earlier payments by those debtors going forward.

Discourage Late Payments

Charging interest to debtors who make payments beyond sanctioned credit period can limit the number of debtors paying late. A stricter action could be to reduce/prohibit further sales to debtors who have a history of delay in payments.

Net off Wherever Possible

If there are credit purchases and credit sales with the same company; advising a net off payment at a defined interval can help reduce the debtors’ amount.

Analysis Report

Generate a report on the aging profile of the debtors; which will highlight weekly collection due. Such analysis can help focus on the weeks where higher payments are due and aid in better working capital management.

Conclusion

Debtor’s turnover ratio and average collection period forms an important aspect of working capital management. This ratio along with inventory turnover ratio and creditor’s turnover ratio can help a firm design an efficient working capital cycle. These ratios along with the liquidity ratios like current and the quick ratio can help banks analyze the liquidity situation of the company and the efficiency with which it manages its receivables. All companies should work towards increasing its debtor’s turnover ratio and reducing the average collection period to the minimum; which eventually will lead to all sales converting to cash sales and negligible or very little credit sales.  This will also help in bringing down the bad debts for the company.

References:

Last updated on : January 2nd, 2017
What’s your view on this? Share it in comments below.

One Response

  1. farooq

Leave a Reply

How to Reduce Current Ratio and Why?
  • Contribution Margin
    Contribution Margin
  • Enterprise Value
    Enterprise Value
  • Debt to Total Asset Ratio
    Debt to Total Asset Ratio
  • P/E Ratio
  • Subscribe to Blog via Email

    Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 122 other subscribers

    Recent Posts

    Find us on Facebook


    Related pages


    capitalize expensesinterpretation of liquidity ratiosaverage receivables formulawhat is meant by payback perioddebit in accounting definitiondebenture loans definitionhedging conceptinventoriabledisadvantages of operating leasestakeholder shareholderwhat does accountancy meandefine bookkeeping in accountingwhat is meant by cash flow statementoverdraft facility interest ratemodigliani theoryshareholder equity calculationdisadvantages of flexible budgetinvestment turnover ratio interpretationaccount payable journal entriesdiscounting a letter of creditpledge and hypothecationstraddle strangle butterflydef of conservativeparticipating convertible preferredscrip dividend definitionbills receivable meanscapital lease ifrsearnings per share equationcapital budgeting and long term financing decisionsvalue maximization stakeholder theoryresidual claim on assetsleverage meaning in hindifinancial leverage investopediaaffirmative covenantdifference between current ratio and quick ratiodupont financial statementscash operating cycle calculationcalculate the payback periodus gaap fixed assetsirr benefitsirr definitionnon recourse factoring definitionoperating lease accounting entrieswhat are liquid assets examplesdef leveragemarginal costing exampleswhat is meant by contingent liabilitiesfinweb.comredeemable sharescontingent liabilities examplesdebentures meaning in accountingincome account normal balancemodified internal rate of return formulasales forecasting regression analysiswhat are callable bondsdefinition of intangible assets in accountingsimple payback calculationdifference between net income approach and net operating income approachtraditional budgeting definitionnegative covenants loan agreementexamples of asset accountswhat is the eoq formulacapital vs finance leaseformula for accounts receivable dayspresent value of dividend calculatorexplain waccpurchase bill discountingdebts to total assets ratioformula for mirrdifference between stakeholder and shareholderdefinition of capital rationingfinance rocfixed assets coverage ratiowhat are the macro environmental factors