Calculate Projected Revenue (month-over-month)

[karthih]

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

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!