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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
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
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 2 steps

Blurred answer
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education