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
-
Because of the downturn in the states economy, the mayor of Stratton thinks that uncollectible taxes are likely to increase from 5 percent of total tax bills to 10 percent in the coming fiscal year....
-
Use cylindrical coordinates to find the volume of the region bounded below by the plane z = 1 and above by the sphere x 2 + y 2 + z 2 = 4.
-
Show that the constant \(M\) in (21.18) can be chosen in the following way: \[M^{2} \geqslant 2 L^{2}+2 \sum_{j=1}^{n} \sup _{t \leqslant T}\left|b_{j}(t, 0) ight|^{2}+2 \sum_{j=1}^{n} \sum_{k=1}^{d}...
-
Albertsen Corporation is considering proposals for either leasing or purchasing aircraft. The proposed lease agreement involves a twin-engine turboprop Viking that has a fair value of $1,000,000....
-
The student will reflect on the specific case study about a business, company, facility, or process, existing or planned, with controversial environmental/social impacts impinging on sustainability....
-
Ashton and Melody Webb are a married couple in their mid-20s. Ashton has a good start as an electrical engineer and Melody works as a sales representative. Since their marriage four years ago, Ashton...
-
If the data have a mean of 4, median 4 and standard deviation 2, then they are: O a. Skewed to the left O b. parallel. O c. Skewed to the right O d. Symmetrical
-
Distinguish between capital and revenue expenditure and state whether the following statements are items of capital or revenue expenditure : (a) Expenditure incurred on repairs and whitewashing at...
-
What is meant by a statement of affairs? How can the profit or loss of a trader be ascertained with the help of a statement of affairs?
-
Distinguish between a ready-to-use and tailored accounting software.
-
Mr. Arnav does not keep proper records of his business he provided following information, you are required to prepare a statement showing the profit or loss for the year. Capital at the beginning of...
-
Calculate the amount of bills receivable during the year. Opening balance of bills receivable Bill dishonoured Bills collected (honoured) Bills receivable endorsed to creditors Closing balance of...
-
Show that if the iterated series |ail i=1 j=1 converges (meaning that for each fixed i EN the series = |aj| converges to some real number bi, and the series Ei bi converges as well), then the...
-
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...
-
How much of a $100 tax would a consumer pay if elasticity of demand is 0.2 and elasticity of supply is 1.8?
-
The Pure Food and Drug Act of 1906 is known as Dr. Wileys Law. It is generally regarded by non-economic historians as representing the triumph of consumer interests over producer interests. a. Why...
-
The elasticity of the supply of labor in part determines who bears the burden of Social Security taxes. Those taxes are typically levied in matching 6.2 percent shares on workers wages and wages paid...
Study smarter with the SolutionInn App