Question
Exercise 2 Drug Company A drug company is producing a new drug. The company has made the following assumptions: Year 1 sales will total 1,000,000
Exercise 2 Drug Company A drug company is producing a new drug. The company has made the following assumptions:
Year 1 sales will total 1,000,000 units.
Analysts estimate that in years 2-5, sales will increase over the previous years sales.
In years 6-7 sales will decline from the previous years sales.
During the growth period, sales will grow at a rate of 15% over the previous year.
During the decline period, sales will decline at a rate of 10% from the previous year.
Write a logical formula that correctly models the analysts sales projections.
TIP: Remember when we talk about percentage growth or percentage decline, were talking about 1 + whatever percentage of growth or decline. For example, if a dog weighs 50 pounds in its first year, and will grow 25% in its second year, its Year 2 weight is 1 + 25% ( or 1.25) * 50 or 62.5 pounds. Similarly, if youre calculating decline, the value is 1- the decline % * the prior year. If the dog loses 10% of its weight in Year 3, its new weight will be (1-.10)*62.5, or 56.25. TIP: If you correctly use absolute cell references you should only have to create a single formula and be able to copy and paste it across the entire table! Warning! Dont use constants in your formula(s)! Only cell references.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started