Oil Price Stress Test: What $60 Oil Does to a Well's Payback

Somewhere right now a pitch deck is pricing a well at whatever oil fetched the week the cover slide was made, and the investor reading it is doing the sum at that number. Then oil loses twenty dollars a barrel, as the EIA's annual Brent averages show it did between 2019 and 2020, and the payback date on page four stops being a date. The card below is the question I wanted answered before signing anything: hold the same well at $60, at $75 and at the price on this page, every barrel at that price for the well's whole life, and see which rows pay the stake back and which never do.

This oil price stress test is a simplified demo of the full calculator at revenue.pcdrama.com: two fixed prices, one price you can type, one investment, and four well-stage presets that set how fast production falls. The table below says what each row holds still and what it lets move, and the section after it reports what the four presets did to payback at $60 and $75 when I ran them.

We ran the engine behind this card at every well-stage preset and both fixed prices on October 15, 2026, and the result that surprised me was that the oil price did not decide whether the well pays back. The decline did. At the New shale preset, 65% a year, the example stake never recovers at $60 or at $75: production stops the month its revenue no longer covers its share of the operating cost, at month 52 for $60 and month 54 for $75, and the cumulative cash line flattens out under the investment line without crossing it. At the other three presets, and at the example program's 15%, both prices pay back, and the well runs until its 100,000 barrels are gone.

Method: fifteen runs of the engine ported from the full calculator, five decline rates times three prices, with every other default held: 150 barrels a day, 100,000 barrels of reserves, a 12.5% landowner royalty, Texas severance tax and $2,500 a month of operating cost for the whole well. The runs are committed as the fixture file the card's own tests check against, so this page and the card read from one copy of the arithmetic. To repeat a row, press a stage button on the card and read that row's "Paid back by" line; "Not within the life of the well" is the line that mattered.

Two more things fell out of the same runs. Doubling the stake doubled the dollars returned and left the payback date exactly where it was, because each unit buys the same slice of the revenue and the same slice of the bills. And a lower price shortened the well's life only at the steepest decline; everywhere else the reserves ran out first, so the price changed how much each month paid and nothing about how many months there were.

We measured this on our own calculator: a steeper first year can take a well from paying back at both prices to paying back at neither, before the oil price has moved at all.

The rows that never pay back do not show a zero. They show a total recovery smaller than the stake, because the well keeps producing and the checks keep arriving, each one a little smaller than the last. The projection has two stopping rules. The first is the reserve estimate: when the 100,000 barrels are produced, the well is done, which is how every preset except New shale ends. The second is the economic limit: the first month whose net cash flow is zero or below, when the investor's share of revenue no longer covers the investor's share of the $2,500 operating cost, and the model shuts the well in. At 65% a year the curve gives out before the rock does, so the economic limit arrives at month 52 or 54 with barrels still in the ground.

Total recovery on the card is cumulative net cash received, including getting the investment back, which is why a row can read as recovered and still be a poor return, or read as never recovered while having sent most of the money home. The chart draws the selected row's cumulative cash from $0 against a dashed line at the investment, and the payout marker only appears where the curve crosses it. On a New shale row at $60 the curve flattens underneath the line and the caption says the investment is not recovered, which is the picture the pitch deck never includes.

The four buttons are effective yearly declines, meaning the share of today's production that is gone a year from now, and each one is pinned to a published figure. The Journal of Petroleum Technology's "Life after 5" reported that wells in the main shale plays commonly lose more than half their output in the first year and about 30% in the second, and that Permian and Bakken horizontal wells still average about 17% a year at year five, against the old assumption that declines settle to 5% to 10% after that. The IEA's 2025 study of decline rates across about 15,000 fields put conventional oil at 5.6% a year after peak, which is where the 8% conventional preset sits, rounded toward the small fields that decline faster.

The standard he means is the one most spreadsheets still carry, a steep start that calms down to a conventional well's pace after five years. The presets let you price a well the way the data describe it rather than the way the assumption does, and the first button is the one to press before the others, because a well in its first year is the one most pitch decks are selling.

"Open the full calculator" takes the row you selected with it: the investment after the program's $50,000 minimum and $4,000,000 cap are applied, the selected row's oil price, the active decline, and the page's gas price, gas rate, reserves, royalty and severance rates. What it cannot carry is the operating cost, because the full calculator reads that from its own program terms, and the two can differ. The example on this page charges the whole well $2,500 a month; the full calculator uses whatever its program settings say. The line under the link says so, and the month-by-month table you will find there is the place to check how far the two drift.

If the row you want to argue about is the one that never pays back, type a price into the third row instead of guessing: the chart redraws for your price, the link rebuilds from it, and the question for the sponsor writes itself. The oil and gas investment calculator this page hangs off covers the other three numbers that decide a well, the production rate, the reserves and who gets paid before you, plus the tax rules the 2022 version of that page got wrong.

• JPT: Life After 5, how tight oil wells grow old
• JPT: Permian Basin decline rates have increased amid the slowdown
• IEA: The implications of oil and gas field decline rates (2025)
• Dallas Fed: Energy Indicators, May 2025, with the survey's break-even prices
• EIA: annual Brent and WTI spot prices
• PCDrama: every formula behind the full calculator

The decline figures come from the Society of Petroleum Engineers' journal and the International Energy Agency, and the break-even context from the Federal Reserve Bank of Dallas, which surveys energy executives every quarter.

This stress test is for illustration only. Its results are not investment, tax or legal advice and do not promise any rate of return or cash flow, so talk to a CPA familiar with oil and gas before you invest.

Sources: JPT, Life After 5, JPT, Permian Basin decline rates, IEA, The Implications of Oil and Gas Field Decline Rates, Dallas Fed Energy Indicators, May 2025, EIA spot prices