Companion files · The Private Markets Career Guides
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 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.
Chapters 6 to 16
One Inputs sheet holds every case assumption: loan terms, floors, fees and the prepayment schedule, tranche dates, burn and ARR, warrant coverage and volatility, the sale price and the wind-down reserve, and the Fund III terms. One sheet per question, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook54 KBAppendix B
First call checklist, investor diligence checklist, revenue and cohort diligence checklist, loan sizing and structure checklist, term sheet checklist, warrant terms checklist, credit memo outline, closing and collateral checklist, monthly monitoring checklist, quarterly portfolio review template, early warning checklist and forbearance term sheet checklist.
Download the toolkit41 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| Larkspan returns | A $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 covenant | Cash 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.
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.