Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started