Question: please solve this in excel and show equations 2002 0 2003 1 2004 2 2005 3 2006 4 G 2007 5 H 2008 6 55.00

please solve this in excel and show equations please solve this in excel and show equations 2002 0 2003 1

2002 0 2003 1 2004 2 2005 3 2006 4 G 2007 5 H 2008 6 55.00 30.00 10.00 45.00 85.00 75.00 2.00 90.00 75.00 20.00 55.00 15.00 10.00 5.00 2.00 Calendar Year Project Year Cash Flow from Investing Signature bonus Exploration & Predevelopment Upstream Development Pipeline/FSO/Export Total Investment Cash Flow from Operations Production (millions of bbls) Oil Price ($/bbl) Gross Revenue (millions of $) Unit Operating Cost ($/bbl) Total Operating Expense (millions of $) Net Operating Earnings Net (Free) Cash Flow de 0.57 20.00 6.109 20.00 .42 20.00 12.4 20.00 20.00 20.00 20.00 6.20 2.60 2.40 2.30 NPV (millions$, discount rate: 16.2%) IRR

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!