Companion files · The Private Markets Career Guides
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 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.
Chapters 2 to 15 and the conclusion
One Inputs sheet holds every case assumption: price decks and case prices, the decline shape, Redfern’s terms, reports, drilling schedules, swaps and compliance certificates, Thornmere’s quarters, swaps and reserve run, the second lien and Haskett’s terms. One sheet per question, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook461 KBAppendix B
Reserve report review checklist, price deck checklist, borrowing base memo checklist, redetermination checklist, deficiency and cure checklist, credit agreement covenant checklist, hedging program checklist, second-lien term sheet checklist, intercreditor checklist, PDP securitization checklist, mineral and royalty collateral checklist, early warning checklist, forbearance and restructuring support checklist, DIP and plan review checklist, ESG and plugging and abandonment checklist and portfolio monitoring checklist.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me4 KB| The oil producer’s base | Cut 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 11 | A $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.
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.