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

Pretty lady cosmetic products has an average production

Pretty Lady Cosmetic Products has an average production process time of forty days. Finished goods are kept on hand for an average of fifteen days before they are sold. Accounts receivable are outstanding an average of t ...

Public finanace and budget apa formatusing your favorite

Public Finanace and budget/ apa format Using your favorite search engine, locate the federal budget and your state budget for the current fiscal year. Compare and contrast both budgets in an essay consisting of no less t ...

Why is it expected to be using higher discount rates to

Why is it expected to be using higher discount rates to discount stock dividend payments compared to the discount rates used to discount bond coupon payments?

Define default risk asymmetric information adverse

Define default risk, asymmetric information, adverse selection, moral hazard, interest rate risk, liquidity risk, and exchange rate risk.

The united states purchased alaska in 1867 for 72m where

The United States purchased Alaska in 1867 for $7.2M (where Mstands for million). Assume that federal tax revenue from the state of Alaska (net federal expenditures) is $55.1M in 2012 and that tax revenue started in 1868 ...

Topic water and real estatewrite a 1 page reviewcommentary

Topic: Water and Real Estate Write a 1 page review/commentary on an article from a magazine, newspaper, Wall Street Journal, etc. on the following topics. Due dates are listed below. This should be a news item and not fr ...

You invest 3000 a year for three years at 12 percenta what

You invest $3,000 a year for three years at 12 percent. a. What is the value of your investment after one year? Multiply $3,000 × 1.12. b. What is the value of your investment after two years? Multiply your answer to par ...

Please answer the following case questions in details in ms

Please answer the following case questions in details in MS - Word First Steps in the Globalization of the Yuan: Case Questions 1) How does the Chinese government limit the use of the Chinese currency, the RMB, on the gl ...

A firm is expected to pay a dividend of 355 next year and

A firm is expected to pay a dividend of $3.55 next year and $3.85 the following year. Financial analysts believe the stock will be at their price target of $120 in two years. Compute the value of this stock with a requir ...

Part aemu electronics is an electronics manufacturer

Part A Emu Electronics is an electronics manufacturer located in Box Hill, Victoria. The company's managing director is Shelly Chan, who inherited the company from her father. The company originally repaired radios and o ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate