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