Question: The table below represents data for a certain oil field. Assume interest rate 12% . Calculate 1-NPV 2- ME 3-POT 4-DPI 5- IRR Time Year

The table below represents data for a certain oil field. Assume interest rate 12% . Calculate 1-NPV 2- ME 3-POT 4-DPI 5- IRR

Time Year Prod. Tax (SMM) 0 1 2 3 4 5 6 7 8 9 10 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Oil Prod (MSTB) 0 0 5505 10079 5524 2099 1020 1184 2211 2653 1976 Oil Price (S/STB) 50 50 50 50 50 50 50 50 50 50 50 Gas Prod. Gas Price (MMSCF) (S/MSCF) 0 3 0 3 3276 3 11934 3 13208 3 5848 3 2968 3 2031 3 2179 3 3469 3 4763 3 Capital Cost (SMM) 5.715 64.68 143.977 4.205 0 0 0 0 0 0 0 Operating Cost (SMM) 0 0 3.825 10.359 9.922 9.922 9.922 9.922 9.922 9.922 9.922 0 0 11.502 21.948 13 5 2.486 2.673 4.749 5.827 4.667 Time Year Prod. Tax (SMM) 0 1 2 3 4 5 6 7 8 9 10 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Oil Prod (MSTB) 0 0 5505 10079 5524 2099 1020 1184 2211 2653 1976 Oil Price (S/STB) 50 50 50 50 50 50 50 50 50 50 50 Gas Prod. Gas Price (MMSCF) (S/MSCF) 0 3 0 3 3276 3 11934 3 13208 3 5848 3 2968 3 2031 3 2179 3 3469 3 4763 3 Capital Cost (SMM) 5.715 64.68 143.977 4.205 0 0 0 0 0 0 0 Operating Cost (SMM) 0 0 3.825 10.359 9.922 9.922 9.922 9.922 9.922 9.922 9.922 0 0 11.502 21.948 13 5 2.486 2.673 4.749 5.827 4.667

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

What was the acquisition premium and what do you conclude from it regarding the fairness of the deal? What was the market reaction to the acquisition announcement and what do you conclude from it...

In the case "H. J. Heinz M&A" how can I financially analyze the company so I can come up with a recommendation at the end? What kind of financial analysis should I do? I attached below the case. I...

Alaska Oil Corporation Capital Budgeting Directed David Fay, Alaska Oil's financial vice president, is preparing a report for the monthly directors' meeting. An important issue is on the agenda, a...

I need your help with this: Can you please quote from the attached chapters / resource if possible? Corporations often use different costs of capital for different operating divisions. Using an...

Enter data into the FSAP (Financial Statement Analysis Package) Excel File.Enter the balance sheet and income statement amounts for 2012 for Exxon Mobile. Document And Entity Information (USD $) 12...

I am having trouble with the 2015 and 2016 statements balancing on the FSAP. Could you take a look at it and tell what is wrong and correct it? Financial Statement Analysis Package (FSAP) A Comment...

Please answer this question.. Very easy. -What sources of value most plausibly account for the differences between buyer and seller? -Structure and execute a discounted cash flow valuation of all of...

Ratio Analysis for ZCL Calculate the current ratio, quick ratio, net working capital, debt-to equity ratio, times-interest earned, financial leverage, asset turnover, Receivables Turnover, Average...

What behavioral sciences contribute to our understanding of OB?

Read the article An examination of the shift in school-level clustering of US adolescent electronic cigarette use and its multilevel correlates, 20112013 by Daniel J. Corsi, Adam M. Lippert and write...

1 0 . A dynamic random access memory ( DRAM ) factory can produce 1 0 0 , 0 0 0 chips per month at a unit cost of \ ( \ $ 4 . 0 0 \ ) . The current DRAM spot price is \ ( \ $ 5 . 5 0 \ ) . It can...

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".