help! - sequential unit start-ups - financial model

[Cory]

I am building a spreadsheet model and attempting to pull
data from a new business unit template. Each quarter,
our business will start-up 5 or 10 new units (i.e.,
locations) and I want to calculate the revenue from the
units as they build-up over time. So, in quarter 1, I
multiply 5 new units by the revenue per unit in quarter 1
from my startup template. In quarter 2, I multiply the
number of units I started last quarter by the quarter 2
revenue in my template PLUS the number of units I am
opening this quarter by the quarter 1 revenue in my start-
up template. By the time I get to quarter 4 and 5, my
formulas are unbearable, not to mention quarters 8 or 9!
Is there a function I should be using??

Any help you financial wizard can provide would be
helpful. Thanks.

 

[immanuel]

Are your revenues per quarter per unit fixed? And is the number of new
units per quarter arbitrary?

Could you post some detail about your data layout? A simple example table
might go a long way...

/i.