Set Capacity
Multiply available rooms by available nights for each category and month.
The Cruise Ship Financial Model is an editable five-year Excel workbook linking room-night capacity, occupancy, ADR, ancillary income, and monthly financial statements.
Use the model to plan cabin inventory, occupancy, pricing, ancillary income, operating costs, and the resulting financial performance over five years.
Editable operating assumptions flow through the workbook into scenario analysis, financial statements, cash flow, and management reporting views.
It converts available room-nights into sold room-nights, applies midweek and weekend ADR by category, then adds enabled ancillary monthly income once.
Multiply available rooms by available nights for each category and month.
Apply occupancy rates to available room-nights to determine sold room-nights.
Apply midweek and weekend ADR to the corresponding sold room-nights.
Add each enabled monthly ancillary income stream once to room revenue.
Sum monthly room revenue and ancillary income across all room categories.
The Revenue Assumptions view organizes room availability, occupancy, category ADR, and ancillary monthly income inputs that feed the room-night revenue calculation.
REVENUE ASSUMPTIONS
The COGS & Operational Expenses view separates direct costs, variable expenses, and fixed operating assumptions for the monthly forecast engine.
COGS & OPERATIONAL EXPENSES
The Scenario Analysis view compares Low, Base, and High revenue, gross margin, contribution margin, and EBITDA paths across the five-year forecast.
SCENARIO ANALYSIS
The Dashboard combines scenario controls, core financial outputs, revenue mix, profitability, cash flow, and investment payback charts in one management view.
DASHBOARD
The ready-made model fits room-night accommodation economics, while materially different revenue logic or operating schedules may justify a custom financial model.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or financial reporting.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the editable Excel financial model as an instant download with five-year monthly and annual projections and three scenarios.
Update room counts, occupancy, ADR, ancillary income, costs, and other model assumptions.
Review projections with monthly detail and annual financial views across five years.
Compare Low, Base, and High cases through the workbook scenario views.
Review income statement, cash flow, balance sheet, summary, and dashboard outputs.
The essential answers are visible in full, with no accordion clicks required.
It calculates sold room-nights from room capacity and occupancy, applies category ADR, then adds enabled ancillary monthly income once.
You can edit opening timing, rooms by category, available nights, occupancy, midweek and weekend ADR, calendar mix, seasonality, and ancillary income.
The Scenario Analysis view compares alternative revenue, gross margin, contribution margin, and EBITDA paths across the five-year forecast.
The product shows an income statement, cash flow statement, balance sheet, dashboard, summary, break-even, ROIC, ratios, valuation, and other reporting views.
Yes. Custom financial modeling can address different revenue logic, operating schedules, or reporting requirements.
It is a forecast built from editable assumptions, not a guarantee of financial performance or business results.
Download your pre-built financial model for a cruise company and get instant access to a comprehensive tool for financial planning and analysis.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark
I used to waste time switching between low, base, and high cases. This template lined them up cleanly, so I could compare them in minutes instead of rebuilding the same forecast three times.
Building the cruise ship financials by hand would have eaten up our week. With the template, I had a working model ready in a few hours and could move straight to planning.
Pricing, operating costs, and growth were all over the place before. This model put everything in one place, and I could explain the assumptions clearly in our investor meeting.