Cruise Line Operator ModelFree Financial Model Download
A five-year operating model for a multi-ship cruise line. Project fleet deployment across three ship classes, build APCD and OPCD capacity, run ticket and onboard yield through a per-class revenue build, and read Y5 revenue, EBITDA margin, occupancy, gross yield, and fuel cost share off a one-page dashboard with traffic-light status.
Free download. No sign-up required.
About this model
A cruise line operator model projects five years of revenue, opex, EBITDA, and net income for a multi-ship cruise line built on three ship classes — Small (premium, ~1,800 berths), Mid (contemporary, ~3,200 berths), and Large (mega-ship, ~5,400 berths) — with class-level berths, sailings per year, cruise duration, ticket yield ($/PCD), onboard yield ($/PCD), fuel cost per APCD, crew / port / insurance cost per APCD, and newbuild capex per ship. Comparable operating economics: Carnival (CCL), Royal Caribbean (RCL), Norwegian Cruise Line (NCLH).
The Fleet sheet runs closing ships per class from starting headcount plus a newbuild schedule (ships added per class per year) and computes average ships (opening + closing) / 2 for the deployment view. The Capacity sheet builds APCD per class as average ships × berths × sailings × cruise days, then OPCD = APCD × Occupancy (default 105% to reflect 3rd/4th-berth bookings on the industry's double-occupancy basis). Passengers carried = OPCD / class-specific cruise duration summed across classes.
The Revenue sheet runs ticket revenue per class = OPCD × Ticket_Yield × (1 + Yield_Growth)^(year-1) and onboard revenue per class = OPCD × Onboard_Yield × (1 + Yield_Growth)^(year-1). Total revenue = ticket + onboard. The P&L sheet runs fuel (APCD × Fuel/APCD × inflation), crew / port / insurance (APCD × Crew/APCD × inflation), commissions (% of ticket revenue), marketing (% of total revenue), and G&A (fixed base × inflation) to total opex and EBITDA. Below the line: D&A as % of revenue, interest as Debt% × cumulative fleet capex × Int_Rate (approximation appropriate for a v1 operating model), tax on positive EBT, net income, and EBITDA / net margin lines.
The Dashboard surfaces Y5 revenue, EBITDA, EBITDA margin (with traffic-light status against thresholds set in Assumptions), occupancy (with status), gross yield $/APCD (with status), fuel cost as % of revenue, total ships in fleet at Y5, passengers carried, and a Y5 capacity-mix table by ship class. Industry benchmarks baked into the threshold defaults: EBITDA margin 25-32% at scale, occupancy 100-108%, gross yield $260-340/APCD in normal operations, fuel 8-14% of revenue. Cruise line CFOs, hospitality investors, equity research analysts, and asset managers use this model to underwrite operating plans, justify newbuild capex against incremental margin contribution, and stress-test yield and fuel assumptions against industry benchmarks.
Recolor to your brand.
Formatted to IB standards.
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with blue inputs, black formulas, and green cross-sheet links.
- Brand-ready
- Institutional grade
- Fully auditable
What's included
- Three ship classes (Small, Mid, Large) with editable berths, sailings per year, cruise duration, ticket and onboard yield, fuel and crew $/APCD, and capex per ship
- Newbuild schedule per class across five years to drive fleet growth
- Fleet sheet with closing ships, average ships, and total berths per class
- Capacity sheet computing Available and Occupied Passenger Cruise Days (APCD / OPCD) per class plus passengers carried
- Revenue sheet with per-class ticket and onboard yield × OPCD and annual yield growth
- P&L from revenue through fuel, crew/port/insurance, commissions, marketing, G&A, EBITDA, D&A, interest, tax, and net income, with EBITDA and net margin lines
- Dashboard with Y5 revenue, EBITDA, EBITDA margin, occupancy, gross yield, fuel % of revenue, ships in fleet, and passengers carried
- Status thresholds in Assumptions so on-track / watch / soft logic can be tuned
Built on industry-standard APCD capacity
Capacity is built bottom-up per class: APCD = average ships × berths × sailings × cruise days. OPCD = APCD × Occupancy. Revenue rides off OPCD; fuel and crew opex ride off APCD, the way cruise operators actually report.
Per-class yield economics
Each of the three ship classes carries its own berths, sailings per year, cruise duration, ticket yield, and onboard yield. Mix shifts toward larger ships lift APCD but typically compress yield, and the per-class revenue blocks make the tradeoff visible.
Dashboard with traffic-light status
Y5 EBITDA margin, occupancy, and gross yield each resolve to On track / Watch / Soft against user-set thresholds in Assumptions. Industry benchmarks are baked into defaults: 25-32% EBITDA margin, 100-108% occupancy, $260-340 gross yield per APCD.
Frequently asked
What is a cruise line operating model?+
A cruise line operating model projects revenue, opex, and EBITDA for a fleet of cruise ships built on capacity (available passenger cruise days), occupancy, and yield per occupied day. It tracks how berths, sailings per year, ticket yield, and onboard yield combine into total revenue, then subtracts fuel and crew (per APCD), commissions, marketing, and G&A to arrive at EBITDA.
What is APCD and why does it matter?+
APCD = Available Passenger Cruise Days = berths × sailings per year × cruise days × ships. It is the cruise industry standard capacity metric and the right denominator for fuel and crew costs (both incur whether the ship is sold out or empty). Revenue, by contrast, scales with OPCD = APCD × occupancy.
Why can occupancy exceed 100%?+
Cruise occupancy is calculated on a double-occupancy basis (2 passengers per cabin). When third and fourth berths are sold (common in family cabins), occupancy can exceed 100%. The industry-standard healthy occupancy benchmark is 100-108%.
How is interest computed without a full debt schedule?+
Interest is Debt_Pct × cumulative fleet capex × Int_Rate. Cumulative fleet capex is the sum of newbuild capex through the year (newbuild ships × capex per ship × $M scaler) plus cumulative maintenance capex (sum of prior revenues × Maint_Pct). It is an approximation appropriate for a v1 operating model — pair with the debt-schedule template for a full per-tranche amortisation view.
Does this replace a 3-statement model?+
No. This is a P&L-only operating model. There is no balance sheet, working capital, or cash flow statement. Pair with the 3-statement template if you need closing cash, debt roll-forward, or full BS / CF visibility.
Alex Tapio
Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte
Related templates
Hotel Operating Model
Operating model for hotel properties including occupancy rates, average daily rate (ADR), RevPAR optimization, and facility-level profitability.
Airline Operations Model
Airline financial projections with route, fleet, and capacity planning.
Theme Park Operating Model
Model theme park revenues by operating season, attendance drivers, and operating expenses with leverage and returns.