---
cid: po.bp.econ.psc.split
hub: econ
tags: [economics, fiscal-terms, production-sharing, PSC, cost-recovery, profit-oil, R-factor, tranche, government-take, contractor-NPV, one-well]
facets: { discipline: economics, method-type: analytical }
title: Production Sharing Contract Split
summary: "Splits a well's revenue under a production sharing contract into royalty, cost oil and profit oil, with the government take and contractor NPV."
slug: po.econ.psc.split
type: worksheet
---

# Production Sharing Contract Split

## Description

How does a production sharing contract divide a 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, income tax and profit-split tiers, by R-factor or by production tranche. You read off the royalty, cost oil, profit oil and tax year by year, the contract's totals, the government's take of the revenue less costs, and the contractor's NPV.

**Parameters:**
- **The well**: the type curve's initial rate `PSC_IP` (STB/d), Arps exponent `PSC_b`, effective secant initial decline `PSC_Dei` and effective terminal decline `PSC_Dterm`, the gas-oil ratio `PSC_GOR` (scf/STB) and the type-curve factor `PSC_TC`
- **Prices**: oil `PSC_Oil` ($/STB) less `PSC_OilDiff`, gas `PSC_Gas` ($/MMBtu) less `PSC_GasDiff`, flat
- **Costs**: the D&C `PSC_DC` ($MM, in year 1), fixed LOE `PSC_LOE` ($/well-month), variable LOE `PSC_LOEVar` ($/STB) and gathering `PSC_Gath` ($/Mscf)
- **Fiscal terms**: the split mode `PSC_Mode` (1 by R-factor, 2 by production tranche), the royalty `PSC_Roy`, the cost-recovery cap `PSC_CostCap` (of the revenue after royalty), the income tax on the contractor's profit oil `PSC_Tax` and the highest acceptable government take `PSC_TakeMax`
- **Profit-split tiers** (a table): each tier's R-factor lower bound `PSC_RfFrom`, its yearly oil lower bound `PSC_TrFrom` (STB a year) and the contractor's share `PSC_Shares`
- **Discounting**: the discount rate `PSC_Disc`, on end-of-year cash flows

**How to use it:** The defaults are an illustrative well under generic terms, not a real contract. Type a field's own forecast over the Oil column and its costs over the Costs column, one row a year, and the contract's own royalty, cap, tax and tiers. Bonuses, an investment uplift, a domestic market obligation, ring-fencing and state participation are not in the split function: model them in cells around it. A sweep reprices the contract over the oil price under both modes, and the chart draws the government's take (left axis) and the contractor's NPV (right axis) against the oil price for each mode. The sheet flags a contractor that loses money, a government take above its limit, and costs never recovered within the term.

**Method:** Each year's oil is the sum of its twelve mid-month rates on the type curve times 30.4375 days. Its value per barrel is V = (Oil − OilDiff) + GOR/1000·(Gas − GasDiff), and its costs are the D&C in year 1 plus 12·LOE + (LOEVar + GOR/1000·Gath)·oil. The revenue is R = oil·V. The royalty is Roy·R and the net revenue N = R − royalty. The cumulative cost recovered is min(cumulative costs, last year's recovered + CostCap·N), so the cost oil is this year's step in it and the excess carries forward without uplift. The profit oil is N − cost oil. In mode 1 the contractor's share is that of the highest tier whose bound is at or below the R-factor, its cumulative receipts (cost oil plus its profit oil) over its cumulative costs to the end of the year before. In mode 2 each slice of the year's oil earns its tranche's share. The contractor's tax is Tax × its profit oil. The government takes the royalty, its profit oil and the tax. The contractor's net cash is cost oil + its profit oil − tax − costs, and its NPV discounts the year-k cash by (1 + Disc)^k. The government's take is its total over the revenue less costs.

**Example:** The default well is the economics family's (the well-program workbook's base case for one well, as on the One-Well NPV and IRR sheet): 800 STB/d initial on an Arps hyperbolic with b = 1 and a 65 %/yr effective secant decline switching to an 8 %/yr exponential tail, 1,500 scf/STB, $70/STB oil less $1.50 and $3.00/MMBtu gas less $1.00, a $7MM D&C, $8,000 a month of fixed LOE, $4/STB of variable LOE and $0.50/Mscf of gathering, over a 20-year contract. The fiscal terms are generic, after Johnston: a 10 % royalty, a 60 % cost-recovery cap, 30 % income tax, and the contractor's share of the profit oil falling from 50 % to 35 % at an R-factor of 1 and to 20 % at 1.5 (or, by tranche, at 50,000 and 100,000 STB a year). Cash is discounted at 10 %, and the government's take is held to 85 %.

