Days Sales Uncollected

What is Days Sales Uncollected?

The term “days sales uncollected” refers to the liquidity measure that most investors use to determine the number of days that a company will take to collect its accounts receivable. In other words, it helps in the assessment of the short term liquidity position of a company by determining its collection capability of the accounts receivable. The metric is also known as “days sales outstanding”, “average collection period”, “accounts receivable period” and “day’s sales in receivable”.

Formula 

The formula for days sales uncollected is fairly simple with the product of average accounts receivable for the period and 365 as the numerator and net credit sales as the denominator. As the names suggest, it is expressed in terms of days. Mathematically, it is represented as,

Days Sales Uncollected = Average Accounts Receivable / Net Credit Sales * 365

The average accounts receivable is the average of the accounts receivable at the beginning of the year (a.k.a. opening accounts receivable) and at the ending of the year (a.k.a. closing accounts receivable). The net credit sales indicate that the proportion of the sales for which the cash is yet to be collected. In some cases, total sales are used as a proxy for net credit sales.

Average Accounts Receivable = (Opening Accounts Receivable + Closing Accounts Receivable) / 2

Examples of Days Sales Uncollected (With Excel Template)

Let’s take an example to understand the calculation of the Days Sales Uncollected formula in a better manner.

Example – #1

Let us take the example of a company with net credit sales of $200 million during the year. At the start of the year, the accounts receivable stood at $50 million that went upto $60 million by the end of the year. Calculate the day’s sales uncollected based on the given information.

Solution:

Average Accounts Receivable is calculated by using the formula given below

Average Accounts Receivable = (Opening Accounts Receivable + Closing Accounts Receivable) / 2

• Average Accounts Receivable = ($50 million + $60 million) / 2
• Average Accounts Receivable = $55 million

It can be calculated by using the formula given below

Days Sales Uncollected = Average Accounts Receivable / Net Credit Sales * 365

• DSU = $55 million / $200 million * 365
• DSU = 100 days

Therefore, the company’s days sales uncollected for the year stood at 100 days.

Example – #2

Now, let us take the example of Walmart Inc.’s annual report for the year 2018. During 2018, the company clocked net sales of $495,761 million. The opening receivable (net) for 2018 stood at $5,835 million while the closing receivable (net) reduced to $5,614 million. Calculate Walmart Inc.’s day’s sales uncollected for the year 2018 based on the given information.

Solution:

Average Accounts Receivable is calculated by using the formula given below

Average Accounts Receivable = (Opening Accounts Receivable + Closing Accounts Receivable) / 2

• Average Accounts Receivable = ($5,835 million + $5,614 million) / 2
• Average Accounts Receivable = $5,724.5 million

It can be calculated by using the formula given below

Days Sales Uncollected = Average Accounts Receivable / Net Credit Sales * 365

• DSU = $5,724.5 million / $495,761 million * 365
• DSU = 4 days

Therefore, Walmart Inc.’s days sales uncollected for the year 2018 stood at 4 days.

Source: s2.q4cdn.com

Example – #3

Let us take the example of the 2018 annual report for Samsung. According to the annual report, the company managed a total revenue of $221.57 billion during 2018. During the same period, the opening trade receivable stood at $25.17 billion while the closing trade receivable stood at $30.78 billion. Calculate the day’s sales uncollected of Samsung for the year 2018 by using the given information.

Solution:

Average Accounts Receivable is calculated by using the formula given below

Average Accounts Receivable = (Opening Accounts Receivable + Closing Accounts Receivable) / 2

• Average Accounts Receivable = ($25.17 billion + $30.78 billion) / 2
• Average Accounts Receivable = $27.98 billion

It can be calculated by using the formula given below

Days Sales Uncollected = Average Accounts Receivable / Net Credit Sales * 365

• DSU = $27.98 billion / $221.57 billion * 365
• DSU = 46 days

Therefore, Samsung’s day’s sales uncollected for the year 2018 stood at 46 days.

source: images.samsung.com

Limitations

Some of the limitations of DSU are:

• This liquidity measure can’t be used to compare companies whose proportion of credit sales vary significantly.
• The metric is not very useful for businesses characterized by peak season in the middle of the year because it uses an average of the value at the start and at the end of the year.

Important Points to Note about Days Sales Uncollected

Some important points about DSU are:

• It can be useful to see how quickly a company is able to collect receivables from its customers.
• A lower value indicates that the company is efficient in collecting the receivables. On the other hand, a higher value indicates weak collection efficiency.

Conclusion

So, days sales uncollected can be seen as a liquidity measure that is used to assess the collection efficiency of a company which eventually forms part of the working capital requirement. As such, it is important for investors and creditors to understand the concept of DSU.

Recommended Articles

This is a guide to the Days Sales Uncollected formula. Here we discuss how it can be calculated by using a formula along with a downloadable excel template. You can also go through our other suggested articles to learn more –

1. Demand Elasticity Example
2. Financial Reporting Examples
3. Equity Ratio
4. Merger Examples
5. Demand Elasticity Formula with Excel Template