Step 1 of 2

Enter the project and bid inputs

Works for any production-enhancement or revenue-share bid. Yellow boxes are editable. The Gamij and Geleki example (ONGC SPEC 2026) is loaded to start with; replace it with your own project. Press Run analysis to open the dashboard.

Project

Project / tender name

Bidder (company)

Owner receiving the revenue share

Contract terms

from the tender document · apply to every field

Contract duration (years)1 to 25

Tender PV discount rate (%)

Tender net oil price (US$/bbl)

Tender net gas price (US$/MMBtu)

bbl per tonne of oil

bbl per m³ of oil

SCM of gas per MMBtu

Minimum incremental (% of baseline)Oil + oil-equivalent gas

Well commitment yearsWells checked in years 1 to N

Incentive above (% of quoted incr.)

Incentive uplift cap (%)

Penalty below (% of quoted incr.)

Shortfall penalty, oil (US$/bbl)

Shortfall penalty, gas (US$/MMBtu)

Fixed-fee tier

Baseline delivered at least (%)

Fee paid (%)

Below tier 1 no fixed fee is paid.

Field and bid

each field keeps its own data

Working on

Field / contract area name

Fixed fee, oil (US$/bbl)

Fixed fee, gas (US$/MMBtu)

Minimum owner share (%)

Minimum wells per yearBid must quote more than this

Owner revenue share bid (%)Whole number, at least the minimum

Prices, fiscal terms and discounting

this field

Oil price (US$/bbl)

Gas price (US$/MMBtu)

Oil royalty (%)

Gas royalty (%)

VAT / other levies (%)

INR per US$

Your discount rate (%)

Income tax rate (%)

Tax depreciation life (years)

Abandonment (% of revenue)

Average well cost (₹ cr)

Year-by-year profile and costs

oil in tonnes · gas in 1,000 m³ · money in ₹ crore

% of baseline % of CAPEX

Paste a block straight from Excel into any cell; rows and columns fill from that cell onward. The table shows one row per contract year.

Year

Baseline oil (t)

Baseline gas (1,000 m³)

Quoted incr. oil (t)

Quoted incr. gas (1,000 m³)

Wells drilled

Other CAPEX (₹ cr)

OPEX (₹ cr)

Scenarios

what actually happens vs. what you quote

Case

Baseline delivered (%)

Actual incremental (% of quoted)

CAPEX factor (%)

OPEX factor (%)

Baseline delivered below the tier thresholds cuts the fixed fee. Actual incremental below the penalty threshold triggers the shortfall penalty; above the incentive threshold earns the incentive.

Open inputs file

Enter the project and bid inputs

Project

Contract terms

Field and bid

Prices, fiscal terms and discounting

Year-by-year profile and costs

Scenarios

No results yet

Scenario comparison

Net cash flow by year

Where contractor revenue comes from

Oil production

What moves NPV most

Choosing the owner share