Companion files · The Private Markets Career Guides

The Oil and Gas Lender

How Banks and Credit Funds Lend Against Oil and Gas Reserves: Borrowing Bases and Redeterminations, Reserve Reports, Hedging, Second-Lien Loans, PDP Securitizations, Restructurings and the Career.

These are the companion files of the book. One workbook rebuilds the Pellridge case: Redfern’s netback per barrel, its three reserve reports run block by block to the economic limit, the three borrowing bases with hedge credit and the PDP check, the fall 2025 deficiency and its six installments, interest and fees day by day, the swap settlements and the covenants, the January 2026 report at case SEC-style prices, a PDP securitization counterfactual, Thornmere’s quarters, leverage and asset coverage, Selbrook’s second-lien returns, Haskett’s restructuring and recoveries, and Pellridge’s book. A toolkit holds the sixteen checklists of Appendix B in an editable form.

The workbook, the toolkit and the read-me, in one archive460 KB

The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.

The files

Three numbers to reproduce first

The oil producer’s baseCut from $320,000,000 to $235,000,000 in the fall of 2025 with $265,000,000 drawn; a $30,000,000 deficiency repaid in six installments of $5,000,000; raised to $335,000,000 in May 2026
The second lien$196,000,000 paid for $200,000,000 of principal; asset coverage of 1.54x against a 1.50x minimum on 30 June 2026; gross multiple 1.11x and IRR 12.5 percent (all rounded)
The prepackaged chapter 11A $640,000,000 plan value, $400,000,000 of exit debt and $240,000,000 of equity for a notes claim of $526,798,611: an implied recovery of 45.6 percent (both rounded)

The files are provided as they are, without warranty of any kind. The model is illustrative: Pellridge, Redfern, Thornmere, Selbrook, Haskett and the other names are fictional, the model is simplified, the rules are general and dated October 2026, and the prices and figures are the book’s assumptions, not market data or benchmarks. Nothing here is investment, legal, tax, engineering or accounting advice.

Also by Julian R. Sterling

More in credit and debt, with free companion files. The full list of titles is on the author page.

Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.

Also available as a standalone free template: reserve-based lending (RBL) model.