I have created a multi retail store budget that consists of openings at
different time periods. The main budget pulls from a one store model that
goes out for 10 years. Ex. In month 2 given a store is opened in month 1 and
a store is opened in month 2, in month 2 store 1 would be in its second month
pulling from month 2 in the one store model and the store opened in month 2
would pull from the first month in the one store model. The way the budget
is setup all you have to do is plug in however many stores you want to open
in any given month and it will pull from the one store model and give
Revenue, expense and cashflow scenarios. My problem is that I can only go to
just over four and a half years and my formulas are too long. I can send a
copy of the budget so you can see my proble first hand if you need it. Urgent
reply is needed. Thanks