Companion files · The Credit Investor
The Credit Investor: Credit Investing by the Numbers: Bonds, Loan Funds, BDCs and Private Credit Funds, Default, Recovery and the Real Yield, With the Models Supplied.
These are the companion files of The Credit Investor by Julian R. Sterling.The book on Amazon →
Also as a DRM-free PDF edition ($19.99).
These are the companion files of the book. An investor puts $500,000 into seventeen credit lines: investment-grade and high-yield bonds, a floating-rate loan fund, three listed BDCs, a private credit interval fund and Treasury bills. On the day of purchase the portfolio displays 7.46 percent. Three years later it has earned 6.02 percent. The BDC that showed 14.67 percent earned 7.76 percent; the dull one that showed 10.11 percent earned 10.16 percent. Three workbooks reproduce every figure the book prints. No sign-up, no email is asked for, nothing is locked. Yellow cells with blue type are inputs; grey cells are formulas.
The archive holds the six files below, seven working documents and three new worked cases, with 00_START_HERE.md at its root. Last revised 15 November 2026. No macros, no circular references, no external links in any workbook. They recalculate in Excel, LibreOffice or Google Sheets.
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.
Part I · Chapters 2 to 4, 6 and 8
Harrowgate Pneumatics from its 8.50 percent coupon and a price of 94.00 to a yield to maturity of 10.06 percent and an expected yield of 1.06 percent; the default and recovery assumptions; the high-yield sleeve by number of defaults and recovery; duration and convexity from the cash flows; the CLO tranche grid. Every computed figure is a live formula, and the Checks sheet sets each figure the book prints beside the cell that computes it.
Download the workbook110 KBPart II · Chapters 5 to 14
The bond ladder, the high-yield bonds, the loan fund, the three listed BDCs with their income stacks, dividend coverage, NAV and discount, the interval fund's fee stack and NAV, the repurchase proration table and the gate, and the tax illustration. Every figure is a live formula, checked on the Checks sheet.
Download the workbook126 KBPart III · Chapters 15 to 18
The seventeen lines at purchase, then every line's cash flows quarter by quarter in the base case and in each stress scenario, the IRRs by line, sleeve and portfolio, the line-by-line shortfall and the quarterly review figures.
Download the workbook212 KBChapters 2, 3, 13, 15 and 18
A line ledger, a yield bridge for one bond, a fee stack for one leveraged fund or BDC, and a quarterly review with triggers you set in advance. Every input is empty and every output a live formula.
Download the workbook21 KBThe whole book
A separate case of $200,000 in four lines. Start a timer, build the fifteen answers, then open the Score sheet and the Answer Key.
Download the workbook14 KBRead first
What each file is, which part of the book it serves, the order to read them in and the conventions.
Download the read-me5 KBSeven pages to print and use. A4, with margins wide enough for US Letter.
Chapters 12, 13 and 18 · Appendix B
Appendix B’s due-diligence lists, one page per vehicle and by moment (before buying, each quarter, before selling): the whole portfolio, a bond held directly, a loan fund and a CLO tranche fund, a listed BDC, an interval or evergreen fund. Chapter 13’s fee stack as a worksheet, gross to net, beside Ashcombe’s figures. And Chapter 18’s quarterly review page with Chapter 12’s gate calendar.
Download the PDF21 KBNew material, not a restatement. Each case takes a situation the book names and does not compute. Each is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Any value the book does not give is marked ADDED.
Chapter 13 · Case one
Ashcombe’s incentive fee at every level of income. Between 5.00% and 5.71% of NAV the manager takes every extra dollar; above it, 12.5% of everything. The catch-up costs the investor $625 a year on $100,000. Income is SOFR plus 6.21 points, so rates alone never bring the hurdle into play: it protects only once a quarter of the loans (25.1%) stop paying.
Chapter 12 · Case two
The gate with the additional 2% Rule 23c-3 allows (ADDED: fully used): a 35% fill instead of 25%, $35,145 on the day instead of $25,747, 6 quarters to get nine tenths out instead of 9. And the discount at which a secondary sale costs the same as waiting: a premium at a 4% cost of money, 2.1% at 12%, 5.3% at 20% (ADDED rates).
Chapter 17 · Case three
The scenario Chapter 17 leaves out, run through the book’s own model. Rates down 2 points take the real yield to 4.90% and cost $16,177, slightly more than the rise earned. Fixed sleeves gain, floating ones lose more. Of the recession’s $47,601, the rate cut alone is $10,440 and the defaults $37,244.
Download the three cases217 KB| One bond | Harrowgate Pneumatics, 8.50 percent coupon at 94.00: yield to maturity 10.06 percent, expected loss 9.00 percent a year, expected yield 1.06 percent |
| One fund | The interval fund pays 9.00 percent; after interest, fees and credit losses it is expected to earn 7.19 percent, and its NAV falls from $25.00 to $23.497 in three years |
| The portfolio | Seventeen lines, $500,000: displayed 7.46 percent, expected 6.25 percent, earned 6.02 percent; 6.63 percent without the one default |
The files are provided as they are, without warranty of any kind. The models are illustrative: the investor and every issuer, fund and BDC in them are fictional, and the figures are the book's assumptions, not market statistics or forecasts. Nothing here is investment, legal or tax advice.
| 15 Nov 2026 | Added seven working documents to print (Appendix B’s lists by vehicle, the fee stack worksheet, the quarterly review page and the gate calendar) and three new worked cases: the catch-up zone, the extra 2 percent of Rule 23c-3 with a secondary sale, and rates falling without a recession. The three worked workbooks are unchanged and their checks still pass. |
9 of the calculations in these workbooks, worked out in full. All articles.
More in credit and debt, with free companion files. The full list of titles is on the author page.
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.