Hi Everyone:

I have a monthly financial projection model and I am trying to build the following functionality.

One assumption is that there will be an acquisition in any given month. For this I have set it up so when a person enters the month on the assumptions chart there is an if statement in the projections sheet that enters the amount in the proper month. However as soon as the acquisition takes place I have a series of 12 (one each month) capital expenditures that take place below in the expenditures row. How do I build the functionality so that as soon as the acquisition date is entered in the capital expenditures line there is a series of 12 payments immediately following the month of the acquisition. Is there some if statement function or date function mixed with a count function etc. that would be able to do this (or perhaps an easy solution that I am totally missing)?


Thanks very much in advance for your help on this and HAPPY NEW YEAR!!!!