Dynamic Oil Field Economic Modeler -
Budget: $50 – $0 USD
Looking for a economic modeler, based in Europe, Latin America or Canada.
I need a dynamic, fully-linked economic model that captures the entire life cycle of an oil field developed under a Production Sharing Agreement fiscal regime. The workbook has to cover exploration and drilling outlays, facilities development and day-to-day production and operating costs, and eventual decommissioning expenses so I can see the complete cash picture.
The model needs to calculate all key economic evaluation metrics, NPV of course, but also IRR, payback, field-level breakeven price per barrel, government take, and any other profitability indicators you consider standard for PSA analysis. I already have a portion of the price decks, production profiles, and cost curves; you will help sanity-check those inputs and fill the remaining gaps with reasonable, well-sourced assumptions that can be toggled easily for sensitivity runs.
Because PSA terms can be intricate, the structure must separate cost-recovery barrels, profit-oil splits, royalties, and tax layers so each can be flexed independently. Cash flow statements should consolidate back to yearly and project-life summaries, with clear timing of capital expenditures and abandonment funds.
Deliverables
• An unlocked Excel model with clearly labeled input, calculation, and output tabs
• A summary dashboard that instantly reports NPV (priority), IRR, payback, breakeven price, and contractor vs. state cash flows
• Scenario analysis capability
• A brief write-up of assumptions, sources, and instructions for updating the model in future
I need a dynamic, fully-linked economic model that captures the entire life cycle of an oil field developed under a Production Sharing Agreement fiscal regime. The workbook has to cover exploration and drilling outlays, facilities development and day-to-day production and operating costs, and eventual decommissioning expenses so I can see the complete cash picture.
The model needs to calculate all key economic evaluation metrics, NPV of course, but also IRR, payback, field-level breakeven price per barrel, government take, and any other profitability indicators you consider standard for PSA analysis. I already have a portion of the price decks, production profiles, and cost curves; you will help sanity-check those inputs and fill the remaining gaps with reasonable, well-sourced assumptions that can be toggled easily for sensitivity runs.
Because PSA terms can be intricate, the structure must separate cost-recovery barrels, profit-oil splits, royalties, and tax layers so each can be flexed independently. Cash flow statements should consolidate back to yearly and project-life summaries, with clear timing of capital expenditures and abandonment funds.
Deliverables
• An unlocked Excel model with clearly labeled input, calculation, and output tabs
• A summary dashboard that instantly reports NPV (priority), IRR, payback, breakeven price, and contractor vs. state cash flows
• Scenario analysis capability
• A brief write-up of assumptions, sources, and instructions for updating the model in future