MINICASE Garga Products enjoys a steady demand for stainless steel infiltrators used in a number of...
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/6648fe3d5898f_7086648fe3ca858f.jpg)
Transcribed Image Text:
MINICASE Garga Products enjoys a steady demand for stainless steel infiltrators used in a number of chemical processes. Revenues from the infiltrator division are $50 million a year and production costs are $47.5 million. However, the 10 high-precision Munster stamping machines that are used in the production process are coming to the end of their useful life. One possibility is simply to replace each existing machine with a new Munster. These machines would cost $800,000 each and would not involve any additional operating costs. The alternative is to buy 10 centrally controlled Skilboro stampers. Skilboros cost $1.25 million each, but compared to the Munster, they would produce a total saving in operator and material costs of $500,000 a year. Moreover, the Skilboro is sturdily built and would last 10 years, compared with an estimated 7-year life for the Munster. Analysts in the infiltrator division have produced the accompanying summary table, which shows the forecast total cash flows from the infiltrator business over the life of each machine. Garga's standard procedures for appraising capital investments involve calculating net present value, internal rate of return, and payback, and these measures are also shown in the table. As usual, Emily Balsam arrived early at Garga's head office. She had never regretted joining Garga. Everything about the place, from the mirror windows to the bell fountain in the atrium, suggested a classy outfit. Ms. Balsam sighed happily and reached for the envelope at the top of her in-tray. It was an analysis from the infiltrator division of the replacement options for the stamper machines. Pinned to the paper was the summary table of cash flows and a note from the CFO, which read, "Emily, I have read through 20 pages of excruciating detail and I still don't know which of these machines we should buy. Note: The cutoff payback period recommended by the CFO is 3 years for the projects. (a) Can you help Ms. Balsam by constructing an Excel spreadsheet and calculate the NPV, IRR and Payback Period for both projects as shown in the following table (25 pts.) (b) Draw the NPV profile curves for both proposals. Show the significant points on the graphs and interpret the numbers. (25 pts.) (c) Which one of the projects should Ms. Balsam recommend to the CFO based on your results in section (a). You need to justify your recommendation and also to explain why some or all of the measures (i.e., NPV, IRR & Payback) are inappropriate. (25 pts.) (d) Her CFO boss insists that s/he wants to persuade the CEO by using the IRR method because it is easier to communicate by using percentage numbers. Could you carry out the appropriate IRR method in the Excel spreadsheet and help Ms. Balsam to make the correct recommendation by just using IRR results? Please include the NPV profile graph for the IRR method and do not forget to explain your result qualitatively as well. (25 pts.) Cash Flows (millions of dollars) Year: 0 1-7 8 9 10 Munster Investment -8.0 Revenues 50.0 Costs 47.5 Net cash flow -8.0 2.5 000 000 000 NPV at 15% IRR Payback period Skilboro Investment -12.5 Revenues 50.0 50.0 50.0 50.0 Costs 47.0 47.0 47.0 47.0 Net cash flow 125 30 30 3.0 3.0 MINICASE Garga Products enjoys a steady demand for stainless steel infiltrators used in a number of chemical processes. Revenues from the infiltrator division are $50 million a year and production costs are $47.5 million. However, the 10 high-precision Munster stamping machines that are used in the production process are coming to the end of their useful life. One possibility is simply to replace each existing machine with a new Munster. These machines would cost $800,000 each and would not involve any additional operating costs. The alternative is to buy 10 centrally controlled Skilboro stampers. Skilboros cost $1.25 million each, but compared to the Munster, they would produce a total saving in operator and material costs of $500,000 a year. Moreover, the Skilboro is sturdily built and would last 10 years, compared with an estimated 7-year life for the Munster. Analysts in the infiltrator division have produced the accompanying summary table, which shows the forecast total cash flows from the infiltrator business over the life of each machine. Garga's standard procedures for appraising capital investments involve calculating net present value, internal rate of return, and payback, and these measures are also shown in the table. As usual, Emily Balsam arrived early at Garga's head office. She had never regretted joining Garga. Everything about the place, from the mirror windows to the bell fountain in the atrium, suggested a classy outfit. Ms. Balsam sighed happily and reached for the envelope at the top of her in-tray. It was an analysis from the infiltrator division of the replacement options for the stamper machines. Pinned to the paper was the summary table of cash flows and a note from the CFO, which read, "Emily, I have read through 20 pages of excruciating detail and I still don't know which of these machines we should buy. Note: The cutoff payback period recommended by the CFO is 3 years for the projects. (a) Can you help Ms. Balsam by constructing an Excel spreadsheet and calculate the NPV, IRR and Payback Period for both projects as shown in the following table (25 pts.) (b) Draw the NPV profile curves for both proposals. Show the significant points on the graphs and interpret the numbers. (25 pts.) (c) Which one of the projects should Ms. Balsam recommend to the CFO based on your results in section (a). You need to justify your recommendation and also to explain why some or all of the measures (i.e., NPV, IRR & Payback) are inappropriate. (25 pts.) (d) Her CFO boss insists that s/he wants to persuade the CEO by using the IRR method because it is easier to communicate by using percentage numbers. Could you carry out the appropriate IRR method in the Excel spreadsheet and help Ms. Balsam to make the correct recommendation by just using IRR results? Please include the NPV profile graph for the IRR method and do not forget to explain your result qualitatively as well. (25 pts.) Cash Flows (millions of dollars) Year: 0 1-7 8 9 10 Munster Investment -8.0 Revenues 50.0 Costs 47.5 Net cash flow -8.0 2.5 000 000 000 NPV at 15% IRR Payback period Skilboro Investment -12.5 Revenues 50.0 50.0 50.0 50.0 Costs 47.0 47.0 47.0 47.0 Net cash flow 125 30 30 3.0 3.0
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Q2. The figure below shows a three stage space-division switch with N =400, n-10 and 8 cross bars at the middle stage. Carefully analyze this multistage network and answer the following questions:...
-
A realtor earns a 10% commission on the sale of a $150,000 home. The realtor lists the home on June 5, the sale occurs on June 12, and the seller pays the realtor the $15,000 commission on July 8....
-
Ships arrive at the port of Savannah at the rate of 40 per 30-day month (Poisson distributed), generally with a full cargo of containers. It takes an average of 12 hours (exponentially distributed)...
-
The statement "Amounts due to vendors should be accurately and promptly classified, summarized, and reported" might serve as a control objective in which of the following transaction cycles? (a)...
-
Ashley Adams and Michael Rovell formed a partnership in which the partnership agreement provided for salary allowances of $45,000 and $35,000, respectively. Determine the division of a $30,000 net...
-
The Issues With this information about the systems in place at Lost Pines Outfitters, your supervisor has asked you to leverage your understanding of systems thinking to address the following...
-
Refer to the tide charts for Seattle and Port Townsend (top = Seattle, bottom = Port Townsend). Determine the arrival time for the higher high tide at each station for May 15, 2011....
-
Simplify. 7x x 4 x+2 2 x+3 x-9x + 14 x+3x
-
X Company currently makes a part and is considering buying it from a company that has offered to supply it for $19.03 per unit. This year, per-unit production costs to produce 16,000 units were:...
-
Defines the following concepts: a. Regular education b. Special education c. Individualized Educational Program (PEI) d. Individualized Transition Plan (PIT) e, Individualized Pre-employment Plan...
-
When Liam Cote decided to help his cousin Felix Cote turn around his business, he had no idea that things were as bad as they were. Liam knew that the bank's loan was coming due and the company could...
-
1 A gear train is to be designed to transmit power from shaft 1 to shaft 2 with the following conditions: (i) Shaft 1 (driven by an electric motor) rotates at 100 revs min-. (ii) Shaft 2 is to rotate...
-
A short forward delivery price of $19. The current forward price for a three-month forward contract is $46. The three-month risk-free interest rate (with continuous compounding) is 8%. What is the...
-
Tell whether the angles or sides are corresponding angles, corresponding sides, or neither. AC and JK
-
Gemini manufactures athletic shoes. The company records manufacturing costs by job number and uses a factory overhead applied rate to charge overhead costs to its products. The company estimates...
-
Century Fan Company manufactures ceiling fans. During the current year, payments were made for the following items. A new clerk classified the cost items. Are the cost items classified correctly? If...
-
Sea Explor manufactures deep-sea diving suits. The company records manufacturing costs by job number and uses a factory overhead applied rate to charge overhead costs to its products. Sea Explor...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App