Offshore AHTS Operator Financial Model

Description

This is a full-scale operational and investment model for a modern Anchor Handling Tug Supply (AHTS) vessel operator, capturing the unique economics of offshore maritime logistics. It is structured around a single-vessel SPV as the base unit but engineered to scale seamlessly to a fleet of any size, reflecting the reality that most operators start with one high-spec unit under a distinct financing structure.

The revenue engine is built around multi-tier charter structures: long-term time charters with built-in escalation clauses, bareboat rentals, and short-term spot fixtures that command a premium. The model explicitly separates hire days from off-hire periods caused by weather, mechanical breakdown, and dry-docking, while allocating mobilisation/demobilisation fees as a separate income line. The interaction between day rate, actual utilisation, and mobilisation bonus is fully dynamic, avoiding the typical trap of a single blended rate.

On the cost side, the model breaks down operating expenditure into vessel-specific categories—marine crew and rotation schedules, lube and bunker consumption as a function of engine hours and operating mode, port charges and canal tolls, hull and machinery insurance (P&I and H&M), and a reserve for repair and maintenance that adjusts with vessel age. Dry-docking events are modelled as a full project cycle with upfront CapEx, lost OpEx due to off-hire, and the subsequent change in class notation. Depreciation is calculated per-vessel with a switch between straight-line and declining balance methods.

The financial structure accommodates senior debt, shareholder equity, and finance or operating leases, including loan sculpting with DSCR targets, interest during construction, and commitment fees. Multiple tax regimes and tonnage tax options are built in, with deferred tax treatment and the ability to model flag-state incentives. A comprehensive scenario manager allows stress-testing of day rates, utilisation, fuel cost, and financing terms, providing a clear view of equity IRR and NAV over a 15–20-year investment horizon.

Modeling specifics

• Dual-mode chartering: distinction between time charter (fixed daily income with escalation) and spot market (volatile, seasonally adjusted day rates), each with independent utilisation factors and mobilisation fee schedules.
• Off-hire waterfall: separately modelled mechanic, weather, and dry-docking off-hire days, each feeding into revenue loss and cost adjustments, preventing blanket utilisation assumptions.
• Dry-docking as a full capital event: schedule based on vessel age and class, including dry-dock CapEx, classification society survey costs, off-hire days, and post-docking insurance premium recalculation.
• Bunker and lube cost engine: fuel consumption linked to operating mode (towing, anchor handling, transit, standby) with load-specific consumption curves, not a fixed daily average.
• Crew rotation and manning cost module: calculates crew wages, travel, and repatriation costs per rotation cycle, with overtime and standby pay triggered by spot voyage patterns.
• Marine insurance split: hull & machinery and P&I premiums modelled separately, with step-ups after major surveys and vessel age – a common under-provisioning area.
• Multi-flag and multi-jurisdiction tax: model supports separate tonnage tax or corporate tax treatment per vessel flag, with deferred tax build-up and tax holiday periods if applicable.
• Age-dependent maintenance reserve: annual repair & maintenance budget increases non-linearly as the vessel ages beyond 5, 10, and 15 years, reflecting real classification society data.
• Ballast and mobilisation economics: income from mobilisation/demobilisation fees modelled net of incurred fuel, port charges, and off-hire opportunity cost, revealing true margin on repositioning.
• Financing stack with sculpting: senior debt, junior debt, and lease liabilities, with automated DSCR-based repayment sculpting and cash sweep logic, giving a realistic debt service profile.

What's included in the base version

• Multi-vessel input sheet with vessel specs, build year, flag, and class
• Charter revenue module with time charter, spot, and bareboat contracts
• Utilisation and off-hire calendar (mechanic, weather, dry-dock)
• Operating cost module (crew, bunker, lube, R&M, insurance, port charges, G&A)
• Dry-docking schedule with CapEx and off-hire integration
• Manning and crew rotation calculator with travel costs
• Fixed asset register with depreciation (straight-line and declining balance)
• Financing module (equity, senior debt, lease, revolving credit)
• Multi-currency P&L, cash flow, and balance sheet
• Tax module with tonnage tax and deferred corporate tax options
• Scenario manager with base, downside, and upside cases
• IRR, NAV, and DSCR dashboard with summary charts

Common modeling mistakes

• Modeling a single blended utilisation rate without off-hire categories – overstates effective day revenue by 15–25% and hides the cash drain of dry-dock periods.
• Treating dry-docking as a pure operating expense or ignoring it entirely – EBITDA is overestimated by 8–12% in years with a survey and the balance sheet misses a material capital liability.
• Using a fixed fuel consumption rate for all vessel modes – understates bunker cost by 10–18% when the vessel performs heavy anchor handling or dynamic positioning work.
• Ignoring mobilisation and demobilisation economics – the reported margin on spot jobs is distorted because fuel, port, and off-hire costs during repositioning are buried in general G&A.
• Assuming crew cost is fixed regardless of spot voyage intensity – overtime and standby pay can increase crewing cost by 7–12% during high-activity periods, eroding spot profitability.
• Applying a single flag tax regime when operating in multiple jurisdictions – deferred tax liabilities and tonnage tax benefits are misstated by several percentage points, altering return metrics.
• Keeping insurance premiums flat over vessel life – H&M and P&I costs typically escalate 3–6% p.a. after the 10-year mark, meaning projected cash flows become overly optimistic in the tail years.
• Not linking maintenance reserve to vessel age and class history – repair costs can jump by 30–50% after the second special survey, which a flat reserve fails to capture.