Multi-State Severance Tax Estimator: Oil/Gas Production Tax by State with Rate Tables
Estimate oil and gas severance tax by US state with built-in rate tables, monthly production input, and annual effective rate benchmarking.
TAGLINE
Estimate oil and gas severance tax by US state with built-in rate tables, monthly production input, and annual effective rate benchmarking.
WHO IT'S FOR
Production accountants and asset analysts estimating state severance tax on oil and gas volumes.
WHAT IT DOES
Applies state oil and gas severance rates to monthly production and revenue, supports high-cost gas and enhanced-recovery exemption flags, and benchmarks each of six states on its own rates. Per-Mcf gas taxes (North Dakota, Louisiana) are applied to volume. Rates are illustrative defaults: confirm them against current state law.
TABS INCLUDED (8)
• Instructions & Legend • Production Input • State Rate Tables — TX, OK, ND, NM, LA, WY • Tax Calculation • Exemptions • Annual Summary — six-state benchmark table and charts • Oil vs Gas Tax Chart — monthly comparison • Summary
KEY FORMULAS
Tax = value × state rate (per-Mcf states: Mcf × $/Mcf), less exemptions; effective rate = tax / (oil revenue + gas revenue)
TECHNICAL SPECS
• Excel 2016+; 110+ formulas; 12-month production sample; 6 states • MDT professional color scheme throughout • Yellow cells = inputs; white cells = formulas
ABOUT RESERVOIR RISK SOLUTIONS
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. www.reservoir-risk-solutions.com
What you get
- Instant workbook access after payment in your Excel Library
- Formula-driven worksheet designed for petroleum workflows
- No recurring fees and no plugin requirements
Licence
Single-user licence: the purchaser may use and modify this workbook for their own work, including work for their employer and clients. It may not be resold, shared publicly or redistributed as a template. Results are engineering estimates for screening and must be checked by a qualified professional before they are relied on.
FAQ
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.
