---
id: po.wb.econ.psc-fiscal-model
title: Production Sharing Contract Fiscal Model
summary: "How a production sharing contract splits one well's revenue over twenty years, and the contractor's NPV, IRR and break-even oil price."
category: Economics
requires:
  - excel-365
tags:
  - economics
  - fiscal-terms
  - production-sharing
  - PSC
  - cost-recovery
  - profit-oil
  - R-factor
  - government-take
---

## Description

How does a production sharing contract divide one well's revenue, and what is left for the contractor? You enter the well's type curve, prices and costs and the contract's royalty, cost-recovery cap, profit-split tiers and income tax. You read off the split year by year over a twenty-year term (cost oil, profit oil, tax and government take) and the contractor's NPV, IRR and break-even oil price from the contract's own annual cash flows.

**How to use it:** Replace the Profile sheet's well, its prices and costs and its terms with a field's own forecast and a real contract's terms, including the three rows of the profit-split tier table. Read the Contract sheet's split year by year and the Valuation sheet's NPV, IRR and break-even, then the Summary's headlines with its checks: they catch an out-of-range term or a tier table that does not descend, a contractor who loses money or a government take above the contract's limit, costs that are never recovered, and a search for the IRR or the break-even that finds no root.

**Method:** Each contract year's oil is the sum of its twelve mid-month rates on the type curve times 30.4375 days. The value per barrel is the oil price less its differential plus GOR/1000 times the gas price less its differential, and the year's costs are the D&C in year 1 plus 12 months of fixed LOE plus the variable LOE and GOR/1000 times the gathering cost per barrel of oil. The split takes the revenue R = oil × value per barrel, takes the royalty, recovers the costs as cost oil under the cap with the excess carried forward, splits the profit oil on the tiers (by R-factor or by yearly production tranche), taxes the contractor's share, and returns the cost oil, the profit oil, the two shares, the tax, the government take and the contractor's net cash.

The contractor's NPV discounts that net-cash column at the year ends with Excel's `NPV`, the same convention as the PSC split blueprint, so the workbook and the blueprint give the same number. The IRR reads a cash-flow vector with Excel's `IRR`: the capital at year 0, because the cost-recovery cap leaves the first year almost cash-neutral and the contractor spends the D&C before production, and the contract's own net cash in the years after it. The IRR is the rate at which that vector's NPV is zero; a cash flow with no root reads n/a.

The break-even is the oil price at which the contract's own NPV is zero. A sweep reprices the whole contract at seven prices from $20 to $80/STB (the revenue, the cost-recovery cap, the profit-split tiers and the split all move with the price), and eight passes close in on the bracket the sweep found. The cell reads the last pass's price; a sweep with no sign change reads n/a.

**Example:** The economics family's shared synthetic well makes 568.3 MSTB over the twenty years and $40.63MM of revenue against $11.62MM of costs, all of it recovered as cost oil. The profit oil is $24.95MM: the contractor keeps $7.52MM, the government takes $17.43MM, and the contractor's income tax is $2.26MM. With the $4.06MM royalty the government takes $23.75MM, 81.9 % of the $29.01MM of revenue less costs. The contractor nets $5.26MM, an NPV of $3.49MM at 10 %, an IRR of 35.4 % with the D&C spent before production. The break-even oil price is $34.81/STB. Split by production tranche instead of by R-factor, the contractor's NPV is $4.67MM, its net cash $8.11MM and the government's take 72.0 %. At $30 oil the cap leaves $1.95MM of costs unrecovered and the contractor loses $1.14MM: the terms are too tight at that price.

## Validity

The fiscal terms are illustrative and generic. They name no country's regime, they are not any real contract's terms, and they differ between countries in what the cap applies to and in how the R-factor counts tax: check the contract. There are no bonuses, no domestic market obligation, no investment uplift, no depreciation schedule for the income tax, no ring-fencing and no state participation.

The NPV, the IRR and the break-even oil price come from the PSC's own annual contract cash flows and the contractor's net cash. A Texas royalty and severance model is a different model with different numbers: the NPV and IRR blueprint (`po.bp.econ.npv.irr`) values the same well under a 25 % royalty, Texas severance and ad valorem taxes and a monthly cash flow, and its $34.09/STB break-even is not this contract's break-even. The discounting and the search for a root follow the NPV and IRR and the break-even price blueprints; the split's numbers are the PSC split blueprint's.

