Buckner Company is considering two capital investments. Both investments have an initial cost of $10,000,000 and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Buckner Company is considering two capital investments. Both investments have an initial cost of $10,000,000 and total net cash inflows of $17,000,000 over 10 years. Buckner requires a 12% rate of return on this type of investment. Expected net cash inflows are as follows: (Click the icon to view the expected net cash inflows.) Read the requirements. Data table Year Plan Alpha Requirement 1. Use Excel to compute the NPV and IRR of the two plans. Which plan, if any, should the company pursue? (Use parentheses or a minus sign for a negative NPV. Rou decimal places, X.XX%.) Year 1 $ 1,700,000 $ Plan Beta 1,700,000 calculations to two Year 2 1,700,000 2,300,000 The NPV (net present value) of Plan Alpha is Year 3 1,700,000 2,900,000 Year 4 1,700,000 2,300,000 The NPV (net present value) of Plan Beta is The IRR (internal rate of return) of Plan Alpha is %. The IRR (internal rate of return) of Plan Beta is %. Which plan, if any, should the company pursue? Year 5 1,700,000 1,700,000 Year 6 1,700,000 1,600,000 Year 7 1,700,000 1,200,000 Year 8 1,700,000 800,000 Year 9 1,700,000 400,000 1,700,000 2,100,000 Year 10 because the NPV is and the IRR is the company's required rate of return. $ 17,000,000 $ 17,000,000 Total Based on the results above, the company should pursue Requirement 2. Explain the relationship between NPV and IRR. Based on this relationship and the company's required rate of return, are your answers as expected in Requirement Thus, if an investment's net present value is p The internal rate of return is the interest rate that makes the net present value of an investment present value is negative, the internal rate of return is the required rate of return. te of return and if the net Print Done as expected. For Plan Alpha, the net present value is and the internal rate of return is the required Based on this relationship and the company's required rate of return, are your answers as expected in Requirement 1? Why or why not? Based on the relationship described above, the internal rate of return and net present value calculated in Requirement 1 for the two plans rate of return. For Plan Beta, the net present value is and the internal rate of return is the required rate of return. Requirement 3. After further negotiating, the company can now invest with an initial cost of $9,500,000 for both plans. Recalculate the NPV and IRR. Which plan, if any, should the company pursue? (Use Excel to determine your answers. Use parentheses or a minus sign for a negative NPV. Round the NPV calculations to the nearest whole dollar and the IRR calculations to two decimal places, X.XX%.) The NPV (net present value) of Plan Alpha is $ Buckner Company is considering two capital investments. Both investments have an initial cost of $10,000,000 and total net cash inflows of $17,000,000 over 10 years. Buckner requires a 12% rate of return on this type of investment. Expected net cash inflows are as follows: (Click the icon to view the expected net cash inflows.) Read the requirements. Data table Year Plan Alpha Requirement 1. Use Excel to compute the NPV and IRR of the two plans. Which plan, if any, should the company pursue? (Use parentheses or a minus sign for a negative NPV. Rou decimal places, X.XX%.) Year 1 $ 1,700,000 $ Plan Beta 1,700,000 calculations to two Year 2 1,700,000 2,300,000 The NPV (net present value) of Plan Alpha is Year 3 1,700,000 2,900,000 Year 4 1,700,000 2,300,000 The NPV (net present value) of Plan Beta is The IRR (internal rate of return) of Plan Alpha is %. The IRR (internal rate of return) of Plan Beta is %. Which plan, if any, should the company pursue? Year 5 1,700,000 1,700,000 Year 6 1,700,000 1,600,000 Year 7 1,700,000 1,200,000 Year 8 1,700,000 800,000 Year 9 1,700,000 400,000 1,700,000 2,100,000 Year 10 because the NPV is and the IRR is the company's required rate of return. $ 17,000,000 $ 17,000,000 Total Based on the results above, the company should pursue Requirement 2. Explain the relationship between NPV and IRR. Based on this relationship and the company's required rate of return, are your answers as expected in Requirement Thus, if an investment's net present value is p The internal rate of return is the interest rate that makes the net present value of an investment present value is negative, the internal rate of return is the required rate of return. te of return and if the net Print Done as expected. For Plan Alpha, the net present value is and the internal rate of return is the required Based on this relationship and the company's required rate of return, are your answers as expected in Requirement 1? Why or why not? Based on the relationship described above, the internal rate of return and net present value calculated in Requirement 1 for the two plans rate of return. For Plan Beta, the net present value is and the internal rate of return is the required rate of return. Requirement 3. After further negotiating, the company can now invest with an initial cost of $9,500,000 for both plans. Recalculate the NPV and IRR. Which plan, if any, should the company pursue? (Use Excel to determine your answers. Use parentheses or a minus sign for a negative NPV. Round the NPV calculations to the nearest whole dollar and the IRR calculations to two decimal places, X.XX%.) The NPV (net present value) of Plan Alpha is $
Expert Answer:
Related Book For
Horngrens Accounting
ISBN: 978-0134674681
12th edition
Authors: Tracie L. Miller nobles, Brenda L. Mattison, Ella Mae Matsumura
Posted Date:
Students also viewed these accounting questions
-
How is compensation for services provided by an owner reported? Choose the option that accurately describes what is required for the situation as described. Jamil, a partner in ABC, will receive Form...
-
Hayes Company is considering two capital investments. Both investments have an initial cost of $10,000,000 and total net cash inflows of $17,000,000 over 10 years. Hayes requires a 12% rate of return...
-
1. List five line coding schemes discussed in this book. 2. Define block coding and give its purpose. 3. Define scrambling and give its purpose. 4. Compare and contrast PCM and DM 5. What are the...
-
Define and give an example of the meaning of the following concepts and terms: a. Tax planning b. Fact c. Conclusion d. Relevant fact e. Primary source f. Secondary source g. IRC h. Reference service...
-
What is the expectation for the \(\$ 1\) bets in Problems 21-30 on a U.S. roulette wheel? See Figure 13.8 Four-number bet 4 16 33 1 20 14 31 9 22 18 29 28 12 35 3 26 0 32 15 19 4 21 2 25: 4 21 2 25...
-
You are watching a race while sitting on a bench. An athlete speeds up from 0 to \(7 \mathrm{~m} / \mathrm{s}\) to the right. Describe his motion from the point of view of another athlete going at...
-
The following are six observations collected from treatment 1, four observations collected from treatment 2, and five observations collected from treatment 3. Test the hypothesis at the .05...
-
19.A radioactive -emission. A detector records n -particles in 2s and by next 2s (accumulatively) it records 1.1 n -particle. Number of -particles recorded by detector after a long time, is (1) 11n...
-
Answer the following two independent cases: Case (1) (2.5 pts: pt. for each entry): The sub governmental unit received postal orders for L.L 20,000,000 classified as follow: L.L. 6,000,000 fees...
-
Who are the Detectives? What they have recounted spending on average and what percentage of their day with reports?
-
What critiques have been raised against traditional models of social stratification, particularly regarding their adequacy in capturing the complexities of contemporary forms of inequality and the...
-
Explore the contractual requirements of a project for Hotel, costs, times, qualities, risks, contractual obligations of the client?
-
Lisa is a self-employed architect who also is a partner in a successful architectural firm. She receives a substantial part of her income from her partnership interest, which is a pass-through...
-
You are an auditor reviewing the investments of a company that uses the cost method. The company holds stock in several firms, one of which has declared bankruptcy. How would this event affect your...
-
Write a brief note on Nissan Case study in which you address the following: 1. Theories and Techniques Explain the five steps of the theory of constraints (TOC) process. To what processes might the...
-
Akramin just graduated with a Master of Engineering in Manufacturing Engineering and landed a new job in Melaka with a starting salary of RM 4,000 per month. There are a number of things that he...
-
What are the six books of original entry?
-
Show the journal entries necessary to record the following items: 2017 Apr 1 Bought office furniture on credit from Durham Brothers Ltd 1,400. 4 We take goods costing 270 out of the business...
-
You are to open the books of F. Polk, a trader, via the journal to record the assets and liabilities, and are then to record the dialy transactions for the month of May. A trial balance is to be...
Study smarter with the SolutionInn App