excel cashflow formula
Posted on 2011-09-11
For a project, I need to estimate the expenditure for certain tasks over the next 10 years. The tasks have various start dates (in terms of year its first undertaken), and various frequencies (in terms of how many years until its next repeated)
The columns that I would enter data are A - Task Name, B - Cost C - Start Date, D - Frequency (years)
I then would have columns E to N for Expenditure for Years 2012....2022. Could someone advise what formula I would use in Columns E to N to show the expenditure in each of those years.
Thanks in advance