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
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
Get step-by-step solutions from verified subject matter experts
