Question

Howell Petroleum Inc is trying to evaluate a generation project with the following cash flows: Year     ...

Howell Petroleum Inc is trying to evaluate a generation project with the following cash flows:

Year      Cash Flow

0           -39,000,000

1           57,000,000

2         -9,000,000

a) If the company requires a return of 10% on its investments, should it accept this project? Why?

b) Compute the IRR for this project. How many IRR's are there? If you apply the IRR decision rule, should you accept the project or not? Whats going on here?

I'd like to solve this problem in excel.

Thank you!

Homework Answers

Answer #1

IRR is being calculated as in below:

IRR Formula in Excel is = IRR(Values, Guess)

IRR Formula is calculated as =[Cash Flows/ (1+r)^i ] - Initial Investment

a) Yes the company is getting 28% as IRR return which is more than 10% of it's expected, so the company should accept this project since it's giving more than required expected return.

b) Computation is solved as in the above screenshot. IRR is 28%. There are three IRR's there with one positive cash flow preceded and followed by two negative cash flows. If a project has a non-normal cash flow, it can have multiple IRRs. This project has two IRR's. Project should be accepted as the IRR is positive.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Cutler Petroleum, Inc., is trying to evaluate a generation project with the following cash flows: Year...
Cutler Petroleum, Inc., is trying to evaluate a generation project with the following cash flows: Year Cash Flow 0 –$ 85,000,000 1 125,000,000 2 – 15,000,000 A. If the company requires a 10% return on its investment should it accept this project? Why? b.Compare the project IRR for this project. How many IRRs are there? If you should apply the IRR division rule. Should you accept the project or not.? What's going on here?
Kong Petroleum, Inc. is trying to evaluate a generator project with the following cash flows: Year...
Kong Petroleum, Inc. is trying to evaluate a generator project with the following cash flows: Year Cash Flow 0 -28,000,000 1 53,000,000 2 -8,000,000 If the company requires a 10% return on its investments, should it accept this project? Why? Compute the IRR for this project. How many IRRs are there? If you apply the IRR decision rule, should you accept the project or not? What’s going on here? *Please type the calculations and answers*
Howell Petroleum, Inc., is trying to evaluate a generation project with the following cash flows: Year...
Howell Petroleum, Inc., is trying to evaluate a generation project with the following cash flows: Year Cash Flow 0 –$38,000,000      1 56,000,000      2 –9,000,000      a. If the company requires a 10 percent return 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. (A negative answer should be indicated by a minus sign. Enter your...
Howell Petroleum, Inc., is trying to evaluate a generation project with the following cash flows:   ...
Howell Petroleum, Inc., is trying to evaluate a generation project with the following cash flows:    Year Cash Flow 0 –$ 43,000,000 1 67,500,000 2 – 18,000,000    a. If the company requires a return of 11 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.)    NPV            $    b. Compute the IRRs for this project. (Do not round intermediate calculations and...
Light Sweet Petroleum, Inc., is trying to evaluate an exploration project with the following cash flows:...
Light Sweet Petroleum, Inc., is trying to evaluate an exploration project with the following cash flows: Year Cash Flow 0 -$39,000,000 1 63,000,000 2 -12,000,000 If the company requires a 12 percent return on its investments, should it accept this project? Yes, the IRR is below the 12% hurdle rate No, the IRR is above the 12% hurdle rate Cannot determine because there are multiple IRRs Yes, the NPV is positive No, the NPV is negative
Light Sweet Petroleum, Inc., is trying to evaluate a generation project with the following cash flows:...
Light Sweet Petroleum, Inc., is trying to evaluate a generation project with the following cash flows:    Year Cash Flow 0 –$ 38,200,000 1 62,200,000 2 – 11,200,000    a-1 What is the NPV for the project if the company requires a return of 12 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)       a-2 Should the company accept this project? Yes No    b. This project has two IRR's, namely...
light Sweet Petroleum Inc, is trying to evaluate a generation project with the following cash flows....
light Sweet 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 project. Year 0 $ 46,000,000 Year 1 $ 71,000,000 Year 2 $ (15,000,000) Required return 12% Use a "guess" of .99 to calculate the higher IRR and -.99 to calculate the lower IRR
Cutler Petroleum, Inc., is trying to evaluate a generation project with the following cash flows: Year...
Cutler Petroleum, Inc., is trying to evaluate a generation project with the following cash flows: Year Cash Flow 0 –$ 38,800,000 1 62,800,000 2 – 11,800,000 a-1 What is the NPV for the project if the company requires a return of 12 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV $ a-2 Should the firm accept this project? No Yes b. This project has two IRRs, namely percent and percent, in...
Bohrer Mining, Inc., is trying to evaluate a project with the following cash flows: Year Cash...
Bohrer Mining, Inc., is trying to evaluate a project with the following cash flows: Year Cash Flow 0 -$38,100,000 1 62,100,000 2 -11,100,000 a-1 What is the NPV for the project if the company requires a return of 10 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) a-2 Should the firm accept this project? b. This project has two IRRs, namely ____?____ percent and ____?____ percent, in order from smallest to largest....
You have been asked to evaluate the following project: Your insurance company will receive cash flows...
You have been asked to evaluate the following project: Your insurance company will receive cash flows of $2.5 million/year for 5 years. In return, you will make a payment of $16 million in 9 years. a. What is the IRR of this project? b. Assuming an 8% discount rate, does the IRR rule tell you to accept or reject this project? c. What is the NPV of this investment?