Carnival Financial Model
Travel Company Financials Example (Free Excel Download)
Carnival Corporation & plc is the world's largest leisure travel and cruise company, operating a portfolio of global brands including Carnival Cruise Line, Princess Cruises, Holland America Line, Seabourn, Costa Cruises, AIDA Cruises, Cunard, and P&O Cruises.
professionals from Deloitte
Used by professionals from
About this model
This model provides a comprehensive equity valuation and credit analysis framework for Carnival Corporation & plc, enabling an analyst to forecast free cash flow generation, assess the trajectory of post-pandemic debt deleveraging, and value the business based on fleet capacity growth and passenger yield dynamics.
Carnival Corporation & plc is the world's largest leisure travel and cruise company, operating a portfolio of global brands including Carnival Cruise Line, Princess Cruises, Holland America Line, Seabourn, Costa Cruises, AIDA Cruises, Cunard, and P&O Cruises. The company generates revenue primarily through the sale of passenger cruise tickets and onboard spending (casino, beverage, spa, and shore excursions).
Business segments include:
- North America and Australia (NAA) Cruise Operations: ~65% of revenue. Includes Carnival Cruise Line, Princess, Holland America, Seabourn, and P&O Cruises (Australia).
- Europe and Asia (EA) Cruise Operations: ~33% of revenue. Includes Costa, AIDA, Cunard, and P&O Cruises (UK).
- Cruise Support: ~1% of revenue. Includes port destinations and related facilities.
- Tour and Other: ~1% of revenue. Includes hotel and transportation operations (e.g., Holland America Princess Alaska Tours).
The business model is highly asset-heavy, requiring massive upfront capital expenditure to build cruise ships, which then generate steady cash flows over a 30-year useful life. Carnival holds the leading market share in the global cruise industry, competing primarily with Royal Caribbean Group and Norwegian Cruise Line Holdings.
Recent major events include the sunsetting of the P&O Cruises (Australia) brand (folded into Carnival Cruise Line in March 2025) and a proposed 2026 unification of its dual-listed structure into a single entity incorporated in Bermuda. The company also recently reinstated its quarterly dividend and achieved investment-grade leverage metrics after paying down over $10 billion in debt since January 2023.
The downloadable Carnival financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsCarnival financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $1.91B | $12.17B | $21.59B | $25.02B | $26.62B |
| Commissions, transportation and other | $269.0M | $1.63B | $2.76B | $3.23B | $3.33B |
| Operating income | -$7.09B | -$4.38B | $1.96B | $3.57B | $4.48B |
| Net income | -$9.50B | -$6.09B | -$74.0M | $1.92B | $2.76B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Carnival
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Passenger Ticket Revenue (NAA and EA Segments)
- Segment name: Passenger ticket
- Revenue driver formula: Available Lower Berth Days (ALBDs) x Occupancy Percentage x Passenger Ticket Yield per PCD (Passenger Cruise Day)
- Historical growth rate: Highly volatile during the pandemic recovery; normalised growth is 3-5% driven by capacity additions and pricing.
- Key growth levers and headwinds: Fleet expansion (newbuilds), itinerary optimisation, and macroeconomic consumer health. Headwinds include geopolitical conflicts affecting specific regions (e.g., Red Sea, Eastern Europe) and extreme weather.
- Pricing dynamics: Highly dynamic and revenue-managed. Prices are adjusted daily based on the booking curve.
- Revenue recognition notes: Ticket revenue is recognised over the duration of the voyage. Cash collected in advance is recorded as Customer Deposits (deferred revenue).
- Seasonality: The third fiscal quarter (June, July, August) is historically the strongest for revenue and margins due to the Northern Hemisphere summer holiday season.
Onboard and Other Revenue (NAA and EA Segments)
- Segment name: Onboard and other
- Revenue driver formula: Passenger Cruise Days (PCDs) x Onboard Spend per PCD
- Historical growth rate: 5-8% CAGR (outpacing ticket revenue as the company improves onboard monetisation).
- Key growth levers and headwinds: Pre-cruise bundling (selling beverage and Wi-Fi packages before sailing), casino operations, and inflation impacting consumer discretionary spending.
- Pricing dynamics: Spot pricing onboard, though increasingly shifted to pre-cruise contractual packages at a slight discount.
- Revenue recognition notes: Recognised at the point of sale or over the duration of the voyage for packages.
- Seasonality: Follows passenger volume seasonality (peaks in Q3).
Cost Structure
Variable Costs / COGS (Cruise Operating Expenses)
- Line-by-line breakdown: Commissions, transportation and other; Onboard and other; Payroll and related; Fuel; Food; Other ship operating.
- Gross margin range: 30-35% (calculated as Total Revenue less Cruise Operating Expenses).
- Key input costs and commodity exposures: Fuel is a massive exposure. The company consumes millions of metric tons of fuel annually. Food costs are also highly sensitive to global commodity inflation.
- How COGS scales with revenue: Fuel and payroll are largely fixed per voyage regardless of occupancy. Food and onboard costs scale linearly with passenger volume (PCDs). Commissions scale linearly with ticket revenue.
Operating Expenses
- R&D: Not material for this business.
- SG&A: Selling and administrative expenses typically run at 10-12% of revenue. Driven by shoreside headcount, marketing, and advertising campaigns.
- Depreciation & Amortisation: Extremely heavy, typically 10-12% of revenue. Driven by the capitalisation of multi-billion-dollar ships depreciated over 30 years.
- Stock-Based Compensation: Relatively small, typically under 1% of revenue.
- Restructuring / one-time charges: Occasional ship impairment charges or losses on ship sales when older tonnage is retired.
Margin Profile
- Gross margin: 30-35%
- EBITDA margin: 25-27% (FY2025 Adjusted EBITDA was $7.2 billion on $26.6 billion revenue, yielding ~27%).
- Operating margin: 15-17% (FY2025 Operating Income was $4.5 billion).
- Net margin: 10-12% (FY2025 Adjusted Net Income was $3.1 billion).
- Margin trend: Expanding. The company has focused on cost discipline and higher-yielding new ships, driving operating margins up over 250 basis points in 2025.
Balance Sheet Structure
- Total assets: Approximately $50-53 billion.
- Key asset categories: Property and Equipment (ships) make up over 75% of total assets.
- Goodwill & intangibles: Approximately $1.2 billion (trademarks and goodwill from historical acquisitions like Princess and Costa).
- Working capital profile:
- Days Sales Outstanding (DSO): Very low (under 10 days) as customers pay in advance.
- Days Inventory Outstanding (DIO): 15-20 days (fuel, food, hotel supplies).
- Days Payable Outstanding (DPO): 45-60 days.
- Net working capital as % of revenue: Deeply negative.
- Is working capital positive or negative?: Negative. The company funds operations through Customer Deposits ($7.2 billion at year-end 2025). This is a massive structural advantage, providing free financing.
- PP&E: Consists primarily of ships under construction and ships in service. Ships are depreciated over 30 years to a 15% residual value.
- Right-of-use assets / operating leases: Material for port facilities and shoreside offices, but small relative to ship assets.
Capital Expenditure & Investment
- Capex as % of revenue: 12-20% (highly variable depending on the ship delivery schedule).
- Maintenance capex vs. growth capex: Maintenance (dry-docks and ship upgrades) is roughly $1.5-2.0 billion annually. Growth capex (newbuilds) accounts for the remainder.
- Major capex programmes underway: The company has a committed order book for new ships stretching out 3-5 years. Capacity growth is strictly managed, guided at less than 1% for 2026.
- Capitalised software / development costs: Immaterial compared to ship capex.
- M&A pattern: Organic grower currently. The company is focused on deleveraging rather than acquisitions.
Debt & Capital Structure
- Total debt: Approximately $27-29 billion (down over $10 billion from the 2023 peak).
- Debt/EBITDA ratio: Currently approaching 3.5x. The company targets a net debt-to-adjusted-EBITDA ratio of under 3.0x by year-end 2026.
- Credit rating: Recently upgraded to investment grade by Fitch.
- Key debt instruments: Export credit facilities (ship mortgages), senior secured notes, senior unsecured notes, and a revolving credit facility.
- Maturity profile: The company actively refinances to smooth out maturities. Significant cash flow is currently directed at paying down 2026 and 2027 maturities.
- Interest rate profile: A mix of fixed and floating, though export credit facilities often carry favourable fixed rates.
- Covenants: Minimum liquidity and maximum leverage ratios.
- Share repurchase programme: Initiated share repurchases in late 2025.
- Dividend policy: Reinstated in late 2025 at $0.15 per share quarterly ($0.60 annualised).
Cash Flow Characteristics
- Operating cash flow conversion: Very high. OCF is typically 1.5x to 2.0x Net Income due to massive depreciation add-backs and positive working capital dynamics from customer deposits.
- Free cash flow margin: 5-10% (highly dependent on the timing of ship deliveries).
- Major non-cash items: Depreciation and amortisation (the largest bridge item).
- Working capital cash flow impact: Source of cash during growth phases (as bookings rise, customer deposits increase).
- Capex intensity: Very high. Ship deliveries require bullet payments upon completion.
- Cash tax rate vs. GAAP effective tax rate: The company is incorporated in Panama (moving to Bermuda) and operates under international shipping tax treaties (e.g., UK and Italian tonnage tax regimes). The effective tax rate is exceptionally low, typically under 5%.
Sheet Structure
- Assumptions: Hardcoded drivers for macroeconomic inputs, fuel prices, capacity growth (ALBDs), yield growth, and cost inflation.
- Operating Stats: Detailed build of fleet capacity. Calculates ALBDs, Occupancy %, and PCDs by segment (NAA and EA).
- Revenue Build: Calculates Passenger Ticket Revenue and Onboard Revenue by segment using the outputs from the Operating Stats sheet.
- Cost Build: Projects Cruise Operating Expenses (Commissions, Onboard, Payroll, Fuel, Food, Other) based on ALBDs and PCDs.
- Income Statement: Consolidated view mirroring the 10-K. Includes Revenues, Cruise Operating Expenses, SG&A, D&A, Operating Income, Interest Expense, and Net Income.
- Balance Sheet: Standard assets, liabilities, and equity. Must explicitly break out Customer Deposits as a major current liability and Property and Equipment as the primary asset.
- Cash Flow Statement: Indirect method. Starts with Net Income, adds back D&A, accounts for changes in Customer Deposits, subtracts Capex, and models debt paydown.
- Debt Schedule: Tranches of debt, interest rate assumptions, mandatory amortisation (export credit facilities), and discretionary paydown.
- PP&E & Capex Schedule: Tracks existing fleet depreciation, maintenance capex, and newbuild delivery payments.
- Valuation: DCF using unlevered free cash flow, WACC calculation, and terminal value based on an EV/EBITDA exit multiple.
Key Financial Relationships
- `ALBDs = Fleet Capacity (Lower Berths) x Days in Period`
- `Passenger Cruise Days (PCDs) = ALBDs x Occupancy Percentage`
- `Passenger Ticket Revenue = PCDs x Passenger Ticket Yield per PCD`
- `Onboard and Other Revenue = PCDs x Onboard Spend per PCD`
- `Gross Cruise Revenue = Passenger Ticket Revenue + Onboard and Other Revenue`
- `Net Yield = (Gross Cruise Revenue - Commissions, transportation and other - Onboard and other costs) / ALBDs`
- `Fuel Expense = Metric Tons of Fuel Consumed x Price per Metric Ton`
- `Net Cruise Costs (NCC) ex Fuel = (Total Cruise Operating Expenses + SG&A - Commissions, transportation and other - Onboard and other costs - Fuel) / ALBDs`
- `Customer Deposits (Current Period) = Customer Deposits (Prior Period) + New Bookings Cash Collected - Revenue Recognised for Sailed Voyages`
- `Interest Expense = Average Debt Balance x Weighted Average Interest Rate`
- `Adjusted EBITDA = Net Income + Interest Expense + Income Tax Expense + Depreciation and Amortisation + Restructuring/Impairment Charges`
Cross-Sheet Dependencies
- The Operating Stats sheet is the foundation of the model. ALBDs and Occupancy drive the Revenue Build and the variable components of the Cost Build.
- The Revenue Build feeds the top line of the Income Statement and drives the inflow of Customer Deposits on the Balance Sheet.
- The Cost Build feeds the operating expenses on the Income Statement.
- The PP&E & Capex Schedule calculates D&A, which feeds the Income Statement and the Cash Flow Statement. It also calculates Capex, which feeds the Cash Flow Statement.
- The Debt Schedule calculates Interest Expense for the Income Statement and requires cash flow available for debt service from the Cash Flow Statement. This creates a circularity that must be managed with a toggle or iterative calculation.
Sign Convention
- Income Statement: Revenues are positive. Expenses (COGS, SG&A, D&A, Interest) are positive numbers in their build schedules but must be subtracted to calculate margins and profit lines.
- Cash Flow Statement: Net Income is positive. Non-cash add-backs (D&A) are positive. Increases in assets are negative (use of cash). Increases in liabilities (like Customer Deposits) are positive (source of cash). Capex is negative. Debt paydown is negative. Dividends paid are negative.
- Balance Sheet: All assets, liabilities, and equity balances are positive.
Things Most Likely to Go Wrong
- Occupancy Misunderstanding: Cruise occupancy routinely exceeds 100% because capacity (ALBDs) is based on two passengers per cabin. Third and fourth passengers in a cabin push occupancy above 100%. The model must allow for this.
- Customer Deposits Disconnect: Failing to link revenue growth to the growth in the Customer Deposits liability. If revenue grows 5%, the deferred revenue balance should grow proportionally, providing a massive cash flow benefit.
- Fuel Price Volatility: Fuel is a massive, volatile cost. The model must separate fuel consumption (metric tons) from the price per ton to allow for accurate sensitivity analysis.
- Net Yield vs. Gross Yield: Management guides on "Net Yields" (which strips out commissions and onboard costs) rather than Gross Revenue. The model must calculate Net Yields to compare against company guidance.
- Constant Currency Adjustments: Carnival generates significant revenue in Euros and Sterling (EA segment). Foreign currency translation can swing reported revenue by 3-5% YoY; the model should include a constant-currency toggle or note.
- Debt Paydown Circularity: The company is aggressively paying down debt. Using excess cash to pay down debt reduces interest expense, which increases net income, which increases cash. This circularity will break the model if not structured with a circuit breaker.
- Tonnage Tax Regime: Applying a standard US corporate tax rate (e.g., 21%) will completely ruin the valuation. The effective tax rate is structurally under 5% due to international shipping laws.
- Ship Delivery Lumps: Capex is not smooth. It spikes in quarters when a new ship is delivered. Annual models smooth this out, but quarterly models must account for delivery dates.
Validation Checks
- "Occupancy percentage should be between 100% and 110% in a normalised environment; flag if below 95%."
- "Net Yield growth should align with management guidance of 2.5% to 3.0% for 2026."
- "Net Debt to Adjusted EBITDA should cross below 3.0x by the end of FY2026 per management targets."
- "Effective tax rate must remain below 5% due to the tonnage tax regime."
- "Customer Deposits should represent approximately 25-30% of next year's forward revenue."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Adjusted ROIC should be >12% (company achieved over 13% in 2025)."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| FY25 Base Revenue | 26.6 | $ Billions | Actual reported FY2025 record revenue. |
| FY25 Base Adjusted EBITDA | 7.2 | $ Billions | Actual reported FY2025 adjusted EBITDA. |
| Capacity Growth (ALBDs) 2026 | 0.8 | % | Management guidance of less than 1% capacity growth for 2026. |
| Net Yield Growth 2026 | 2.5 | % | Management guidance for 2026 net yield growth. |
| Unit Cost Growth (NCC ex-fuel) | 3.25 | % | Management guidance for 2026 unit cost growth. |
| Occupancy Percentage | 106.0 | % | Normalised historical run-rate for the consolidated fleet. |
| SG&A as % of Revenue | 11.0 | % | Historical average required to support global operations. |
| D&A as % of Revenue | 10.5 | % | Reflects heavy capitalisation of the fleet. |
| Effective Tax Rate | 2.0 | % | Blended rate under Italian, German, and UK tonnage tax regimes. |
| Customer Deposits Balance | 7.2 | $ Billions | Actual year-end 2025 customer deposits. |
| Quarterly Dividend | 0.15 | $ / Share | Reinstated dividend rate as of late 2025. |
| Target Net Debt / EBITDA | 2.9 | x | Management target to be under 3.0x by year-end 2026. |
| WACC | 9.5 | % | Reflects high beta and current cost of debt. |
| Terminal Growth Rate | 2.0 | % | Long-term GDP-aligned growth for the cruise industry. |
Data Sources & Benchmarks
- SEC EDGAR: Carnival Corporation (CCL) 10-K, 10-Q, and 8-K filings.
- Investor Relations: Carnival Corporation website for earnings presentations and quarterly business updates.
- Key Peers: Royal Caribbean Group (RCL), Norwegian Cruise Line Holdings (NCLH).
- Industry Data: Cruise Lines International Association (CLIA) for global passenger volume forecasts and order book data.
- Consensus Estimates: Bloomberg or FactSet for forward yield and EBITDA estimates.
Sources
- Carnival Corporation & plc Form 10-K for the fiscal year ended November 30, 2025 (filed via SEC EDGAR).
- Carnival Corporation & plc Q4 2025 Earnings Release and Presentation (December 19, 2025).
- StockTitan: CCL SEC Filings and 2025 Records.
- Alpha Spread: Carnival Reports Record Annual Earnings and Reinstates Dividend.
Do more with the Carnival model
Frequently asked
What does Carnival Corporation & plc do?+
Carnival Corporation & plc is the world's largest leisure travel and cruise company, operating a portfolio of global brands including Carnival Cruise Line, Princess Cruises, and Holland America Line. The company generates revenue primarily through the sale of passenger cruise tickets and onboard spending.
How does Carnival generate its revenue?+
Carnival generates revenue mainly from the sale of passenger cruise tickets and various onboard spending activities such as casino, beverage, spa, and shore excursions. Its North America and Australia Cruise Operations segment contributes approximately 65% of its total revenue.
What is Carnival's capital expenditure strategy?+
Carnival's business model is highly asset-heavy, requiring significant upfront capital expenditure to build cruise ships, which then generate steady cash flows over a 30-year useful life. Capex as a percentage of revenue is highly variable, ranging from 12-20%, depending on the ship delivery schedule, with growth capex focused on newbuilds.
Why does Carnival have negative net working capital?+
Carnival has a deeply negative net working capital profile because customers typically pay for cruises in advance, leading to substantial customer deposits. This provides a massive structural advantage, offering free financing for its operations.
What are the key inputs for valuing Carnival Corporation & plc in a financial model?+
Key inputs for valuing Carnival in a financial model include forecasting free cash flow generation, assessing the trajectory of post-pandemic debt deleveraging, and analyzing fleet capacity growth and passenger yield dynamics. The model also considers assumptions like a 0.9% revenue growth rate and a 4.78% tax rate.
Can I download an Excel financial model for Carnival Corporation & plc?+
Yes, an Excel financial model for Carnival Corporation & plc is available for download. This model provides a comprehensive equity valuation and credit analysis framework, with a forecast horizon extending from FY2026 to FY2030.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Travel Company Financial Models
Browse another company in the same sector.
Airbnb
Airbnb operates a global two-sided marketplace that connects hosts offering accommodations and experiences with guests seeking unique travel stays.
Booking Holdings
Booking Holdings is the world's leading provider of online travel and related services, connecting consumers with travel service providers for accommodation, flights, and rental cars.
Expedia Group
Expedia Group is a leading global online travel agency (OTA) that provides travel products and services to leisure and corporate travellers.
Hilton Worldwide
Hilton Worldwide Holdings Inc.
Las Vegas Sands
Las Vegas Sands (LVS) is a leading global developer and operator of integrated resorts, featuring premium accommodations, world-class gaming, retail malls, conventions, and entertainment.
Marriott International
Marriott International is the world's largest hotel company, operating, franchising, and licensing over 9,300 properties and 1.7 million rooms across more than 30 brands globally.
MGM Resorts
MGM Resorts International is a global gaming and entertainment company operating integrated casino, hotel, and entertainment resorts.
Norwegian Cruise Line Holdings
Norwegian Cruise Line Holdings Ltd.
Explore more Consumer financial model templates.
