The same drug company is producing a new drug. The company has made the following assumptions:

During Year 1, 100,000 units will be sold. Sales will grow for three years and then decline for seven years.

During the growth period, sales will grow at a rate of 15 percent per year. During the decline, sales will drop at a rate of 10 percent per year.

Develop a worksheet with values for Year 1 sales, the length of the growth cycle, the length of the decline cycle, the growth rate during the growth cycle, and the rate of decrease during the decline cycle. Then compute projected unit sales for Years 1 through 11.