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 = –$38,000,000

1 = $62,000,000

2 = – $11,000,000

a-1. What is the NPV for the project if the company requires a return of 11 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? Yes or No

b. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)

This project has two IRR's, namely _______ percent and ________ percent, in order from smallest to largest.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

NPV=C0+ CF1/(1+r)^1 + CF2/(1+r)^2 …………CFn/(1+r)^n

=-38000000+ 62000000/1.11 – 11000000/1.11^2

=$8,928,009

Yes the project should be accepted since NPV is positive.

IRRs are: 42.9% and -79.74%

WORKINGS

Sign in Book1 - Excel 《Product Activation Failed) AutoSave Share Tell me what you want to do File Insert Draw Page Layout Formulas Data Review View Help Home Wrap Text General 田FF Calibri Conditional Fornat as Cell Insert Delete Fornat FormattingTable Styles- 、. Sort & Find & Editing : 호 들經垣@werge & Center-5 . % , Filter Select Paste u . 녀 . 2.A Number Styles Cells Alignment Clipboard B7 CF Year 0 38000000 62000000 11000000 IRR IRR IRR(C3:C5) -RR($CS3:SCS 5,-70%) 10 12 13 14 16 17 Sheet1 Shet2 + 100 Ready C ENG 4:08 AM

Add a comment
Know the answer?
Add Answer to:
Howell Petroleum, Inc., is trying to evaluate a generation project with the following cash flows: Year...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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 0 1 2 Cash Flow 538,400,000 62,400,000 - 11,400,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.) NPV 9. Should the firm accept this project? O No Yes b. (A negative answer should be indicated by a minus sign. Do...

  • 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,600,000 1 63,600,000 2 – 12,600,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 firm accept this project? No Yes    b. (A negative answer should be indicated by a minus...

  • Problem 5-13 Problems with IRR Howell Petroleum, Inc., is trying to evaluate a generation project with...

    Problem 5-13 Problems with IRR Howell Petroleum, Inc., is trying to evaluate a generation project with the following cash flows: Year 0 1 2 Cash Flow 39,500,000 63,500,000 - 12,500,000 a-1. What is the NPV for the project if the company requires a return of 11 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV Should the firm accept this project? Ο Νο Yes b. (A negative answer should be indicated by...

  • 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...

  • 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 -$48,000,000 71,000,000 -13,000,000 1 2 a-1. What is the NPV for the project if the company requires a 12 percent return? (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? Yes No This project has two IRR's, namely b. percent, in order percent and from smallest to...

  • Howell Petroleum, Inc., is trying to evaluate a generation project with the following cash flows: Year Cash Flow -$38,0...

    Howell Petroleum, Inc., is trying to evaluate a generation project with the following cash flows: Year Cash Flow -$38,000,000 O - 56,000,000 -9,000,000 N 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 answers from lowest...

  • 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 -$40,000,000 0 61,500,000 -15,000,000 2. If the company requires a return of 10 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...

  • 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...

  • 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 -$40,000,000 61,500,000 -15,000,000 2 a. If the company requires a return of 10 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...

  • 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 -$40,000,000 O EN 61,500,000 -15,000,000 a. If the company requires a return of 10 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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT