Reference no: EM13335890

The Charlotte Motor Werks (CMW) Corporation is trying to decide whether to introduce a new roadster for mass markets, a revolutionary and risky idea. The directors of the company only want to produce the car if it has at least an 80% chance of generating a positive net present value (NPV) over the next ten years. If the company decides to produce the car, it will have to pay an uncertain initial start-up cost that is estimated to follow a triangular distribution with a minimum value of $2 billion, maximum value of $2.4 billion, and a most likely value of $2.1 billion. In the first year, the company would produce 100,000 units. Demand during the first year is uncertain but expected to be normally distributed with a mean of 95,000 and standard deviation of 7,000. After the first year, the demand in any year will be modeled as a normally distributed random variable with a mean equal to the actual demand in the previous year and standard deviation of 7,000. For any year in which the demand exceeds production, production will be increased by 5% in the following year. For any year in which the production exceeds demand, production will be decreased by 5% in the next year, and the excess cars will be sold to a rental car company at a 20% discount. In the first year, the sales price of the car will be $13,000 and the total variable cost per car is expected to be $9,500. Both the selling price and variable cost is expected to increase each year at the rate of inflation, which is assumed to be uniformly distributed between 2% and 7% (assume no inflation during year 1). The company’s cost of capital is 9%.

a. Create a spreadsheet model for this problem and replicate it 1000 times.

What is the minimum, average and maximum net present value CMW can expect if they decide to produce this car? (12 pts) Chk. fig. Avg. ~ [$300 – 348 million]

b. What is the probability of CMW earning a positive NPV over the next ten years? (3 pts)

c. Should they produce this car (discuss)? (5 pts)