Companion files · The Private Markets Career Guides

The Ship Finance Professional

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 workbook, the toolkit and the read-me, in one archive115 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

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

Also by Julian R. Sterling

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.