create DSO formula in Excel

Completed Posted Mar 2, 2014 Paid on delivery
Completed Paid on delivery

Based on the last 12 months sales and the current outstanding amount I would like to calculate the weighted average DSO.

I have started to create the logic, but the formula is not good enough for exceptions (e.g. in case the net sales amount is negative - because of large returned quantities)

DSO (Days Sales Outstanding) - is a formula to understand the timelag between Sales and Cash Collection.

Data Entry Data Processing Excel

Project ID: #5507388

About the project

9 proposals Remote project Active Mar 3, 2014

Awarded to:

javed1705

I am an ACCA , APA and Mcom finance having full command over advance excel Your project has caught my attention as i know that this is my favorite topic and i am highly interested with due concern... I am full More

$34 USD in 0 days
(35 Reviews)
5.3

9 freelancers are bidding on average $105 for this job

dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$155 USD in 3 days
(83 Reviews)
5.6
hieutc

Hi, I could help you with this. However could you tell me on the logic how to deal with those exception (i.e remove the negative from the weighted, or consider negative is zero etc...) Regards,

$50 USD in 0 days
(3 Reviews)
2.4
nswapsj

Did you want just the errors removed and ignore negatives? If so can do that for $30 >>Drop me a line anyway and we can discuss this. Cheers, Ed

$30 USD in 3 days
(1 Review)
2.1
elqueabandona

Hello, I have a degree in Business and use excel every day as part of my job. I like working with excel spreadsheets, create formulas and interpreting the resulting information. I am interested in your project. Above a More

$30 USD in 3 days
(2 Reviews)
1.8
probirmondal92

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
klrameet

Hi, I am looking forward to an opportunity to get this job done for you. I am currently working for an investment bank in their process efficiency department and have delivered on several automation projects using e More

$166 USD in 3 days
(0 Reviews)
0.0
chanuidu2014

i think i can handle this job smartly, for your target. if u gave a chance to me i will do this job as my best. Thank You

$222 USD in 3 days
(0 Reviews)
0.0