We can perform dso analysis in excel, but how does it work?

Asked By Colleen J Fix 0 points N/A Posted on - 06/01/2013

I have realized we can do dso analysis in excel (Days Sales Outstanding) by taking average accounts receivable during the month / net credit sales during the month and multiplying by the number of days (30 days). I can see there could be an accounts receivable if the business has its own credit arrangements with customers, however I don't understand how the DSO formula works?

• Status: Open
• Question Views: 655
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Davidson Mudge 0 points N/A #171530

We can perform dso analysis in excel, but how does it work?

Hi Colleen,

                Let me put the explanation into an analysis Days’ Sales Outstanding (DSO) Ratio it is an activity ratio which gives you the data about how efficient your sales collection activities is. It means the lower value of DSO the better and it is much favorable for your business. It is best to make monthly or even weekly trend so you can have a better picture on where your business is.

About Davidson Mudge

Questions
3

Answers
500

Best Answers
197

• Vote Up 0 Vote Down

• Posted on - 06/08/2013
• Question Category: MS Excel