I've been struggling with this scenario for many hours now and am hopeful
someone on this group can provide an assist.

Consider the following known data:
2005 Annual Invoice Date
2005 Annual Invoice Amount
2006 Annual Invoice Amount

I need to create a monthly amortized view of this data (through 2007),
taking into consideration that the invoice month is one month in advance of
the booking month.

For instance:
A customer was billed $12000 on 3/1/05 for an annual contract. This invoice
would be amortized $1000 per month for 12 months starting 4/05 and ending
3/06. The renewal in 2006 will $15000. This will be amortized $1250 per
month for 12 months starting 04/06 and ending 03/07.

Again, I know the 2005 invoice date, the 2005 invoice amount, and the 2006
renewal rate. What is the best course to be able to display monthly data
through 2007?

I have been able to do this for 2006 using the following logic applied to
each of the 12 months of 2006.

JAN: If the invoice date MONTH = 12, then apply 1/12 of the 2006 rate, else
apply 1/12 of the 2005 rate.

FEB-DEC: If the invoice date MONTH <= one month prior to the current month,
then apply 1/12 of the 2006 rate, else apply 1/12 of the 2005 rate.

While surely not the best way to do this, it works but I can't figure out
how to extend the 2006 invoice for the proper number of months into 2007.

Any ideas would be greatly appreciated! I know this is probably a tough one.

Thanks,
David