Cash flow help

Posted by tugwilson PM | on Wed, 14/07/2010 - 13:30 759 7 comments | report

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.

Comments

There are 7 comments. Login or register to view them.

Put Percentages in their own cells

stevie | Wed, 14/07/2010 - 13:47

Drop-down box?

gsgordon | Wed, 14/07/2010 - 14:01

Spreadsheet formulae

tugwilson | Wed, 14/07/2010 - 14:57

Spreadsheet formulae

tugwilson | Wed, 14/07/2010 - 14:57

What else is in the formula?

patvanaalst | Wed, 14/07/2010 - 15:11

Excel help re formulae

tugwilson | Wed, 14/07/2010 - 16:29

Use a Table?

stevie | Wed, 14/07/2010 - 20:37