Formula which give you start position based on input

Hi

I am looking for a formula which give you the start position based on Launch Period and a % increase each period until the end of the year.

For example:

New product launched in P6 and predicted FY launch for Y1 is 0.31
% Increase 8% each period
Based on the Year 2 launch is 0.5m some of this cost can be manually be inputted into the P12 (cell shown in green)
0.5m can be used as 1/12 and then it works back wards to get the start position. (which i am stuck on)

I have attached an spreadsheet. and highlighted the cells in yellow where there is a formula which does not work. The variance in column T24 should be zero.

Thanks

Is there reason (as I don't understand the maths) that you don't have the formula in P24? If you do the variance is 0 !!!

There shouldnt be a formula in P24 as this number will give P1-5 rollover into the following year as balancing number.

This formula need to provide me with the RUN RATES depending on the launch period.

Hope this makes sense

Thanks

ahh makes sense so cant we make the formula work backwards from P12 down to the Launch Period including the percentage increase from each period.

Thanks

What is the issue? the formula is ALL the cells so there is no need to change anything. For some reason you had a constant in P24.

We have got a FULL year project for 2017 of 0.30692 in column R24 if the project launches in P6 then using the INPUT number in P12 to make it a FULL year number for next year as P1-P5 are missing we need to work back wards to apply the rate and get back to the launch period with the percentage.

Hope this makes sense. I know its confusing, its working out the run rates for Y1 and Y2 rollover. e.g if product launches in P6 2017 it would be a FY in P6 2018.

Thanks