Companion files · The Private Markets Career Guides
Borrowing Bases, Transactional Facilities, Pre-Export Finance, Repo and Collateral Control: Lending to Oil, Metals and Agricultural Traders.
These are the companion files of the book. One workbook rebuilds the commodity desk of Brantholm Bank, the fictional lender of the case, and its three fictional borrowers: Kessring Petroleum's borrowing base of $146.20 million and its availability, one gasoil cargo financed from purchase to payment, Tolvane Grains' wheat repo and Quillmar Mining's $120.00 million pre-export facility, quarter by quarter. It then breaks them with price, volume and fraud scenarios, and ends with self-checks. A toolkit holds the 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 3 to 13, and Appendix A
An Inputs sheet holds every assumption of the case, dates included, and one sheet follows each step of the book: Calendar, Borrowing Base, Availability, Cargo, Repo, Pre-Export, Scenarios, Income. The last sheet ends with self-checks and puts the figures printed in the book beside the cells that compute them, and the 10 exercises of Appendix A run on it.
Download the workbook39 KBAppendix B
Know your trader (chapter 3); Reading a trader's accounts (chapters 2 and 3); The security package (chapter 4); A cargo before drawing (chapter 5); The borrowing base certificate (chapters 6 to 8); A pre-export facility (chapter 9); Warehouses, collateral managers and inspection (chapters 10 and 11); Fraud red flags and the response (chapters 12 to 14).
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| Headroom | A borrowing base of $146.20 million against a committed amount of $140.00 million gives availability of $140.00 million and, with $128.00 million drawn, headroom of $12.00 million, not $18.20 million |
| Diverted stock | 50,000 tonnes of pledged gasoil sold without the proceeds reaching the collection account take the borrowing base to $114.70 million and open a deficiency of $13.30 million |
| Lowest cover | Quillmar's cover is 2.33x at the peak quarter; with copper down 30 percent and production down 40 percent it falls to 0.98x, and the debt service does not move |
The files are provided as they are, without warranty of any kind. The model is illustrative: Brantholm Bank, Kessring Petroleum, Quillmar Mining, Tolvane Grains and every other party are fictional, and prices, volumes, advance rates, haircuts, rates, fees and dates are the book’s assumptions, not the terms of any real bank, trader, producer or facility, the quote of any real market or a forecast. Nothing here is legal, credit or investment advice.