create DSO formula in Excel
$30-250 USD
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.
Project ID: #5507388
About the project
9 freelancers are bidding on average $105 for this job
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,
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
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
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