the above answers are wrong. Please show steps in excel
Return to question 6 After extensive medical and marketing research, Pill, Inc., believes it can penetrate the pain reliever market. It is considering two alternative products. The first is to produce a medication for headache pain. The second is a pill for headache and arthritis pain. Both products would be introduced at a price of $8.80 per package in real terms. The headache-only medication is projected to sell 3 million packages a year, while the headache and arthritis remedy would sell 4.8 million packages a year. Cash costs of production in the first year are expected to be $4.70 per package in real terms for the headache-only brand. Production costs are expected to be $5.25 in real terms for the headache and arthritis pill. All prices and costs are expected to rise at the general inflation rate of 3 percent. 4 points Either product requires further investment. The headache-only pill could be produced using equipment costing $21 million. That equipment would last three years and have no resale value. The machinery required to produce the broader remedy would cost $29 million and last three years. The firm expects that equipment to have a $1 million resale value (in real terms) at the end of Year 3 The company uses straight-line depreciation. The firm faces a corporate tax rate of 34 percent and believes that the appropriate real discount rate is 8 percent. Calculate the NPV for the headache pain reliever only. (Enter your answer in dollars, not millions of dollars. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 1,234,567.89.) NPV 6655620.17 Calculate the NPV for the headache and arthritis pain reliever. (Enter your answer in dollars, not millions of dollars. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 1,234,567.89.) NPV 9,810,011.13 Return to question 6 After extensive medical and marketing research, Pill, Inc., believes it can penetrate the pain reliever market. It is considering two alternative products. The first is to produce a medication for headache pain. The second is a pill for headache and arthritis pain. Both products would be introduced at a price of $8.80 per package in real terms. The headache-only medication is projected to sell 3 million packages a year, while the headache and arthritis remedy would sell 4.8 million packages a year. Cash costs of production in the first year are expected to be $4.70 per package in real terms for the headache-only brand. Production costs are expected to be $5.25 in real terms for the headache and arthritis pill. All prices and costs are expected to rise at the general inflation rate of 3 percent. 4 points Either product requires further investment. The headache-only pill could be produced using equipment costing $21 million. That equipment would last three years and have no resale value. The machinery required to produce the broader remedy would cost $29 million and last three years. The firm expects that equipment to have a $1 million resale value (in real terms) at the end of Year 3 The company uses straight-line depreciation. The firm faces a corporate tax rate of 34 percent and believes that the appropriate real discount rate is 8 percent. Calculate the NPV for the headache pain reliever only. (Enter your answer in dollars, not millions of dollars. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 1,234,567.89.) NPV 6655620.17 Calculate the NPV for the headache and arthritis pain reliever. (Enter your answer in dollars, not millions of dollars. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 1,234,567.89.) NPV 9,810,011.13
