Companion files
A Practitioner’s Guide to Covenants, Baskets, EBITDA Add-Backs and What the Lender Can Actually Do
These are the companion files of How to Read a Credit Agreement by Julian R. Sterling.The book on Amazon →
Five Excel workbooks that reproduce every figure the book prints, four of them now corrected where the book is wrong. Around them: the same models with every input emptied, 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.
Thirteen workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 23 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? The Contracts Reading Pack: four PDF editions on leases, loan agreements, LPAs and credit agreements, this book included, $49.99. See the pack →
The working models behind the books, built out for live deals: the Pro models →
Learn to underwrite a direct loan, step by step: the Private Credit Modeling course →
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.
The book’s own files. 89 figures are checked against what the book prints, and all 89 reproduce; thirteen of them carry a figure the first edition printed differently, and say so.
Chapters 2 to 30 · the whole facility
A seven-year unitranche built from one sheet of assumptions. The covenant tests, the margin ratchet, the cash sweep and the headroom all follow from the inputs; nothing is typed twice, so changing one number moves everything that depends on it and nothing that does not.
Go to sheet 4 and read the headroom column. Then go back to Assumptions and set the add-back cap to 100 per cent. Quarters 9 to 11 come back into compliance — and nothing about the business changed. That is the argument of the book in one keystroke.
Headroom is shown in EBITDA rather than in turns, deliberately. “0.21 turns of headroom” means nothing to anybody; €0.8 million of EBITDA means the company is one bad month from a default, and that is the same fact stated so a credit committee can act on it.
A sixth sheet, added in this revision, computes what the clause-by-clause chapters print, and corrects seven of those figures. The margin grid moves six times in five years, not four, and a 45-day certificate lag on its downward steps costs 0.21, not 0.170. The year-four sweep takes 1.23, not 0.9. A 15 million cash cap first bites at Q19 and adds 2.76 to net debt at Q20, not nothing at Q16. And Kestrel is portable in Q1 to Q5 as well as from Q15.
Download the workbook37 KBChapters 4, 5, 23 and 28
The definition of Consolidated EBITDA, quarter by quarter: what is claimed, what the cap allows, and what survives. On the base case the add-back is the only thing passing the test in quarters 7 and 8 — 5.97× and 6.65× unadjusted against a 5.75× covenant — and the 20 per cent cap disallows €0.32 million in quarter 8 alone.
Then the run-off. The add-back is a two-year concession and the covenant steps down at quarter 9. Both happen in the same quarter, which is why the breach lands where it does. Change either date and watch the default move: it is a drafting outcome, not a trading one, and the two dates were agreed by different people on different days.
A new sheet moves the run-off to 36 months. With the 20 per cent cap kept, as Chapter 28 has it, Q9 passes by €0.41 million, not the 0.61 the first edition prints; 0.61 is Chapter 23’s uncapped case.
Download the workbook19 KBChapters 5, 15 and 22
The same quarter cured two ways. As deemed EBITDA the sponsor writes €3.59 million; as a prepayment it writes €19.74 million — 5.5 times as much for identical covenant compliance, because a prepayment has to move net debt rather than the numerator.
The cap sheet then does the arithmetic nobody does at signing: three breach quarters against a two-in-four cure limit. The third one cannot be cured whatever the sponsor is willing to fund — which means the negotiated cure right does not cover the case it was negotiated for. That is worth knowing on the day the term sheet is signed rather than on the day the third breach arrives.
And a prepayment stays paid. After 19.74 at Q9, Q10 passes at 5.21× and Q11 at 4.84× without another cure, so over the whole breach the prepayment drafting costs 19.74, not the 33.25 Chapter 22 adds up, and the gap between the conventions is €13.70 million, not 27.20.
Download the workbook18 KBChapters 8, 9, 22 and 26
The four grower baskets, sized at every quarter’s Consolidated EBITDA and at unadjusted EBITDA, so the capacity the add-back creates is a number: 5.88 at Q1. From Q9 every basket has collapsed onto its fixed floor, which is the feature of a grower basket that reads as innocuous in the definitions and is not.
The MFN sheet prices the sunset: 2.06 a year while the protection runs, 10.31 over five years to run (the first edition prints 8.25, which is four), and nothing the day after it expires. A lender that has not put a number on that day has priced only half of what it agreed to.
Download the workbook18 KBAppendix A · the working document
The sixty-four questions of Appendix A as a sheet you can work in: the same questions, in the same order, generated from the same source file as the chapter, so the book and the workbook cannot drift apart.
There are columns for the answer, the source document, the owner and the date. The status column is computed, and it marks any question answered without a source as “unsourced” — because an answer whose authority is “the borrower says” is not an answer. The Progress sheet counts only the sourced ones, in total and by section.
Work top to bottom on a first read. On a re-read start with Definitions and Financial covenants: they are what the arithmetic of the book turns on, and they are the two sections you can answer from the document alone.
Download the workbook15 KBThe default in this facility is not produced by trading. It is produced by two dates in the definitions — the expiry of a two-year add-back concession and a covenant step-down — landing in the same quarter. Move either one and the breach disappears without a euro of EBITDA changing. That is why the workbook makes both dates inputs, and why the run-off sheet exists at all.
A cure right is negotiated because the sponsor expects a bad patch, and a bad patch is rarely one quarter long. Against a two-in-four limit, three consecutive breach quarters leave the third uncurable — not expensive, uncurable. The limit is usually the least-discussed line in the section, and it is the one that decides whether the right is worth anything in the case it was bought for.
The two forms of cure are also not interchangeable at any price. Deemed EBITDA and prepayment produce the same covenant outcome for €3.59 million against €19.74 million. Which form the agreement permits is therefore worth about sixteen million euros in this single quarter, and it is settled by one clause.
The four model workbooks with every input emptied. Each checks sheet counts what is still missing and tests what holds for any inputs.
Blank set · four workbooks
Kestrel’s twenty-eight quarters with the 74 inputs emptied: the transaction, the definition of Consolidated EBITDA, the covenant levels and cure limits, and the trading, quarter by quarter. The headroom test on the defined and the unadjusted number; the cure priced both ways, with a prepayment kept once paid; the baskets and the MFN. The model stays blank until its inputs are in, then runs every sheet.
The book’s figures are listed in a text file inside the archive. Type Kestrel back in and the files return 0.83 of headroom at Q8, a breach from Q9, and cures of 3.59 and 19.74.
Download the blank set73 KBThirteen pages to print and take into a meeting. A4, with margins wide enough for US Letter.
Chapters 4 to 28
The ninety-minute read with the five questions that catch most problems. Consolidated EBITDA and Net Debt line by line. The calendar that lays the step-downs over the run-offs, with headroom in EBITDA at every test date. Both covenants and what the hedge does to them. The equity cure priced both ways. The compliance certificate in prescribed form. The basket register with the builder. Incremental debt, MFN and the sunset. What the lender holds on the day of the breach. The lender’s quarterly five. The borrower’s playbook. The negotiation record. And security, the intercreditor and the recovery.
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
Seven on the definitions, the headroom and the cure, seven on the ratchet, the sweep, the baskets and MFN, seven on information to amendments, seven on security to amend-and-extend, six on the clauses and the three other borrowers, 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.
Where the book has been corrected, the question says so. The marking sheet holds every answer, every tolerance and the reason for each.
Download the question book17 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 8 and 10 · Case one
Chapter 8 says a builder basket “becomes the largest basket in the document by year four or five”. On Kestrel, at 50 per cent of retained cash flow, it is worth 1.85 at year four and 6.38 at year five, and is the largest basket only in year seven: the sweep and the breach years eat the retained cash. Small as it is, it lifts the dividend capacity at Q20 to 12.88, and the sponsor can take 12.76, every euro retained since closing: leverage from 3.56× to 3.95×, all of it permitted.
Chapters 18 and 19 · Case two
Kestrel’s swap on half the facility after rates fall 1.5 points: a mark of 3.03, Chapter 19’s example almost exactly. Counted as debt it cuts Q8 headroom from 0.83 to 0.30; ranked second in Chapter 18’s waterfall it takes 2.2 points of recovery. And the hedge meant to protect interest cover keeps it in breach: Q9 cover 1.91× half hedged, 2.12× floating.
Chapter 25 · Case three
Chapter 25’s two-year extension at Q20, with 30 per cent of the lenders saying no. Their stub of 40.03 falls due at the original maturity, against 30.81 of cash above the operating retention: a gap of 9.22, because the extending lenders’ fee, margin and amortisation consume the cash. Above 22.6 per cent not extending, the extension has solved nothing, and the number can be computed before the request goes out.
Download the three cases43 KB| Blue on a pale fill | an input — you may edit these |
| Black text | a formula — do not overtype these |
| Yellow fill | the assumptions that carry the answer |
| Checks sheet | 89 figures in the four model workbooks, each beside the figure the book prints; every other workbook ends with its own checks |
| ADDED | a figure the book does not give, used in the cases and marked wherever it appears |
Amounts are in millions of euros, and Kestrel Industrial is fictional and deliberately simple: it exists to show a mechanism, not to represent a company. 89 figures are tested across the four model workbooks, and all 89 reproduce. The quarter 10 deemed-EBITDA cure, once marked “rounding”, reproduces now that net debt is carried to four decimals: 2.4553, which the book prints as €2.46 million. Where the book is wrong, the check carries the corrected figure and says what the first edition printed, because a check that widens its own tolerance until everything passes is not a check.
How to Read a Credit Agreement 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).
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.
| 23 Sep 2026 | Four workbooks corrected. Kestrel gains a sheet computing the clause-by-clause figures: the margin grid moves six times in five years, not four; the certificate lag costs 0.21, not 0.170; the year-four sweep takes 1.23, not 0.9; a 15 million cash cap bites from Q19; Kestrel is portable in Q1 to Q5 too. A prepayment cure stays paid: 19.74 once over the breach, a gap of 13.70 between the conventions, not 27.20. The 36-month run-off with the cap kept passes Q9 by 0.41, not 0.61; the MFN sunset is worth 10.31 over five years, not 8.25. 89 checks, all reproduced. Added: a blank set of the four models, thirteen working documents, forty questions that mark themselves and three new cases. Each workbook can now be downloaded on its own. |
More in credit and debt, with free companion files. The full list of titles is on the author page.
These files accompany How to Read a Credit Agreement. 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.