Genesis Pharmaceutical has developed a new diabetes medication. It estimates that the sales volume during the first year will be 200,000 units. The sales volume is projected to grow by 20% each year. The price of each unit is $50 during the first year and will increase by 5% each year. The fixed manufacturing costs for the medication are $500,000 for every 100,000 units, and the variable costs are $25 per unit. The variable costs will increase by 10% each year due to increased material and labor costs. a. Develop a spreadsheet model to estimate the total profit Genesis Pharmaceutical makes on this medication over the next five years. Note: Round your answer to 2 decimal places. Total profit b-1. Convert the future profits into their net present value. If it costs Genesis Pharmaceutical $12,000,000 in R&D to develop the medication, What is the net present value (NPV) of the 3-year profit assuming a discount rate of 3%? Note: Round your answer to 2 decimal places. NPV of the total profit
Genesis Pharmaceutical has developed a new diabetes medication. It estimates that the sales volume during the first year will be 200,000 units. The sales volume is projected to grow by 20% each year. The price of each unit is $50 during the first year and will increase by 5% each year. The fixed manufacturing costs for the medication are $500,000 for every 100,000 units, and the variable costs are $25 per unit. The variable costs will increase by 10% each year due to increased material and labor costs. a. Develop a spreadsheet model to estimate the total profit Genesis Pharmaceutical makes on this medication over the next five years. Note: Round your answer to 2 decimal places. Total profit b-1. Convert the future profits into their net present value. If it costs Genesis Pharmaceutical $12,000,000 in R&D to develop the medication, What is the net present value (NPV) of the 3-year profit assuming a discount rate of 3%? Note: Round your answer to 2 decimal places. NPV of the total profit
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
None
![Genesis Pharmaceutical has developed a new diabetes medication. It estimates that the sales volume during the first year will be
200,000 units. The sales volume is projected to grow by 20% each year. The price of each unit is $50 during the first year and will
increase by 5% each year. The fixed manufacturing costs for the medication are $500,000 for every 100,000 units, and the variable
costs are $25 per unit. The variable costs will increase by 10% each year due to increased material and labor costs.
a. Develop a spreadsheet model to estimate the total profit Genesis Pharmaceutical makes on this medication over the next five years.
Note: Round your answer to 2 decimal places.
Total profit
b-1. Convert the future profits into their net present value. If it costs Genesis Pharmaceutical $12,000,000 in R&D to develop the
medication, What is the net present value (NPV) of the 3-year profit assuming a discount rate of 3%?
Note: Round your answer to 2 decimal places.
NPV of the total profit](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F91645501-7f6b-4e31-a441-cd82aec27bfe%2F9f60471a-3382-4c46-918e-2fe83b23554b%2Fjqk4v1_processed.png&w=3840&q=75)
Transcribed Image Text:Genesis Pharmaceutical has developed a new diabetes medication. It estimates that the sales volume during the first year will be
200,000 units. The sales volume is projected to grow by 20% each year. The price of each unit is $50 during the first year and will
increase by 5% each year. The fixed manufacturing costs for the medication are $500,000 for every 100,000 units, and the variable
costs are $25 per unit. The variable costs will increase by 10% each year due to increased material and labor costs.
a. Develop a spreadsheet model to estimate the total profit Genesis Pharmaceutical makes on this medication over the next five years.
Note: Round your answer to 2 decimal places.
Total profit
b-1. Convert the future profits into their net present value. If it costs Genesis Pharmaceutical $12,000,000 in R&D to develop the
medication, What is the net present value (NPV) of the 3-year profit assuming a discount rate of 3%?
Note: Round your answer to 2 decimal places.
NPV of the total profit
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education