Me again.
Opening debtors for my projections are £200,000. payment profile say 21% pay after one month, 30% after two month, 35% after three month 14% after four month, or whatever.
Does anyone please know a formulae to work out the customer receipts for the first four months for the forecasts, paying off the £ 200,000 opening debtors? I suppose another way of putting it is to correctly calculate the opening aged debtors with the info above.
Thanks again.
Replies (1)
Please login or register to join the discussion.
Not possible!
You need to do this bit manually based on the actual composition of the £200k.