Cash flow help

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 |
stevie's picture

Drop-down box?

gsgordon |

Spreadsheet formulae

tugwilson |

Spreadsheet formulae

tugwilson |

What else is in the formula?

patvanaalst |
patvanaalst's picture

Excel help re formulae

tugwilson |

Use a Table?

stevie |
stevie's picture