How to add values based on date they occur?

[browndog]

Hi,

I'm trying to create a master template for doing cash flow projections for a number of years. Ideally I would like have a cell for the number of years I want (10 for example) and have excel populate a group of cells based on that number. Each row of cells would be one year and each column would be one month. The dates would be calculated based on a starting date that I enter into a cell.

After that I would like to have a cell for starting cash flows ($1,000 for example) and then another cell that I can plug increases into. For example cash flows may increase to $1,250. I would also need a cell for the date cash flow increases go into effect (1/2019 for example).

I realize this may be difficult to explain on here but if you have any links to documentation that covers this that would be great. I think my biggest hurdle right now is that I'm not even sure what you would call what I'm trying to do.

Thanks

[browndog]

Anyone got any ideas?