Hi all,

I wanted to know how to calculate projected revenue month-over-month. I tried searching this forum but could not find any post which has my specific problem and hence I am posting it here.

I have my months listed from A3 to A14 and revenue listed in column B3 to B14. I have calculated month-over-month growth rate in column C (C3 to C14) using the formula below:

=((B4-B3)/B3)*100

I have also already calculated similar values for 2010 and 2009. I need to calculate the projected revenue (month-over-month) from Sept 2011 till Dec 2011. I also need to reuse this for future calculations.

Can anyone help me out with this query?

Thanks in advance for anyone who responds.

Regards,
Kay