Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

Capital Budgeting Case

Profit Oil Company, INC.

Background:

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

A five-year project has an initial fixed asset investment

A five-year project has an initial fixed asset investment of $260,000, an initial NWC investment of $20,000, and an annual OCF of -$19,000. The fixed asset is fully depreciated over the life of the project and has no sal ...

You are reviewing your targets for short-term cash reserves

You are reviewing your targets for short-term cash reserves next year. You wish to carry at least twenty days cash on hand. If annual budgeted cash expenses are $48,000,000, what amount of short-term cash reserves should ...

Explain why end users who conduct their risk management

Explain why end users, who conduct their risk management operations in the treasury department, should not require the treasury department to be a profit center ? Distinguish the typical objectives of a dealer engaging i ...

1 when are correlational research designs used in

1. When are correlational research designs used in behavioral research? What are their advantages and disadvantages? 2. What are a linear relationship and a curvilinear relationship? What does it mean if two variables ar ...

1 describe how structural equations modeling works2

1. Describe how structural equations modeling works. 2. Distinguish between latent variable modeling and path analysis as types of structural equations modeling.

Budgetary process1 why is an audit considered to be the

Budgetary process 1. Why is an audit considered to be the final phase of a budgetary process? 2. What organizations undertake governmental program evaluations, and why do they do it? 3. Are program evaluations more likel ...

1 what is the difference between global remuneration and

1. What is the difference between global remuneration and international assignment compensation? 2. What are the major issues related to the effectiveness of global remuneration plans? 3. How are equity compensation plan ...

Discounted payback timeline manufacturing co management is

Discounted payback: Timeline Manufacturing Co. management is evaluating two projects. The company uses payback criteria of three years or less. Project A has a cost of $1,912,855, and project B's cost is $1,875,000. Cash ...

How does the value of an unlevered firm change if it takes

How does the value of an unlevered firm change if it takes on debt in the presence of corporate taxes? Repeat the analysis for ANF from the previous problem, after relaxing only the "no corporate tax" assumption of perfe ...

1 what types of fees and conditions are prohibited under

1. What types of fees and conditions are prohibited under RESPA? 2. For what items may a lender require escrow accounts from a borrower?

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen