Financial ratios

Days sales outstanding

In accountancy, days sales outstanding (also called DSO and days receivables) is a calculation used by a company to estimate the size of their outstanding accounts receivable. It measures this size not in units of currency, but in average sales days. Typically, days sales outstanding is calculated monthly. Generally speaking, higher DSO ratio can indicate a customer base with credit problems and/or a company that is deficient in its collections activity. A low ratio may indicate the firm's credit policy is too rigorous, which may be hampering sales. Days sales outstanding is often misinterpreted as "the average number of days to fully collect payment after making a sale". The formula for this would be Σ(Sales date) - (Paid date)/ (Sale count). This calculation is sometimes called "True DSO". Instead, days sales outstanding is better interpreted as the "days worth of (average) sales that you currently have outstanding". Accordingly, days sales outstanding can be expressed as the following financial ratio: DSO ratio = accounts receivable / average sales per day, orDSO ratio = accounts receivable / (annual sales / 365 days) Accounts receivable refers to the outstanding balance of accounts receivable at a point in time here whereas average sales per day is the mean sales computed over some period of time. This can be annual as in the formula above, or it can be any period of time considered useful to the company. Because this is an average general KPI, though, choosing a time period that's too low may introduce undesirable artifacts in the data. Typically this is a calendar year or month or a fiscal year or period. Changes in "the average number of days to fully collect payment after making a sale" could impact days sales outstanding in that fluctuations in the length of the average collection effort could affect a company's accounts receivable balance, but days sales outstanding is also affected by fluctuations in sales volume. Days sales outstanding is considered an important tool in measuring liquidity. In some sense it measures the balance between a company's sales efforts and collection efforts. If sales decreases in isolation DSO will increase indicating that may run into cash flow problems in future when the sales dip flows through the collection cycle. If sales decreases proportionally to accounts receivable, DSO will not increase. While this may not be welcome news, it does not indicate a change in the balance of sales and receivables, and therefore will not affect DSO. Similarly, taking longer to collect will negatively affect DSO if sales remain the same (since the balance of receivables will increase), but if it's accompanied by a proportional increase in sales it does not change the balance of sales to receivables and so does not affect DSO. Days sales outstanding tends to increase as a company becomes less risk averse. Higher days sales outstanding can also be an indication of inadequate analysis of applicants for open account credit terms. An increase in DSO can result in cash flow problems, and may result in a decision to increase the creditor company's bad debt reserve. Days sales outstanding can vary from month to month, and over the course of a year with a company's seasonal business cycle. Of interest when analyzing the performance of a company is the trend in DSO. If DSO is getting longer, accounts receivable is increasing or average sales per day are decreasing. An increase in accounts receivable could indicate that customers are taking longer to pay their bills, which may be a warning that customers are dissatisfied with the company's product or service, or that sales are being made to customers that are less credit-worthy, or that salespeople have to offer longer payment terms in order to generate sales. Similarly, a decrease in average sales per day could indicate the need for more sales staff or better utilization. Some companies may attempt to focus in more on the collection aspect of DSO equation by calculating days delinquent sales outstanding (DDSO). This is simply (delinquent accounts receivable)/ (average sales per day). Because accounts receivable = current + delinquent accounts receivable, the DDSO formula is often defined as (accounts receivable)/ (average sales per day) − (current accounts receivable)/ (average sales per day). While mathematically more complex, it is the same number. This formula can be interpreted as DSO - "Best Possible" DSO, though. In this case it's the "Best Possible" because it's not assumed that, on average, you can expect your invoices to be paid before the due date. In this interpretation DDSO can be interpreted as the portion of DSO owing to over due receivables. Similar to DSO, though, DDSO can be affected by the speed of collecting overdue invoices but it does not measure speed. It measures size in units of average daily sales. (Wikipedia).

Video thumbnail

This channel's 1 year anniversary!!!

Thank you everyone for supporting me this year.

From playlist 1st anniversary

Video thumbnail

Special Holiday Art Quiz #31

Special Holiday Art Quiz #31

From playlist Art Quizzes

Video thumbnail

Vodafone-Happy to Help Ad (full)

In some very special way I still remain loyal to this brand,yet another spectaculary meaningful ad from O&M..gd going

