Companion files · The Private Markets Career Guides

The Commodity Trade Finance Lender

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 workbook, the toolkit and the read-me, in one archive77 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

HeadroomA 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 stock50,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 coverQuillmar'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.