# Cruise Line Operator Model

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.

- Canonical: https://finamodel.com/templates/cruise-line
- Excel download: https://finamodel.com/templates/cruise-line.xlsx
- Category: Hospitality
- Model type: Operating model
- Difficulty: Intermediate
- Audiences: Developers & sponsors, Investors & analysts, Cruise line CFOs, Hospitality investors, Equity research analysts, Asset managers
- Tags: cruise, fleet, apcd, onboard yield, occupancy

## Overview

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.

## 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
- Three ship classes (Small / Mid / Large) with editable berths, sailings, cruise duration, ticket and onboard yield, fuel and crew $/APCD, and capex per ship
- Fleet sheet with closing and average ships per class plus total berths
- Capacity sheet computing Available and Occupied Passenger Cruise Days (APCD / OPCD) per class and passengers carried
- Per-class ticket and onboard revenue with 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, margin (status), occupancy (status), gross yield (status), fuel % of revenue, ships, and passengers, plus a Y5 capacity-mix table
- Status thresholds in Assumptions for margin, occupancy, and yield

## Understanding the Cruise Line Operator Model: Fleet, Capacity, Revenue, and Cash Flow

This cruise line model projects five years of operations for a mid-cap operator with three ship classes. It builds capacity from fleet deployment, converts occupied days into ticket and onboard revenue, and layers in full cruise-line costs to produce EBITDA, free cash flow, and leverage.

A dashboard scores key metrics against industry thresholds.

### Key Operating Drivers

The model is driven by three ship classes: Small (~1,800 berths), Mid (~3,200 berths), and Large (~5,400 berths).

- Each class has its own sailings per year, cruise duration, ticket yield, onboard yield, fuel cost, port and crew operating costs, newbuild capital expenditure, and useful life.

- Fleet size ramps from six ships to eleven by Year 5.

- This class-level granularity allows you to test how deployment mix shifts capacity and economics.

### Calculation Flow and Revenue Build

Capacity starts with available passenger cruise days (APCD) per ship, calculated as berths times sailings per year times cruise duration. Total APCD sums the average ships in each class multiplied by per-ship APCD.

- Occupied passenger cruise days (OPCD) equal APCD times an occupancy rate, defaulting to 105%. Revenue is built per class: ticket and onboard revenues are class OPCD times their respective yields, grown annually.

- Total revenue is the sum across classes and revenue types. Operating costs include fuel, food, crew, port, commissions, marketing, and general and administrative expenses, with fuel scaling off APCD.

### Financial Outputs and Cash Flow

The model produces EBITDA, net income, and a cash flow and debt schedule. Depreciation and amortization derive from cumulative fleet investment divided by useful life, defaulting to 30 years straight-line.

- The debt schedule rolls forward opening debt, newbuild draws, and amortization. Interest expense is calculated on average debt balance.

- Free cash flow equals EBITDA minus cash tax, interest, maintenance capital expenditure, newbuild capital expenditure, plus changes in customer deposits. Net debt to EBITDA is also computed.

These outputs feed a dashboard with traffic-light status for metrics like occupancy, net yield, and leverage.

### Practical Use and Scope

This template helps evaluate how fleet deployment, capacity, and yields interact to drive profitability and liquidity. The dashboard highlights Year 5 revenue, EBITDA, EBITDA margin, occupancy, net yield, leverage, free cash flow, fuel cost percentage, fleet count, and passengers.

- Traffic-light thresholds flag performance against industry benchmarks. The model assumes normal operations and excludes per-ship vintage depreciation, dispositions, brand segments, currency hedging, and demand shocks.

- It is intended for underwriting a single-operator cruise line with a multi-ship fleet.

## 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.

## 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.

## Workbook structure

### Cover

Workbook overview, sheet legend, and tab-colour key for navigation.

- Title and scope framing
- Sheet-by-sheet purpose summary
- Tab-colour legend

### Assumptions

Every driver in one sheet: per-class inputs, newbuild schedule, operating parameters, status thresholds.

- Three classes with berths, sailings, cruise days, ticket and onboard yield, fuel and crew $/APCD, capex per ship
- Newbuild schedule: ships added per class per year across Y1-Y5
- Occupancy, yield growth, fuel and opex inflation, commissions, marketing, G&A base, maintenance capex, D&A, debt %, interest rate, tax rate
- EBITDA margin, occupancy, and net yield thresholds for status logic

### Fleet

Closing ships, average ships, and berths per class.

- Closing ships per class = starting + cumulative newbuilds through year
- Average ships per class = (opening + closing) / 2 for the deployment view
- Berths per class = closing ships × class-specific berths
- Total ships and total berths rows across all classes

### Capacity

APCD, OPCD, and passengers carried.

- APCD per class = average ships × berths × sailings per year × cruise days
- OPCD per class = APCD × Occupancy
- Total APCD and total OPCD across all classes
- Passengers carried = sum across classes of (OPCD / cruise duration)

### Revenue

Per-class ticket and onboard revenue with annual yield growth.

- Ticket revenue per class = OPCD × Ticket_Yield × (1 + Yield_Growth)^(year-1)
- Onboard revenue per class = OPCD × Onboard_Yield × (1 + Yield_Growth)^(year-1)
- Total ticket, total onboard, total revenue
- Gross yield per APCD as a sanity-check line

### P&L

Revenue to net income, with margins and an identity check.

