Acquisition Schedule Formula

**wmfinance** · 07-19-2010, 02:38 PM

I have a row in my life cycle cost estimate (20 year projection) that needs to follow the following command:

It should be zeroed out every year, except on acquisition years, and every 5th years. Essentially, I would like it so when I change the acquisition years, it will follow the above command.

for example: (3 year acquisition cycle)

Please Login or Register  to view this content.

*If i changed the acquisition cycle to 4 years, it would follow:

Please Login or Register  to view this content.

I would give a dummy book, but I don't even know where to go with this formula...

Any help would be much appreciated!

**shg** · 07-19-2010, 03:20 PM

Here's one way:

Please Login or Register  to view this content.

**ConneXionLost** · 07-19-2010, 03:27 PM

My attempt.

Cheers,

**wmfinance** · 07-19-2010, 04:13 PM

Wow, they both work, you guys are awesome! ConneX, yours is a bit off on, with the 5yr being 4 on your spreadsheet. I added to your both your reps btw

Now to make my life even harder I have differenct aquisition numbers on different schedules?

Please see dummy book for example.

Thanks again, and if you need furthur clarification I will be sure to help out.

*One more thing: I went off of ConneX's workbook because it was just a bit easier to translate to my LCCE...