Ask Question, Ask an Expert


Ask Basic Finance Expert

Capital Budgeting Case

Profit Oil Company, INC.


Petroleum Rig Operations Financed in Texas Inc, henceforth referred to as PROFIT is a regional oil exploration company headquartered in the Houston, TX. It is a conservative rationalized corporation solely owned and operated by the Johnnie Walker (JW) Harrison. He goes by JW to avoid focusing on his given name in the social settings. JW has been in the oil extraction business for over 25 years and has seen both good times and bad.

JW did 2012 extensive geotechnical and seismic testing at a cost of $2,000,000 in a newly opened lease area in Gulf of Mexico. He would have acquired these costs whether or not he proceeded with the project. These evaluations indicated, but didn’t guarantee, that a drilling venture in this area could be successful. He is extremely strong on the engineering side of the oil business but desperately requires your financial acumen to advise him with this substantial investment compensating him for his wildcat reputation.

Facts & Data:

The extraction time (project life) when oil can no longer be economically recovered is estimated to be ten (10) years. Capital investment costs, revenues, and expenses, are significant and consist of the subsequent:

• Purchase of a jack-up oil rig able of standing 325ft of water and costing $29,500,000. A jack-up rig is a kind of mobile offshore oil and gas drilling platform which is moored on sea floor resting on a number of supporting legs. Most popular design uses 3 legs and can drill to depths of 25,000ft.

• Significant relocation costs of the rig from Costa Rica estimated $2,000,000

• Equipment necessary to bring to full operational status will be $2,500,000

• Tugs, helicopter, equipment, facilities for JW’s use estimated to be $1,000,000

• All of these assets will be fully depreciated on straight line basis over project life. However, JW expects that he will be capable to sell the rig for $7,500,000 in Year 10. There might be cash flow impact in year 10 due to the tax impact associated with the sale.

• Estimated that rig will make 1,000 barrels of oil/day and be in operation 325days

• Locked in a fixed sale price/barrel for 10yrs at $95/barrel

• Estimates the projects variable cost will be 35% of his yearly gross revenues

• Fixed Costs will be $7,500,000 per year. Corporate tax estimated to be 35%

Investment Criteria Established by Profit

• Internal Rate of Return (IRR) greater than his cost of capital which is 22%

• Positive Net Present Value (NPV) discounted at his cost of the capital

• Maximum payback of no more than the 5 years

JW needs answers to the subsequent problems based upon date and info given

1. What are his total investment costs in year 0 which will be capitalized and fully depreciated over 10 year drilling period?

2. What are the yearly cash flows associated with this ambitious venture for years 1-10.

3. What are projects approximate Payback?

4. What is Internal Rate of Return of the project?

5. What is Net Present Value of the project?

6. What is your suggestion to JW as to whether or not this project is viable financially and meets his investment criteria?

These answers constitute the “BASE-LINE” conclusions and suggestion

Do one change at a time and show your results for each. (Total investment costs, cash flows years 1-10, IRR, NPV, PB)

• A drop of 30 drilling days in operation for potential hurricane exposure

• An increase in variable cost percentage to 40% of Revenues

• A decrease in fixed costs by 10% ($750,000)

• An increase in sale price/barrel by 10% ($105)

• A change in his cost of capital to 25% to reflect potential risk increases

1) What is your base line recommendation to JW?

2) What are your suggestion to JW’s problems based upon these individual changes and where would you focus your analysis and why?

3) If you adjusted for ALL the changes in assumptions (Scenario analysis) above what would your results indicate? How would you advise JW?

IE: Make a grid summary of your conclusions on one page describeing impact on each change (Sensitivity Analysis) on the investment criteria established by JW.

If you adjusted for ALL the changes in assumptions (Scenario analysis) above what would your results indicate? How would you recommend JW?

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M91565

Have any Question? 

Related Questions in Basic Finance

M banking assignmentstudy guide for essay questions

Money Banking Assignment Study guide for essay questions. Compiled from questions your colleagues submitted. 1) What are the main functions of: a) the Federal Reserve (details of how the Fed performs its functions, prima ...

Ginger created an ilit and transferred a life insurance

Ginger created an ILIT and transferred a life insurance policy and rental property to the trust. She named her husband Alfred and her children the beneficiaries of the trust. The income from the property is sufficient to ...

You learn that your inheritance will allow you to receive

You learn that your inheritance will allow you to receive the amount of $5800 at the end of each year for a total of 12 consecutive years. However, because of your young age, these amounts will not begin until the end of ...

Assignmentwrite a 3- to 5-page essay about the ethical and

Assignment Write a 3- to 5-page essay about the ethical and financial implications of insider trading. Note: Some of the assessments in this course build upon each other, so you are strongly encouraged to complete them i ...

Finance assignmentcreate a 1050-word report and include the

Finance Assignment Create a 1,050-word report, and include the following: • Explain the relationship between risk and return • Identify an example of risk and return. • Explain which is more risky bonds or common stocks. ...

Explain the difference between path-dependent options and

Explain the difference between path-dependent options and path-independent options and give examples of each ? Give an example of a situation in which someone might wish to use a barrier option ? Explain the advantages a ...

1 what is the function of the optional delivery commitment2

1. What is the function of the optional delivery commitment? 2. Name five important characteristics of mortgage pools. Tell why each is important. 3. Why was the formation of FHLMC so important?

1 write the general form of a regression equation that has

1. Write the general form of a regression equation that has a single predictor variable. Identify the criterion variable, the predictor variable, the regression constant, and the regression coefficient. 2. A regression e ...

Consider a portfolio consisting of 10 million invested in

Consider a portfolio consisting of $10 million invested in the S&P 500, and $7.5 million invested in U.S. Treasury bonds. The S&P 500 has an expected return of 14 percent and a standard deviation of 16 percent. The Treas ...

Assignmentanswer questions-what are the two principal ways

Assignment Answer questions: -What are the two principal ways in which Congress and state legislatures exercise oversight of administrative agencies? -In what ways does the budgeting process lend itself to political cont ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro