# Carnival (CCL) Financial Model Free Excel 3-statement financial model and company analysis for Carnival. - Canonical: https://finamodel.com/companies/carnival - Industry: Travel - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/CCL.xlsx ## Model Purpose 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. ## Company Overview 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. ## 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 1. **Assumptions**: Hardcoded drivers for macroeconomic inputs, fuel prices, capacity growth (ALBDs), yield growth, and cost inflation. 2. **Operating Stats**: Detailed build of fleet capacity. Calculates ALBDs, Occupancy %, and PCDs by segment (NAA and EA). 3. **Revenue Build**: Calculates Passenger Ticket Revenue and Onboard Revenue by segment using the outputs from the Operating Stats sheet. 4. **Cost Build**: Projects Cruise Operating Expenses (Commissions, Onboard, Payroll, Fuel, Food, Other) based on ALBDs and PCDs. 5. **Income Statement**: Consolidated view mirroring the 10-K. Includes Revenues, Cruise Operating Expenses, SG&A, D&A, Operating Income, Interest Expense, and Net Income. 6. **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. 7. **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. 8. **Debt Schedule**: Tranches of debt, interest rate assumptions, mandatory amortisation (export credit facilities), and discretionary paydown. 9. **PP&E & Capex Schedule**: Tracks existing fleet depreciation, maintenance capex, and newbuild delivery payments. 10. **Valuation**: DCF using unlevered free cash flow, WACC calculation, and terminal value based on an EV/EBITDA exit multiple. ## Key Financial Relationships 1. `ALBDs = Fleet Capacity (Lower Berths) x Days in Period` 2. `Passenger Cruise Days (PCDs) = ALBDs x Occupancy Percentage` 3. `Passenger Ticket Revenue = PCDs x Passenger Ticket Yield per PCD` 4. `Onboard and Other Revenue = PCDs x Onboard Spend per PCD` 5. `Gross Cruise Revenue = Passenger Ticket Revenue + Onboard and Other Revenue` 6. `Net Yield = (Gross Cruise Revenue - Commissions, transportation and other - Onboard and other costs) / ALBDs` 7. `Fuel Expense = Metric Tons of Fuel Consumed x Price per Metric Ton` 8. `Net Cruise Costs (NCC) ex Fuel = (Total Cruise Operating Expenses + SG&A - Commissions, transportation and other - Onboard and other costs - Fuel) / ALBDs` 9. `Customer Deposits (Current Period) = Customer Deposits (Prior Period) + New Bookings Cash Collected - Revenue Recognised for Sailed Voyages` 10. `Interest Expense = Average Debt Balance x Weighted Average Interest Rate` 11. `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 1. **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. 2. **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. 3. **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. 4. **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. 5. **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. 6. **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. 7. **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. 8. **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 1. "Occupancy percentage should be between 100% and 110% in a normalised environment; flag if below 95%." 2. "Net Yield growth should align with management guidance of 2.5% to 3.0% for 2026." 3. "Net Debt to Adjusted EBITDA should cross below 3.0x by the end of FY2026 per management targets." 4. "Effective tax rate must remain below 5% due to the tonnage tax regime." 5. "Customer Deposits should represent approximately 25-30% of next year's forward revenue." 6. "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period." 7. "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. --- ## Frequently asked questions ### 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. [Interactive forecast calculator](https://finamodel.com/companies/carnival/forecast)