Forecast closing debtors calculation
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
How hard?
Monthly sales/30 * Debtor days