help! - sequential unit start-ups - financial model

  • Thread starter Thread starter Cory
  • Start date Start date
C

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.
 
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.
 
Back
Top