Ello.
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.
Replies (7)
Please login or register to join the discussion.
Put Percentages in their own cells
Are you creating a formula that refers to a separate cell for the allocation percentage? You can then just change the percentages to change the profile of receipts/payments.
So instead of formula being, say, B2*20% it would be, say, B2*A3 where A3 holds the value 20%.
Drop-down box?
Not much detail in question, but you could use a drop-down box to select either 1,2,3 months or the choice of percentage.
What else is in the formula?
Could you paste in an example? With a key to what data is in which cell reference? If your percentages are OK then what else is in there to make it so long?
Cheers
Pat
Use a Table?
I just use a table with month and turnover across the top (columns) and phasing/% down the side (rows). Then each cell is just a simple calculation of % x Turnover. When you have set up the initial formulae [correctly] you can copy them across to adjacent cells.