From playlist Advertisements

Video thumbnail

Week 0

From playlist Performances 2014

Video thumbnail

Excel Magic Trick 1381: Power Query: Records In Column into Table then Two Different Top 3 Reports

Download Files: Start File: https://excelisfun.net/files/EMT1381Start.xlsx Finish File: https://excelisfun.net/files/EMT1381Finished.xlsx See how to convert non-proper data set (records that are listed in a single column) into two Top 3 Reports (Including Ties for Third) for Domestic Sa

From playlist Excel Data Analysis Tricks

Video thumbnail

Social perception - The Halo Effect | Individuals and Society | MCAT | Khan Academy

Created by Arshya Vahabzadeh. Watch the next lesson: https://www.khanacademy.org/test-prep/mcat/individuals-and-society/perception-prejudice-and-bias/v/social-perception-the-just-world-hypothesis?utm_source=YT&utm_medium=Desc&utm_campaign=mcat Missed the previous lesson? https://www.khan

From playlist Individuals and society | MCAT | Khan Academy

Video thumbnail

GameStop Selling New Shares! $GME

Two months after Reddit day traders took GameStonk ( $GME ) shares to surprising heights in a massive short squeeze, the video game retailer is finally trying to cash in. On Monday, it announced plans to issue up to 3.5 million new shares worth $650m via an “at-the-market” offering, or ATM

From playlist What is Happening In The Market?

Video thumbnail

Accounting Lecture 11 - Bank Reconciliations

From the free study guides and course manuals at www.my-accounting-tutor.com. Reconciling the bank statement and making required journal entries.

From playlist Accounting Lectures

Video thumbnail

Business Analytics Decision Tree In R | Webinar 1 | Edureka

Watch Sample Class recording: http://www.edureka.co/r-for-analytics?utm_source=Youtube&utm_medium=webinar&utm_campaign=bar-09-06-15 Business Analytics with R is designed for those with a keep interest towards analytics that can be implemented in multiple industrial domains and scenarios.

From playlist Webinars by Edureka!

Video thumbnail

How to Become a Product Manager? | A Complete Roadmap to Become a Product Manager | Simplilearn

🔥 Professional Certification In Product Management: https://www.simplilearn.com/product-management-certification-training-course?utm_campaign=HowtoBecomeaProductManager-R7my00sb1ms&utm_medium=Description&utm_source=youtube This Video on How to become a Product Manager will give you a

From playlist Product Management

Video thumbnail

Fundamental Analysis

This video explains how to use fundamental analysis to determine if a company may be undervalued or overvalued by using valuation ratios such as the price to book ratio, price to sales, & price to earnings ratio. It also explains how to determine if a company may go bankrupt using the deb

From playlist Stocks and Bonds

Video thumbnail

Algebra PERCENT WORD PROBLEM – Let’s solve it step-by-step….

TabletClass Math: https://tcmathacademy.com/ Algebra word problem help with solving a percent word problem. For more math help to include math lessons, practice problems and math tutorials check out my full math help program at https://tcmathacademy.com/ Math Notes: Pre-Algebra N

From playlist GED Prep Videos

Video thumbnail

Pre-Algebra FLASH SALE 1 Year 80% OFF (limited time only)

TabletClass Pre-Algebra: https://tabletclass-academy.teachable.com/p/tabletclass-math-pre-algebra1 Use coupon code: tcmath

From playlist Pre-Algebra

Video thumbnail

History of the Holidays: History of Thanksgiving | History

Although Thanksgiving celebrations dated back to the first European settlements in America, it was not until the 1860s that Abraham Lincoln declared the last Thursday of November to be a national holiday. HISTORY®, now reaching more than 98 million homes, is the leading destination for aw

From playlist History of the Holidays | History

Video thumbnail

How To Calculate The Price to Sales (P/S) Ratio Using Market Capitalization

This finance video tutorial explains how to calculate the price to sales (P/S) ratio using market capitalization. It also explains how to use the P/S ratio as an indicator to determine if a stock might be undervalued or overvalued. My Website: https://www.video-tutor.net Patreon Donatio

From playlist Stocks and Bonds

Related pages

Financial ratio | Days payable outstanding | Cash conversion cycle | Days in inventory