Excel 2007 : Cumulative Projectied Cash Flow

In the profit sections of the projected cash flow sheets, I need each month of the 12, to have ascending amounts, cumulatively equal the final given amount. For example they would go up x% a month to equal ______.

I'm on a time constraint so any help would be very much appreciated.

It seems like a simple matter of formula, plus auto fill, but I'm clueless as to what that formula is referred to as, and am having a hard time finding it.


MJ

P.S Dont judge the business proposal financials, its just an assignment