Product Tanker Operator Financial Model

Description

Built for a company operating a fleet of product tankers transporting refined petroleum products (gasoline, diesel, jet fuel, naphtha) on spot, time-charter, and COA contracts. The model captures vessel-level physical specs, market TCE (Time Charter Equivalent) dynamics, and the interplay between voyage revenues, bunker costs, and utilization across multiple trading routes.

Voyage expenses are broken down into bunker consumption (IFO 380, VLSFO, MGO) for laden/ballast legs, port calls, and canal transits (Suez, Panama), adjusting for fuel price differentials and port fee tariffs. Revenue per vessel is driven by DWT, prevailing market rates, and actual operating days, with automatic off-hire for dry docking and breakdowns.

The fleet CAPEX module handles newbuilding and second-hand acquisitions with milestone-based payment schedules. Operational logic includes dry dock cycles (every 2.5–5 years), special survey reserves, ballast water treatment retrofits, and IMO environmental compliance steps, all reflected in OPEX, off-hire days, and asset impairment.

Financing is structured around ship mortgages with balloon payments, floating interest rates (SOFR/LIBOR + margin), and interest-only periods. Consolidation yields fleet-level financials, investor cash flows, and shipping-specific KPIs: net TCE, daily OPEX per vessel, fleet utilization, loan-to-value ratios, and unlevered/levered returns.

Modeling specifics

• Individual Vessel Modeling: Each tanker carries its own DWT, age, speed-consumption curves, hull type, and flag state, feeding into a vessel-level P&L that rolls up to the fleet.
• Dynamic Charter Mix Engine: Vessels can shift between spot, time-charter, and COA segments period by period, with differing TCE rate assumptions, utilization factors, and voyage commission structures.
• Bunker Fuel Cost Engine: Calculates consumption by voyage phase using specific fuel types (IFO 380, VLSFO, MGO) and applies regional price spreads; includes scrubber/no-scrubber logic and fuel hedging inputs.
• Dry Dock and Special Survey Scheduler: Automatically budgets yard costs, off-hire days, and capex reserves for each vessel's 5-year special survey and intermediate dry docks, preventing OPEX/CAPEX misclassification.
• Shipping-Specific Debt: Mortgage facility with advance rate of 60–80%, balloon at maturity, step-up repayments, and floating rate; handles multiple drawdowns linked to vessel deliveries.
• Newbuilding Payment Waterfall: Ties equity contributions and debt drawdowns to shipyard milestones (keel laying, launching, delivery) and integrates pre-delivery inspection and supervision costs.
• IMO Environmental Compliance: Separately models scrubber installation, low-sulfur fuel adoption, CII/DSCI trajectory, and EU ETS allowance costs, affecting OPEX, off-hire, and terminal vessel value.
• Leaseback Terminals: Optional structure where a vessel is sold and bareboat-chartered back, modeled as an off-balance-sheet or capital lease with residual value guarantee.

What's included in the base version

• Fleet schedule and employment manager (spot/time-charter mix, vessel positioning)
• Vessel-level technical database (DWT, speed, fuel curves, age, hull type)
• Revenue model with TCE calculation and voyage charter recognition
• Voyage expense engine (bunker fuel, port charges, canal tolls, brokerage)
• OPEX module per vessel (crewing, insurance, stores, routine maintenance)
• Dry docking scheduler and statutory survey reserve accounting
• CAPEX module for vessel acquisitions (newbuilding milestones, second-hand purchases)
• Ship mortgage financing (one facility per vessel)
• Financial statements (monthly/quarterly P&L, Balance Sheet, Cash Flow)
• Fleet-level consolidation and investor equity waterfall
• Standard shipping KPIs (Net TCE, daily OPEX, fleet utilization, Cash Breakeven, Project IRR)

Common modeling mistakes

• Underestimating dry dock off-hire days – fleet utilization overstated by 2–4%, dry dock CAPEX deferred, inflating near-term cash flow.
• Ignoring bunker fuel price differentials between IFO 380 and VLSFO – voyage expenses understated by 15–20% for non-scrubber vessels.
• Modeling spot TCE as constant rather than linked to market indices and vessel age – revenue over-optimistic by 10–25% for older tonnage.
• Treating ship mortgage principal as level payments without a balloon – cash flow strain masked in early years; DSCR drops by 0.8–1.5x.
• Not phasing newbuilding CAPEX by yard milestones – pre-delivery funding gap can exceed 30–50% of contract price, distorting equity requirements.