In year 1 the well makes 165,040 STB, worth $11.80MM at $71.50 a barrel, oil and gas. The royalty takes $1.18MM, so the cap is 0.6 × 10.62 = $6.37MM, against $7.88MM of costs; $1.51MM carries into year 2. The $4.25MM of profit oil is split 50/50, since the R-factor is 0 in the first year, and the contractor's net cash is −$0.02MM. By year 2 the R-factor is (6.37 + 2.12)/7.88 = 1.08, so the contractor's share falls to 35 %. From year 5 it is 20 %, the R-factor having passed 1.5. Over 20 years the well makes 568.3 MSTB and $40.63MM of revenue against $11.62MM of costs, all recovered. The government takes $23.75MM: $4.06MM of royalty, $17.43MM of profit oil and $2.26MM of tax. That is 81.9 % of the $29.01MM of revenue less costs. The contractor nets $5.26MM, an NPV of $3.49MM at 10 %.

By tranche (mode 2) the contractor keeps more of the later, smaller years: its NPV is $4.67MM and the government's take 72.0 %. At $30 oil the cap leaves $1.95MM unrecovered and the contractor loses $1.14MM. The sweep shows the difference between the modes. Under the R-factor the take climbs from 76.4 % at $40 to 84.0 % at $120, and the contractor's NPV only from $0.95MM to $6.42MM. By tranche the take stays near 72 %, and the NPV rises from $0.88MM to $9.87MM.

## Validity

A generic PSC on one well's forecast, one row a year, with a flat price. There are no bonuses, no domestic market obligation, no investment uplift, no depreciation schedule for the income tax (the tax base is the contractor's profit oil, as in the usual simplified flow diagram), no ring-fencing and no state participation. Real contracts differ in what the cap applies to and in how the R-factor counts tax: check the contract. The well is produced for the whole term; a contract that ends at the economic limit or relinquishes the field earlier is not modelled. Named alternatives: the One-Well NPV and IRR sheet for the well under the Texas royalty and taxes; the Decline Economics sheet for the economic limit that would end it; the well-program workbook for a program of wells; Johnston (1994) for the flow diagrams of other fiscal systems. Field units.

## 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.

## Functions used

`PO.ECON.PSC.Split`

## Spreadsheet: PscSplit

