Forecasting Monthly Growth Rate in Excel

[Taylor1234]

I am trying to forecast revenue by end of year based on one number and the exponential growth rate for several clients. For example, I have the number 150 and the growth rate is .5%, 150(1+.005)^1 for the first month. For the second month I want it to be equal to month 1's results plus the exponential growth rate. Month 1 results(1+.005)^2, is there a function I can use so I dont have to put this formula in every box?
this is how i have it set up:

I have an input box
# growth rate
client 1 150 .5%
client 2 200 .5%
client 3 175 .5%

Model

client 1 jan feb march
total # with growth rate =150(1+.5%)^1 =150(1+.5%)^2 =150(1+.5%)^3

client 2
total # with growth rate =200(1+.5%)^1 =200(1+.5%)^2 =200(1+.5%)^3

and so on... does anyone know of a way I can use a function in excel for this?

Please let me know. Thank you very much!!! Any suggestions on setting it up differently are appreciated if you think there is an easier way. I will need an input table as this is a forecast based on a lot of assumptions, so the numbers will change quite often

 

[joeu2004]

I am trying to forecast revenue by end of year based on one number and the exponential growth rate for several clients. For example, I have the number 150 and the growth rate is .5%, 150(1+.005)^1 for the first month. For the second month I want it to be equal to month 1's results plus the exponential growth rate. Month 1 results(1+.005)^2, is there a function I can use so I dont have to put this formula in every box?

If the initial investment is in A1 (150), the growth rate is in B1 (0.5%), and the number of months is in C1 (7), either of the following formulas can be written in D1:

=A1*(1+B1)^C1
or
=FV(B1,C1,0,-A1)

If you want to calculate the number of months to the end of the year, you might write the following in C1:

=12-MONTH(TODAY())

That is conservative, ignoring any growth in the current partial month.