Chemical Tanker Operator Financial Model

Description

The model replicates the operations of a chemical tanker company, handling a diversified fleet of IMO type II/III parcel tankers that transport multiple segregated grades simultaneously. It captures the nuances of stainless steel and coated tanks, cargo compatibility matrices, and mandatory tank cleaning between incompatible cargos—including cleaning time and consumable costs that directly impact voyage profitability.

Employment mix is fully modeled: spot voyage charters, contracts of affreightment (CoA) with multi-lift terms, and time charters. Each fixture generates detailed voyage estimates with freight rate (Worldscale or lumpsum), cargo volumes per grade, load/discharge ports, bunker costs, port and canal tariffs, and demurrage/despatch terms. The model accounts for ballast legs and repositioning to optimize the fleet schedule.

Regulatory and environmental factors are embedded: compliance with MARPOL Annex II, IBC Code, EU ETS (for EU-bound voyages), IMO DCS/CII rating projections, and effects of EEXI/engine power limitation on speed and fuel consumption. Dry-docking and special surveys are scheduled per vessel based on ship type and age, with detailed cost buildup and off-hire days affecting cash flow.

Financial outputs consolidate vessel-level results into corporate financial statements, debt service schedules (including ship mortgage with balloon structures), tax depreciation over economic life, and liquidity reserves. Sensitivity and scenario analysis cover key levers such as freight rate volatility, bunker price, utilization, and FX movements, enabling robust stress testing of the business plan.

Modeling specifics

• Tank coating/grade compatibility matrix that restricts consecutive cargo sequences, automatically inserting cleaning periods and chemical costs, preventing revenue overestimation when switching between incompatible cargos.
• Separation of spot voyage fixtures and CoA program, with CoA volume flexibility and escalation clauses, avoiding the error of averaging freight rates across all employment.
• Voyage estimation engine that calculates port-specific charges (including chemical tanker surcharges for hazardous cargo) and transit canal tolls based on vessel dimensions and loaded/ballast condition.
• Demurrage and laytime modeling for spot voyages, incorporating laycan, agreed laytime, demurrage rate, and despatch, enabling accurate net voyage TCE calculation that reflects real fixture terms.
• Bunker consumption adjusted for speed, draft, and ECA passage, with fuel grade switching options (HFO, VLSFO, MGO) and associated price scenarios, so that voyage cost is precise.
• Dry-dock and special survey scheduling based on ship age and survey cycle, with cost escalation and correct off-hire days, ensuring cash flow projections are not distorted in docking years.
• Crew cost modeling with nationalities, CBAs, and inflation-linked escalation, plus differentiate between manning in rotation and standby, capturing the real operating cost structure over long hold periods.
• Fleet expansion timeline with sequential newbuilding deliveries or second-hand acquisitions, where each new vessel integrates into the schedule on its delivery date, with pre-delivery financing drawdowns.

What's included in the base version

• Fleet schedule and employment dashboard with vessel chartering status
• Voyage-level revenue and voyage expense model (per fixture)
• Operating expenses breakdown (crew, technical, stores, insurance, management fees)
• Dry-dock and special survey schedule with cost and off-hire modeling
• Corporate profit & loss statement, balance sheet, and cash flow
• Debt financing module with multiple tranches, grace periods, and balloon repayments
• Depreciation calculator and corporate tax computation
• Key financial KPIs and returns (project IRR, equity NPV, DSCR, LLCR)
• Sensitivity tables on freight rate, bunker price, vessel utilization, and FX
• Executive dashboard with charts, vessel utilization alerts, and covenant health

Common modeling mistakes

• Using a single blended freight rate for all cargo grades and ignoring product-specific premiums — distorts gross voyage revenue by 15–20% compared to grade‑level pricing.
• Omitting tank cleaning downtime and consumable costs when switching cargo types — overstates available earning days by 8–12% and understates voyage expenses by a factor of 2–3.
• Ignoring ballast leg distance and repositioning fuel cost — overstates TCE for spot fixtures by 15–25%, especially in triangulation patterns.
• Neglecting demurrage revenue and assuming cargo operations always finish within laytime — misses earnings that can account for 5–10% of freight income per fixture.
• Applying a flat annual utilization rate without seasonal market and CII‑driven slow‑steaming — leads to overestimation of annual tonne‑mile employment by 5–15% during weak markets.
• Not modeling dry‑dock cash outflows and off‑hire days explicitly — understates free cash shortfall by 30–50% in the year a survey falls due.