3 Part 3 of 3 Cost of new equipment Initial working capital required Overhaul of the...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6659a499e7eb2_8736659a4998e1b2.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6659a49aa7015_8746659a49a28490.jpg)
Transcribed Image Text:
3 Part 3 of 3 Cost of new equipment Initial working capital required Overhaul of the equipment after three years Salvage value of the equipment after five years Annual revenues and costs: $420,000 $110,000 $ 50,000 $ 30,000 168 points Sales Variable expenses eBook References Fixed out-of-pocket operating costs $850,000 $500,000 $196,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 $110,000 to $130,000 would you expect the internal rate of return to increase, c 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 $110,000 to $130,000. Note: Be sure to return the fixed out-of-pocket operating costs to the original value of $196,000). 3 Part 3 of 3 Cost of new equipment Initial working capital required Overhaul of the equipment after three years Salvage value of the equipment after five years Annual revenues and costs: $420,000 $110,000 $ 50,000 $ 30,000 168 points Sales Variable expenses eBook References Fixed out-of-pocket operating costs $850,000 $500,000 $196,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 $110,000 to $130,000 would you expect the internal rate of return to increase, c 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 $110,000 to $130,000. Note: Be sure to return the fixed out-of-pocket operating costs to the original value of $196,000).
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Clarence Oil and Gas Corporation agreed to conduct G&G studies and other exploration activities on a lease owned by Charles Energy Company in exchange for an interest in the property if proved...
-
Journalize the following transactions for Combs Company. (a) Purchased 6,000 units of raw materials on account for $11,500. The standard cost was $12,000. (b) Issued 5,600 units of raw materials for...
-
The trajectory of a projectile launched from the origin at an initial speed of at an angle of 0 degrees to the horizontal is given by the parametric equations x = v cos(0)t y = - 1 2912 +v sin(0)t...
-
In the context of inventory costs, _____ are incurred as a result of the work involved in configuring tools, equipment, and machines within a factory to produce an item. A) setup costs B) holding...
-
Lab 27 Network Management with ipMonitor Part 1: Install ipMonitor 1. ipMonitor is a free network monitoring software which identifies SNMP agents on a network. Click the link to go to the download...
-
9. (a) What are dielectrics? Differentiate between polar and non-polar dielectrics with examples. (b) Find the relation between electronic polarizability and atomic radius. (c) Establish the relation...
-
Evaluate 3x/4 6cosx-2 sin x dx 6sinx+2cosx #14 (A)-In (B)-In 2 (C) In (2) (D) In 2 (E) none of these
-
A truck powered by a diesel engine working at a 100% load factor is operated at a mine. If fuel consumption for this truck is 0.3 l/kW and the truck is rated at 1,600 kW what is the level of fuel...
-
Ununununununununununununununun 3. A binary transmission system uses the following waveform and its antipodal counterpart to represent binary 1 and 0 symbols respectively. On the receiver, a...
-
The minutes remaining now is: 7 Seject your answer by ciICKng on tne raIO Dutton that corresponas to tne ietter or your cnoice. You may cneck tne pox next to tne question number to mark it for...
-
Cheatham and Howe is a law firm that is initiating an activity-based costing sys- tem. Jim Cheatham, the senior partner and strong supporter of ABC, has prepared the following list of activities...
-
Paul DiGiovanni & Sons, Inc. is a small manufacturing company in Balboa that uses activity-based costing. DiGiovanni & Sons accumulates overhead in the following activity cost pools. Instructions For...
-
Curly-Soo, Inc. manufactures hair curlers and blow-dryers. The handheld hair curler is Curly-Soo's high volume product (80,000 units annually). It is a "large barrel," 20-watt, triple-heat appliance...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App