Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Healthcare Finance An Introduction To Accounting And Financial Management

Authors: Louis C. Gapenski

5th Edition

1567934250, 978-1567934250

More Books

Students also viewed these Finance questions

Question

Outline two major problems for psychogenic identity theory.

Answered: 1 week ago

Question

=+1. What is the brand's character or personality?

Answered: 1 week ago

Question

=+3. Who is the audience?

Answered: 1 week ago

Question

=+4. What do they (audience members) currently think?

Answered: 1 week ago