Estimate oil and gas severance tax by US state with built-in rate tables, monthly production input, and annual effective rate benchmarking.
Multi-State Severance Tax Estimator — Oil/Gas Production Tax by State with Rate Tables
$59 USD — one-time purchase
Estimate oil and gas severance tax by US state with built-in rate tables, monthly production input, and annual effective rate benchmarking.
Production accountants and asset analysts estimating state severance tax on oil and gas volumes.
Applies state oil and gas severance rates to monthly production and revenue, supports exemption flags, and benchmarks effective tax rates across six states. Dedicated crossplot tabs support visual QC of model vs measured data.
• Instructions & Legend • Production Input • State Rate Tables — TX, OK, ND, NM, LA, WY • Tax Calculation • Exemptions • Annual Summary • Tax Rate Chart — effective rate by state • Oil vs Gas Tax Chart — monthly comparison • Summary
Tax = volume × price × state rate; effective rate = tax/revenue
• Excel 2016+; 320+ formulas; 12-month production sample; 6 states • MDT professional color scheme throughout • Yellow cells = inputs; white cells = formulas
7-tab severance tax estimator: multi-state rates, monthly calc, annual benchmark. Includes QC crossplots with 1:1 reference lines.
severance tax, production tax, Texas, Oklahoma, state tax
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. reservoirrisksolutions.com
TITLE: Severance Tax Excel Estimator | Multi-State Oil Gas Production Tax Rate Tables PRICE: $59 USD — suggested; set your price in Etsy shop manager TAGS: severance tax, production tax, Texas Oklahoma, state tax calculator, oil gas accounting, Excel template, petroleum accounting, tax estimator, monthly production, digital download, energy accounting
Professional Excel workbook for upstream engineers. Applies state oil and gas severance rates to monthly production and revenue, supports exemption flags, and benchmarks effective tax rates across six states. Dedicated crossplot tabs support visual QC of model vs measured data.
Who it's for: Production accountants and asset analysts estimating state severance tax on oil and gas volumes.
What's included: • Instructions & Legend • Production Input • State Rate Tables — TX, OK, ND, NM, LA, WY • Tax Calculation • Exemptions • Annual Summary • Tax Rate Chart — effective rate by state • Oil vs Gas Tax Chart — monthly comparison • Summary
Technical specs: Excel 2016+; 320+ formulas; 12-month production sample; 6 states. Excel 2016+, no plugins, sample data pre-loaded.
About Reservoir Risk Solutions — built by petroleum engineers. reservoirrisksolutions.com DIGITAL_DELIVERY: Instant download — Excel .xlsx file
Is this a one-time purchase?
Yes. Each workbook is sold as a one-time purchase with no recurring subscription.
How do I access purchased files?
After checkout, your file appears in Excel Library under your account for download.
Do these templates require macros or plugins?
No. Templates are designed for Excel 2016+ and do not require VBA macros or external add-ins.