The production foreman for ABC Corporation has proposed the following two projects for minimizing costs and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The production foreman for ABC Corporation has proposed the following two projects for minimizing costs and generating higher revenue: Project 1: Retool current production equipment. The following price quote has been identified: Retooling costs Set-up costs In addition, the following incremental cash flows have been identified: Increased revenue for the first year is expected to be $98,000. Revenue will increase at approximately 5% per year for the following four years. ● ● ● ● $230,000 $ 40,000 Reduced operating costs for the first year are expected to be $40,000. Cost savings will diminish by 22% a year for the project's remaining four years. The retooled equipment will require $32,000 in additional maintenance costs for the first year. These additional costs will increase by 16% a year for the remaining four years. The retooled equipment will require an additional $9,000 in working capital. Working capital will be recaptured at the end of the investment horizon. The expected salvage value of the retooled equipment at the end of the five-year investment horizon is $22,000. Project 2: Expand current production capabilities by purchasing additional equipment. The following price quote has been identified: Base cost Installation costs Modifications $425,000 $ 75,000 $ 7,500 In addition, the following incremental cash flows have been identified: Increased revenue for the first year is expected to be $125,000. Revenue will increase at approximately 10% per year for the following four years. ● ● ● ● Additional information: The new equipment and the retooling costs are considered 5-year property for depreciation purposes. ABC Corporation utilizes the appropriate MACRS depreciation method for allocating capital costs. The applicable depreciation rates are shown below. Year 1: 20% Year 2: 32% Year 3: 19% Year 4: 12% Year 5: 11% Year 6: 6% The marginal corporate tax rate for ABC Corporation is 25%. 3. Reduced operating costs for the first year are expected to be $75,000. Cost savings will diminish by 11% a year for the project's remaining four years. 4. The new equipment will require $35,000 in specialized maintenance costs for the first year. These specialized costs will increase by 9% a year for the remaining four years. 5. The new equipment will require an additional $20,000 in working capital. Working capital will be recaptured at the end of the investment horizon. The expected salvage value of the equipment at the end of the five-year investment horizon is $19,000. a. b. C. REQUIRED: 1. 2. d. e. f. Prepare an incremental cash flow analysis worksheet for each project. Compute the net present value (NPV) for each project using a cost of capital range, where the range equals 8% through 32% (use increments of 2 percentage points). Compute the internal rate of return (IRR) for each project. Prepare an annotated net present value profile that clearly identifies the following: The NPVs for each project. a. The IRRs for each project (within 3 decimal places after conversion to percentage format). The precise (i.e., within 3 decimal places) crossover rate. Prepare a memorandum using robust sentences and paragraphs, and avoid the use of bullet points. Ensure that the memorandum addresses the following points of analysis: Differences between independent and mutually exclusive projects Assume that the projects are independent. Determine which project(s) should be selected for cost of capital (,) figures equal to 10%, 18%, and 24%. Thoroughly explain the reasons behind the selections, and determine if the crossover rate and internal rates of return are relevant to the selections. b. C. a. i. ii. Assume that the projects are mutually exclusive. Determine which project(s) should be selected for cost of capital (,) figures equal to 10%, 18%, and 24%. Thoroughly explain the reasons behind the selections, and determine if the crossover rate and internal rates of return are relevant to the selections. b. Perform a sensitivity analysis of revenue 6. C. a. b. C. d. e. i. f. ii. iii. d. In light of the analysis performed on these projects, select the better project and make a specific recommendation. Thoroughly explain why the project chosen is a more appropriate choice than the other project. Support the selection made with the relevant results of your calculations and analysis. Submit the following in electronic form as a single compiled PDF: The extended memorandum. Each incremental cash flow analysis worksheet. The NPV analysis with the given range of cost of capital. The results of the sensitivity analysis. The annotated NPV profile. The Grammarly summary page showing a rating of 90% or better for your written work. Perform a sensitivity analysis of the salvage value For projects 1 and 2, increase the projected salvage value in year 5 by 8% and assume that everything else remains the same. For a cost of capital (k) of 12%, determine the new NPV for both projects and the percentage changes the NPVs experienced relative to the base cases. Briefly discuss implications. For projects 1 and 2, decrease the projected salvage value in year 5 by 8% and assume that everything else remains the same. For a cost of capital (k,,) of 12%, determine the new NPV for both projects and the percentage changes the NPVs experienced relative to the base cases. Briefly discuss the implications. i. ii. For projects 1 and 2, increase projected revenue in year one by 8% and assume that everything else remains the same. For a cost of capital (ks) of 12%, determine the new NPV for both projects and the percentage changes the NPVs experienced relative to the base cases. Briefly discuss the implications. For projects 1 and 2, decrease projected revenue in year one by 8% and assume that everything else remains the same. For a cost of capital (k,,) of 12%, determine the new NPV for both projects and the percentage changes the NPVs experienced relative to the base cases. Briefly discuss the implications. Present your findings in a table showing the NPVs and the percentage changes relative to the base case. iii. Present your findings in a table showing the NPVs and the percentage changes relative to the base case. The production foreman for ABC Corporation has proposed the following two projects for minimizing costs and generating higher revenue: Project 1: Retool current production equipment. The following price quote has been identified: Retooling costs Set-up costs In addition, the following incremental cash flows have been identified: Increased revenue for the first year is expected to be $98,000. Revenue will increase at approximately 5% per year for the following four years. ● ● ● ● $230,000 $ 40,000 Reduced operating costs for the first year are expected to be $40,000. Cost savings will diminish by 22% a year for the project's remaining four years. The retooled equipment will require $32,000 in additional maintenance costs for the first year. These additional costs will increase by 16% a year for the remaining four years. The retooled equipment will require an additional $9,000 in working capital. Working capital will be recaptured at the end of the investment horizon. The expected salvage value of the retooled equipment at the end of the five-year investment horizon is $22,000. Project 2: Expand current production capabilities by purchasing additional equipment. The following price quote has been identified: Base cost Installation costs Modifications $425,000 $ 75,000 $ 7,500 In addition, the following incremental cash flows have been identified: Increased revenue for the first year is expected to be $125,000. Revenue will increase at approximately 10% per year for the following four years. ● ● ● ● Additional information: The new equipment and the retooling costs are considered 5-year property for depreciation purposes. ABC Corporation utilizes the appropriate MACRS depreciation method for allocating capital costs. The applicable depreciation rates are shown below. Year 1: 20% Year 2: 32% Year 3: 19% Year 4: 12% Year 5: 11% Year 6: 6% The marginal corporate tax rate for ABC Corporation is 25%. 3. Reduced operating costs for the first year are expected to be $75,000. Cost savings will diminish by 11% a year for the project's remaining four years. 4. The new equipment will require $35,000 in specialized maintenance costs for the first year. These specialized costs will increase by 9% a year for the remaining four years. 5. The new equipment will require an additional $20,000 in working capital. Working capital will be recaptured at the end of the investment horizon. The expected salvage value of the equipment at the end of the five-year investment horizon is $19,000. a. b. C. REQUIRED: 1. 2. d. e. f. Prepare an incremental cash flow analysis worksheet for each project. Compute the net present value (NPV) for each project using a cost of capital range, where the range equals 8% through 32% (use increments of 2 percentage points). Compute the internal rate of return (IRR) for each project. Prepare an annotated net present value profile that clearly identifies the following: The NPVs for each project. a. The IRRs for each project (within 3 decimal places after conversion to percentage format). The precise (i.e., within 3 decimal places) crossover rate. Prepare a memorandum using robust sentences and paragraphs, and avoid the use of bullet points. Ensure that the memorandum addresses the following points of analysis: Differences between independent and mutually exclusive projects Assume that the projects are independent. Determine which project(s) should be selected for cost of capital (,) figures equal to 10%, 18%, and 24%. Thoroughly explain the reasons behind the selections, and determine if the crossover rate and internal rates of return are relevant to the selections. b. C. a. i. ii. Assume that the projects are mutually exclusive. Determine which project(s) should be selected for cost of capital (,) figures equal to 10%, 18%, and 24%. Thoroughly explain the reasons behind the selections, and determine if the crossover rate and internal rates of return are relevant to the selections. b. Perform a sensitivity analysis of revenue 6. C. a. b. C. d. e. i. f. ii. iii. d. In light of the analysis performed on these projects, select the better project and make a specific recommendation. Thoroughly explain why the project chosen is a more appropriate choice than the other project. Support the selection made with the relevant results of your calculations and analysis. Submit the following in electronic form as a single compiled PDF: The extended memorandum. Each incremental cash flow analysis worksheet. The NPV analysis with the given range of cost of capital. The results of the sensitivity analysis. The annotated NPV profile. The Grammarly summary page showing a rating of 90% or better for your written work. Perform a sensitivity analysis of the salvage value For projects 1 and 2, increase the projected salvage value in year 5 by 8% and assume that everything else remains the same. For a cost of capital (k) of 12%, determine the new NPV for both projects and the percentage changes the NPVs experienced relative to the base cases. Briefly discuss implications. For projects 1 and 2, decrease the projected salvage value in year 5 by 8% and assume that everything else remains the same. For a cost of capital (k,,) of 12%, determine the new NPV for both projects and the percentage changes the NPVs experienced relative to the base cases. Briefly discuss the implications. i. ii. For projects 1 and 2, increase projected revenue in year one by 8% and assume that everything else remains the same. For a cost of capital (ks) of 12%, determine the new NPV for both projects and the percentage changes the NPVs experienced relative to the base cases. Briefly discuss the implications. For projects 1 and 2, decrease projected revenue in year one by 8% and assume that everything else remains the same. For a cost of capital (k,,) of 12%, determine the new NPV for both projects and the percentage changes the NPVs experienced relative to the base cases. Briefly discuss the implications. Present your findings in a table showing the NPVs and the percentage changes relative to the base case. iii. Present your findings in a table showing the NPVs and the percentage changes relative to the base case.
Expert Answer:
Answer rating: 100% (QA)
Solution Lets calculate the incremental cash flows for each project Project 1 Initial investment 230000 40000 270000 Incremental revenue in year 1 98000 Incremental cost savings in year 1 40000 Increm... View the full answer
Related Book For
Foundations of Financial Management
ISBN: 978-1259024979
10th Canadian edition
Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen, Doug Short, Michael Perretta
Posted Date:
Students also viewed these operating system questions
-
The coming year is expected to be a good one with probability 0.70. Given that it is a good year, you expect that a dividend will be declared with probability 0.90. However, if it is not a good year,...
-
The PW value for an alternative is expected to be one of two values based on bids from two vendors. Your office partner told you that the low bid is $3200 per year. If she indicates a chance of 70%...
-
The real risk-free rate is 3%. Inflation is expected to be 2% this year and 4% during the next 2 years. Assume that the maturity risk premium is zero. What is the yield on 2-year Treasury securities?...
-
Describe the graphs of the equation. x 2 + y 2 3
-
Use the Gagnon, Inc., balance sheet data on the following page. Company Acid-Test Ratio Horner, Inc. (Utility).............................................. 0.73 Isaacson Company (Department...
-
Explain the components in Figure 1-17. FIGURE 1-17 Microsoft Access Compononte of a Microsoft Access Databasa System Form-Processing Application Data Entry Forms Report-Gonorator Application Reports...
-
Nancy Carpenter Optical Dispensary purchased supplies on account for \($1,200\). Two weeks later, the business paid half on account. Requirements 1. Journalize the two transactions for Nancy...
-
Bigelow Corporation has total assets of $850,000, sales of $1,350,000, and one class of common stock with 375 shareholders, and a class of preferred stock with 250 shareholders, both of which are...
-
Code Workstation Key Task No. C1 SA3 Stator assembly 1. Determine the number of workers required and the corresponding task assignment for achieving a production rate of 650 units per shift in case...
-
A man in hauling a box of mass 100 kg up a 35 degree incline by a rope attached to the top of the box. If the rope makes an angle of 20 degrees to the incline, and the man is pulling with a net force...
-
12. The fastest growing sector of higher education in Texas is the University of Texas at Austin. O community colleges. four-year universities. Oprivate religious colleges and universities.
-
The CEO has a salary of $100,000 per year. At year 1, she was also awarded 10,000 options at the strike price of $50 per share. Each option allows her to buy one share of the company's stock. At the...
-
Draw the shear and moment diagram for the uniformly loaded beam. Sketch the deflected shape and find the inflection point. Consider C is pin and B is a roller support. A w = 6 kips/ft A A + y Problem...
-
Organizations today use information systems for several purposes. How will you use the internet and specific resources like SBA.GOV & SCORE.ORG as well as websites devoted to your type of business?...
-
Execute: Fetch: 3. Store AC to device 6. Execute G Memory 300 301 302 N 940 3005 5940 7006 volo Memory 300 301 302 3005 5940 7006 940 000 Memory 300 301 302 3005 5940 7006 940 00/2 CPU Registers PC...
-
Assume the prices of product X and Y are $1.50 and $1.00, respectively, and that Mr. Chen has $24 to spend. Assume a normal indifference curve. Assume that Mr. Chen needs 4 of product X to maximize...
-
Study the pictures/images below. Obviously these was focus on LT sociology, anthropology and poltical science. Try to do some analysis by finding clues that are synonymous with the main concepts....
-
Bill Board must choose between two bonds: Bond A pays $90 annual interest with semiannual payment and has a market value of $850. It has 10 years to maturity. Bond B pays $80 annual interest with...
-
Millennium Bonds were sold in 2010 with a 10 percent, 25-year maturity, $1,000 par value, and a floating- rate covenant. If rates on similar risk bonds are currently (2016) yielding 7 percent, what...
-
David's Magic Stores has an operating profit of $210,000. Interest expense for the year was $30,000; preferred dividends paid were $24, 700; and common dividends paid were $36,000. The tax was...
-
Which client personnel normally sign the representation letter to the auditor?
-
List and explain nine types of representations that may be obtained from management.
-
An auditor compares \(19 \times 5\) revenues and expenses with those of the prior year and investigates all changes exceeding 10 percent. By this procedure, the auditor would be most likely to learn...
Study smarter with the SolutionInn App