Companion files
Authorised Declarant Status, Embedded Emissions, Certificates and Supplier Data
These are the companion files of The CBAM Compliance Handbook by Julian R. Sterling.The book on Amazon →
One Excel workbook, corrected where it was wrong. Chapter 10 builds a cash-flow model and stops one step short of the year that matters: it warns that budgeting only the 2026 lump sum understates 2027 “substantially”, and leaves the word where the number should be. The workbook supplies the number, sizes the buffer the chapter recommends and never sizes, finds a term the surrender formula counts twice, and closes on 35 checks, every one green. Around it: a blank version for your own imports, thirteen working documents to print, forty questions that mark themselves, and three cases the book names and never takes to a number. All free. Nothing is gated behind a sign-up, and no email address is asked for.
Six workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 24 September 2026.
Reading the paperback or the Kindle edition? The same book is also sold as a DRM-free PDF: searchable, printable, yours on any device. $19.99, instant download.Buy the PDF edition → Free sample
Finished the book? Two or more PDF editions bought together are 15% off. Browse the PDF editions →
The working models behind the books, built out for live deals: the Pro models →
Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.
Join the reader listRun by MailerLite, off this site. How your address is used.
Appendix F · Chapters 10, 11 and 13
“Substantially” is a factor of exactly two. Certificates cannot be bought before 1 February 2027; the 2026 obligation is surrendered by 30 September 2027; and through the same year the declarant is building holdings against 2027 imports at each quarterly checkpoint. On one calendar that is €6,750 in March, €8,100 in June, €6,075 plus €27,063 in September, €6,075 in December — €54,063 against a lump sum of €27,063. A treasurer who budgets only the lump sum has budgeted 50.1 per cent of the year. And the two is structural, not coincidental: the factor doubles while the checkpoint is a half, so half the 2027 obligation is exactly the whole of the 2026 one.
The surrender formula counts one term twice. Step four of chapter 10 says it applies the CBAM factor and the free-allocation adjustment. Its own table applies the factor and nothing else — 14,400 × 2.5 per cent = 360, with no room for a second multiplier, so the implied adjustment is exactly 1.00. The table is right: chapter 11 sets the factor and the retained free allocation as complements, so the factor already carries the adjustment. But chapter 11 also states the formula as five separate terms including that adjustment. A reader who builds from the formula arrives at a smaller obligation than the chapter’s own worked example — and under-declaring is what Article 26(1) sanctions.
The cap the chapter warns about does not bind. Hold O(1+b), surrender O, repurchase O×b, cap O. The cap binds only above a buffer of 100 per cent of the obligation. At ten, twenty or fifty it does not bind at all. What binds is the 31 October deadline — a diary entry with an owner, not a financial constraint, and it should not be priced like one.
Which makes the buffer close to free, and the decision independent of the penalty. Thirty-six certificates cost €2,700 and, carried eight months at five per cent, cost €90. The break-even probability of a shortfall does not depend on the buffer size — carry and protection scale together, so the ratio is identical at five per cent and at thirty. And expressing the penalty as a multiple of the certificate price puts the break-even between 3.3 and 0.7 per cent across the whole plausible range, so the decision never needs the indexed figure chapter 13 rightly refuses to print.
And €3.40 a tonne becomes €65 by 2030. Same book of imports, same intensity, same price — only the factor moves: €13.50 in 2028, €30.38 in 2029, €65.48 in 2030, €135.00 in 2034. Nineteen times by 2030, which is inside the horizon of every supply contract being signed now. The workbook also tests chapter 11’s claim that four fifths of the increase falls after 2029: it is 79.5 per cent, exact to a tenth of a point, and the verdict cell prints CONFIRMED. Thirty-five checks.
Revised: the 2030 cost a tonne is €65.48, not €65.47 (65.475 rounds up, as 30.375 did for 2029); three inputs are ADDED, not four, because the forward price of 75 is the chapter’s own; three checks that read only the first row of their range in Excel now test every row; and seven checks are added.
Download the workbook21 KBGo to sheet 4 and read the last two rows. Then replace Northbeck’s four volume cells on sheet 1 with your own quarterly imports and the intensity with your own supplier figure: everything downstream is linear, so the whole calendar rescales in five keystrokes. Then go to sheet 5 and change the penalty multiple — the break-even column closes the argument about whether to hold a buffer without anyone having to establish the indexed penalty first.
It cannot confirm the regulation. The book is unusually careful about this and the workbook keeps its caution: the checkpoint percentage, the checkpoint dates and the phase-out schedule are the figures as consistently reported, and the book says plainly that a verbatim read of the consolidated text returned a different percentage in one case. Confirm them against the consolidated regulation before you rely on any of this operationally, and record the date of your read. The workbook can only tell you what follows if the parameters are what they are reported to be — which is why every one of them is an editable cell rather than a constant.
The workbook with its 23 inputs emptied. Enter your own quarters, intensity and prices; the checks sheet counts what is still missing and runs eleven tests that hold for any inputs.
Chapters 10, 11 and 13 · Appendix F
Four quarters of imports, the intensity, the quarterly prices and the forward price, the checkpoint, the three treasury inputs and the phase-in schedule. The file gives the certificates and the cost by quarter, the implied free-allocation adjustment that must read 1.00, the cost a tonne to 2034, the 2027 calendar and the years after it, and the break-even probability that decides the buffer. The buffer sizes and penalty multiples stay, because they are the axes of their tables, not data.
The book’s inputs are listed in a text file inside the archive. Type them back in and the file returns 360 certificates, 27,062.64, a 2027 requirement of 54,062.64 and a break-even of 2.56 per cent.
Download the blank set19 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 10, 11 and 13 · the whole book
The scope screen, with the annual mass threshold. The authorised declarant file, condition by condition. The supplier data request, with what the contract must say. Supplier figure or default value, year by year. The obligation line by line, Northbeck’s beside a blank column. The surrender formula checked for the term counted twice. The phase-in budget to 2034. The 2027 treasury calendar and the multi-year cash plan. The buffer decision. The deadline and penalty register, with two names on every date. The parameter log for reading the regulation. And one page for the finance committee.
Download the PDF34 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Eight on the Northbeck year, seven on the phase-in, seven on the 2027 load, six on the buffer and the penalty, six on the model rerun on other inputs, and six on the three cases below. Numbers are marked to a tolerance, multiple choice to the letter, and the score sheet counts your errors part by part: that is your revision list.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
Download the question book16 KBNew material, not a restatement. Three situations the chapters name and never take to a number. Each case is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Type your own figures in and every finding recomputes.
Chapters 10, 11 and 13 · Case one
A workbook built from the five-term formula multiplies the factor by the retained free allocation. In 2026 it is 9 certificates short, 675 euros on 360, and the implied adjustment reads 0.975: inside any tolerance. The share short is the factor itself, so by 2030 it is 3,387.24 certificates and 330,256 euros of penalty at 1.3 times the price (ADDED), and in 2034 the workbook says nothing is owed. A budget that falls after 2030 on flat volumes is the signature. The check that catches it has no tolerance.
Chapters 10 and 11 · Case two
Chapter 10’s 1.8 against a default of 2.30 with its mark-up (ADDED). At 12,000 euros a year for verified data (ADDED), the data does not pay in 2026, by 1,050 euros: 2026 is the one year in which defaults are the cheaper answer. From 2027 it pays above 3,333 tonnes, and in 2030 it is worth 346,290 euros, 43.29 a tonne. Over nine years, 2,906,460.
Chapters 10 and 13 · Case three
The chapter asks for a buffer “sized to the uncertainty in your own emissions data”. The rule: cover every outcome whose chance of being reached is above the 2.56 per cent break-even. With a 3 per cent chance that the supplier’s figure is rejected (ADDED), that is 146 certificates, 40.6 per cent, at an expected cost of 365 euros. The modest 10 per cent costs 780. At a 2 per cent chance the rule stops at 90.
Download the three cases36 KB| Amber fill | an input — you may edit these |
| Grey fill | a formula — do not overtype these |
| ADDED | a figure the book does not give: three treasury parameters in the workbook, and the case inputs, marked wherever they appear |
| Checks sheet | thirty-five controls, seven of which exist only to reproduce the book before extending it; in the blank set and the cases, each control states its own verdict and the file ends ALL OK |
Northbeck Metals is the book’s own invented company and the volumes and intensity are its own. The prices, dates, factors and rules are the published framework as the book reports them. This is not legal or compliance advice, and the regulation should be confirmed against its consolidated text.
The workbooks open in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers; the PDF prints on A4 or US Letter. They use no macros and no add-ins, so nothing needs to be enabled or trusted. If your spreadsheet asks to update links on opening, decline — there are none.
| 24 Sep 2026 | The workbook corrected, 35 checks. The 2030 cost a tonne is €65.48, not €65.47; three inputs are ADDED, not four, since the forward price of 75 is chapter 10’s own; three checks that read only the first row of a range in Excel now test every row, and seven are added. Added: a blank version, thirteen working documents, forty questions that mark themselves, and three cases. The workbook can now also be downloaded on its own. |
More in regulation and compliance, with free companion files. The full list of titles is on the author page.
The CBAM Compliance Handbook develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on Amazon Read the related analysisAlso as an ebook on Apple Books · Google Play · DRM-free PDF edition ($19.99).
These files accompany The CBAM Compliance Handbook. The book is on Amazon.
If this book helped — or didn’t — a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.