Question: I need the actual FORMULAS to solve these problems/questions and write out the formula in the yellow output area. Use column B and cells B6-B9.
I need the actual FORMULAS to solve these problems/questions and write out the formula in the yellow output area. Use column B and cells B6-B9. (see notes in RED) Use a guess of .99 to calculate the higher IRR and -.99 to calculate the lower IRR.

Howell Petroleum, Inc., is trying to evaluate a generation project with the following cash flows. If the company requires a return of 12 percent on its investments, what is the project's NPV? What are the IRRs for the 2 project? 3 4 Input area: 5 11 (Use cells A6 to B9 from the given information to complete this question. You must use the built-in Excel function to answer 12 this question. Use a "Guess" of .99 to calculate the higher IRR and -..99 to calculate the lower IRR.) Howell Petroleum, Inc., is trying to evaluate a generation project with the following cash flows. If the company requires a return of 12 percent on its investments, what is the project's NPV? What are the IRRs for the 2 project? 3 4 Input area: 5 11 (Use cells A6 to B9 from the given information to complete this question. You must use the built-in Excel function to answer 12 this question. Use a "Guess" of .99 to calculate the higher IRR and -..99 to calculate the lower IRR.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
