Automatic update to cashflow spread sheet

  • Thread starter Struggling of Essex
  • Start date
S

Struggling of Essex

I am creating a five year cash flow table. Months from Jan 06 to Jan 10 will
be along the top and long running construction projects will be listed on the
left hand side.

The variables associated with each project are

Cost
Commencement date
Duration in months

I would like the Cashflow to spread the cost (on a straight line basis) over
the duration, with the first month’s expenditure in line with the
commencement date for each project and update automatically when the
variables change each month.

Can anybody help me?


Many thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cash flow charts 1
Cashflow, cashflow, cashflow 1
Cashflow 2
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Cashflow 4
create a payment schedule about a resource 5
How to distribute/spread/map cost of project across different year 3
Fixed Cost Cash Flow 3

Top