Question

Need the 2ND IRR please!

Howell Petroleum, Inc., is trying to evaluate a generation project with the following cash flows: Year o Cash Flow -$39,500,000 60,500,000 -14,500,000 2 a. If the company requires a return of 8 percent on its investments, what is the NPV of the project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Compute the IRRs for this project. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. Enter the larger IRR in the first answer box and the smaller IRR in the second answer box. If you can only calculate one IRR, enter it in both boxes to receive partial credit. A negative answer should have a minus sign.) $ NPV Larger IRR Smaller IRR 4,087,105.62: 23.42%

Answer 1

Using excel formula to calculate the second IRR

		A
1	Year	Cash Flow
2	0	-39500000
3	1	60500000
4	2	-14500000	Guess Values
	Irr	-70.26%	-55%
	Excel formula	IRR(A2:A4,-55%)

Second smaller IRR =-70.26%