Develop a cash flow model using excel spreadsheets

Assignment Help Corporate Finance
Reference no: EM131486154

Assignment

PROJECT SCENARIO

You have been selected by Oil Company to study an interesting prospect - a sour gas reservoir in a foreign country (Jordan). The host government is proposing two alternative methods to develop the field (described below), with gas used in local power generation, but at present only limited data is available, primarily from one well test (currently waiting for the service company to provide the data) and other reservoirs in the same country. You need to supplement existing data by making engineering estimates as required.

Word documents about the following topics are attached:

a- Likely future product prices for gas and other products
b- Decommissioning techniques and costs for facilities after abandonment
c- Political and economic issues in Jordan
d- What new technology could be applied to improve recovery and/or economics

Try to link the information obtained in these reports to the project.

Carry out the following tasks:

a- Estimate the reserves and recoverable hydrocarbons for the reservoir. Attached is the Excel sheet for the data to be used.

b- Make a development plan for the reservoir (number of wells, timing, production etc.).

c- Develop a cash flow model using Excel spreadsheets.

d- Plan for the entire field to be decommissioned by plugging and abandoning wells and removing and scrapping all facilities or other more-economic option.

e- Compare the two development options proposed by the host government:

i. A special service contract where the operating or service company handles all costs and is paid a fixed price per unit of gas produced (with ownership of any oil or condensate produced being transferred to the host government).

ii. A concession contract in which all costs are handled by the operator, products are sold at market rates, and the government charges royalties and corporate tax.

f- Estimate financial parameters which management could use to compare your project with others.

g- Perform a risk analysis, including sensitivity studies using the cash flow model you have built, and use of other techniques to be presented in classes.

h- Write a report (minimum 2000 words) describing all the work done above, and making recommendations as to which if any development option is worthy of more detailed evaluation. You must take into account the findings of the attached word documents.

i- You will notice that there is no information concerning where the reservoir is located physically, other than the country. As I said you are at liberty to develop the scenario, so effectively you can chose whether it is offshore or onshore - but do make sure the whole team makes the same decision. Onshore will be cheaper, but you may find less information published about on-shore fields. Also, international partners are typically involved in developing more challenging reservoirs, such as offshore ones.

j- You have little in the way of constraints concerning how many wells to drill and when to drill them. However, you will have the reserves, and you should be able to work out how much gas one of your wells can produce over the project lifetime. This will allow you to put a cap on the number of wells you can drill - you should not plan a development that can produce more than the reserves!

k- You have little in the way of capital costs given, so you need to cost your facilities - based on the production volumes you are planning - hopefully based on costs for similar facilities you have found in the literature.

l- The same is true for abandonment and decommissioning costs. If you have found no analogue on which to base these costs, a simple rule of thumb is to assume the cost will be the same as the cost of all the capex used to set up the project - yes, it is expensive!

Attachment:- Attachments.rar

Reference no: EM131486154

Questions Cloud

Average waiting time before weighed for each week : determine the average number of trucks waiting, the average time spend at weigh station by each truck and average waiting time before weighed for each week
What do you think the future best practices might look like : What kind of professional development will the staff need to make this center a success? How might this improve services to those in need?
Describe a few security risks that databases : Describe a few security risks that databases must be protected against.
Changing the culture of the organization : Changing the culture of the organization can be one of the toughest tasks for a manager.
Develop a cash flow model using excel spreadsheets : Make a development plan for the reservoir (number of wells, timing, production etc.). Develop a cash flow model using Excel spreadsheets.
Discuss of situational factors in planning process : Discuss the importance of situational factors in the planning process and how leadership principles, metrics,
Provide a summary of the symptoms necessary to diagnose : Identify the differences between the criteria for assessing mild, moderate, or severe substance use disorder according to the DSM-5 .
Principles of web development : One HTML tag that I would like to discuss is the strong tag. This tag defines important text in the page, paragraph, or sentence.
Calculate the items requested : Based on the data provided here, calculate the items requested: a. The total annual operating cost of the motor vehicle.

Reviews

Write a Review

Corporate Finance Questions & Answers

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  Principles and tools for financial decision-making

Principles and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd