Dynamic Oil Field Economic Modeler -

min $50 USD / hour

Closed

Posted 7 days ago

min $50 USD / hour

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

Data Analysis

Data Visualization

Excel

Financial Forecasting

Project ID: 39728867

About the project

8 proposals

Remote project

Active 1 day ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

8 freelancers are bidding on average $53 USD/hour for this job

@AwaisChaudhry

Hello, I understand that you need a comprehensive economic model for an oil field under a Production Sharing Agreement fiscal regime. This model will include all phases from exploration to decommissioning, ensuring a complete view of cash flows involved. My approach will focus on developing a dynamic Excel workbook that captures essential metrics such as NPV, IRR, breakeven price per barrel, and government take, using your existing data and filling gaps with sound assumptions that allow for easy adjustments. I will ensure that the structure of the model distinctly separates cost-recovery barrels, profit-oil splits, and other fiscal elements, providing flexibility for sensitivity analysis. Deliverables will include an unlocked Excel model with user-friendly tabs, a dashboard for instant reporting of key metrics, and documentation for future updates. Could you share more details about the specific inputs and assumptions you have for the existing price decks and cost curves? Thanks, Muhammad Awais

$50 USD in 33 days

5.0

(4 reviews)

6.7

@mohamedahmedmoha

Having successfully provided financial modeling, budgeting, forecasting as well as project-based cost tracking for over 15 years, I am confident in my ability to produce the comprehensive financial model you're looking for. My extensive experience in handling large datasets and constructing dynamic financial models makes me well-suited for navigating the intricate terms of a Production Sharing Agreement (PSA). I understand the need for flexibility and feasibility in oil field economics, so you can be assured that my model will allow easy sensitivity analysis using well-sourced assumptions. I aim to offer comprehensive value and ensure a seamless continuity for your business which goes beyond just delivering your initial project needs but by also providing a brief write-up of assumptions, sources plus instructions on navigating the model in future. So why settle for less when you can have it all with me? Let's connect so I can bring clarity to your finances all throughout your oil field project!

$50 USD in 40 days