# The Commodity Trade Finance Lender: companion files

Julian R. Sterling

## What is here

- **Commodity_Trade_Finance_Model.xlsx**: the workbook that rebuilds the Brantholm case and reproduces the figures of the book with live formulas. Sheets: Inputs, Calendar, Borrowing Base, Availability, Cargo, Repo, Pre-Export, Scenarios, Income.
- **Commodity_Trade_Finance_Toolkit.docx**: the 8 checklists of Appendix 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)), in editable form.

## Which sheet answers which chapter

- Inputs and Calendar: every assumption and every case date; day counts computed from the dates (Appendix A)
- Chapter 6: Borrowing Base (Kessring's certificate at 31 October 2026, line by line: borrowing base $146.20 million; Kessring's gearing at the same date for chapter 3)
- Chapter 7: Availability (the lower of the borrowing base and the committed amount: $140.00 million; headroom $12.00 million, and the wrong answer shown for training)
- Chapter 5: Cargo (a loan of $22.05 million, exposure $22.21 million at maturity, line usage, buyer default and a misdescribed cargo)
- Chapter 10: Repo (purchase price $7.48 million, repurchase $7.60 million, margin call $0.75 million, missing stock)
- Chapter 9: Pre-Export (Quillmar quarter by quarter: peak debt service $12.25 million, lowest cover 2.33x, break-even copper prices)
- Chapters 8 and 13: Scenarios (fuel oil price down, diverted stock with a deficiency of $13.30 million, copper price and volume shocks down to 0.98x)
- Income: what Brantholm earns before costs (borrowing base facility $3.34 million a year), then the self-checks
- Appendix A: 10 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Inputs, raise the committed amount from $140.00 million to $160.00 million: the borrowing base becomes the binding limit, and headroom rises to the figure that was wrong in the base case.
2. On Inputs, lower the copper price deck, then the tonnes sold a quarter, by the same proportion: cover falls by almost the same amount each time, because a pre-export lender carries volume risk as well as price risk. Reset the inputs afterwards: the checks at the end of the Income sheet compare 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. Every input, dates included, is on the Inputs sheet. No macro, no circular reference, no external link. The result cell at the end of the Income sheet should read ALL CHECKS OK on the default inputs.

Brantholm Bank, Kessring Petroleum, Quillmar Mining, Tolvane Grains and every other party in the case are fictional; prices, volumes, advance rates, haircuts, rates, fees and dates are teaching assumptions, not the terms of any real bank, trader, producer or facility, the quote of any real market or a forecast. Provided as is, without warranty. Not legal, credit or investment advice.
