LNG Tanker Operator Financial Model

Description

This model captures the full economics of a modern LNG carrier under own ownership or long‑term charter, addressing the specific physical and commercial realities that separate LNG shipping from standard bulk or tanker operations. It spans the entire lifecycle of the vessel, from construction drawdowns and acceptance trials through trading operations to residual value realisation.

The core revenue logic handles time charter, spot Cargo (single and multi‑leg), and pool participation, with detailed laytime and demurrage calculations. Charter‑party clauses such as take‑or‑pay windows, profit‑sharing, and heel obligations are structurally embedded, allowing the user to test different contract mixes and see how voyage‑specific costs flow through to TCE and daily earnings.

Operationally the model incorporates dual‑fuel (tri‑fuel where applicable) propulsion, modeling gas vs. pilot diesel split across speed bands, gas combustion unit (GCU) and re‑liquefaction plant utilisation to manage boil‑off. Boil‑off gas (BOG) is not a flat percentage – it varies with ambient conditions, tank insulation class, cargo containment system (membrane vs. Moss) and vessel age. This BOG balance is integrated into both fuel consumption and cargo delivery calculations.

Costs are built from voyage‑level detail: canal transit fees (Suez/Panama) with all‑in tug and agency charges, port disbursements, fuel oil and LNG bunker prices in major hubs, crew, technical maintenance and periodic dry‑dockings. Insurance (H&M, P&I, war risk) and management fees are layered in, giving a full OPEX picture that reflects flag‑state and trading‑route realities.

The financing section models senior debt with flexible terms, grace periods, balloon payments and variable interest rates, alongside operating lease or bareboat charter structures. Tax assumptions cover tonnage tax regimes and corporate income tax, creating a realistic post‑tax cash flow to support NPV, IRR and debt‑service coverage ratios over a project horizon of 20–25 years.

Investment magnitude is illustrative – the model is designed for assets where capital commitments run to hundreds of millions of dollars per vessel. It shows the order of numbers, allowing the user to validate the logic and swap in their own assumptions without being forced to a pre‑packaged price tag.

Modeling specifics

• Dynamic boil‑off gas model driven by monthly sea/air temperatures, tank insulation type, and cargo containment system, influencing both fuel availability and delivered cargo volume.
• Dual‑fuel engine consumption split between gas and pilot diesel mapped to actual speed‑consumption curves, with automatic recalculation when vessel speed changes.
• Detailed re‑liquefaction and gas combustion unit logic: model selects whether to reliquefy, burn in GCU, or use as propulsion fuel based on market gas price and emission constraints.
• Cargo heel requirement modelling – minimum liquid volume retained in tanks to maintain temperature – accounting for lost cargo capacity and its impact on working capital.
• Multi‑leg voyage builder for spot cargoes with load/discharge terminals, draft restrictions, canal options and boil‑off accumulated across each leg.
• Canal transit cost engine covering Suez and Panama net tonnage, escort tugs, agency fees and waiting time, with automatic adjustment for laden vs. ballast passage.
• Charter‑party cashflow engine handling hire payments, performance bonuses, fuel‑oil differential clauses and off‑hire days in a single unified timeline.
• Vessel efficiency degradation over age: hull fouling and engine wear factor into fuel consumption forecasts, directly affecting voyage margins and residual value estimates.
• Integrated fuel inventory accounting – LNG bunker stock (aboard and destination) alongside diesel, with re‑order logic based on voyage length and price differentials.
• Time‑charter resume module that generates a multi‑year revenue projection from a sequence of consecutive fixtures, each with its own rate, escalation and optional extension periods.

What's included in the base version

• Revenue model: time charter (fixed & escalation), spot voyage TCE, pool earnings
• OPEX breakdown: crew, insurance (H&M, P&I), technical management, spares, lubes, stores
• Voyage cost calculator: bunkers (LNG and diesel), canal tolls, port charges, agency fees
• Boil‑off gas balance: heel requirement, boil‑off rate curves, re‑liquefaction/GCU dispatch
• Vessel maintenance: dry‑dock cycle, special surveys, capex for upgrades
• Financing debt module: senior loan, annuity/symmetric amortisation, grace period, balloon
• Tax module: tonnage tax and/or corporate income tax, deferred tax asset tracking
• Consolidated financial statements (P&L, cash flow, balance sheet) over project life
• Investment metrics: free cash flow, NPV, IRR, debt service coverage ratios, payback
• Sensitivity‑ready input structure with scenario manager shells for key drivers

Common modeling mistakes

• Assuming a constant boil‑off rate regardless of season, insulation type and vessel age – overstates delivered cargo revenue by 5–9% and distorts voyage profitability.
• Ignoring the LNG heel requirement – inflates effective cargo capacity by 1.5–3%, understates working capital and creates unrealistic off‑hire cash inflows.
• Modelling a single blended fuel cost instead of splitting LNG bunker from pilot diesel – misstates voyage cost by 4–8% and hides the real impact of dual‑fuel efficiency.
• Not linking boil‑off gas utilisation to re‑liquefaction or GCU capacity constraints – can overvalue spot cargoes by 2–4% when gas prices are low.
• Overlooking canal transit fees, waiting time and escort tug costs for laden/ballast conditions – underestimates voyage expenses by $15,000–$45,000 per transit, depending on route.
• Applying the same vessel speed irrespective of market and charter party terms – inflates TCE by 6–12% in a weak market when operators slow steam.
• Treating dry‑dock as a simple annual cash charge instead of a multi‑day off‑hire event with lost revenue and large capex lump – shortens effective earning days by up to 2% and distorts cash timing.
• Excluding the gradual degradation of hull and engine efficiency – overstates late‑life project cash flows by 3–7% and residual value by a similar margin.