Companion files · The Private Markets Career Guides

The Venture Debt Lender

How Venture Debt Really Works: Growth Term Loans, Warrants, Underwriting Runway and Investors, Loan Documents, Workouts, Fund Economics and the Career of a Venture Lender at a Specialist Fund or Tech Bank.

These are the companion files of the book. One workbook rebuilds the Cordwain case: the Larkspan loan month by month with its tranches, interest-only period, fees and prepayment, Larkspan’s runway and rule of 40, the Black-Scholes value of the warrants, the IRR with and without warrants, Pallwick’s cash against its covenant, the workout recovery and one year of Fund III’s economics. A toolkit holds the twelve checklists of Appendix B in an editable form.

The workbook, the toolkit and the read-me, in one archive91 KB

The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.

The files

Three numbers to reproduce first

Larkspan returnsA $15.0 million loan prepaid in month 23: an IRR of 12.2 percent had it run 48 months, 14.6 percent as realized, and 18.5 percent with the warrants counted at their $971,000 mark
Pallwick covenantCash of $10.14 million at 31 December 2025, $7.79 million at 31 January 2026 and $5.39 million at 28 February 2026, below the $6.0 million minimum cash covenant
Pallwick recovery$5.81 million recovered on $7.33 million of principal: a recovery rate of 79.3 percent, a loss of $1.52 million and an IRR of 0.9 percent on the loan

The files are provided as they are, without warranty of any kind. The model is illustrative: Cordwain Capital Partners and the other names are fictional, the model is simplified, the rules are general and dated October 2026, and the figures are the book’s assumptions, not benchmarks. Nothing here is investment, legal or tax advice.

Also by Julian R. Sterling

More in credit and debt, with free companion files. The full list of titles is on the author page.

Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.

Also available as a standalone free template: venture debt model.