- Total revenue from the Revenue sheet
- Fuel = sum across classes of (APCD × Fuel/APCD) × (1 + fuel inflation)^(year-1)
- Crew, port, insurance = sum across classes of (APCD × Crew/APCD) × (1 + opex inflation)^(year-1)
- Commissions = % of ticket revenue, marketing = % of total revenue, G&A = base × inflation
- EBITDA, D&A (% of revenue), interest (Debt% × cumulative fleet capex × Int_Rate), EBT, tax (max of EBT and zero), net income
- EBITDA margin and net margin lines, plus identity check

### Dashboard

One-page metrics with traffic-light status.

- Y5 revenue and Y5 EBITDA in dollars
- Y5 EBITDA margin (with status)
- Y5 occupancy and Y5 gross yield (each with status)
- Y5 fuel % of revenue, Y5 ships in fleet, Y5 passengers carried
- Y5 capacity mix table: APCD per class and % of total fleet

### Cover

Workbook overview, sheet legend, and tab-colour key for navigation.

- Title and scope framing
- Sheet-by-sheet purpose summary
- Tab-colour legend

### Assumptions

Every driver in one sheet: per-class inputs, newbuild schedule, operating parameters, status thresholds.

- Three classes with berths, sailings, cruise days, ticket and onboard yield, fuel and crew $/APCD, capex per ship
- Newbuild schedule: ships added per class per year across Y1-Y5
- Occupancy, yield growth, fuel and opex inflation, commissions, marketing, G&A base, maintenance capex, D&A, debt %, interest rate, tax rate
- EBITDA margin, occupancy, and net yield thresholds for status logic

### Fleet

Closing ships, average ships, and berths per class.

- Closing ships per class = starting + cumulative newbuilds through year
- Average ships per class = (opening + closing) / 2 for the deployment view
- Berths per class = closing ships × class-specific berths
- Total ships and total berths rows across all classes

### Capacity

APCD, OPCD, and passengers carried.

- APCD per class = average ships × berths × sailings per year × cruise days
- OPCD per class = APCD × Occupancy
- Total APCD and total OPCD across all classes
- Passengers carried = sum across classes of (OPCD / cruise duration)

### Revenue

Per-class ticket and onboard revenue with annual yield growth.

- Ticket revenue per class = OPCD × Ticket_Yield × (1 + Yield_Growth)^(year-1)
- Onboard revenue per class = OPCD × Onboard_Yield × (1 + Yield_Growth)^(year-1)
- Total ticket, total onboard, total revenue
- Gross yield per APCD as a sanity-check line

### P&L

Revenue to net income, with margins and an identity check.

- Total revenue from the Revenue sheet
- Fuel = sum across classes of (APCD × Fuel/APCD) × (1 + fuel inflation)^(year-1)
- Crew, port, insurance = sum across classes of (APCD × Crew/APCD) × (1 + opex inflation)^(year-1)
- Commissions = % of ticket revenue, marketing = % of total revenue, G&A = base × inflation
- EBITDA, D&A (% of revenue), interest (Debt% × cumulative fleet capex × Int_Rate), EBT, tax (max of EBT and zero), net income
- EBITDA margin and net margin lines, plus identity check

### Dashboard

One-page metrics with traffic-light status.

- Y5 revenue and Y5 EBITDA in dollars
- Y5 EBITDA margin (with status)
- Y5 occupancy and Y5 gross yield (each with status)
- Y5 fuel % of revenue, Y5 ships in fleet, Y5 passengers carried
- Y5 capacity mix table: APCD per class and % of total fleet

## Features

- **Industry-standard APCD / OPCD capacity build:** Per-class APCD is average ships × berths × sailings × cruise days. OPCD = APCD × occupancy (default 105% to reflect 3rd/4th-berth bookings). Revenue rides off OPCD; fuel and crew opex ride off APCD, the way the industry actually breaks down.
- **Per-class yield economics:** Ticket and onboard yield per class live in Assumptions as $/PCD. Per-class revenue blocks make it obvious whether a class is pulling its weight on yield, and the Dashboard surfaces the blended gross yield with traffic-light status.
- **Fuel and crew on the right denominator:** Fuel scales with APCD (burn happens whether the ship is sold out or not) and crew/port/insurance scales with APCD too. Commissions ride off ticket revenue at the industry-standard 12-15% range. Marketing is a percent of total revenue.

## Use cases

- **Cruise-line operating board pack:** Walk the board through five years of fleet deployment, capacity, revenue, EBITDA, and the dashboard with traffic-light status - all driven by class-level yield and per-APCD cost inputs that the CFO can flex live.
- **Newbuild capex justification:** Use the newbuild schedule to show how Y3-Y5 ship additions translate to incremental APCD, OPCD, and revenue, and whether the marginal EBITDA covers the debt-financed capex carry.
- **Yield-vs-fuel stress test:** Flex Yield_Growth down (or Occupancy down) and Fuel_Infl up to see margin compression. The Dashboard occupancy and margin status flip from On track to Watch as the assumption set crosses the user-set thresholds.

## Frequently asked questions

### 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.

## Related templates

- [Hotel Operating Model](https://finamodel.com/templates/hotel-model)
- [Airline Operations Model](https://finamodel.com/templates/airline-model)
- [Theme Park Operating Model](https://finamodel.com/templates/theme-park-model)