Forecast closing debtors calculation

Forecast closing debtors calculation

Didn't find your answer?

Hi

Can anyone please suggest an excel formula to calculate, as accurately as possible, the closing debtors based on debtor days for forecast purposes?

Kind regards

Replies (1)

Please login or register to join the discussion.

avatar
By neileg
13th Aug 2013 13:40

How hard?

Monthly sales/30 * Debtor days

Thanks (0)