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

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

Raghubhai 

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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education