home *** CD-ROM | disk | FTP | other *** search
-
- RESERVE ECONOMIC ANALYSIS
-
- Developed by First City National Bank of Houston -
- Engineering Department
-
-
-
- The following is a list of possible entries the user will need
- to make a typical REAL (Reserve Economic AnaLysis) run. These
- are the entries that the user should consider initially; however,
- not all of the items may be needed. The data input form provides
- a good check list to insure that the necessary information has
- been covered for each evaluation and is repeated here in greater
- detail.
-
- 1. Well identification
- a. Well (and/or lease) name and number
- b. Field (and reservoir) designation
- c. State
- d. County
- e. Operator
-
- 2. General Information
- a. Present worth month, year and discount rate
- b. As of date
-
- 3. Production Information
- a. Production start date
- b. Phase(s) of production to be scheduled and the major
- phase
- c. Cumulative production
- d. Production schedule
-
- 4. Product Prices and Operating Cost
- a. Escalation parameters
-
- 5. Tax Information
- a. Production and severance tax
- b. Ad Valorem tax
- c. Windfall profit tax
- - Tier category
- - Base price
- - GNP deflator
- - Tax rates
-
- 6. Ownership Information
- a. Working interest before and after reversion
- b. Net revenue interest before and after reversion
-
- 7. Investment Information
- a. Time point of investment
- b. Tangible or intangible investment
-
-
-
-
-
- 8. Other Consideration
- Many entries are needed to sort, to retrieve or to
- consolidate the cases involved in a project; they are
- called masked items. Even though these items will not alter
- the numerical output and could be ignored if the user so
- desired, it is good practice to fill out these entries at
- the time data is input so that future reference to any
- evaluation can be more accurate. These masked items are file
- number, name of the engineer(s) who did the evaluation, the
- reserve category and all entires listed under well
- identification.
-
- The following is further explanation of the data input on an item
- per item basis. A maximum of 77 pieces of data can be input into
- REAL. This data is listed under general categories , such as;
- descriptive input, production and economic data, masked items and
- miscellaneous data and can be explained according to their
- numerical order listed in the sample of the input screen.
-
-
- DESCRIPTIVE INPUT
-
- All items under descriptive input are self-explanatory. They
- include the following:
-
- ITEM CELL DESCRIPTION
-
- 1 B3 Name of the company that owns the appraised
- interest
- 2 B4 Well (and/or lease) name and number
- 3 B5 Name of the field in which the well is
- located. The reservoir name can also be
- included in bracket if needed
- 4 B6 Name of county (or parish) on which the well
- is located
- 5 B7 Name of state (or province) on which the
- well is located
- 6 B8 Name of the company that operates the well
-
- GENERAL RESTRICTIONS
-
- For these descriptive items, the maximum number of characters
- that will allow the input to be fully displayed on the screen is
- 36 characters. However, the output format will support a string
- of up to 54 characters (part of which will be hidden on the input
- screen).
-
-
-
-
-
-
-
-
-
- MISCELLANEOUS DATA
-
- ITEM CELL DESCRIPTION
-
- 7 G3 Month to which the Present Worth is
- discounted. Should be input as a value and
- could have one or two digits for the month
- (plus a decimal point and a fraction of the
- month if it is necessary to discount the PW
- to some point other then first of the month).
- Example:
- Input 10 for October 1st
- Input 8.5 for August 15th
- 8 G4 Year to which the Present Worth is discounted.
- This is also the first year that the
- output will calculate and display. Should be
- input as a four digit value.
- 9 G5 File number is one of the masked items needed
- for future operations, such as, saving a
- file or retrieving a file.
- 10 G6 Name of the engineer(s) who did the evalua-
- tion.
- 11 G7 Reserves category could be input as abbrevia-
- tions such as PDP for Proved Developed
- Producing, PDNP for Proved Developed Non-
- producing, etc.
- 12 G8 As of date is the date only beyond which the
- production is considered. In most cases this
- is the same as PW date (items 7&8). This date
- should be input as a label or as a date, the
- as of date values are items 19 and 20.
-
-
-
- PRODUCTION AND ECONOMIC DATA
-
- 13 A9 Initial working interest should be input in
- percent.
- 14 B9 Initial net revenue interest should also be
- input in percent.
- 15 C9 If the operating cost is a function of the
- number of wells, it should be input as
- $/well/month. This cost is additive to the
- other operating cost (item 16).
- 16 D9 Operating cost in $/month or as certain
- percent of the gross revenue regardless of
- number of wells. Use the negative sign to
- indicate this cost as a percent of gross
- revenue.
-
-
-
-
-
- Example:
- Input 2000 if the operating cost is
- 2000/month, input -8.5 if the operating cost
- is 8.5 percent of the revenue before taxes.
- This cost is additive to the operating cost
- (item 15).
-
- ITEM CELL DESCRIPTION
-
- 17 E9 Ad Valorem tax is input as a percent of the
- revenue before taxes.
- 18 F9 Major phase indicator is used to show if the
- main phase of production is oil or gas.
- If oil is the major phase, input 1
- If gas is the major phase, input 2
- 19 G9 First month of production. The restric-
- tion on this item is the same as the PW
- month (item 7).
- 20 H9 First year of production. The restriction
- is the same as on PW year (item 8).
-
- The next 19 items contain three sets of value for the oil (7),
- the gas (7) and the third phase (5) as follows:
-
- 21,28,35 B10-B12 Cumulative production in thousand units
- (i.e. MBO, MMCF, etc...)
- 22,29,36 C10-C12 Initial product prices per unit of pro-
- duction (i.e. $/bbl, $/mcf, etc...)
- 23,30,37 D10-D12 Production and severance tax in percent or
- dollars per unit of production. Use the
- negative sign if the entry is in dollars
- per unit of production.
- Example:
- For the state of Louisiana, P&S tax is 12.5%
- for the oil and 7 cents per mcf for the gas,
- the input will be: 12.5 for item 23
- -0.07 for item 30
- 24,31,38 E10-E12 Initial production in unit of production per
- month (i.e. BOPM, MCFPM, GAL/mo., etc..
- 25,32,39 F10-F12 Final production in units of production per
- month. If the entry is zero or left blank,
- the default value for this input is the
- actual economic limit (actual as opposed to a
- calculated economic limit that will be dis-
- cussed later in items 40 and 91).
-
-
-
-
-
-
-
-
-
-
- ITEM CELL DESCRIPTION
-
- 26,33 G10,G11 Product classifications are input according
- to the table below:
- Classification Oil Tier Gas Type
- 1 1 N/A
- 2 2 102
- 3 3 103
- 4 N/A 104
- 5 N/A N/A
- 6 N/A 106
- 7 N/A 107
- 8 N/A 108
- 9 Other Other
-
- 27,34 H10,H11 Gross number of wells for gas and oil. The
- number is used to calculate the operating
- cost using item number 15.
- 40 B13 There are three methods of declining major
- phase production. A code number (from 0 to 2)
- is put in B13 to use that type of decline.
- For subordinate phase decline see items 64 -
- 67.
-
- 0 When exponential decline is to be used
- and the decline rate is calculated by
- the program. In order to do so, the
- user has to input the remaining re-
- serves in thousands (item 41). The
- program then estimates the economic
- limit (calculated EL opposed to actual
- EL mentioned in items F10-F12.)
- 1 When exponential decline is to be used
- 2 When a simulated hyperbolic decline is
- to be used. This method used many con-
- tinuous portions of exponential decline
- of reducing declining rates and is much
- easier to use then hyperbolic decline.
- 2 Can also be used for any unconventional
- declining scheme, such as, one typical
- of a waterflood response where produc-
- tion increases, then levels out and
- finally starts to decline in a more
- conventional way.
-
- 41-46 C13-H13 Decline rates are input in percent. If the
- declining code (item 40) is 0, item 41 would
- be the gross reserves. If the declining
- code is 1, one entry to item 41 will be
- required. If the declining code is 2, up to
- six continuous portions of yearly exponential
- decline can be input. The decline rate for
- following years will be the same as the
- decline rate in the last (latest) entry,
- unless manually input. (For more informa-
- tion refer to manual inputting in Operating
- Section).
- Example:
- To calculate the exponential decline with
- known reserves of 40,000 Bbls (item 41) and
- initial rate (item 24):
- Item 40 41 42 43 44 45 46
- Entry 0 40
-
- For a well that will decline exponentially at
- an annual rate of 25%:
- Item 40 41 42 43 44 45 46
- Entry 1 25
-
- For a well that will decline 70% in the first
- year, 60% in the second year, 50% in the
- third year, 40% in the fourth year, 30% in
- the fifth year and 20% thereafter. (A number
- must be put in all related cell locations.):
- Item 40 41 42 43 44 45 46
- Entry 2 70 60 50 40 30 20
-
- 47 to C14 to Amount of gross investment in thousands of
- dollars, six locations are available for the
- first six years of well life. If it becomes
- necessary to input additional investments
- after the initial six years of well life,
- these investments will have to be input
- manually. All costs are expressed in today's
- dollar.
-
- Example:
- Input the following gross investment schedule
- YEAR AMOUNT($M)
- 1 100
- 2 0
- 3 100
- 4 0
- After 0
-
- B C D E F G
- Item 47 48 49 50 51 52
- Entry 100 0 100 0 0 0
-
- 54-59 B16,B17 After payout (APO) working interest in
- percent.
- 55-60 C16,C17 After payout, net revenue interest in
- percent.
- 56-6l D16,D17 Payout amount in thousand dollars or thou-
- sand units of production of the major phase.
- 57-62 E16,E17 Gross/Net payout indicator
- If payout is in gross amount, enter 1
- If payout is in net amount, enter 2
-
- 58-63 F16,F17 Dollar/Unit of production indicator
- If payout is in $M, enter 1
- If payout is in thousand unit of major phase,
- enter 2.
-
- Example for two payout reversions:
-
- For a well that will reverse to 50% WI and
- 40% NRI after PO of 250 $M gross and will
- reverse to 40% WI and 32% NRI after PO of
- 520 MB net, the input looks like this:
- Item 54 55 56 57 58
- Entry 50 40 250 1 1
- Item 59 60 61 62 63
- Entry 40 32 250 2 2
-
- 64-67 B18-C18 Optional ratios to major phase. Two initial
- ratios (items 64 and 66) and two final ratios
- (items 65 and 67) are included and should be
- input in unit/unit. These entries are
- particularly useful when the production
- ratios between the subordinate phases and the
- major phase are changing. The changing will
- be calculated logarithmically, meaning that
- if plotted on semilog paper, the ratio will
- decline (or incline) on a straight line.
- If the subordinate phase declines at the same
- rate as the major phase, put a 1 (one) in
- location B18 and C18. The ratio is major
- phase to subordinate phase production.
-
- Example:
- The condensate yield ratio of the appraised
- gas well is changing from 100 B/MMCF to 50
- B/MMCF, and the plant liquid yield ratio of
- the same well remains constant at 2 gal/MCF,
- the input will be:
- Item 64 65
- Entry .100 .050
- Item 66 67
- Entry 2
-
-
-
-
-
-
-
-
-
-
-
-
-
- ITEM CELL DESCRIPTION
-
- 68 B20 Adjustment factor is input as a value from
- 0 to 1 to reflect the risk associated with
- the reserves category of the appraised well.
- A reasonable adjustment factor would be:
-
- 1.00 for established proved producing wells
- 0.80 for established proved shut-in wells
- 0.60 for newly completed shut-in wells or
- behind pipe reserves
-
- OTHER INPUT
- 70 J13 Base price, in $/B, of tier 1 oil for Wind-
- fall Profit Tax consideration.
- 71 J19 Base price, in $/B, of tier 2 oil for Wind-
- fall Profit Tax consideration.
- 72 J15 Base price, in $/B, of tier 3 oil for Wind-
- fall Profit Tax consideration.
- 73 J2 Discount factor in percent.
- 74 J3 Inflation rate in percent, this inflation
- rate is used to calculate future value of an
- expenditure, of which the estimated cost is
- in today's dollar.
- 75-77 J6-J8 Ceiling prices of oil, gas and the third
- phase, respectively, in $/unit of production.
-
- Note: (1) If production and severance tax is to be in
- $/unit of production, a negative sign is
- required.
-
-
-
-
-
-
-
- OPERATING THE PROGRAM
-
- After the data has been input, the user has several options
- of which he can use one or more. These options are:
-
- 1. Revise the input. In this case, he needs to type the
- "home" key to move the cursor to location A1 and begin
- his revision from there.
-
- 2. The user thinks that the output is "correct", and he
- wants to make a hard copy of this output. Normally, he
- would have to set up a complex string of print commands
- to accomplish this. However, with the user defined
- functions (marcos in Lotus 123), he only needs to
- perform a few simple key strokes. These strokes, which
- are set up in a menu-driven fashion, will be discussed
- in the next chapter.
-
- 3. The user may also want to save his output onto the disk
- for future reference. Again, the user defined feature
- can be used to simplify the saving procedure.
-
- 4. To start a new case. In this case, the user wants to
- return to location A1 (by typing the "home" key) and
- begin to input another set of data to the screen.
-
- 5. Input part of the output (such as production and
- pricing schedule, number of the well...) manually.
- This action overrides the formulas and labels of the
- program. As a result, after manual inputting is used
- the user has to retrieve REAL again if he wants to
- use any of the erased formulas or labels.
-
- Some of the manual inputting changes you can make by year are as
- follows:
-
- 1. Working interest
- 2. Net revenue interest
- 3. Decline schedule
- 4. Schedule of production
- 5. Operating expenses
- 6. Investments
-
-
-
-
- OPERATING MENU
-
- The menu written for REAL can be shown as follows:
-
- (1) (2)
- [Alt A] [Alt B]
- PRINT SAVE FILE REPLACE FILE RUN MANUAL
-
-
- 1. "Alt A" gives the option to print the file, save the input
- and output portion of REAL, or to retrieve an already saved
- file so you can work with it again.
-
- 2. "Alt B" calculates the program, or use F9. The manual moves
- you to the section for manual input of production.
- rog