Question: Can you answer this question step by step on how to do the calculations in excel You are evaluating a project to build an oil

Can you answer this question step by step on how to do the calculations in excel

You are evaluating a project to build an oil pipeline in one of the emerging markets. Building the pipeline will take 8 annual investments, each of which is paid at the beginning of the year, starting immediately. The first of these investments is $20 million and the amount of the remaining 7 investments is expected to decrease by 3% per year. The pipeline will commence its operations in year 9 and will transport 3,500,000 barrels of oil per year in perpetuity. As the pipeline owner, you will collect an annual cash flow equal to 10% of the total value of transported oil, with cash flows occurring at the end of each year.

If the discount rate is 12%, what is the minimum price of oil per barrel under which the Profitability Index is 1.05? For simplicity, assume that oil prices are constant over time and that the costs of running the pipeline are negligible.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!