# The Carbon Markets Professional: companion files

Julian R. Sterling

## What is here

- **Carbon_Markets_Professional_Model.xlsx**: the workbook that rebuilds the Orrinmoor case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Case Prices, Brennholt Position, Brennholt Hedge Program, Brennholt Cost and Accounting, Trading Book P&L, Stress and Margin, Option Quote, Kerrowan ERPA and Delivery, Integrity Score, Aurelline Sale and Inventory, Desk Risk Report, Checks.
- **Carbon_Markets_Professional_Toolkit.docx**: the sixteen checklists of Appendix 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, Article 6 authorization checklist), in editable form.

## Which sheet answers which chapter

- Chapter 8: Case Prices (the December 2026 contract fell 13.4 percent, rounded, from 31 March to 14 April 2026; the December 2027 contract stood 2.4 percent, rounded, above December 2026 on 30 September 2026)
- Chapters 3 and 5: Brennholt Position (free allocation of 1,462,500 after the 97.5 percent CBAM factor in 2026; a 2026 shortfall of 320,000 after the 30 June 2026 revision, 337,500 before it)
- Chapter 6: Brennholt Hedge Program (four tranches at an average of €79.025; hedge ratios of 29.6 (rounded), 59.3 (rounded), 87.5 and 100.0 percent; 2027 hedged at 17.4 percent, rounded)
- Chapter 7: Brennholt Cost and Accounting (€25,288,000 in all, €10.54 per tonne of cement, rounded; €264,000 below the same volume at the €79.85 settlement)
- Chapter 9: Trading Book P&L (quarterly P&L of €1,525,000, €2,746,000, minus €3,705,000 and €385,000; €951,000 for the year)
- Chapter 10: Stress and Margin (a quarter-to-date loss of €4,445,000 on 14 April 2026 against a €4,000,000 limit; €2,320,000 of client hedge variation margin; exposure to Brennholt of €1,030,000; net cash outflow €5,390,000)
- Chapter 11: Option Quote (a €75.00 put at €10.24 per allowance, rounded; a zero-cost collar in which Brennholt would hold a €92.01 call, rounded, and sell the put)
- Chapters 12 and 14: Kerrowan ERPA and Delivery (181,500 credits issued, 82.5 percent of the estimate; $1,724,250 paid at $9.50)
- Chapter 13: Integrity Score (average 3.80, grade B, at the ERPA; 4.40, grade A, after the letter of authorization)
- Chapter 15: Aurelline Sale and Inventory (150,000 credits at $16.40; gross margin $1,035,000; 31,500 credits in inventory at $15.20)
- Desk Risk Report: position, P&L, margin, exposure and hedge ratio at the four quarter ends; no red reading at any quarter end

## Two inputs to change first

1. On Inputs, lower the 14 April 2026 settlement of the December 2026 contract: watch the quarter-to-date loss, the variation margin, the exposure to Brennholt and the net cash outflow move together on Stress and Margin.
2. On Inputs, change the 2027 CBAM factor: watch the 2027 shortfall on Brennholt Position, the 2027 hedge ratio and the volume still to buy on Brennholt Hedge Program. Reset the inputs afterwards: the Checks sheet compares 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. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Orrinmoor Energy Trading, Brennholt Zement, Aurelline Airways, the Kerrowan project and every other name in the case are fictional; the model is a simplified teaching model; rules are general and dated October 2026; all case prices and figures are illustrative assumptions, not market data or benchmarks. Provided as is, without warranty. Not investment, legal, accounting or tax advice.
