Companion files · The Credit Investor

7.46 percent on the screen, 6.02 percent earned

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.

All the companion files and the read-me, in one archive643 KB

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 →

Get an email if these files are corrected

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 list

Run by MailerLite, off this site. How your address is used.

The files

The documents the chapters describe

Seven pages to print and use. A4, with margins wide enough for US Letter.

Three cases the book does not work

New 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.

Three numbers to reproduce first

One bondHarrowgate 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 fundThe 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 portfolioSeventeen 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.

What changed, and when

15 Nov 2026Added 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.

Articles on this book

9 of the calculations in these workbooks, worked out in full. All articles.

Also by Julian R. Sterling

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.