Companion files · The Private Markets Career Guides
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 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 15
One Inputs sheet holds every case assumption: the case settlement prices, Brennholt’s allocation, CBAM factors, emissions, hedging policy and forwards, the trading book’s trades, limits and margin rates, the option terms, Kerrowan’s ERPA, estimates, marks and scores, and the sale to Aurelline. One sheet per question, a Desk Risk Report that colors every status, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook49 KBAppendix B
Compliance position checklist, free allocation and CBAM factor checklist, hedging policy checklist, forward confirmation checklist, daily position and P&L checklist, margin and liquidity checklist, client credit checklist, limit breach escalation checklist, option quote checklist, accounting policy checklist, project due diligence checklist, integrity scoring checklist, ERPA terms checklist, issuance and registry delivery checklist, CORSIA sale checklist and Article 6 authorization checklist.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me4 KB| Brennholt, a cement producer | A 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 Aurelline | 181,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.
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.