Mattel is developing a new Madonna doll. Managershave made the following assumptions.It is equally likely that the doll will sell for two, four,six, eight, or ten years.At the beginning of year 1, the potential market for thedoll is 1 million. The potential market grows by an averageof 5% per year. They are 95% sure that the growth inthe potential market during any year will be between 3%and 7%.They believe their share of the potential market duringyear 1 will be at worst 20%, most likely 40%, and at best50%. All values between 20% and 50% are possible.The variable cost of producing a doll during year 1 isequally likely to be $4 or $6.The sales price of the doll during year 1 will be $10.Each year, the sales price and variable cost of producingthe doll will increase by 5%.The fixed cost of developing the doll (incurred in year0) is equally likely to be $4, $8, or $12 million.At time 0, there is one competitor in the market. Duringeach year that begins with four or fewer competitors, thereis a 20% chance that a new competitor will enter the market.To determine year t unit sales (for t 1), proceed asfollows. Suppose that at the end of year t 1, x competitorswere present. Then assume that during year t, a fraction.9 .1*x of loyal customers (last year’s purchasers) willbuy a doll during the next year and a fraction .2 .04*x ofpeople currently in the market who did not purchase a dolllast year will purchase a doll from the company this year.We now generate a prediction for year t unit sales. Of course,this prediction will not be precise. We assume that it is sureto be accurate within 15%, however.Cash flows are discounted at 10% per year.a Estimate the expected NPV (in time 0 dollars) ofthis project.b You are 95% sure the expected NPV of this projectis between _____ and _____.c You are 95% sure that the actual NPV of the projectis between _____ and _____.d What two factors does the tornado diagram indicateare key drivers of the project’s profitability?

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Mattel is developing a new Madonna doll. Managers
have made the following assumptions.
It is equally likely that the doll will sell for two, four,
six, eight, or ten years.
At the beginning of year 1, the potential market for the
doll is 1 million. The potential market grows by an average
of 5% per year. They are 95% sure that the growth in
the potential market during any year will be between 3%
and 7%.
They believe their share of the potential market during
year 1 will be at worst 20%, most likely 40%, and at best
50%. All values between 20% and 50% are possible.
The variable cost of producing a doll during year 1 is
equally likely to be $4 or $6.
The sales price of the doll during year 1 will be $10.
Each year, the sales price and variable cost of producing
the doll will increase by 5%.
The fixed cost of developing the doll (incurred in year
0) is equally likely to be $4, $8, or $12 million.
At time 0, there is one competitor in the market. During
each year that begins with four or fewer competitors, there
is a 20% chance that a new competitor will enter the market.
To determine year t unit sales (for t 1), proceed as
follows. Suppose that at the end of year t 1, x competitors
were present. Then assume that during year t, a fraction
.9 .1*x of loyal customers (last year’s purchasers) will
buy a doll during the next year and a fraction .2 .04*x of
people currently in the market who did not purchase a doll
last year will purchase a doll from the company this year.
We now generate a prediction for year t unit sales. Of course,
this prediction will not be precise. We assume that it is sure
to be accurate within 15%, however.
Cash flows are discounted at 10% per year.
a Estimate the expected NPV (in time 0 dollars) of
this project.
b You are 95% sure the expected NPV of this project
is between _____ and _____.
c You are 95% sure that the actual NPV of the project
is between _____ and _____.
d What two factors does the tornado diagram indicate
are key drivers of the project’s profitability?

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps with 28 images

Blurred answer
Knowledge Booster
Intangible cost
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education