Use Excel 2007 etc for preparing forecasts. Can anyone please suggest a formulae for payment of debtors/creditors over percentage profile eg, 30% one month, 50% two months, 20% three months. I'm sure you get the drift, so if you change the percentage, the cash flow amends.
I currently use long, tedious fixed cell references and -, but i'm sure there is a quicker way.
Thanks in anticipation.