Henderson Company has an opportunity to manufacture and sell a new product for a five-year period....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Henderson Company has an opportunity to manufacture and sell a new product for a five-year period. The company estimated the following costs and revenues for the new product: Cost of new equipment Initial working capital required Overhaul of the equipment after three years $420,000 $120,000 $ 50,000 Salvage value of the equipment after five years $ 30,000 Annual revenues and costs: Sales $850,000 Variable expenses Fixed out-of-pocket operating costs $500,000 $194,000 When the project concludes in five years the working capital will be released for investment elsewhere in the company. Click here to download the Excel template, which you will use to answer the questions that follow. Click here for a brief tutorial on Goal Seek in Excel. 3. In the Excel template, using Goal Seek, calculate this investment's internal rate of return. If the company's hurdle rate is 18% would it be likely to accept or reject the investment? Why? 4. What is the project's net present value when using a discount rate of 18% ? 5. If the company wants to achieve an 18% return on this investment, what is the maximum amount that it can spend each year on fixed out-of-pocket operating costs? Use Goal Seek to compute your answer. Note: The fixed out-of-pocket operating costs remain constant for all five years, therefore modifying cell C13 automatically updates cells D13 through G13. 6. If the investment in working capital increased from $120,000 to $140,000 would you expect the internal rate of return to increase, decrease, or stay the same? No computations are necessary to answer this question. 7. Refer to the original data. Using Goal Seek, calculate the internal rate of return if the investment in working capital increases from $120,000 to $140,000. Note: Be sure to return the fixed out-of-pocket operating costs to the original value of $194,000). Henderson Company has an opportunity to manufacture and sell a new product for a five-year period. The company estimated the following costs and revenues for the new product: Cost of new equipment Initial working capital required Overhaul of the equipment after three years $420,000 $120,000 $ 50,000 Salvage value of the equipment after five years $ 30,000 Annual revenues and costs: Sales $850,000 Variable expenses Fixed out-of-pocket operating costs $500,000 $194,000 When the project concludes in five years the working capital will be released for investment elsewhere in the company. Click here to download the Excel template, which you will use to answer the questions that follow. Click here for a brief tutorial on Goal Seek in Excel. 3. In the Excel template, using Goal Seek, calculate this investment's internal rate of return. If the company's hurdle rate is 18% would it be likely to accept or reject the investment? Why? 4. What is the project's net present value when using a discount rate of 18% ? 5. If the company wants to achieve an 18% return on this investment, what is the maximum amount that it can spend each year on fixed out-of-pocket operating costs? Use Goal Seek to compute your answer. Note: The fixed out-of-pocket operating costs remain constant for all five years, therefore modifying cell C13 automatically updates cells D13 through G13. 6. If the investment in working capital increased from $120,000 to $140,000 would you expect the internal rate of return to increase, decrease, or stay the same? No computations are necessary to answer this question. 7. Refer to the original data. Using Goal Seek, calculate the internal rate of return if the investment in working capital increases from $120,000 to $140,000. Note: Be sure to return the fixed out-of-pocket operating costs to the original value of $194,000).
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Eisner Company has an opportunity to manufacture and sell a new product for a five-year period. The company estimated the following costs and revenues for the new product: Cost of new equipment $...
-
Pierce Phones is considering the introduction of a new model of headphone whose selling price is $18 per unit and whose variable expense is $15 per unit. The company's monthly fixed expense is...
-
Ed Bogdanski, owner of the American Precast Company, has hired you as a part-time analyst. Ed was extremely pleased when you determined that there is a positive relationship between the number of...
-
In addition to being subject to loss, UDP packets have a maximum length, potentially as low as 576 bytes. What happens when a DNS name to be looked up exceeds this length? Can it be sent in two...
-
What is the difference between management accounting and the other two types of conventional accountingfinancial accounting and other accounting systems?
-
On January 1, 2014, Yellow Car Company issued 15-year, $50,000,000 face value, 4% bonds, at par. Each $1,000 bond is convertible into 20 shares of Yellow Car common stock . None of the bonds were...
-
The Twain Mill Company has issued rights to its shareholders.The stock is currently selling for $20 rights-on.The subscription price on the rights offering is $18.Three rights are required to...
-
32) Many roller coasters begin with a motor pulling the carts to the top of a large hill. A larger initial hill allows the roller coaster to travel for a longer period of time. why is this the case?...
-
Why are problem solving and decision making important in sports?
-
Why is it necessary to determine the decision structure and the conditions surrounding the decision?
-
Discuss the role of governing bodies in managing and controlling their sport.
-
What is the performance equation and how is it used with coaching?
-
What are three career paths in sport management that you find interesting?
-
Inscribe a paper on Architecture behind Great Egyptian Pyramid
-
The following data are supplied for the common stocks of Nikola Corporation, Tesla, Inc. and General Motors: Nikola Corp (NKLA) Tesla Inc. (TSLA) Close Price ($) Close Price ($) 67.53 30.00 40.81...
-
For the idealized class-B output stage in Figure 8.18 in the text, show that the maximum theoretical conversion efficiency for a symmetrical squarewave input signal is 100 percent. <00 B V+ A Figure...
-
Consider an idealized class-B output stage shown in Figure P8.22. The output stage is to deliver \(50 \mathrm{~W}\) of average power to a \(24 \Omega\) load for a symmetrical input sine wave. Assume...
-
Consider an idealized class-B output stage shown in Figure P8.22. (The effective turn-on voltages of devices A and B are zero, and the effective "saturation" voltages of \(v_{A}\) and \(v_{B}\) are...
Study smarter with the SolutionInn App