# The Venture Debt Lender: companion files

Julian R. Sterling

## What is here

- **Venture_Debt_Lender_Model.xlsx**: the workbook that rebuilds the Cordwain case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Larkspan Schedule, Larkspan Runway and Rule of 40, Warrants, Larkspan Returns, Pallwick Cash and Covenant, Pallwick Recovery, Fund Economics, Checks.
- **Venture_Lending_Toolkit.docx**: the twelve checklists of Appendix 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, forbearance term sheet checklist), in editable form.

## Which sheet answers which chapter

- Chapters 6 and 8: Larkspan Schedule (the loan month by month, contractual and realized, tranches, interest-only, amortization, fees and the prepayment)
- Chapters 6 and 10: Larkspan Runway and Rule of 40 (cash, burn and runway, the case rule of 40, the Series C and the bank line)
- Chapter 7: Warrants (counts, Black-Scholes values at issuance and at the mark, intrinsic and time value)
- Chapter 8: Larkspan Returns (contractual, realized and with-warrant IRRs, with the IRR function on monthly cash flows)
- Chapters 12 and 14: Pallwick Cash and Covenant (monthly cash against the minimum cash covenant, the breach month)
- Chapter 15: Pallwick Recovery (the workout waterfall, the recovery rate, the loss and the IRR of the loan)
- Chapter 16: Fund Economics (one illustrative year of Fund III, with and without warrant gains)

## Two inputs to change first

1. On Inputs, move the Larkspan prepayment month from 23 to 36: watch the prepayment fee fall and the realized IRR move toward the contractual one on Larkspan Returns.
2. On Inputs, lower the Pallwick sale price from $5.0 million to $4.0 million: watch the recovery, the recovery rate and the IRR fall on Pallwick Recovery. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Cordwain Capital Partners, Fund III, Larkspan and Pallwick are fictional; the model is a simplified teaching model; rules are general and dated October 2026; all case figures are illustrative assumptions, not benchmarks. Provided as is, without warranty. Not investment, legal or tax advice.
