Companion files · The Private Markets Career Guides

The Carbon Markets Professional

How Emissions Trading Really Works: EU ETS Compliance and Hedging, Allowance Trading, Voluntary Credits and Integrity, CORSIA, Article 6 and the Career.

These are the companion files of the book. One workbook rebuilds the Orrinmoor case: the case prices and the carry, Brennholt’s free allocation after the CBAM factor, its shortfall, hedge program, hedge ratios and average cost, the trading book’s positions and quarterly P&L, the April 2026 stress with its margin calls and client credit exposure, the option quote and the zero-cost collar, Kerrowan’s delivery and integrity score, the resale to Aurelline and the desk’s quarterly risk report. A toolkit holds the sixteen checklists of Appendix B in an editable form.

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

Brennholt, a cement producerA 2026 shortfall of 320,000 allowances after the CBAM factor and a revision, fully hedged in four tranches at an average of €79.025, €10.54 per tonne of cement (rounded)
The EUA trading book€951,000 over four quarters, and a quarter-to-date loss of €4,445,000 on 14 April 2026 against a €4,000,000 limit, with a net cash outflow of €5,390,000 in the fortnight
Kerrowan and Aurelline181,500 credits issued, 82.5 percent of the estimate, bought at $9.50; 150,000 resold at $16.40 for CORSIA, a gross margin of $1,035,000

The files are provided as they are, without warranty of any kind. The model is illustrative: Orrinmoor, Brennholt, Aurelline, the Kerrowan project 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, accounting or tax advice.

Also by Julian R. Sterling

More in infrastructure and energy, 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.