Coastal Small-tonnage Dry Cargo Operator Financial Model

Description

This financial model is tailored for a coastal small-tonnage dry cargo shipping company, operating a fleet of multi-purpose or mini-bulk vessels (approx. 3,000–10,000 DWT) in short-sea trades. It handles the tramp shipping business model — spot voyage charters, time charters, and contracts of affreightment — transporting breakbulk, bulk, or containerized dry cargoes. The model provides an order-of-magnitude estimate of total up-front investment: vessel purchases (second-hand or newbuild), pre-operational expenses, and the working capital to cover the first voyages until freight is collected.

Operations are modeled voyage-by-voyage with a per-vessel schedule. For each trip, the model calculates port-to-port distance, sailing time, fuel consumption at laden and ballast speeds, and the earned gross freight based on cargo intake and the agreed freight rate per tonne. Port costs are broken down into detailed items (pilotage, towage, berth dues, cargo handling) and can be adjusted by country. Demurrage and despatch are calculated from laytime statements, coupling revenue to terminal efficiency. The fleet can be deployed with a mix of voyage charters and period time charters, with appropriate revenue recognition and cost allocation.

Fleet maintenance is modeled with age-based cost escalation and mandatory dry-docking cycles. Each vessel is assigned a dry-docking schedule linked to its age and classification society requirements; the model books off-hire days and specific capital outlays for the dock, repairs, and special survey. A dedicated reserve fund feature can spread these lumpy costs over operating years. Operating expenses — crew, insurance, stores, technical management — are projected per vessel and escalate with inflation and crew seniority.

The financial structure includes senior debt with a ship mortgage, customized repayment profiles (including balloon), and currency flexibility. Working capital is driven by the gap between immediate voyage disbursements (bunkers, port charges) and delayed freight receipts; the model sizes the required revolving facility or equity buffer automatically. Full financial statements (income statement, cash flow, balance sheet) and key shipping KPIs — TCE, fleet utilization, EBITDA per vessel — are generated. A set of sensitivities tests the resilience to freight rate, bunker price, and utilization shocks.

Modeling specifics

• Voyage-specific fuel consumption curves that vary by vessel condition (laden/ballast) and speed, not a single daily average.
• Integrated demurrage/despatch calculation based on laytime allowed and actual loading/discharge rates, adjusting effective freight earnings.
• Detailed port cost builder with itemized tariffs (pilotage, towage, berth, cargo handling) and country-level customization.
• Age-dependent dry-docking cycle with off-hire days and capital outlay for special survey, dock rent, and repairs — not a simple annual provisioning.
• Time charter hire modelling with escalation index and off-hire periods for scheduled maintenance, linked to the dry-docking calendar.
• Working capital sizing driven by the timing mismatch between upfront voyage disbursements and freight collection delays (payable in 15–45 days).
• Ballast leg economics and triangular trade logic so that repositioning costs are fully accounted for in voyage profitability.
• Separate reserve fund mechanism to smooth lumpy dry-docking and major repair costs over operating years, with interest accrual.
• Dual flag-state and tonnage tax regime selector, allowing comparison of net income under different fiscal settings.

What's included in the base version

• Voyage revenue model (spot, time charter, contract of affreightment)
• Multi-vessel schedule with port-to-port distances and ballast legs
• Port cost database with optional country-specific tariffs
• Fuel and lubes consumption per voyage (laden/ballast, speed-dependent)
• Operating expenses per vessel with escalation drivers
• Dry-docking schedule, off-hire days, and survey capital expenditure
• Senior debt financing with customizable repayment and balloon structure
• Working capital module (receivables, payables, revolving credit)
• Profit & loss, cash flow, and balance sheet statements
• Shipping KPIs (TCE per day, fleet utilization, EBITDA per vessel)
• Sensitivity tables for freight rate, bunker price, and utilization
• Corporate income tax or tonnage tax regime selection

Common modeling mistakes

• Ignoring demurrage/despatch and terminal delays — overstates effective freight rate by 5–15%.
• Using a flat daily fuel consumption regardless of speed and draft — underestimates bunker costs by 10–20%.
• Overlooking dry-docking off-hire and special survey capex — understates total vessel costs by 8–12% per annum.
• Assuming 100% utilization without seasonal weather or port congestion — overestimates annual cargo volume by 10–25%.
• Not modeling freight payment terms (cash out for bunkers today, cash in 30–45 days later) — understates working capital need by 30–50%.