LPG Tanker Operator Financial Model

Description

A dedicated vessel-operating financial model built for an LPG carrier company, covering the complete lifecycle from acquisition (newbuild or second-hand) through operation, debt service, and eventual disposal. The model mirrors the economics of a modern gas tanker—whether a fully refrigerated VLGC, a semi-refrigerated MGC, or a pressurized handy-size vessel—and is structured to serve both pure shipowners and industrial operators moving their own propane/butane.

The operational core captures the unique physics of LPG shipping: boil-off gas management, reliquefaction plants, maximum allowable working pressure constraints, compatibility with dual-grade cargoes (propane, butane, ammonia), and the resulting impact on voyage speed, fuel consumption, and port stay. Every revenue day is linked to a vessel routing logic that allows ballast legs, canal passages (Panama, Suez), and seasonal terminal queues that directly affect utilization.

Revenue strategy is decentralized: the user can blend period time-charter contracts with open spot-market voyages, assign seasonal freight indices, and simulate multi-year charter parties with escalation clauses. The model also accounts for cargo-specific freight premiums, waiting time at berth, and demurrage/despatch regimes, giving a realistic picture of risk-adjusted earnings rather than a flat daily rate.

On the cost side, the model granularly projects technical management fees, crew wages by nationality/manning scale, lubes and stores, hull and machinery insurance, P&I club calls, and periodic dry-dockings aligned with the vessel’s special survey cycle. It incorporates flag-state and class-related costs, including planned maintenance of cargo handling systems (pumps, compressors) and regulatory retrofits driven by IMO 2020, EEXI, and CII, with the ability to switch fuel strategy and predict the resulting operating expenditure trajectory.

The financing structure supports senior debt with flexible drawdown profiles during construction (if any), grace periods, and sculpted or annuity repayment, alongside shareholder equity injection. A dedicated tax module optionally toggles between corporate income tax and a tonnage-tax regime, capturing relevant capital allowances and ring-fenced shipping activities. Intercompany fees and management charges are built in for groups that operate through a separate ship manager, ensuring the model reflects the legal and commercial structure actually used in the industry.

Modeling specifics

• Voyage-based profitability engine with port-call databases, canal tariffs, and time-in-port algorithms that adjust for terminal type, cargo parcel size, and berth availability, avoiding the common pitfall of a simple daily-rate multiplier.
• Gas-carrier physics: boil-off rate, reliquefaction energy consumption, and maximum filling limits by cargo temperature are explicitly modeled, so changes in cargo slate or voyage length automatically recalculate fuel and cargo loss.
• Dynamic bunker management with multi-fuel selection (VLSFO, MGO, HFO+scrubber, LPG-as-fuel) and a real-time emissions calculator that projects the vessel’s Carbon Intensity Indicator (CII) trajectory and EEXI compliance costs over the holding period.
• Dry-dock and special survey scheduler that splits CAPEX into tailshaft, hull blasting, cargo-tank inspection, and pump/compressor overhauls, triggered by age and calendar, with automatic impact on off-hire days.
• Contract stacking engine that layers multiple time-charter agreements and spot periods with user-defined seasonal rate curves, escalation formulas, and options for charterer's redelivery windows, giving a true picture of cash-flow lumpiness.
• Integrated financing waterfall with debt-sculpting, cash-sweep mechanisms, and liquidity reserve covenants that replicate the typical ring-fenced borrowing structure of a single-ship SPV, preventing uncontrolled dividend leakage.
• Tax regime selector that simultaneously computes corporate tax with accelerated depreciation and a tonnage-tax calculation based on net tonnage, allowing direct after-tax comparison for flag and jurisdiction planning.

What's included in the base version

• Voyage-level revenue builder with port costs, canal fees, and terminal waiting days
• Bunker consumption matrix (main engine, generators, boil-off) linked to fuel price curves
• Technical and crew OPEX calculator with flag, manning scale, and insurance (H&M, P&I) projections
• Dry-dock and special survey CAPEX planner synchronized with IACS class intervals
• Multi-contract revenue stacking: time-charter and spot with seasonal indices and escalation
• Senior debt facility with grace period, sculpted/annuity repayment, and interest rate swaps
• Full three-statement financial output (P&L, cash flow, balance sheet) on a quarterly/annual basis
• Scenario manager and sensitivity tables for freight rates, bunker prices, and operational utilization

Common modeling mistakes

• Applying a flat daily rate without accounting for ballast legs and port waiting days — overstates voyage revenue by 15–25% and hides the true volatility of spot operations.
• Treating all port costs as a single lump sum — underestimates gas-terminal specific dues, nitrogen purging, and cargo handling fees by 20–30%, making marginal voyages appear more profitable than they are.
• Ignoring reliquefaction energy consumption and boil-off cargo loss — understates OPEX by 8–15% for fully refrigerated VLGCs on long laden voyages, artificially boosting the bottom line.
• Skipping the effect of hull fouling and speed degradation between dry-docks — inflates annual carrying capacity by 5–7% and underbanks fuel cost, leading to an overoptimistic repayment schedule.
• Omitting liquidity-reserve covenants and off-hire reserve accounts — overstates free cash available for dividends by 12–18% and can hide a technical default on the loan.
• Treating major cargo-system overhauls (pumps, compressors) as ordinary maintenance — misses $1.5–3 million lump-sum CAPEX per vessel per decade, shifting the break-even point by 1.5–2.5 years.