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
-
A laptop computer maker uses battery packs supplied by two companies, A and B . Both brands should have the same average battery life between charges (LBC); however, the computer maker seems to...
-
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 $...
-
Max and Marion sell for Whatisits Company. Max has by far the highest in the firm - .400. Unfortunately, his average order is the lowest - $3,000. He only saves himself by making many calls per day...
-
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...
-
Harry Daniels is a quality control engineer for the Specific Electric Corporation. Specific manufactures electric motors. One of the steps in the manufacturing process involves the use of an...
-
Give the molecular formula of each compound shown in Problem 1-31. In problem (a) (b) (c) (d) (e) (f) (g) (h) pyridine pyrrolidine furan y-aminobutyric acid a neurotransmitter) CHO SO H
-
Your local newsagent makes sales of 52,000 and purchases of 31,000 over the last accounting year. The owner took goods costing 455 without paying for them. Closing stock was valued at its cost of...
-
For each of the following independent situations, calculate the amount(s) required. Required: 1. At the break-even point, Jefferson Company sells 115,000 units and has fixed cost of $349,600. The...
-
1. Assume HO: = = [Choose] > 9 and Ha: u 9. 2. Assume HO: us 6 and Ha: u > 6. 3. Your friend claims that his mean golf score is 63. 4. You flip a coin and record whether it shows heads or tails. You...
-
Homework-Ch.11 5 333 points eBook Beacon Corporation issued a 8 percent stock dividend on 25,000 shares of its $8 par common stock. At the time of the dividend, the market value of the stock was $26...
-
Justify which general factors you consider should be taken into account when recruiting salespeople for the positions described in the exercise. In particular, suggest how the performance of such...
-
Discuss the occasions when you believe auditors should be required to report suspicion of a client engaged in fraud to a third party.
-
Of the following, which is not an example of a project interacting with operations? a. Retooling a factory to increase production efficiency. b. Opening a new call center. c. Increasing rose bouquet...
-
Why is Allowance for Uncollectible Accounts debited when a customer account is written off?
-
During the sales interview, the following objections are raised. How would you deal with them? 1 Im sorry, I have an urgent meeting in ten minutes time. Can we make it quick? 2 We havent had any...
-
After watching this video, Please answer these questions to the best of your ability Link (https://youtu.be/__-w--Nr8nA) to first 7 questions. 1. What would you see as the origins of Becca's...
-
Use nodal analysis to determine voltages v1, v2, and v3 in the circuit Fig. 3.76. Figure 3.76 4 S 3i, 2 A 4A
-
Lockwood Company has two production departments, Fabricating and Assembling. At a department managers' meeting, the controller uses flexible budget graphs to explain total budgeted costs. Separate...
-
Loeb's Company's organization chart includes the president; the vice president of production; three assembly plants Dallas, Atlanta, and Tucson; and two departments within each plant Machining and...
-
The Hack craft Division of Nunez Company reported the following data for the current year. Top management is unhappy with the investment center's return on investment (ROI). It asks the manager of...
Study smarter with the SolutionInn App