Companion files
A Practitioner's Guide to Direct Lending, Underwriting, and Portfolio Management in Private Markets
These are the companion files of The Private Credit Investor by Julian R. Sterling.The book on Amazon →
These are the workbooks and documents that go with the book. The four original workbooks reproduce the figures it prints — the Halstead coverage ratios of the modelling chapter and the Ridgeline bridge of the appendix. Around them: the same models with the inputs emptied, four printable working documents, a question book that marks itself, and three cases the book names and never takes to a number. Every number is a live formula. Nothing is locked, protected or watermarked.
Free to download. No sign-up, no email address, nothing to fill in.
Ten workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 22 September 2026.
Read the book already? An honest review on Amazon, good or bad, is what the next reader goes on: write a review. The files stay free either way.
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 →
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.
These carry the book’s own figures, so that every number it prints can be traced to a live formula. Download these four64 KB
The modelling chapter
The Halstead Precision Components case, live. The chapter underwrites a unitranche at 6.25x leverage and publishes two numbers — a fixed charge coverage ratio of 1.7x in the base case and 1.15x in the downside, thin but still above 1.0x. This file computes both. Switch the case on sheet 1 and the whole five-year model re-runs; the stress case, a 20 percent decline with margins at 15 percent, returns 0.93x — which is the chapter's argument made arithmetically. There is also a panel for the parts of the business that are not seasoned, and a flag for any that has not been stressed separately.
Appendix C
Worked out into its sections: financial information, the business, legal and structural, collateral and security, structure and terms, conditions precedent, and what must be true before the deal reaches committee. Thirty-three items with a status dropdown, a notes column and a progress sheet.
Appendices B and D
The twenty practitioner questions, each with what it is testing and a self-score, and the credit committee memo outline as a fillable structure with what each section is for. Useful in two directions — for a candidate preparing, and for a reviewer assessing readiness.
The fund economics chapter, and the appendix
The book tells a story about Ridgeline Credit Partners’ Fund IV: eleven per cent gross, roughly eight net, and an investor relations team that could walk a prospective LP through the bridge in detail, line by line, showing precisely where each percentage point went. It does not show a single line. This workbook shows them.
The arithmetic works — 11 per cent gross does produce 7.84 net. But building the bridge reveals that the two numbers are not measured on the same thing. Eleven per cent is a yield on assets; 7.84 is a return on equity. Between them sits a turn of fund leverage, which is not a fee and not a loss — it is a different denominator. On a consistent base the gross is 15.00 per cent and the erosion is 47.7 per cent, not the 28.7 the headline framing implies.
Three more figures the chapter names without pricing. The word “invested” in “1.5 per cent on invested capital” is worth 1.20 points of net return — fifteen per cent of everything the LP receives, depending on whether it means the LP’s capital or the fund’s assets. Leverage from zero to two turns buys 1.04 points of return and costs 4.67 points of loss tolerance: four and a half points of safety surrendered per point gained. And a five per cent position recovering twenty cents costs more than a full year of the fund’s net output.
The lender’s model and the Ridgeline bridge, with the same formulas and every input emptied. Type your own borrower or your own fund into the blue cells and the model runs.
Blank set · two workbooks
Nineteen inputs on the lender’s model: the business, the structure, the covenants and the three cases. Ten on the fund bridge: leverage, yield, cost of debt, the fee and its base, expenses, losses, the preferred return and the carry. Each workbook closes on a checks sheet that counts the inputs still empty and runs the tests that hold on any deal: debt never negative, cash never below the revolver, a downside margin below the base margin, a stress harsher than the downside, a leverage covenant set above closing leverage.
Put the book’s inputs back and the book’s figures come back with them: 1.70x, 1.15x and 0.93x on Halstead; 7.84 per cent net and 47.7 per cent real erosion on Ridgeline.
Download the blank set35 KBFive pages to print and take into a meeting. A4, with margins wide enough for US Letter.
Appendices B and C · monitoring · amendments
The thirty-three-item underwriting and diligence checklist, with a status, an owner and a note for each item. The credit committee memo outline, one box per section. The one-page quarterly credit snapshot the monitoring chapter describes: trailing revenue and EBITDA against the underwriting case, leverage and coverage against the covenants, any deviation above ten per cent explained, and the early-warning signs ticked off. And an amendment, waiver and forbearance form built on the chapter’s rule that a waiver is a negotiation, not a courtesy: what is asked, why, what the fund receives in exchange, and the three forbearance conditions of the Bellamy example.
Download the PDF13 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All chapters
The numerical questions work the book’s own cases: Halstead’s coverage and leverage, Aster’s first-out and last-out, Calloway’s yield against its IRR, the Ridgeline bridge and the loss rate the fund can survive. They are marked against a tolerance, so a reasonable rounding passes. The score sheet counts the wrong answers by chapter, which gives the only revision list worth having.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
Download the question book18 KBNew material, not a restatement. Three situations the chapters name in passing 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.
Case one · extends the stress case
Halstead stressed for two years instead of one, with customers paying later while it lasts. The company never runs out of cash: liquidity falls from 15.0 to 10.5 and recovers. But both covenants break for two years, coverage at 0.93x and 0.96x, leverage at 11.3x and 11.1x, and the equity cure the leverage covenant would demand is 22.1, twice the company’s entire liquidity. The breach is not a payment problem; it is the lender’s seat at the table while the borrower can still pay. The note prices the amendment the monitoring chapter prescribes, and shows why working capital, which cost more cash than the coverage shortfall, never appears in the coverage ratio at all.
Case two · extends the Calloway pricing example
The same loan earns 13.6 per cent if repaid in year one, 11.6 in year two and 10.8 held to maturity: the yield to maturity the term sheet quotes leaves out 0.74 points of the return the fund actually expects. Then the Brightwater choice, priced: 25 basis points of spread and 0.43 points of OID cost exactly the same over a two-year life, but if the loan stays four years the spread cut costs more, because it is paid every year and the OID only once.
Case three · extends the Aster unitranche
Aster’s $140m unitranche split into an $85.2m first-out and a $54.8m last-out. On declared spreads, the retained last-out earns 2.33 points a year more than the loan as a whole. After two quarters of margin compression, EBITDA is 15 per cent lower and the last-out has moved from 3.5–5.75x to 4.1–6.8x without a dollar of new debt. Sold at 5x, the whole unitranche recovers 74 cents; the first-out is repaid in full and the last-out recovers 33, a loss equal to about twenty-nine years of its extra coupon.
Download the three cases33 KB| Blue text | a hardcoded input — you may edit these |
| Black text | a formula — do not overtype these |
| Green text | a link to another sheet |
| Yellow fill | the assumptions that carry the answer |
The book publishes the two coverage ratios without publishing the model behind them, so two inputs are calibrated so that both reproduce exactly: the all-in cash coupon and capital expenditure as a share of revenue. Both are ordinary inputs on the first sheet. Everything else is used as the text states it — 6 percent growth, 22 percent margins, 6.25x leverage, a 12 percent revenue decline and a 17 percent margin in the downside.
Note where the leverage covenant sits: above the downside level rather than close to closing leverage, which is what the book describes when it says the downside result informed where the covenant was set. Tighten it and watch the downside turn into a breach.
The Private Credit Investor 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.
The workbooks open in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers. They use no macros and no add-ins, so nothing needs to be enabled or trusted.
| 22 Sep 2026 | Blank model set, four printable working documents, the question book and three new cases added. Read-me rewritten. |
| 22 Aug 2026 | The Ridgeline bridge workbook added. |
| 12 Aug 2026 | First publication of the workbooks. |
More in credit and debt, with free companion files. The full list of titles is on the author page.
Also available as a standalone free template: direct lending credit model.
These files accompany The Private Credit Investor. 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.