Models parameters on the difference in net present value

Assignment Help Financial Management

Reference no: EM13939774

The Executive Committee of PLE is debating whether to replace its original tractor model, the PLE-Classic, with a new model, the PLE-Tough, which would appeal to a younger clientele. Whatever tractor chosen will be produced for the next 4 years, after which time a reevaluation will be necessary. The PLE-Tough has passed through the concept and initial design phases and is ready for final design and manufacturing. Final development costs are estimated to be $750,000, and the new fixed costs for tooling and manufacturing are estimated to be $6 million. The PLE-Tough is expected to sell for $4,200. The first year sales for the PLE-Tough is estimated to be 4,000, with a sales growth for the subsequent years of 6% per year. The variable cost per vehicle is uncertain until the design and supply-chain decisions are finalized, but is estimated to be $2,300. Next-year sales for the PLE-Classic are estimated to be 3,800, but the sales are expected to decrease at a rate of 10% for each of the next 3 years. The selling price is $3,800. Variable costs per vehicle are $2,140. Since the model has been in production, the fixed costs for development have already been recovered.

a. Develop a 4-year financial model to recommend the best decision using a net present value discount rate of 10%. Include the discount rate as an input variable in your model.

b. What is the best decision using a net present value discount rate of 10%? What is the best decision using a net present value discount rate of 25%?

c. Use Goal Seek to find how sensitive the best decision (discount rate of 10%) is to the estimated variable cost of the PEL-Tough. In other words, what is the maximum acceptable variable cost for the PEL-Tough such that the PEL-Tough is the product of choice?

d. Construct a tornado chart and explain the sensitivity of each of the model’s parameters on the difference in net present value.

Reference no: EM13939774

Questions Cloud

Describe how you would go about dating this site : You have found some very old stone tools in an excavation in Olduvai Gorge, Africa. These stone tools are in association with soe extinct plant fossils and a cooking hearth, and are located in between volcanic strata. Describe how you would go a..

Production of x rays within a hospital : a) Explain the two processes involved in the production of X Rays within a hospital setting ensuring you describe both continuous and characteristic spectrums created.

Memory values and a one-address machine with an accumulator : Given the following memory values and a one-address machine with an accumulator, what values do the following instructions load into the accumulator?

Discuss the three major trends that have prevailed : Discuss the three major trends that have prevailed in international business during the last two decades.

Models parameters on the difference in net present value : The Executive Committee of PLE is debating whether to replace its original tractor model, the PLE-Classic, with a new model, the PLE-Tough, which would appeal to a younger clientele. Whatever tractor chosen will be produced for the next 4 years, afte..

What bacterial structure does penicillin weaken : Chemotaxis in E. coli depends on what flagellar characteristic? What bacterial structure does penicillin weaken?

Medication management plan for kate : You are required to answer the following questions on the case study below and provide a 600 word medication management plan for Kate.

Explain the mechanism which restores the balance : Explain the mechanism which restores the balance of payments equilibrium when it is disturbed under the gold standard.

How civilization emerged in mesopotamia : How civilization emerged in Mesopotamia, Ancient Egypt and the Hittite empire? What are the characteristics of these civilizations that we have inherited

User Account

All Pages