Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help on excel. thank you! 7. [20 points] Suppose Rice Energy wants to build a platform to extract oil in the Gulf of Mexico.

please help on excel. thank you!
image text in transcribed
image text in transcribed
7. [20 points] Suppose Rice Energy wants to build a platform to extract oil in the Gulf of Mexico. This will involve an initial investment of $4 billion (1 =0). The platform will start operations after one year (t = 1). It is expected to last for five years and have a salvage value at the end of the period of $640 million (1 =5). The platform will extract 100,000,000 crude oil barrels a year. The firm anticipates that in the first year the price of one oil barrel is $65, and thereafter the price is expected to increase by 4% a year. Raw materials to extract each barrel are forecasted to cost $18 in the first year and these costs are predicted to increase by 3% annually. Total labor costs for the platform are expected to be $1.1 billion in the first year and thereafter will increase by 7% a year. The permits to operate the platform cost $300 million a year payable at the beginning of each year. The discount rate for this type of project is 12%. Assume all cash flows occur at the end of each year except where otherwise stated. What is the NPV of the project? Should Rice Energy do the project? Why

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Health Care Finance

Authors: William O. Cleverley, James O. Cleverley

8th Edition

1284094634, 978-1284094633

More Books

Students also viewed these Finance questions

Question

3. Laugh at the right time for the right time.

Answered: 1 week ago