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

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!