Companion files · The Private Markets Career Guides
How Banks, Lessors and Credit Funds Finance Ships: Secured Loans and Loan-to-Value Covenants, Sale-and-Leasebacks and Bareboat Charters, Ship Values, Carbon Rules, Sanctions, Restructurings and the Career.
These are the companion files of the book. One workbook rebuilds the Brackwater Maritime Credit Fund II case: the charter margin and cash breakeven, the Sorrel schedule, loan-to-value tests, cure, stress and release price, the Ketterly hire, lease balance and purchase option, the Dunmore default, recycling, ship sales and shortfall, the marks at 30 September 2026, and the fund’s waterfall and net returns. A toolkit holds the fifteen 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 5 to 16
One Inputs sheet holds every case assumption: the fund terms, the Sorrel loan, its six ships and the fleet value index, the Ketterly price, lease rate, purchase obligation and option premiums, the Dunmore loan, its three ships, their values and tonnage, the recycling and sale prices, and the other loans and leases. One sheet per question, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook82 KBAppendix B
Ship loan credit paper checklist, borrower and sponsor due diligence checklist, ship technical and class checklist, valuation certificate review checklist, security package and closing checklist, insurance review checklist, loan-to-value test checklist, charter and counterparty review checklist, sale-and-leaseback term sheet checklist, purchase option and redelivery checklist, carbon rules checklist, sanctions screening checklist, early warning and watch list checklist, standstill and forbearance checklist and ship sale and recycling checklist.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me4 KB| Sorrel, six bulk carriers | $120.0 million at 8.50 percent against ships worth $182.0 million: a failed test at 72.8 percent on 31 December 2022, cured with $4.44 million, and a projected IRR of 9.3 percent |
| Ketterly, an MR tanker | Bought for $27.0 million and chartered back at $358,504 a month: an option price of $19.83 million on 1 April 2026 and a realized IRR of 10.1 percent against 9.6 percent over the full term |
| The fund at 30 September 2026 | $555.96 million called, $265.40 million distributed and $397.2 million of net asset value: a gross IRR of 8.8 percent, a net IRR of 6.0 percent, a net TVPI of 1.17x and $13.3 million of accrued carry |
The files are provided as they are, without warranty of any kind. The model is illustrative: Brackwater Maritime Capital, Sorrel Bulk Carriers, Ketterly Tankers, Dunmore Capes, the ships 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, tax or legal advice.
More in infrastructure and energy, 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: ship finance model.