Royalty_check_reconciliation_calculator.xlsx
Morrison
Royalty Check Reconciliation Calculator
Instructions
(Note:
Input values are shown in yellow and calculated values are shown in blue)
Col. 2:
Enter the monthly gas volume in Mcf and monthly oil/liquid volume in barrels.
Col. 3:
Enter the gas price in $/Mcf and oil/liquid price in $/bbl.
Col. 4:
This is the calculated gross production value (Col. 2 x Col. 3 = Col. 4).
Col. 5:
Enter value of total monthly production taxes.
Col. 6:
Enter other lease and marketing cost adjustments as a positive value.
Col. 7:
This is the net value of oil and gas production (Col. 4 - Col. 5 - Col.6 = Col. 7).
Gross Production Values
1
2
3
4
5
6
7
Production Type
Monthly Production Volumes
Production Prices
($/Mcf-bbl)
Production Gross Value
($)
Production Taxes
($)
Other Adjustments ($)
Production Net Value
($)
Gas (Mcf)
Liq. (bbls)
Totals
Royalty Owner's Net Values
Owner's Decimal Interest
8
9
10
11
12
13
14
Production Type
Monthly Production Quantity
Production Prices
($/Mcf-bbl)
Production Gross Value
($)
Production Taxes
($)
Other Adjustments ($)
Production Net Value
($)
Gas (Mcf)
Liq. (bbls)
Totals
This royalty check reconciliation calculator is provided by Proven Concepts, Inc. for estimating purposes only and its answers are based on the information you provided.
For a more detailed analysis of your check record information please contact Proven Concepts, Inc.
The browser does not support JavaScript. The calculations created using
SpreadsheetConverter
will not work. Please access the web page using another browser.
Proven Concepts, Inc., PO Box 2267, Frisco, Texas, 75034 Tel: 972 529-1253, Fax: 214 592-9881
