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:
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.) 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.)
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
A stock is currently priced at $39.3. Its dividend is expected to grow at a rate of 5.9% per year indefinitely. The stock's required return is 8.4%. The stock's predicted price 7 years from now, P7,...
-
Selected account balances and transactions of Alpine Manufacturing Co. follow: May Transactions: a. Purchased raw materials and factory supplies on account at costs of $45,000 and $10,000,...
-
Pauley, Inc., pays its employees' weekly wages in cash. A supplementary payroll sheet that lists the employees' names and their earnings for a certain week is shown below. Complete the payroll sheet...
-
Some members of the financial community allege that corporate managers manage their companys reported accounting results. Discuss the possible motivations behind this behavior.Can you envision a...
-
Given the following set of cash flows: Period Cash Flow 1 $ 45,000 2 40,000 3 35,000 4 30,000 5 25,000 a. If your required rate of return is 7% per year, what is the present value of the above cash...
-
What motivates financial institutions (FIs) to hedge foreign currency exposures? What are the limitations to hedging foreign currency exposures
-
analyze an interpersonal conflict. This conflict can be an actual situation that you have participated in or observed or from a conflict situation that you watched in a film or a television show. In...
-
A retailer has net annual sales of $ 3 , 0 0 0 , 0 0 0 . Retail expenses are $ 2 6 0 , 0 0 0 . Net profit is $ 4 0 0 , 0 0 0 . . For the retailer in this problem, the retail selling price is $ 1 0 ....
-
Applying Castellano's Model of Employee Engagement , analyze the root causes of the HILL's problem and their manifestation.
-
What exactly are the differences you noted between the TV series and the novel? Why do you suppose these differences exist--and how do they help us understand Dexter in different ways. Essentially,...
-
CPA Exam Adapted: A company purchased a computer on May 1, for $12,000 with an estimated salvage value of $1,500 and a 3-year life. What is the depreciation expense for the year ended December 31,...
-
Does bad faith exist in a distributive bargaining scenario? For instance, when selective presentation is used, does it ever become an exercise in bad faith?
-
Consider a two-period binomial model for the stock price with both periods of length one year. Let the initial stock price be S0 = 100. Let the up and down factors be u = 1.25 and d = 0.75,...
-
The diagram shows the two forces acting on a small object. Which of the following is the resultant force on the object? A. 8 N downwards B. 8 N upwards C. 2 N downwards D. 2 N upwards 3 N 5 N
-
Omaha, Inc., recorded certain capital stock transactions shown in the following journal entries: (1) issued common stock for \(\$ 40\) cash per share, (2) purchased treasury shares at \(\$ 50\) per...
-
Kitch Corporation has 50,000 shares of \(\$ 5\) par value common stock outstanding and retained earnings of \(\$ 820,000\). The company declares a 100 percent stock dividend. The market price at the...
-
The stockholders' equity accounts of Willis Corporation at January 1 appear below: During the year, the following transactions occurred: Jan. 10 Issued 35,000 shares of common stock for \(\$ 18\)...
Study smarter with the SolutionInn App