|     | A                                                                                                                                                                | B                                                                                                                                                                                              | C                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | D                                                                                                                                  | E                                                                                                                                          | F                                                                                                                                          | G                                                                                                             | H                                                                                                             | I                                                                                                             | J                                                                                                             | K                                                                                                             |
|-----|------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------|
| 1   | Production Sharing Contract Split                                                                                                                                |                                                                                                                                                                                                | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 2   | Blue cells on yellow are inputs: the economics family's well under a generic production sharing contract. The yearly split and the takes follow.                 |                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 3   | The Well and Its Type Curve                                                                                                                                      |                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 4   | Initial oil rate of the type curve                                                                                                                               | 800                                                                                                                                                                                            | STB/d                                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 5   | Arps hyperbolic exponent b                                                                                                                                       | 1                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 6   | Initial decline, effective secant                                                                                                                                | 0.65                                                                                                                                                                                           | %/yr                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 7   | Terminal decline, effective (exponential tail)                                                                                                                   | 0.08                                                                                                                                                                                           | %/yr                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 8   | Gas-oil ratio, constant over life                                                                                                                                | 1500                                                                                                                                                                                           | scf/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 9   | Type-curve factor (scales the initial rate)                                                                                                                      | 1                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 10  | Oil and Gas Prices                                                                                                                                               |                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 11  | Oil price (WTI)                                                                                                                                                  | 70                                                                                                                                                                                             | $/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 12  | Oil differential, deducted (quality and transport)                                                                                                               | 1.5                                                                                                                                                                                            | $/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 13  | Gas price (Henry Hub, 1 MMBtu per Mscf)                                                                                                                          | 3                                                                                                                                                                                              | $/MMBtu                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 14  | Gas differential, deducted (Waha basis)                                                                                                                          | 1                                                                                                                                                                                              | $/MMBtu                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 15  | Capital and Operating Costs                                                                                                                                      |                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 16  | Drilling and completion of the well                                                                                                                              | 7                                                                                                                                                                                              | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 17  | Fixed LOE                                                                                                                                                        | 8000                                                                                                                                                                                           | $/well-month                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 18  | Variable LOE per barrel of oil                                                                                                                                   | 4                                                                                                                                                                                              | $/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 19  | Gas gathering and processing                                                                                                                                     | 0.5                                                                                                                                                                                            | $/Mscf                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 20  | Fiscal Terms of the Contract                                                                                                                                     |                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 21  | Profit split, 1 by R-factor or 2 by production tranche                                                                                                           | 1                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 22  | Royalty, of the gross revenue                                                                                                                                    | 0.1                                                                                                                                                                                            | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 23  | Cost-recovery cap, of the revenue after royalty                                                                                                                  | 0.6                                                                                                                                                                                            | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 24  | Income tax on the contractor's profit oil                                                                                                                        | 0.3                                                                                                                                                                                            | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 25  | Highest acceptable government take                                                                                                                               | 0.85                                                                                                                                                                                           | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 26  | Discounting                                                                                                                                                      |                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 27  | Discount rate, end-of-year cash flows                                                                                                                            | 0.1                                                                                                                                                                                            | %/yr                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 29  | Calculation Constants                                                                                                                                            |                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 30  | Days in a month, 365.25/12                                                                                                                                       | 30.4375                                                                                                                                                                                        | days/month                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 31  | Months in a year                                                                                                                                                 | 12                                                                                                                                                                                             | months/yr                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 32  | Dollars in a million                                                                                                                                             | 1000000                                                                                                                                                                                        | $/$MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 33  | Years in the contract, the period table's rows                                                                                                                   | 20                                                                                                                                                                                             | years                                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 34  | PO.ECON.PSC.Split output, the government take                                                                                                                    | 6                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 35  | PO.ECON.PSC.Split output, the contractor's net cash flow                                                                                                         | 7                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 37  | Profit-Split Tiers (the contractor's share from each bound up)                                                                                                   |                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 38  | Tier                                                                                                                                                             | R-factor from (—)                                                                                                                                                                              | Oil a year from (STB)                                                                                                                                                                                                                                                                                                                                                                                                                                                | Contractor share (%)                                                                                                               | Bound in force                                                                                                                             |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 39  | First                                                                                                                                                            | 0                                                                                                                                                                                              | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 0.5                                                                                                                                | =IF(PSC_Mode=1,B39,C39)                                                                                                                    |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 40  | Second                                                                                                                                                           | 1                                                                                                                                                                                              | 50000                                                                                                                                                                                                                                                                                                                                                                                                                                                                | 0.35                                                                                                                               | =IF(PSC_Mode=1,B40,C40)                                                                                                                    |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 41  | Third                                                                                                                                                            | 1.5                                                                                                                                                                                            | 100000                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 0.2                                                                                                                                | =IF(PSC_Mode=1,B41,C41)                                                                                                                    |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 43  | The Well's Production and Value per Barrel                                                                                                                       |                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 44  | Initial nominal decline, from the effective secant                                                                                                               | =((1-PSC_Dei)^(-PSC_b)-1)/PSC_b                                                                                                                                                                | 1/yr                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 45  | Terminal nominal decline, from the effective                                                                                                                     | =-LN(1-PSC_Dterm)                                                                                                                                                                              | 1/yr                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 46  | Time the hyperbolic switches to the terminal decline                                                                                                             | =MAX(0,(PSC_Di/PSC_Dt-1)/(PSC_b*PSC_Di))                                                                                                                                                       | years                                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 47  | Rate at the switch over the initial rate                                                                                                                         | =(1+PSC_b*PSC_Di*PSC_Ts)^(-1/PSC_b)                                                                                                                                                            | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 48  | Initial oil rate, IP × type-curve factor                                                                                                                         | =PSC_IP*PSC_TC                                                                                                                                                                                 | STB/d                                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 49  | Realised value per barrel of oil, with its gas                                                                                                                   | =PSC_Oil-PSC_OilDiff+PSC_GOR/1000*(PSC_Gas-PSC_GasDiff)                                                                                                                                        | $/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 50  | Variable cost per barrel, LOE and the gas's gathering                                                                                                            | =PSC_LOEVar+PSC_GOR/1000*PSC_Gath                                                                                                                                                              | $/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 52  | The Split Over the Contract                                                                                                                                      |                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 53  | Oil over the contract                                                                                                                                            | =SUM(TAKE($B$88:$B$107,PSC_Years))/1000                                                                                                                                                        | MSTB                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 54  | Gross revenue                                                                                                                                                    | =SUM(TAKE($C$88:$C$107,PSC_Years))/PSC_PerMM                                                                                                                                                   | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 55  | Costs, capital and operating                                                                                                                                     | =SUM(TAKE($D$88:$D$107,PSC_Years))/PSC_PerMM                                                                                                                                                   | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 56  | Cost oil, the costs recovered                                                                                                                                    | =SUM(TAKE($E$88:$E$107,PSC_Years))/PSC_PerMM                                                                                                                                                   | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 57  | Profit oil                                                                                                                                                       | =SUM(TAKE($F$88:$F$107,PSC_Years))/PSC_PerMM                                                                                                                                                   | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 58  | Contractor profit oil                                                                                                                                            | =SUM(TAKE($G$88:$G$107,PSC_Years))/PSC_PerMM                                                                                                                                                   | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 59  | Government profit oil                                                                                                                                            | =SUM(TAKE($H$88:$H$107,PSC_Years))/PSC_PerMM                                                                                                                                                   | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 60  | Contractor income tax                                                                                                                                            | =SUM(TAKE($I$88:$I$107,PSC_Years))/PSC_PerMM                                                                                                                                                   | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 61  | Government take, royalty + profit oil + tax                                                                                                                      | =SUM(TAKE($J$88:$J$107,PSC_Years))/PSC_PerMM                                                                                                                                                   | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 62  | Contractor net cash, undiscounted                                                                                                                                | =SUM(TAKE($K$88:$K$107,PSC_Years))/PSC_PerMM                                                                                                                                                   | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 63  | Contractor NPV, end-of-year cash flows                                                                                                                           | =NPV(PSC_Disc,TAKE($K$88:$K$107,PSC_Years))/PSC_PerMM                                                                                                                                          | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 64  | Government take, of the revenue less costs                                                                                                                       | =PSC_GovTake/(PSC_Revenue-PSC_Costs)                                                                                                                                                           | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 65  | Costs never recovered within the term                                                                                                                            | =PSC_Costs-PSC_CostOil                                                                                                                                                                         | $MM                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 66  | Contractor return check                                                                                                                                          | =IF(PSC_CtrNPV<=0,"FAIL",IF(PSC_GovShare>PSC_TakeMax,"WARN","PASS"))                                                                                                                           | =IF(PSC_CtrNPV<=0,"the contractor loses "&FIXED(-PSC_CtrNPV,2)&" $MM at "&FIXED(PSC_Disc*100,0)&" %: the terms are too tight at this price",IF(PSC_GovShare>PSC_TakeMax,"the contractor earns "&FIXED(PSC_CtrNPV,2)&" $MM, but the government takes "&FIXED(PSC_GovShare*100,1)&" %, above "&FIXED(PSC_TakeMax*100,1)&" %","the contractor earns "&FIXED(PSC_CtrNPV,2)&" $MM at "&FIXED(PSC_Disc*100,0)&" %, the government takes "&FIXED(PSC_GovShare*100,1)&" %")) |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 67  | Cost recovery check                                                                                                                                              | =IF(PSC_Unrecovered*PSC_PerMM<1,"PASS","WARN")                                                                                                                                                 | =IF(PSC_Unrecovered*PSC_PerMM<1,"the contractor recovers all its costs within the term",""&FIXED(PSC_Unrecovered,2)&" $MM of costs is never recovered within the term")                                                                                                                                                                                                                                                                                              |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 69  | How to use it: type the well's or field's own forecast over the Oil column, its costs over the Costs column, and the contract's own royalty, cap, tax and tiers. |                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 70  | The defaults are an illustrative well under generic terms, not a real contract: no bonuses, no uplift, no ring-fencing and no state participation.               |                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 72  | The Takes Against the Oil Price, Both Split Modes (nothing to edit)                                                                                              |                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 73  | Oil price ($/STB)                                                                                                                                                | Value per barrel ($/STB)                                                                                                                                                                       | NPV, R-factor ($MM)                                                                                                                                                                                                                                                                                                                                                                                                                                                  | NPV, tranche ($MM)                                                                                                                 | Take, R-factor (%)                                                                                                                         | Take, tranche (%)                                                                                                                          |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 74  | =30                                                                                                                                                              | =PSC_Price+A74-PSC_Oil                                                                                                                                                                         | =NPV(PSC_Disc,PO.ECON.PSC.Split(1,PSC_Gross,B74,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM                                                                                                                                                                                                                                                                                                                                   | =NPV(PSC_Disc,PO.ECON.PSC.Split(2,PSC_Gross,B74,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM | =SUM(PO.ECON.PSC.Split(1,PSC_Gross,B74,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B74-PSC_Cost) | =SUM(PO.ECON.PSC.Split(2,PSC_Gross,B74,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B74-PSC_Cost) |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 75  | =40                                                                                                                                                              | =PSC_Price+A75-PSC_Oil                                                                                                                                                                         | =NPV(PSC_Disc,PO.ECON.PSC.Split(1,PSC_Gross,B75,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM                                                                                                                                                                                                                                                                                                                                   | =NPV(PSC_Disc,PO.ECON.PSC.Split(2,PSC_Gross,B75,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM | =SUM(PO.ECON.PSC.Split(1,PSC_Gross,B75,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B75-PSC_Cost) | =SUM(PO.ECON.PSC.Split(2,PSC_Gross,B75,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B75-PSC_Cost) |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 76  | =50                                                                                                                                                              | =PSC_Price+A76-PSC_Oil                                                                                                                                                                         | =NPV(PSC_Disc,PO.ECON.PSC.Split(1,PSC_Gross,B76,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM                                                                                                                                                                                                                                                                                                                                   | =NPV(PSC_Disc,PO.ECON.PSC.Split(2,PSC_Gross,B76,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM | =SUM(PO.ECON.PSC.Split(1,PSC_Gross,B76,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B76-PSC_Cost) | =SUM(PO.ECON.PSC.Split(2,PSC_Gross,B76,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B76-PSC_Cost) |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 77  | =60                                                                                                                                                              | =PSC_Price+A77-PSC_Oil                                                                                                                                                                         | =NPV(PSC_Disc,PO.ECON.PSC.Split(1,PSC_Gross,B77,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM                                                                                                                                                                                                                                                                                                                                   | =NPV(PSC_Disc,PO.ECON.PSC.Split(2,PSC_Gross,B77,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM | =SUM(PO.ECON.PSC.Split(1,PSC_Gross,B77,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B77-PSC_Cost) | =SUM(PO.ECON.PSC.Split(2,PSC_Gross,B77,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B77-PSC_Cost) |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 78  | =70                                                                                                                                                              | =PSC_Price+A78-PSC_Oil                                                                                                                                                                         | =NPV(PSC_Disc,PO.ECON.PSC.Split(1,PSC_Gross,B78,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM                                                                                                                                                                                                                                                                                                                                   | =NPV(PSC_Disc,PO.ECON.PSC.Split(2,PSC_Gross,B78,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM | =SUM(PO.ECON.PSC.Split(1,PSC_Gross,B78,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B78-PSC_Cost) | =SUM(PO.ECON.PSC.Split(2,PSC_Gross,B78,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B78-PSC_Cost) |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 79  | =80                                                                                                                                                              | =PSC_Price+A79-PSC_Oil                                                                                                                                                                         | =NPV(PSC_Disc,PO.ECON.PSC.Split(1,PSC_Gross,B79,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM                                                                                                                                                                                                                                                                                                                                   | =NPV(PSC_Disc,PO.ECON.PSC.Split(2,PSC_Gross,B79,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM | =SUM(PO.ECON.PSC.Split(1,PSC_Gross,B79,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B79-PSC_Cost) | =SUM(PO.ECON.PSC.Split(2,PSC_Gross,B79,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B79-PSC_Cost) |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 80  | =90                                                                                                                                                              | =PSC_Price+A80-PSC_Oil                                                                                                                                                                         | =NPV(PSC_Disc,PO.ECON.PSC.Split(1,PSC_Gross,B80,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM                                                                                                                                                                                                                                                                                                                                   | =NPV(PSC_Disc,PO.ECON.PSC.Split(2,PSC_Gross,B80,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM | =SUM(PO.ECON.PSC.Split(1,PSC_Gross,B80,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B80-PSC_Cost) | =SUM(PO.ECON.PSC.Split(2,PSC_Gross,B80,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B80-PSC_Cost) |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 81  | =100                                                                                                                                                             | =PSC_Price+A81-PSC_Oil                                                                                                                                                                         | =NPV(PSC_Disc,PO.ECON.PSC.Split(1,PSC_Gross,B81,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM                                                                                                                                                                                                                                                                                                                                   | =NPV(PSC_Disc,PO.ECON.PSC.Split(2,PSC_Gross,B81,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM | =SUM(PO.ECON.PSC.Split(1,PSC_Gross,B81,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B81-PSC_Cost) | =SUM(PO.ECON.PSC.Split(2,PSC_Gross,B81,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B81-PSC_Cost) |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 82  | =110                                                                                                                                                             | =PSC_Price+A82-PSC_Oil                                                                                                                                                                         | =NPV(PSC_Disc,PO.ECON.PSC.Split(1,PSC_Gross,B82,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM                                                                                                                                                                                                                                                                                                                                   | =NPV(PSC_Disc,PO.ECON.PSC.Split(2,PSC_Gross,B82,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM | =SUM(PO.ECON.PSC.Split(1,PSC_Gross,B82,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B82-PSC_Cost) | =SUM(PO.ECON.PSC.Split(2,PSC_Gross,B82,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B82-PSC_Cost) |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 83  | =120                                                                                                                                                             | =PSC_Price+A83-PSC_Oil                                                                                                                                                                         | =NPV(PSC_Disc,PO.ECON.PSC.Split(1,PSC_Gross,B83,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM                                                                                                                                                                                                                                                                                                                                   | =NPV(PSC_Disc,PO.ECON.PSC.Split(2,PSC_Gross,B83,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_CashOut))/PSC_PerMM | =SUM(PO.ECON.PSC.Split(1,PSC_Gross,B83,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_RfFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B83-PSC_Cost) | =SUM(PO.ECON.PSC.Split(2,PSC_Gross,B83,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_TrFrom,PSC_Shares,PSC_GovOut))/SUM(PSC_Gross*B83-PSC_Cost) |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 85  | The Contract Year by Year (the split columns spill from PO.ECON.PSC.Split)                                                                                       |                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 86  | Each year's oil is its twelve mid-month rates; the D&C falls in year 1. Cost oil to contractor net cash are the LAMBDA's outputs 1 to 7 under the mode above.    |                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                                                    |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 87  | Year (—)                                                                                                                                                         | Oil (STB)                                                                                                                                                                                      | Revenue ($)                                                                                                                                                                                                                                                                                                                                                                                                                                                          | Costs ($)                                                                                                                          | Cost oil ($)                                                                                                                               | Profit oil ($)                                                                                                                             | Contractor profit oil ($)                                                                                     | Government profit oil ($)                                                                                     | Contractor tax ($)                                                                                            | Government take ($)                                                                                           | Contractor net cash ($)                                                                                       |
| 88  | =1                                                                                                                                                               | =LET(ps_t,(2*(PSC_MoYr*(A88-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days)  | =B88*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                       | =(A88=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B88                                                                         | =PO.ECON.PSC.Split(PSC_Mode,PSC_Gross,PSC_Price,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_Limits,PSC_Shares,1)                              | =PO.ECON.PSC.Split(PSC_Mode,PSC_Gross,PSC_Price,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_Limits,PSC_Shares,2)                              | =PO.ECON.PSC.Split(PSC_Mode,PSC_Gross,PSC_Price,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_Limits,PSC_Shares,3) | =PO.ECON.PSC.Split(PSC_Mode,PSC_Gross,PSC_Price,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_Limits,PSC_Shares,4) | =PO.ECON.PSC.Split(PSC_Mode,PSC_Gross,PSC_Price,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_Limits,PSC_Shares,5) | =PO.ECON.PSC.Split(PSC_Mode,PSC_Gross,PSC_Price,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_Limits,PSC_Shares,6) | =PO.ECON.PSC.Split(PSC_Mode,PSC_Gross,PSC_Price,PSC_Cost,PSC_Roy,PSC_CostCap,PSC_Tax,PSC_Limits,PSC_Shares,7) |
| 89  | =2                                                                                                                                                               | =LET(ps_t,(2*(PSC_MoYr*(A89-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days)  | =B89*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                       | =(A89=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B89                                                                         |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 90  | =3                                                                                                                                                               | =LET(ps_t,(2*(PSC_MoYr*(A90-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days)  | =B90*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                       | =(A90=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B90                                                                         |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 91  | =4                                                                                                                                                               | =LET(ps_t,(2*(PSC_MoYr*(A91-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days)  | =B91*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                       | =(A91=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B91                                                                         |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 92  | =5                                                                                                                                                               | =LET(ps_t,(2*(PSC_MoYr*(A92-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days)  | =B92*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                       | =(A92=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B92                                                                         |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 93  | =6                                                                                                                                                               | =LET(ps_t,(2*(PSC_MoYr*(A93-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days)  | =B93*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                       | =(A93=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B93                                                                         |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 94  | =7                                                                                                                                                               | =LET(ps_t,(2*(PSC_MoYr*(A94-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days)  | =B94*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                       | =(A94=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B94                                                                         |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 95  | =8                                                                                                                                                               | =LET(ps_t,(2*(PSC_MoYr*(A95-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days)  | =B95*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                       | =(A95=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B95                                                                         |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 96  | =9                                                                                                                                                               | =LET(ps_t,(2*(PSC_MoYr*(A96-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days)  | =B96*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                       | =(A96=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B96                                                                         |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 97  | =10                                                                                                                                                              | =LET(ps_t,(2*(PSC_MoYr*(A97-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days)  | =B97*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                       | =(A97=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B97                                                                         |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 98  | =11                                                                                                                                                              | =LET(ps_t,(2*(PSC_MoYr*(A98-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days)  | =B98*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                       | =(A98=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B98                                                                         |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 99  | =12                                                                                                                                                              | =LET(ps_t,(2*(PSC_MoYr*(A99-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days)  | =B99*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                       | =(A99=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B99                                                                         |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 100 | =13                                                                                                                                                              | =LET(ps_t,(2*(PSC_MoYr*(A100-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days) | =B100*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                      | =(A100=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B100                                                                       |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 101 | =14                                                                                                                                                              | =LET(ps_t,(2*(PSC_MoYr*(A101-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days) | =B101*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                      | =(A101=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B101                                                                       |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 102 | =15                                                                                                                                                              | =LET(ps_t,(2*(PSC_MoYr*(A102-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days) | =B102*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                      | =(A102=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B102                                                                       |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 103 | =16                                                                                                                                                              | =LET(ps_t,(2*(PSC_MoYr*(A103-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days) | =B103*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                      | =(A103=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B103                                                                       |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 104 | =17                                                                                                                                                              | =LET(ps_t,(2*(PSC_MoYr*(A104-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days) | =B104*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                      | =(A104=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B104                                                                       |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 105 | =18                                                                                                                                                              | =LET(ps_t,(2*(PSC_MoYr*(A105-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days) | =B105*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                      | =(A105=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B105                                                                       |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 106 | =19                                                                                                                                                              | =LET(ps_t,(2*(PSC_MoYr*(A106-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days) | =B106*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                      | =(A106=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B106                                                                       |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |
| 107 | =20                                                                                                                                                              | =LET(ps_t,(2*(PSC_MoYr*(A107-1)+SEQUENCE(PSC_MoYr))-1)/2/PSC_MoYr,SUM((ps_t<=PSC_Ts)*PSC_Qi*(1+PSC_b*PSC_Di*ps_t)^(-1/PSC_b)+(ps_t>PSC_Ts)*PSC_Qi*PSC_Qs*EXP(-PSC_Dt*(ps_t-PSC_Ts)))*PSC_Days) | =B107*PSC_Price                                                                                                                                                                                                                                                                                                                                                                                                                                                      | =(A107=1)*PSC_DC*PSC_PerMM+PSC_LOE*PSC_MoYr+PSC_OpexVar*B107                                                                       |                                                                                                                                            |                                                                                                                                            |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |                                                                                                               |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.ECON.PSC.Split | =LAMBDA(Mode, Gross, Price, Cost, Royalty, CostCap, Tax, Limits, Shares, Output, LET(rev, Gross*Price, roy, Royalty*rev, net, rev-roy, capv, CostCap*net, cumc, SCAN(0, Cost, LAMBDA(run_c, val_c, run_c+val_c)), cumcap, SCAN(0, capv, LAMBDA(run_k, val_k, run_k+val_k)), rec, cumcap+SCAN(0, cumc-cumcap, LAMBDA(low_r, val_r, MIN(low_r, val_r))), recprev, cumcap-capv+SCAN(0, cumc-Cost-cumcap+capv, LAMBDA(low_p, val_p, MIN(low_p, val_p))), costoil, rec-recprev, profit, net-costoil, tier, SCAN(0, Shares, LAMBDA(run_t, val_t, run_t+1)), ds, Shares-SCAN(0, tier, LAMBDA(run_d, tier_d, SUM((tier=tier_d-1)*Shares))), ix, SCAN(0, Gross, LAMBDA(run_i, val_i, run_i+1)), tranche, SCAN(0, ix, LAMBDA(run_q, per_q, LET(g, SUM((ix=per_q)*Gross), IF(g>0, SUM((g-Limits>0)*(g-Limits)*ds)/g, 0)))), receipts, SCAN(0, ix, LAMBDA(run_x, per_x, LET(cprev, SUM((ix<per_x)*Cost), rf, IF(cprev>0, run_x/cprev, 0), run_x+SUM((ix=per_x)*(costoil+SUM(ds*(rf>=Limits))*profit))))), back, SCAN(0, ix, LAMBDA(run_b, per_b, SUM((ix=per_b-1)*receipts))), cpo, CHOOSE(Mode, receipts-back-costoil, tranche*profit), gpo, profit-cpo, tx, Tax*cpo, govtake, roy+gpo+tx, ncf, costoil+cpo-tx-Cost, share, SCAN(0, govtake, LAMBDA(run_g, val_g, run_g+val_g))/SCAN(0, rev-Cost, LAMBDA(run_v, val_v, run_v+val_v)), CHOOSE(Output, costoil, profit, cpo, gpo, tx, govtake, ncf, share))) | Production sharing contract split per period: cost oil under a cap with carry-forward, profit oil by R-factor (Mode 1) or production tranche (Mode 2), tax and takes |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| PSC_IP | $B$4 | Initial oil rate of the type curve, STB/d |
| PSC_b | $B$5 | Arps hyperbolic exponent b |
| PSC_Dei | $B$6 | Initial decline, effective secant, %/yr |
| PSC_Dterm | $B$7 | Terminal decline, effective (exponential tail), %/yr |
| PSC_GOR | $B$8 | Gas-oil ratio, constant over life, scf/STB |
| PSC_TC | $B$9 | Type-curve factor (scales the initial rate) |
| PSC_Oil | $B$11 | Oil price (WTI), $/STB |
| PSC_OilDiff | $B$12 | Oil differential, deducted (quality and transport), $/STB |
| PSC_Gas | $B$13 | Gas price (Henry Hub, 1 MMBtu per Mscf), $/MMBtu |
| PSC_GasDiff | $B$14 | Gas differential, deducted (Waha basis), $/MMBtu |
| PSC_DC | $B$16 | Drilling and completion of the well, $MM |
| PSC_LOE | $B$17 | Fixed LOE, $/well-month |
| PSC_LOEVar | $B$18 | Variable LOE per barrel of oil, $/STB |
| PSC_Gath | $B$19 | Gas gathering and processing, $/Mscf |
| PSC_Mode | $B$21 | Profit split, 1 by R-factor or 2 by production tranche |
| PSC_Roy | $B$22 | Royalty, of the gross revenue, % |
| PSC_CostCap | $B$23 | Cost-recovery cap, of the revenue after royalty, % |
| PSC_Tax | $B$24 | Income tax on the contractor's profit oil, % |
| PSC_TakeMax | $B$25 | Highest acceptable government take, % |
| PSC_Disc | $B$27 | Discount rate, end-of-year cash flows, %/yr |
| PSC_Inputs | $B$4:$B$27 | The well's type curve, oil and gas prices, D&C and operating costs, the contract's split mode, royalty, cost-recovery cap, tax and the take limit, and the discount rate |
| PSC_Days | $B$30 | Days in a month, 365.25/12, days/month |
| PSC_MoYr | $B$31 | Months in a year, months/yr |
| PSC_PerMM | $B$32 | Dollars in a million, $/$MM |
| PSC_Years | $B$33 | Years in the contract, the period table's rows, years |
| PSC_GovOut | $B$34 | PO.ECON.PSC.Split output, the government take |
| PSC_CashOut | $B$35 | PO.ECON.PSC.Split output, the contractor's net cash flow |
| PSC_Tiers | $A$39:$E$41 | Each tier's R-factor and yearly oil lower bounds, the contractor's share of the profit oil, and the bound the split mode uses |
| PSC_RfFrom | $B$39:$B$41 | The tiers' R-factor lower bounds, ascending from 0 |
| PSC_TrFrom | $C$39:$C$41 | The tiers' yearly oil lower bounds, ascending from 0, STB a year |
| PSC_Shares | $D$39:$D$41 | The contractor's share of the profit oil in each tier |
| PSC_Limits | $E$39:$E$41 | The tiers' lower bounds in force: R-factors in mode 1, yearly oil in mode 2 |
| PSC_Di | $B$44 | Initial nominal decline, from the effective secant, 1/yr |
| PSC_Dt | $B$45 | Terminal nominal decline, from the effective, 1/yr |
| PSC_Ts | $B$46 | Time the hyperbolic switches to the terminal decline, years |
| PSC_Qs | $B$47 | Rate at the switch over the initial rate |
| PSC_Qi | $B$48 | Initial oil rate, IP × type-curve factor, STB/d |
| PSC_Price | $B$49 | Realised value per barrel of oil, with its gas, $/STB |
| PSC_OpexVar | $B$50 | Variable cost per barrel, LOE and the gas's gathering, $/STB |
| PSC_OilTot | $B$53 | Oil over the contract, MSTB |
| PSC_Revenue | $B$54 | Gross revenue, $MM |
| PSC_Costs | $B$55 | Costs, capital and operating, $MM |
| PSC_CostOil | $B$56 | Cost oil, the costs recovered, $MM |
| PSC_ProfitOil | $B$57 | Profit oil, $MM |
| PSC_CtrProfit | $B$58 | Contractor profit oil, $MM |
| PSC_GovProfit | $B$59 | Government profit oil, $MM |
| PSC_TaxPaid | $B$60 | Contractor income tax, $MM |
| PSC_GovTake | $B$61 | Government take, royalty + profit oil + tax, $MM |
| PSC_CtrCash | $B$62 | Contractor net cash, undiscounted, $MM |
| PSC_CtrNPV | $B$63 | Contractor NPV, end-of-year cash flows, $MM |
| PSC_GovShare | $B$64 | Government take, of the revenue less costs, % |
| PSC_Unrecovered | $B$65 | Costs never recovered within the term, $MM |
| PSC_ReturnCheck | $B$66 | Contractor return check verdict |
| PSC_ReturnCheckNote | $C$66 | Contractor return check comment |
| PSC_RecoveryCheck | $B$67 | Cost recovery check verdict |
| PSC_RecoveryCheckNote | $C$67 | Cost recovery check comment |
| PSC_Results | $B$44:$B$67 | The decline terms, the value and variable cost per barrel, the contract's revenue, costs, cost oil, profit oil, tax and takes, the contractor's cash and NPV, and two checks |
| PSC_Sweep | $A$74:$F$83 | Oil prices, the value per barrel at each, and the contractor's NPV and the government's take by R-factor and by tranche |
| PSC_Gross | $B$88:$B$107 | The contract's oil, one row a year, STB |
| PSC_Cost | $D$88:$D$107 | The contract's recoverable costs, capital and operating, one row a year, $ |
| PSC_Contract | $A$88:$D$107 | Each contract year, its oil, its gross revenue and its recoverable costs |
| PSC_SweepCurve | $A$74:$F$83 | Government Take and Contractor NPV Against the Oil Price |

---

## Related Blueprints
- [Break-Even Oil Price](/blueprint/po.econ.breakeven.price.md)
- [Decline Economics](/blueprint/po.econ.decline.economics.md)
- [Workover Decision](/blueprint/po.econ.workover.decision.md)
- [One-Well NPV and IRR](/blueprint/po.econ.npv.irr.md)
- [One-Well NPV Tornado](/blueprint/po.econ.tornado.sensitivity.md)
- [Injector Hall Plot and Voidage Replacement](/blueprint/po.res.hall.plot.md)

