Solved

# 500 points if you create the Excel formula for this.

Posted on 2004-03-30

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!