Question

Jamaica Corp. is adding a new assembly line at a cost of $8.5 million. The firm expects the project to generate cash flows of $2 million, $3 million, $4 million, and $5 million over the next four years. Its cost of capital is 16 percent. What is the internal rate of return that Jamaica can earn on this project?

Answer 1

Answer:

IRR= 20%

Step-by-step explanation:

The Internal Rate of Return (IRR) tries to find the profitability of the money that remains invested during the life of a proyect. It is also known as the discount rate that makes the Net Present Value (NPV) equal to cero. When the NPV is equal to cero, then the proyect does not create or destroy value. So, if we calculate the NPV with the IRR we will find that it is equal to cero. In this case, if the cost of capital were 20% the proyect will not create or destroy value, but the problem is giving us a cost of capital that is less than 20%, then the proyect creates value. If we calculate the NPV with the rate of 16% it will be grater than zero.

The figure attached shows the IRR formula. But i calculated using Excel: first i put the cash flows of each year ( the first one is negative because it is an investment ). Then i used the formula: "=IRR(C4:C8)"