I need a full understanding of how to solve for IRR through excel. Not just the answers
Fantastic news! We've Found the answer you've been seeking!
Question:
I need a full understanding of how to solve for IRR through excel. Not just the answers please.
Transcribed Image Text:
Hamilton Company is considering two capital investments. Both investments have an initial cost of $7,000,000 and total net cash inflows of $16,000,000 over 10 years. Hamilton requires a 20% 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 pl decimal places, X.XX%.) Year 1 $ 1,600,000 $ Plan Beta 1,600,000 the Year 2 1,600,000 2,200,000 The NPV (net present value) of Plan Alpha is $(292,045) Year 3 1,600,000 2,800,000 Year 4 1,600,000 2,200,000 The NPV (net present value) of Plan Beta is The IRR (internal rate of return) of Plan Alpha is $ 610,051 Year 5 1,600,000 1,600,000 Year 6 1,600,000 1,500,000 %. Year 7 1,600,000 1,300,000 Year 8 1,600,000 1,100,000 The IRR (internal rate of return) of Plan Beta is %. Year 9 1,600,000 1,600,000 900,000 800,000 Year 10 $ 16,000,000 $ 16,000,000 Total Print Done Requirements 1. Use Excel to compute the NPV and IRR of the two plans. Which plan, if any, should the company pursue? 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 1? Why or why not? 3. After further negotiating, the company can now invest with an initial cost of $6,500,000 for both plans. Recalculate the NPV and IRR. Which plan, if any, should the company pursue? Print Done IRR calculations to two Hamilton Company is considering two capital investments. Both investments have an initial cost of $7,000,000 and total net cash inflows of $16,000,000 over 10 years. Hamilton requires a 20% 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 pl decimal places, X.XX%.) Year 1 $ 1,600,000 $ Plan Beta 1,600,000 the Year 2 1,600,000 2,200,000 The NPV (net present value) of Plan Alpha is $(292,045) Year 3 1,600,000 2,800,000 Year 4 1,600,000 2,200,000 The NPV (net present value) of Plan Beta is The IRR (internal rate of return) of Plan Alpha is $ 610,051 Year 5 1,600,000 1,600,000 Year 6 1,600,000 1,500,000 %. Year 7 1,600,000 1,300,000 Year 8 1,600,000 1,100,000 The IRR (internal rate of return) of Plan Beta is %. Year 9 1,600,000 1,600,000 900,000 800,000 Year 10 $ 16,000,000 $ 16,000,000 Total Print Done Requirements 1. Use Excel to compute the NPV and IRR of the two plans. Which plan, if any, should the company pursue? 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 1? Why or why not? 3. After further negotiating, the company can now invest with an initial cost of $6,500,000 for both plans. Recalculate the NPV and IRR. Which plan, if any, should the company pursue? Print Done IRR calculations to two
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Technology guru Tim O'Reilly said this about the publishing industry: " To adapt, publishers need to cannibalize their own business, experimenting with new forms, new formats, and new business...
-
San Francisco Sea Salt's controller prepared the following cash flow statements (in thousands of dollars) for the past two years, the current year (2010), and the upcoming year (2011): After...
-
Find the following present values, using Table: a. $6,000 received 30 years from now, discounted at 10 percent. b. $4,000 to be received at the end of each of the next 10 years, discounted at 6...
-
A slurry of pure \(\mathrm{NaCl}\) crystals, \(\mathrm{NaCl}\) in solution, \(\mathrm{NaOH}\) in solution, and water is sent to a system of thickener(s) at a rate of \(100.0 \mathrm{~kg} /...
-
Colonel Sporting Goods is authorized to issue 18,000 shares of common stock . During a two-month period, Colonel completed these stock-issuance transactions: Apr 23 Issued 3,000 shares of $1.00 par...
-
3 8 2 0 ( 1 + 0 . 0 6 1 2 ) > 1 2 x
-
Alfie feels that he faces the following probability distributions of losses with respect to his wealth: Loss Amount ($) Probability 0 0.15 600 0.35 1,200 0.28 3,000 0.14 7,000 0.08 What is Alfies...
-
What are the key challenges that visionary leaders encounter when implementing strategic change initiatives, and how can they effectively manage resistance and drive successful transformation ?
-
What unique challenges do virtual or remote teams face in terms of conflict resolution, and how can technology be used to bridge gaps ?
-
How was QUAD formed and how is it different from BRICS? Are these political entities or economic trade agreements?
-
How can an organization classify a risk as "acceptable"? How is this implemented within your organization?
-
What opportunities and challenges arise from the use of technology platforms and virtual mediation tools in facilitating conflict resolution processes, particularly in distributed or remote work...
-
Case 1 A company has four legal claims outstanding, each for $109,000. There is a 10% chance that one claim will be paid out, a 10% chance that two will be paid out, a 5% chance for three, and a 5%...
-
What are the before image (BFIM) and after image (AFIM) of a data item? What is the difference between in-place updating and shadowing, with respect to their handling of BFIM and AFIM?
-
The following information is taken from the annual report of the Walgreens Boots Alliance, Inc..: Walgreens uses LIFO to value its inventory. Restate the companys financial results for 2015 assuming...
-
The following information is taken from the annual report of The Coca-Cola Company: Using this information, calculate the accounts payable turnover ratio and the days payable period for 2015 and...
-
The following information is taken from the annual report of The Claremont Corporation: The company uses the LIFO method to value its inventory. In addition, the footnotes to the companys annual...
Study smarter with the SolutionInn App