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.    
       
                   

 
Proven Concepts, Inc., PO Box 2267, Frisco, Texas, 75034 Tel: 972 529-1253, Fax: 214 592-9881