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

Reviews

Write a Review

 

Financial Management Questions & Answers

  Current earnings per share

Bill’s Bakery has current earnings per share of $2.98. Current book value is $4.9 per share. The appropriate discount rate for Bill’s Bakery is 11 percent. Calculate the share price for Bill’s Bakery if earnings grow at 3.8 percent forever.

  What is the minimum nominal rate of return

What is the minimum nominal rate of return you should accept, if you require a 5% real rate of return and the rate of inflation is expected to average 4.60% during the investment period?

  What is the degree of operating leverage

Given the following information, what is the degree of operating leverage? Price = $20 per unit; variable cost = $6 per unit; fixed costs = $5,000 per year; depreciation = $8,000 per year; sales = 2,000 units per year. Tax rate = 34%.

  Considering the purchase of additional printing equipment

The owner of a small printing company is considering the purchase of additional printing equipment to expand her business. If the owner expands the business and sales are high, projected profits (minus the cost of the equipment) should be $90,000; if..

  Working capital cash flow cycle

Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $120,000 (all on credit), and it earned a net profit of 7%. Its inventory turnover was 4.8588 times during th..

  What is meant by the chutzpah defense

The Sarbanes-Oxley Act of 2002 enhanced corporate governance and accountability and stated implications for non-compliance of public companies. Name the six items of improved corporate governance. What is meant by the “Chutzpah Defense”? Is this type..

  What is proper cash flow amount to use as initial investment

Kenny, Inc., is looking at setting up a new manufacturing plant in South Park. The company bought some land six years ago for $7.7 million in anticipation of using it as a warehouse and distribution site, but the company has since decided to rent fac..

  What does it mean when cash flow from operations

What does it mean when cash flow from operations, investing activities, financial activities on a company's cash flow statement is negative? Is this bad news? Is it dangerous?

  Determine amount of each payment required for sinking fund

Determine the amount of each payment required for a sinking fund in order that enough money will be available to pay off the $25,000 loan, money earns 3% compounded annually, 10 annual payments.

  Different management training positions

Suppose there are 8 different management training positions to be assigned to 8 employees in the company's junior management training program. In how many different ways can the 8 individuals be assigned the 8 different positions?

  What is beths percentage return from her strategy

If the spot rate of the euro in one year is $1.00, what is Beth's percentage return from her strategy? If the spot rate of the euro in one year is $1.08, what is Beth's percentage return from her strategy?

  Do you think us equity markets are cleaner

In light of the Enron, Worldcom, option back dating, government bailouts / nationalizations and Madoff scandals, do you think U.S. equity markets are cleaner and more reliable than stock markets in the rest of the world?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd