# The Ship Finance Professional: companion files

Julian R. Sterling

## What is here

- **Ship_Finance_Professional_Model.xlsx**: the workbook that rebuilds the Brackwater Maritime Credit Fund II case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Charter and Breakeven, Sorrel Schedule, Sorrel Covenant Tests, Sorrel Release Price, Ketterly Lease, Ketterly Options and Exit, Dunmore Default, Dunmore Recovery and Recycling, Fund Cash Flows, Waterfall, Checks.
- **Ship_Finance_Professional_Toolkit.docx**: the fifteen checklists of Appendix 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, ship sale and recycling checklist), in editable form.

## Which sheet answers which chapter

- Chapter 5: Charter and Breakeven ($14,500 a day of owner's margin on an MR time charter at $22,000; Ketterly hire of about $11,786 a day; a Sorrel cash breakeven of about $15,571 per ship per day)
- Chapter 7: Sorrel Schedule ($120.0 million at 8.50 percent, $3.0 million a quarter, a final payment of $44.48 million on 30 June 2027; projected IRR 9.3 percent; a mark of $50.73 million)
- Chapter 8: Sorrel Covenant Tests and Sorrel Release Price (72.8 percent against a 70.0 percent limit at 31 December 2022, cured with $4.44 million; 44.3 percent under a 25.0 percent stress; a release price of $14.09 million on a $25.8 million sale)
- Chapter 9: Ketterly Lease (a $27.0 million tanker valued at $33.0 million; hire of $358,504 a month; a lease balance of $22.98 million against a $39.5 million value at 1 October 2024)
- Chapter 10: Ketterly Options and Exit (an option price of $19.83 million on 1 April 2026; realized IRR 10.1 percent against 9.6 percent over the full term)
- Chapter 14: Dunmore Default (payments stopped after 31 December 2023 at a balance of $29.25 million; 88.2 percent against a 75.0 percent limit at 30 June 2024; IRR of 12.0 percent had it paid as agreed)
- Chapter 15: Dunmore Recovery and Recycling (21,900 tonnes at $380, $8.32 million gross; two ship sales; a shortfall of $8.13 million; realized IRR minus 1.4 percent)
- Chapter 16: Fund Cash Flows and Waterfall ($555.96 million called, $265.40 million distributed, NAV $397.2 million; gross IRR 8.8 percent, net IRR 6.0 percent, net TVPI 1.17x; accrued carry $13.3 million)

## Two inputs to change first

1. On Inputs, raise the 31 December 2022 fleet value index from 0.86 to 0.90: the Sorrel test passes, the cure prepayment disappears, and the schedule, the IRR and the fund's distributions move with it.
2. On Inputs, change the price per light displacement tonne of the Dunmore recycling sale: watch the net proceeds, the shortfall and the realized IRR on Dunmore Recovery and Recycling, and the fund's distributions. 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.

Brackwater Maritime Capital, Brackwater Maritime Credit Fund II, Sorrel Bulk Carriers, Ketterly Tankers and Dunmore Capes are fictional, and so are the ships; 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, tax or legal advice.
