Articles

How much borrowing base does a three-year oil hedge add, and how much cash flow does it protect?

Lenders count a hedge at its value at their price deck. It lifts the base today and protects cash flow if the price falls, but only for the years it covers.

A swap on 50% of production in years 1 to 3 at $75 a barrel is worth $10.26m at a $65 deck and adds $6.67m of borrowing base, from $83.48m to $90.14m against an $85.0m loan. If the price falls to $45, year-1 debt service cover is 1.61x with the hedge and 0.98x without it.

The assumptions

Illustrative producing-property loan, invented figures
ItemValue
Proved developed production1,000 thousand barrels in year 1, declining 20% a year for 8 years
Lender price deck$65 a barrel, flat
CostsLease operating cost $18 a barrel; severance and production taxes 8% of revenue
Borrowing base65% of the present value of net cash flow at 10%
Loan$85.0m at 8.0%, repaying 20% of the original balance a year
HedgeSwap on 50% of production in years 1 to 3 at $75 a barrel, valued at the deck and counted by the lender

Step 1: the borrowing base without the hedge

Net cash flow a year = volume × (65 × (1 − 8%) − 18) = 1,000 × 42.20 = $41.8m in year 1, falling with the 20% decline

Present value at 10% over 8 years = $128.43m; borrowing base = 65% × 128.43 = $83.48m

Excel, cash flows in B6:I6: =0.65*NPV(0.10,B6:I6)

The loan of $85.0m is above the $83.48m base, a deficiency of $1.52m, which the borrower would have to cure by repaying, pledging more reserves or adding hedges.

Step 2: the hedge credit

Hedged volume = 50% of 1,000 = 500 thousand barrels in year 1, 400 in year 2 and 320 in year 3

Swap value at the deck = volume × (75 − 65): $5.00m, $4.00m and $3.20m, with a present value of $10.26m

Borrowing base with hedge = 65% × (128.43 + 10.26) = $90.14m, an increase of $6.67m

The hedge turns a $1.52m deficiency into headroom of $5.14m. The lender counts the swap because the price is locked for those barrels.

Step 3: what happens when the price falls

Borrowing base and year-1 cover at different decks
Price deckBase, no hedge, $mBase with hedge, $mHeadroom with hedge, $mYear-1 cover, no hedgeYear-1 cover with hedge
$6583.4890.145.141.76x1.97x
$6074.2984.29−0.711.56x1.88x
$5565.1178.44−6.561.37x1.79x
$5055.9272.58−12.421.18x1.70x
$4546.7366.73−18.270.98x1.61x

Debt service in year 1 is 8.0% × 85.0 + 20% × 85.0 = $23.8m. At $45 the unhedged cash flow of $23.4m covers it only 0.98 times, while the hedge adds $15.0m and holds cover at 1.61 times. The base with hedge falls to $66.73m, below the loan, so the hedge protects cash flow before it protects the base.

What if: the hedge is larger, shorter or the price rises

Hedge terms at a $65 deck and at $45
CaseBase at $65, $mBase at $45, $mYear-1 cover at $45
No hedge83.4846.730.98x
30% hedged, 3 years87.4858.731.36x
50% hedged, 3 years (base)90.1466.731.61x
70% hedged, 3 years92.8174.731.87x
50% hedged, 2 years88.5862.041.61x
50% hedged, 5 years92.1172.621.61x

Hedging 70% of production lifts the base at $65 to $92.81m and raises year-1 cover at $45 to 1.87x, at the price of more upside given away. If the price rises to $85 the 50% hedge gives up $5.0m in year 1, 8.3% of the $60.2m of year-1 cash flow before the hedge. Lenders usually cap hedges at 70% to 80% of proved developed production, and the model ignores counterparty risk and basis differentials.

The common mistakes

Takeaway

Questions readers ask

How does a hedge increase a reserve-based borrowing base?

The lender adds the present value of the swap at its price deck to the present value of the reserves. Here that is $10.26m, which at a 65% advance rate adds $6.67m of base.

Does an oil hedge protect the borrowing base if prices fall?

Only partly. At a $45 deck the base with hedge is $66.73m, still $18.27m below an $85.0m loan, because the hedge covers only three of eight years.

What is the cost of hedging a producer’s oil?

The upside given away. At $85 a barrel the 50% swap costs $5.0m in year 1, 8.3% of year-1 cash flow before the hedge.

The workbooks behind this article

The free companion files for The Oil and Gas Lender rebuild a fictional bank’s three oil and gas files: reserve reports run to the economic limit, three borrowing bases with hedge credit, a deficiency and its cure, covenants and a prepackaged chapter 11. The figures in this article use invented inputs and are not in them. No account and no email address.

Open the companion files →

Not on Amazon: 11 paperbacks by Julian R. Sterling on banking, credit and payments, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: credit, private credit and distressed debt → · All 1908 articles →