Opening debtors payment profile question thingy

Opening debtors payment profile question thingy

Didn't find your answer?

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.

avatar
By stevie
15th Jul 2010 08:23

Not possible!

You need to do this bit manually based on the actual composition of the £200k.

Thanks (0)