Let's do some simple rounding, to make this rather complex question easier to answer.

I track my company's monthly income in an Excel spreadsheet where Column A contains the months (dating back to January of '03), and Column B contains the amounts. For example, A1=01/03, A2=02/03, B1=2000, B2=2100, A72=12/08, etc.

Let's say my company made $5,000 in March (so B15=5000).

And let's say I have a goal for my company to make $1,000,000 in the calendar year 2008, so SUM(B61..B72) is 1,000,000.

By what consistent percentage will I have to increase my company's income every month to be able to hit $1,000,000 in 2008?

I want to be able to enter a formula into an Excel spreadsheet so that I can change the goal, and the target date to achieve that goal.

I look forward to your answers!

X * (1 + P)^N = Y

If you divide both sides by X, take the natural logarithms, and use the logarthm property that

ln(a^b) = b * log(a)

you have:

N * ln(1 + P) = ln(Y/X)

Now you need to move N to the right and take the exponential of both sides, because it is the inverse function of the natural logarithm:

exp(ln(1 +P)) = exp(ln(Y/X)/N)

which finally gives you:

P = exp(ln(Y/X)/N) - 1

In Excel this formula is written as follows:

=EXP(LN(Y/X)/N)-1

where Y and X are the cells where your goal and the March revenue are stored. Obviously, you can also store your goal directly in the formula:

=EXP(LN(1000000/B15)/N) - 1

If you want to have a parametric N, you can use the function COUNTA(cell-range) which counts the non-empty cells in a range. Therefore, COUNTA(A:A) would count the months. Another useful function in this context might be ROW(reference) which gives you the row of a cell. Therefore:

COUNT(A:A) - ROW(B15)

would calculate for you the number of months left (72 - 15)

There are perhaps financial functions which would be useful, but I am familiar with the Math functions...