Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need this assignment done in Crystal Ball Simulation. Need also done in Tornado Diagram and Sensitivity chart ConocoPhillips Natural Gas Wellhead Project Given Price

I need this assignment done in Crystal Ball Simulation. Need also done in Tornado Diagram and Sensitivity chart

ConocoPhillips Natural Gas Wellhead Project
Given
Price $1,200,000.00
ConocoPhillips's Cost of Capital for project 15.00%
Project life 10 years
Solution
1. Years
0 1 2 3 4 5 6 7 8 9 10
Investment
Increase in NWC
MACRS Depr Rate (7 year) 0.1429 0.2449 0.1749 0.1249 0.0893 0.0893 0.0893 0.0445
Natural Gas Wellhead Price (per MCF)
Volume (MCF/day)
Days per year
Fee to Producer of Natural Gas
Compression & processing costs (per MCF)
Cash Flow Calculations
Natural Gas Wellhead Price Revenue
Lease fee expense
Compression & processing costs
Depreciation expense
Net operating Profit
Less: Taxes (40%)
Net operating profit after tax (NOPAT)
Plus: Depreciation expense
Return of net working capital
Project Free Cash Flow
NPV
IRR

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance And Sustainability

Authors: Karolina Daszyńska-Żygadło, Agnieszka Bem, Bożena Ryszawska, Erika Jáki, Taťána Hajdíková

1st Edition

3030344037, 978-3030344030

More Books

Students also viewed these Finance questions