The well is produced for the whole twenty-year term. An economic-limit cut-off, an early relinquishment, a second well and any change of the price deck are not modelled, and the workbook holds one well, not a programme. A contract whose cash flow never changes sign reads n/a for the IRR rather than a spurious rate. The break-even is the last of eight passes; a contract whose sweep never changes sign has none, and the cell reads n/a.

## References

- Johnston, D. (1994). *International Petroleum Fiscal Systems and Production Sharing Contracts*. PennWell.
- Johnston, D. (2003). *International Exploration Economics, Risk, and Contract Analysis*. PennWell.
- Mian, M.A. (2011). *Project Economics and Decision Analysis*, Vol. 1, 2nd ed. PennWell (fiscal terms and the contractor's cash flow).
- Arps, J.J. (1945). Analysis of Decline Curves. *Trans. AIME* 160, 228-247.
- Petroleum Office blueprints `po.bp.econ.psc.split`, `po.bp.econ.npv.irr`, `po.bp.econ.breakeven.price`.

## Inputs

| Input | Unit | Default | Name |
|---|---|---|---|
| Initial oil rate of the type curve | STB/d | 800 | `PF_IP` |
| Arps hyperbolic exponent b | — | 1 | `PF_b` |
| Initial decline, effective secant | %/yr | 65 % | `PF_Dei` |
| Terminal decline, effective | %/yr | 8 % | `PF_Dterm` |
| Gas-oil ratio, constant over life | scf/STB | 1,500 | `PF_GOR` |
| Type-curve factor | — | 1 | `PF_TC` |
| Oil price | $/STB | 70 | `PF_Oil` |
| Oil differential, deducted | $/STB | 1.5 | `PF_OilDiff` |
| Gas price, per MMBtu | $/MMBtu | 3 | `PF_Gas` |
| Gas differential, deducted | $/MMBtu | 1 | `PF_GasDiff` |
| Drilling and completion of the well | $MM | 7 | `PF_DC` |
| Fixed LOE, a well-month | $/well-month | 8,000 | `PF_LOE` |
| Variable LOE per barrel of oil | $/STB | 4 | `PF_LOEVar` |
| Gas gathering and processing | $/Mscf | 0.5 | `PF_Gath` |
| Profit split, 1 by R-factor, 2 by tranche | — | 1 | `PF_Mode` |
| Royalty, of the gross revenue | % | 10 % | `PF_Roy` |
| Cost-recovery cap, of the net revenue | % | 60 % | `PF_CostCap` |
| Income tax on the contractor's profit oil | % | 30 % | `PF_Tax` |
| Highest acceptable government take | % | 85 % | `PF_TakeMax` |
| Discount rate, end-of-year cash flows | %/yr | 10 % | `PF_Disc` |
| Profit-split tiers: R-factor from, oil a year from, contractor share | —, STB, % | 0, 0, 50 %; 1, 50,000, 35 %; 1.5, 100,000, 20 % | `PF_Shares`, `PF_Limits` |

The tier table's last column is the bound the split mode puts in force (`PF_Limits`): the R-factors in mode 1, the yearly oil in mode 2; `PF_Shares` holds the contractor's shares.

## Sheets

- `Guide` — what the workbook does, why its fiscal terms are illustrative, the base-case well and how the contractor is valued.
- `Profile` — the well's type curve, prices and costs, the contract's fiscal terms and discount rate, the profit-split tier table, and the decline terms, initial rate and value per barrel they give, with the input check.
- `Contract` — the twenty contract years, one row a year: oil, revenue and costs, then cost oil, profit oil, the contractor's and the government's profit oil, the contractor's tax, the government take and the contractor's net cash, with the totals and the return and cost-recovery checks.
- `Valuation` — the contractor's NPV, IRR and break-even oil price, the IRR's cash-flow vector, the seven-price sweep, the bracket it found and the break-even search pass by pass.
- `Summary` — the headline results and every check under one verdict.
- `Test Cases` — the worked example and other cases, with expected and computed results.

## Functions used

`PO.ECON.PSC.Split` (the catalog LAMBDA, which travels with the workbook), `NPV`, `IRR`, `LET`, `SEQUENCE`, `SUM`, `MAX`, `MIN`, `COUNTIF`, `ROWS`, `LEFT`, `AND`, `OR`, `FIXED`, `IF`, `IFERROR`.
