Contract start end date issues

[angrybrian]

For financial modelling, I always encounter the issue of forecasting employee benefits and contract revenue.


Every contract has a start and end date. This causes an issue when forecasting for a particular month in the model.


There are always 5 scenarios which I must consider - they are:


1 The Contract hasnt started

2 The contract starts in during this month

3 The contract run through this entire month

4 The contract ends during the month

5 The contract has already finished


To trigger a revenue calculation I create some flags; as shown below. I normally put these into one formula, but its nice to some them separately so the client can see what is being calculated.


My question is - there must be a simplified way to do this???? Anyone suggestions


I've posted a mock calculation to my public skydrive so you can view it:


https://skydrive.live.com/#!/edit.aspx?cid=B6331141F6A7CC06&resid=B6331141F6A7CC06%21159&app=Excel

 

[Faseeh]

Hi angrybrian,


Welcome to the Forums.


The worksheets looks nice and if you want simpler formula, stick with it. The sheet can have fewer formula at the expense of greater complexity. Just inform what you do you want.


Regards,

Faseeh

 

[angrybrian]

Thanks mate


I didn't have anything particular that I wanted, I simply wanted to see if anyone else has another approach to this common practical issue


AB.