create DSO formula in Excel

$30-250 USD

Завершено

Опублікований

about 10 years ago

$30-250 USD

Оплачується при отриманні

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

ID проекту: 5507388

Про проект

9 пропозицій(-ї)

Дистанційний проект

Активність 10 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@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 fully competent in doing said assignment/job, I have more than 7 years of exp hire me at fordable cost with best results, readily available for said task........ regards javed

$34 USD за 0 день

4,8

(35 відгуки(-ів))

5,3

9 фрілансерів(-и) готові виконати цю роботу у середньому за $105 USD

@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 response. Thanks.

$155 USD за 3 дні(-в)

5,0

(83 відгуки(-ів))

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 за 0 день

5,0

(3 відгуки(-ів))

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 за 3 дні(-в)

5,0

(1 відгук)

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 all, to improve the formulas to provide the information you need. Best regards.

$30 USD за 3 дні(-в)

4,7

(2 відгуки(-ів))

1,8

@probirmondal92

A proposal has not yet been provided

$155 USD за 3 дні(-в)

0,0

(0 відгуки(-ів))

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 excel. Hope to hear from you soon. Regards

$166 USD за 3 дні(-в)