# The Oil and Gas Lender: companion files

Julian R. Sterling

## What is here

- **Oil_and_Gas_Lender_Model.xlsx**: the workbook that rebuilds the Pellridge case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Redfern Unit Economics, Reserve Report Jan 2025, Reserve Report Jul 2025, Reserve Report Jan 2026, Borrowing Base Bridge, Deficiency and Installments, Redfern Interest and Fees, Redfern Hedges, Redfern Covenants, SEC Price vs Bank Deck, PDP ABS Sizing, Thornmere Quarters, Thornmere Covenant Tests, Second Lien Returns, Haskett Restructuring, Pellridge Book, Checks.
- **Oil_and_Gas_Lender_Toolkit.docx**: the sixteen checklists of Appendix 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, portfolio monitoring checklist), in editable form.

## Which sheet answers which chapter

- Chapter 2: Redfern Unit Economics (a realized price of $61.00 and a margin of $35.75, rounded, before fixed costs at the April 2026 deck)
- Chapters 4, 5, 7 and 8: Reserve Report Jan 2025, Reserve Report Jul 2025, Reserve Report Jan 2026 (total unrisked PV9 of $823,006,513, $536,843,667 and $814,650,160, all rounded)
- Chapter 5: SEC Price vs Bank Deck (PV10 of $900,616,605, rounded, at the case SEC-style prices)
- Chapters 7 and 8: Borrowing Base Bridge (bases of $320,000,000, $235,000,000 and $335,000,000, and the two fall 2025 counterfactuals)
- Chapter 8: Deficiency and Installments (a $30,000,000 deficiency cured in six installments of $5,000,000); Redfern Interest and Fees (Pellridge earns $6,034,544, rounded)
- Chapter 9: Redfern Hedges (Redfern pays its counterparties a net $23,100,000); Redfern Covenants (leverage of 1.65x and 1.20x, both rounded)
- Chapter 10: Second Lien Returns ($196,000,000 paid for $200,000,000 of principal; gross multiple 1.11x and IRR 12.5 percent, both rounded)
- Chapter 11: Thornmere Quarters, Thornmere Covenant Tests (leverage from 2.21x to 2.62x; asset coverage 1.54x against a 1.50x minimum, all rounded)
- Chapter 12: PDP ABS Sizing (notes of $277,244,584, rounded, a counterfactual)
- Chapters 14 and 15: Haskett Restructuring (plan value $640,000,000; notes claim $526,798,611 and implied recovery 45.6 percent, both rounded)
- Conclusion: Pellridge Book ($140,000,000 committed, $95,000,000 drawn and $6,834,739, rounded, of income)

## Two inputs to change first

1. On Inputs, lower the WTI price of the October 2025 deck: watch the July 2025 report's values on Reserve Report Jul 2025, then the fall base on Borrowing Base Bridge, the deficiency and its installments on Deficiency and Installments, and the interest on Redfern Interest and Fees.
2. On Inputs, lower Selbrook's gas deck: watch the asset coverage ratio fall toward its 1.50x minimum on Thornmere Covenant Tests. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Pellridge, Redfern, Thornmere, Selbrook, Haskett and every other name in the case are fictional; the model is a simplified teaching model; rules are general and dated October 2026; all case prices, volumes, costs, rates and figures are illustrative assumptions, not market data or benchmarks. Provided as is, without warranty. Not investment, legal, tax, engineering or accounting advice.
