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
- Change in Net Working Capital (NWC) Formula
- Cash Flow from Operations Ratio
- Cash Flow Per Share
- 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
- Days Sales Uncollected
- 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
- Markup Percentage 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 Days Sales Uncollected?
The Days’ Sales Uncollected also known as average collection period is one of the liquidity ratios that is measured to estimate the number of days before receivables will be collected. The ratio is used by creditors and investors widely to determine the short-term liquidity of the company. In terms of individual, the days’ sales uncollected ratio formula measures how long it will take for the customers to pay their credit card balances.
Components of Days Sales Uncollected
#1 – Accounts Receivable
Accounts Receivable is the proceeds or payments due to the company for its credit sales to its customers. When a company extends credit to the customer, it provides a time period to the customers for payment. The sales are realized when the invoice is generated.
#2 – Net Sales
Net sales are the company’s gross sales after returns, discounts, and allowances. Revenues reported on the income statement often represent net sales.
Days Sales Uncollected Formula
The days’ sales uncollected ratio divides accounts receivable by net sales and multiplies it by 365. It can be expressed as:
The result is expressed in days.
- Data of Accounts receivable can be picked up from the balance sheet.
- Credit sales have to be provided by the company. They are rarely reported in the separate head in the income statement.
- Cash can be used for different operational activities if it is collected sooner. With lower days sales uncollected, liquidity and cash flows tend to increase. It also depicts that accounts receivables are not bad debts but are good in nature.
- A higher ratio shows the non-suitable collection process. Also, customers are not able or unwilling to pay. Such companies face problems to convert sales into cash.
Days Sales Uncollected Examples
Below are the Examples of days sales uncollected as follows.
4.9 (1,067 ratings)
Suppose ABC Ltd. is a US based Company. At the end of March 2018,
- Accounts Receivable=$400,000.
- Net Credit Sales=$3,600,000.
So, the days’ sales uncollected will be
Days’ Sales Uncollected Formula = Accounts Receivable/Net Sales * 365
= 40.56~ 41 days.
So, ABC Co. will require approximately 41 days to collect the receivables.
Suppose Doro’s Pine Boards is a UK based retailer that offers credit to customers. Doro sells inventory to customers as per the credit policy wherein customers will pay within 30 days. Some customer pay promptly but some makes a delayed payment. Company’s financial statements have the following details:
- Accounts Receivable: £11,000
- Net Credit Sales: £131,000
Days’ Sales Uncollected Formula = Accounts Receivable/Net Sales * 365
=30.65 days~ 31 days
The company takes 31 days to collect cash. So, it is a good ratio that it is similar to the company’s set standard.
Advantages of Days Sales Uncollected
- If a department store or any organization sells its goods and services to its customers or clients on credit, they are ultimately selling more products. So, they have large accounts receivable on their books which is a good sign for their financial performance.
- For management, apart from liquidity, the ratio can be used to estimate the effectiveness of credit and collection activities.
- It can be used as a tool for peer creditors in the case one creditor finds a customer or party not creditworthy to give products on credit basis. It can work as a warning for others too.
- It can indicate if the company is maintaining customer satisfaction or if credit is being given to customers who are not creditworthy.
Disadvantages of Days Sales Uncollected
- A high ratio shows that the company is taking longer to collect money that may lead to cash flow problems.
- If a company’s payment of expenses is directly dependent on payments received from accounts receivable, a sharp rise in the ratio can disrupt this flow and drastic changes can be required.
- If a company has a volatile Days Sales Uncollected ratio, this may be cause for concern, but if a company’s ratio dips during a particular season each year, there is no issue.
Limitations of Days Sales Uncollected
If we consider the efficiency of a business, days sales uncollected comes with a set of limitations that are important for any investor to notice:
- When companies are compared on the basis of the ratio, it must be done in the same industry so that they can have similar business models and revenue. Companies of different size often have very different capital structures, which can influence calculations.
- The ratio is not useful in comparing companies with significant differences in the proportion of credit sales.
- The ratio is not a perfect indicator of a company’s accounts receivable efficiency, as it is dependent on volume and frequency of sales. Days Sales Uncollected must be used along with other metrics.
- It only accounts for credit sales. It ignores cash sales. If they were factored into the calculation, they would decrease the ratio.
- Generally, Days Sales Uncollected ratio as below 45 days is considered low. However, it depends on business type and structure. There is no ideal ratio.
- The unusually high figure depicts casual credit policy or inadequate collection process. It could be possible because of the slow economy where customers are not able to pay.
- Another point to consider is Seasonality. The business sales may vary from month to month. So, the receivables figures in the numerator may not be a true picture of a particular time period or the entire year.
- Also, consider the distribution. Some of the receivables could be overdue since long and this may impact the measurement. Notation can be useful in this regard.
We can conclude that Days Sales Uncollected is widely used for collections and credit management. It assists with cash flow planning. It’s an indicator of the success of the collection’s department. However, it is largely affected by external factors like is the client’s business is powerful or what is the business condition as a whole. It is very important to keep a check on the ratio as it is an indicator of liquidity and solvency of the organization.
This has been a guide to what is Days Sales Uncollected. Here we discuss how to calculate days sales uncollected along with its formula and step by step examples. You may learn more about accounting from the following articles –