Reference no: EM13939355
As part of the company’s continues commitment to product innovation, 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.
|
Return on stockholders equity
: Rogers Inc. had 600,000 shares of $2 par common stock outstanding at the end of both 2013 and 2014. Retained earnings at the end of 2013 amounted to $2,160,000. No dividends were paid during 2014, and net income for the year was $600,000. Determine R..
|
|
Determine the cash flows associated with different trucks
: Steve is a contract carrier for the United States Postal Service. He has been hauling mail for nearly thirty years. His current contract is to haul mail between 20 cities in the eleven western states. Determine the cash flows associated with the diff..
|
|
What is the project discounted payback
: Project K costs $70,000, its expected inflows are $16,000 per year for 8 years, and its WACC is 13%. What is the project's discounted payback?
|
|
Dividend exclusion for corporations receiving dividends
: The dividend exclusion for corporations receiving dividends from another corporation has resulted in
|
|
What is best decision using net present value discount rate
: As part of the company’s continues commitment to product innovation, 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..
|
|
Security exchanges create efficient markets
: security exchanges create efficient markets that do all of the following except
|
|
Adjustable gross income-federal income tax
: A single young person had an adjustable gross income (AGI) of 68,000$ and allowable itemized deductions of 5,000$ in 2012. Compute the 2012 federal income tax:
|
|
What is after-tax cost of debt
: Bedrick Co. Can borrow at an interest rate of 7.3% for a period of eight years. Its marginal federal-plus state tax rate is 40%. What is Bedrick's after-tax cost of debt? The company faces a tax rate of 40%. If the company wants to issue new debt, wh..
|
|
Calculate the present value of deprecation
: George bought a piece of equilvalent for 35,000$. The equipment has a useful life of 10 years and a salvage value of 2,000$ at the end of its useful life. Assume that the annual interest rate is 9%. Calculate the present value of deprecation, using t..
|