software

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!!!!--
kidflip
------------------------------------------------------------------------
kidflip's Profile: www.excelforum.com/member.php...oamp;userid=30033
View this thread: www.excelforum.com/showthread...hreadid=497194In your expenditures row, you can combine a couple of IFs with an OFFSET.
Something like:
=if(and(this_monthgt;=acquisition_month,this_monthlt;a cquisition_month
12),offset(acquisition_expense_first_month,0,this_ month -
acquisition_month),0)
That is, if this month is either before the acquisition of a year of more
after, acquisition expenses are 0. Otherwise, use the number of months since
the acquisition to determine the current month's expenses
(quot;acquisition_expense_first_monthquot; would be a cell reference in which you'd
have the expenses incurred in the month of the acquisition; subsequent cells
in the same row would have subsequent monthly expenses).
HTH. --Bruce

quot;kidflipquot; wrote:

gt;
gt; Hi Everyone:
gt;
gt; I have a monthly financial projection model and I am trying to build
gt; the following functionality.
gt;
gt; One assumption is that there will be an acquisition in any given month.
gt; For this I have set it up so when a person enters the month on the
gt; assumptions chart there is an if statement in the projections sheet
gt; that enters the amount in the proper month. However as soon as the
gt; acquisition takes place I have a series of 12 (one each month) capital
gt; expenditures that take place below in the expenditures row. How do I
gt; build the functionality so that as soon as the acquisition date is
gt; entered in the capital expenditures line there is a series of 12
gt; payments immediately following the month of the acquisition. Is there
gt; some if statement function or date function mixed with a count function
gt; etc. that would be able to do this (or perhaps an easy solution that I
gt; am totally missing)?
gt;
gt;
gt; Thanks very much in advance for your help on this and HAPPY NEW
gt; YEAR!!!!
gt;
gt;
gt; --
gt; kidflip
gt; ------------------------------------------------------------------------
gt; kidflip's Profile: www.excelforum.com/member.php...oamp;userid=30033
gt; View this thread: www.excelforum.com/showthread...hreadid=497194
gt;
gt;