Gregg Wolin
Member
I apologize for the title but I was having a hard time putting my question into a few words...
I have a model that uses a projection of market share over a 30-year period (monthly).
Sales Start (Mo) 36
Capture: Year 1 1%
Capture: Year 2 2%
Capture: Year 3 4%
Annual Growth 1%
Capture Cap 8%
My existing model works fine IF the analysis starts at time=0. I'd like to ability to delay the start of sales for a period of months (say 36), at which time the Year 1, Year 2 and Year 3 capture rates are used. After the 36 months of sales, months 37-48 will be the Year 3 monthly rate + 1%, Year 5 will be the Year 4 rate +1%. This continues until the period where the annual growth would result in a capture rate > the Capture Cap at which time the capture rate stays flat.
The attached workbook illustrates what i am after.
I have a model that uses a projection of market share over a 30-year period (monthly).
Sales Start (Mo) 36
Capture: Year 1 1%
Capture: Year 2 2%
Capture: Year 3 4%
Annual Growth 1%
Capture Cap 8%
My existing model works fine IF the analysis starts at time=0. I'd like to ability to delay the start of sales for a period of months (say 36), at which time the Year 1, Year 2 and Year 3 capture rates are used. After the 36 months of sales, months 37-48 will be the Year 3 monthly rate + 1%, Year 5 will be the Year 4 rate +1%. This continues until the period where the annual growth would result in a capture rate > the Capture Cap at which time the capture rate stays flat.
The attached workbook illustrates what i am after.
Attachments
Last edited: