Offshore PSV Operator Financial Model

Description

The model replicates a full-cycle platform supply vessel operator that acquires one or more PSVs (newbuild or second‑hand) and deploys them under time‑charter agreements with escalators and optional periods, as well as spot market hires. A blended utilisation engine switches between contract regimes, reflecting the reality that a vessel rarely works 365 days a year on a single contract.

Operating expenditure is split into running costs (crew, insurance, technical management), voyage‑related costs that may fall to the owner or charterer depending on the charter party, and the critical element of periodical large‑scale maintenance. Mandatory class special surveys and dry‑dockings are modelled as scheduled off‑hire windows with upfront cash outflows and pre‑built reserve fund accruals, so the user sees the true cash‑flow profile.

Financing is structured through a senior mortgage loan with a grace period, variable interest rate, covenant package (DSCR, minimum liquidity, dividend lock‑up) and a balloon repayment at maturity. The cash waterfall respects lender‑priority distributions and can sweep excess cash toward mandatory prepayment, giving a lender‑ready view of the deal.

The workbook is built to handle a fleet of vessels with staggered acquisition dates and different technical lifecycles, consolidating free cash flow at a holding‑company level and allowing the user to test expansion scenarios or vessel replacement strategies within a single file. An embedded multi‑currency environment reflects the fact that vessel purchase may be denominated in EUR while dayrate revenue is in USD and local operating costs in another currency.

The model demonstrates the scale of capital required for a modern PSV operator, which can run into the tens of millions of dollars depending on vessel specification and financing structure. The figures shown are indicative and are meant to illustrate the order of magnitude of investment, not a definitive project valuation.

Modeling specifics

• Dual charter regime with spot‑market transition – the vessel automatically shifts to a spot‑market profile when off‑charter, with separate utilisation and dayrate assumptions that can include a risk premium over time‑charter rates.
• Dynamic dry‑dock and special survey scheduler – a maintenance calendar linked to vessel age and class cycle extracts the vessel from service, accrues survey funds, and distributes the actual capital outlay over the off‑hire weeks, preventing the common mistake of treating dry‑docks as smooth monthly opex.
• Financing waterfall with multi‑tranche debt and covenant testing – cash flow is cascaded through senior debt service, reserve accounts, and liquidity buffers; DSCR and minimum cash covenants are tested at each period, and a sweep mechanism allocates excess cash to mandatory prepayment if thresholds are breached.
• Balloon repayment and refinancing assumption – the senior loan includes a substantial bullet at maturity; the model offers a toggle to assume refinancing or vessel sale at a terminal value, with separate cash‑flow treatment so the impact on equity IRR is isolated.
• Multi‑vessel consolidation with interlinked fleet age profile – each vessel has its own acquisition date, depreciation, survey cycle, and charter history, and the model aggregates free cash flow at HoldCo level while preserving individual asset metrics for performance analysis.
• Tonnage‑tax vs. corporate income tax toggle – users can switch between a standard depreciation‑based tax calculation (accelerated or straight‑line) and a simplified tonnage‑tax regime typical of many shipping jurisdictions, altering after‑tax cash flows and investor returns with a single click.
• Multi‑currency construction and operation – vessel purchase, debt, revenue, and operating costs can be specified in different currencies with automatic translation at user‑defined or projected exchange rates, and the effect of FX moves on equity IRR is visible in real time.

What's included in the base version

• Single‑vessel revenue engine with time‑charter and spot‑market modules, dayrate escalation, and utilisation scheduling
• Operating expenditure model separating running costs, voyage costs (owner/charterer allocation), and periodic maintenance reserves
• Dry‑dock and special survey calendar with off‑hire blocking and reserve fund accrual
• Vessel acquisition capex (newbuild or second‑hand) with phased payment milestones
• Senior mortgage financing module with customisable grace period, interest rate, balloon, and financial covenants
• Tax regime switch (tonnage tax vs. corporate income tax with depreciation)
• Multi‑currency framework for translating vessel cost, debt, revenue, and opex into a presentation currency
• Monthly integrated financial statements (income statement, cash flow, balance sheet) over a 15‑year project horizon
• Key investment metrics dashboard: Project IRR, Equity IRR, DSCR, NPV, and dividend capacity

Common modeling mistakes

• Applying a flat annual utilisation rate without deducting scheduled dry‑dock off‑hire – revenue is overstated by 5–15% and cash‑flow gaps are completely hidden.
• Treating dry‑dock costs as smooth monthly operating expenses instead of lump‑sum outflows with a reserve fund – DSCR and liquidity covenants appear much stronger than in reality, masking the actual refinancing pressure.
• Ignoring the balloon payment at loan maturity and modelling perpetual amortisation – the cash‑flow shock and refinancing risk are pushed 10–12 years into the future, making the investment look safer than it is.
• Using a single dayrate for both time‑charter and spot periods without reflecting spot‑market volatility – spot revenue is systematically overestimated, often inflating equity IRR by several percentage points.
• Forgetting to split fuel and port charges between owner and charterer under different charter party terms – can misallocate 20–30% of voyage costs and distort EBITDA margin by an equivalent amount.
• Assuming the vessel and all cash flows are in one currency when purchase is often in EUR and dayrate in USD – exchange rate fluctuations can swing equity IRR by 2–5 percentage points over the project life.