Supporting work, kept in context.
These are the files I used while developing the Clarksons project. They show the questions I explored before building the final model. Each original is available below with a description of how it contributed.
Some notes predate v5.3 and contain earlier assumptions or interpretations. The reading notes identify material limits and corrections. For the project’s final scenario numbers, use the v5.3 workbook and appendix.
Oil prices and Broking revenue
I tested the idea that either a rise or a fall in oil prices must help Broking revenue. I compared oil prices, freight indicators and reported revenue, then considered how chartering, ship sales and newbuilding activity differ.
How it fits: Helped me avoid using the oil price as a direct revenue driver in the scenario model.
Reading note: This is a directional check across three comparisons, with a freight proxy in one comparison. It cannot prove a common cause or rule out a demand channel. The PDF’s stronger causal wording should be read with that limit.
Read PDFOil price outlook
I gathered dated oil-price snapshots and forecasts from several institutions, compared the assumptions behind them, and flagged a source conflict around the OCBC attribution.
How it fits: Background for the model’s disruption scenarios and the questions I need to keep following.
Reading note: Forecast horizons differ: year-end targets, quarterly averages and annual averages are not directly comparable. The PDF sometimes groups them together. Prices are a dated snapshot, and the September OCBC claim remains unverified.
Read PDFCompany news and market log
I collected company announcements and market reports between earnings releases, and noted which items could change an assumption and which were only useful background.
How it fits: A record to return to when reviewing acquisitions, new services, freight conditions and later results.
Reading note: This predates v5.3. Its M&A assumptions and some market commentary refer to an earlier model. Use the final workbook for current project assumptions; aggregator price targets are not primary research.
Read PDFOperating profit structure workbook
I assembled segment revenue and operating profit, then calculated revenue mix, margins, head-office cost absorption, geographic mix and per-employee measures.
How it fits: The source table behind my segment comparisons and the starting point for choosing different assumptions by business line.
Reading note: Segment profit is shown before head-office costs. The workbook’s “Group Average” operating profit per employee uses the segment total before head office; it should not be read as consolidated group profit per employee.
Download workbookHow the business earns revenue
I mapped the four segments to their revenue models and the work people do in each area, using Clarksons’ business-model and careers pages.
How it fits: Helped me connect the financial statements to commissions, financing fees, port services and recurring research income.
Reading note: This is qualitative website research. It is not an audited disclosure or evidence of a specific customer contract.
Read PDFMargins, compensation and the balance sheet
I compared changes in revenue and implied costs, separated bonus expense from ESOP cash purchases, and examined cash, receivables and short-term settlement balances.
How it fits: Informed the model’s flow-through margins, working-capital treatment and distinction between profit and cash.
Reading note: The interim receivables line includes trade and other receivables. The ex-settlement DSO is a proxy, not a pure trade-debtor measure. Its complement does not establish the share of revenue collected in cash. Bonus timing alone also cannot establish earnings quality.
Read PDF