Norwegian Cruise Line Holdings Financial Model

• Total assets: Approximately $18-20 billion.
• Key asset categories: Property and equipment dominates the balance sheet (over 80% of total assets), representing the fleet of 34 ships.
• Goodwill & intangibles as % of total assets: Approximately 5-8%, stemming from the historical acquisition of Prestige Cruises (Oceania and Regent).
• Working capital profile:
• Days Sales Outstanding (DSO): 5-10 days (most revenue is collected before sailing).
• Days Inventory Outstanding (DIO): 10-15 days (fuel and food provisions).
• Days Payable Outstanding (DPO): 30-45 days.
• Net working capital as % of revenue: Significantly negative.
• Is working capital positive or negative? NCLH operates with structurally negative working capital due to massive Advance Ticket Sales balances. This provides a cash flow advantage as the company funds growth from customer deposits.
• PP&E: Consists of ships under construction, ships in service, and shoreside equipment. Ships have a 30-year useful life.
• Right-of-use assets / operating leases: Immaterial relative to the owned ship asset base.

• Capex as % of revenue: Highly volatile, ranging from 10% to 30%+ depending on the ship delivery schedule.
• Maintenance capex vs. growth capex: Maintenance (dry-docks and ship upgrades) is roughly $300-400 million annually; the vast majority of capex is growth capex for newbuilds.
• Major capex programmes underway: 13 new ships on order across all three brands for delivery through 2036, adding over 38,400 berths.
• Capitalised software / development costs: Immaterial.
• M&A pattern: Organic grower; the last major acquisition was Prestige in 2014.

• Total debt: $14.6 billion (as of FY2025).
• Net debt: $14.4 billion.
• Debt/EBITDA ratio: 5.3x Net Leverage at the end of 2025, with a target to reduce this significantly.
• Credit rating: Non-investment grade (high yield).
• Key debt instruments: Export Credit Agency (ECA) backed loans (used to finance new ships), senior secured notes, unsecured notes, and a revolving credit facility.
• Maturity profile: Staggered, but requires constant refinancing; ECA loans amortise over 12 years post-delivery.
• Interest rate profile: Mix of fixed and floating, with a weighted average cost of debt around 6-7%.
• Covenants: Minimum liquidity requirements and maximum loan-to-value ratios on secured ship mortgages.
• Share repurchase programme: Suspended; capital allocation is strictly focused on debt paydown and funding newbuilds.
• Dividend policy: No dividend paid; not expected in the near term.

• Operating cash flow conversion: Strong, typically >1.5x Net Income due to massive depreciation add-backs and working capital inflows from advance ticket sales.
• Free cash flow margin: Highly variable and often negative in years with multiple ship deliveries.
• Major non-cash items: Depreciation and amortisation of ships, stock-based compensation, and deferred income taxes.
• Working capital cash flow impact: Massive source of cash in Q1 and Q2 as customers pay for summer sailings; use of cash in Q3 as those sailings occur and deferred revenue is recognised.
• Capex intensity: Extremely high.
• Cash tax rate vs. GAAP effective tax rate: Both are exceptionally low (typically 1-3%). NCLH is incorporated in Bermuda and qualifies for exemption from US corporate income tax on international shipping income under Section 883 of the Internal Revenue Code.

1. Assumptions: Hardcoded drivers for capacity days, occupancy, pricing, fuel costs, and macroeconomic inputs.
2. Operating Metrics: Calculation of Available Passenger Cruise Days, Occupancy %, Passenger Cruise Days, and Net Yield.
3. Revenue Schedule: Segmented build-up of Passenger Ticket Revenue and Onboard/Other Revenue based on the operating metrics.
4. Operating Costs: Detailed build of Commissions, Payroll, Fuel (driven by metric tons consumed and price per ton), Food, and SG&A.
5. Income Statement: Consolidated P&L mirroring the 10-K format.
6. Balance Sheet: Assets, Liabilities, and Equity, explicitly breaking out Advance Ticket Sales and Ship assets.
7. Cash Flow Statement: Operating, Investing, and Financing cash flows, capturing the working capital benefit of customer deposits.
8. PP&E & Capex Schedule: Ship delivery schedule, progress payments, delivery capex, and 30-year depreciation waterfall.
9. Debt Schedule: Tranche-by-tranche breakdown of ECA loans, senior notes, and the revolver, including mandatory amortisation and interest expense calculations.
10. Valuation: DCF using WACC, terminal growth, and an EV-to-EBITDA multiple cross-check.

1. "Capacity Days = Available Berths x Days in Period"
2. "Passenger Cruise Days = Capacity Days x Occupancy Percentage"
3. "Passenger Ticket Revenue = Passenger Cruise Days x Gross Ticket Revenue per Passenger Cruise Day"
4. "Onboard and Other Revenue = Passenger Cruise Days x Onboard Spend per Passenger Cruise Day"
5. "Total Cruise Revenue = Passenger Ticket Revenue + Onboard and Other Revenue"
6. "Fuel Expense = Fuel Consumption in Metric Tons x Average Price per Metric Ton (net of hedges)"
7. "Gross Cruise Cost = Total Cruise Operating Expense + Marketing, General and Administrative Expense"
8. "Net Yield = (Total Revenue - Commissions, Transportation and Other - Onboard and Other Expense) / Capacity Days"
9. "Adjusted Net Cruise Cost excluding Fuel = (Gross Cruise Cost - Fuel Expense) / Capacity Days"
10. "Advance Ticket Sales Ending Balance = Beginning Balance + Cash Received from Customers - Passenger Ticket Revenue Recognised"
11. "Ship Depreciation = (Gross Ship Asset Value - 15% Residual Value) / 30 Years"
12. "ECA Loan Drawdown = 80% x Newbuild Ship Delivery Cost"

The Assumptions sheet drives the Operating Metrics, which in turn feed the Revenue Schedule and Operating Costs. The PP&E & Capex Schedule is critical; it dictates the timing of ship deliveries, which triggers massive capex outflows on the Cash Flow Statement, corresponding debt drawdowns on the Debt Schedule, and new capacity days on the Operating Metrics sheet. The Debt Schedule calculates interest expense, which flows to the Income Statement. Net Income and Depreciation flow to the Cash Flow Statement, which determines the ending cash balance and revolver needs on the Balance Sheet. Circularity exists between the revolver balance, interest expense, and net income; this requires a circuit breaker toggle.

• Revenue, assets, and equity are positive.
• Expenses, capital expenditures, and dividends are negative.
• On the Cash Flow Statement, cash inflows (e.g., debt issuance, increase in advance ticket sales) are positive, and cash outflows (e.g., debt repayment, capex) are negative.
• Debt balances on the balance sheet are positive.

• Failing to model Advance Ticket Sales correctly; cash is collected months before revenue is recognised, creating massive seasonal swings in operating cash flow.
• Misaligning the PP&E schedule with the debt schedule; new ships are typically 80% financed via export credit agencies, so a $1 billion ship delivery must trigger an $800 million debt inflow in the exact same period.
• Ignoring the 15% residual value in ship depreciation calculations, which will overstate depreciation expense.
• Applying a standard US corporate tax rate; NCLH is exempt from most US taxes under Section 883, so the effective tax rate should remain around 1-3%.
• Overlooking fuel price volatility; the model must include a specific line for fuel consumption (metric tons) and price per ton, rather than growing fuel expense as a flat percentage of revenue.
• Miscalculating occupancy; cruise lines routinely report occupancy above 100% because the metric is based on double occupancy per cabin, but cabins often hold three or four passengers.
• Forgetting that ECA debt amortises; these are not bullet maturities and require regular principal payments over 12 years.
• Misinterpreting "Net Yield" and "Net Cruise Cost"; these are industry-specific non-GAAP metrics that deduct certain variable costs from the numerator. The model must calculate these exactly as defined in the 10-K.

• "Total Assets = Total Liabilities + Equity in every period."
• "Occupancy percentage should remain between 102% and 108%; flag if it drops below 100% in a normalised environment."
• "Adjusted EBITDA margin should be in the 35-39% range; flag if outside this band."
• "Effective tax rate must remain below 5% due to Section 883 exemption."
• "Net Leverage (Net Debt / Adjusted EBITDA) should trend downward from the 5.3x FY2025 baseline."
• "Operating Cash Flow must exceed Net Income significantly due to heavy D&A add-backs."
• "Capex must spike in years where new ships (e.g., Prima Class or Allura Class) are delivered."

• Filings: SEC EDGAR (NCLH 10-K, 10-Q, 8-K) and the NCLH Investor Relations website.
• Peers: Carnival Corporation (CCL), Royal Caribbean Group (RCL).
• Industry Data: Cruise Industry News (for global orderbook and capacity statistics), Seatrade Cruise News.
• Consensus Estimates: Bloomberg or FactSet for forward EBITDA and yield estimates.

• Norwegian Cruise Line Holdings Ltd. FY2024 Annual Report on Form 10-K
• Norwegian Cruise Line Holdings Ltd. Q4 and Full Year 2025 Earnings Release (March 2, 2026)
• Cruise Industry News Orderbook and Capacity Reports
• Seatrade Cruise News: NCLH Q4 outperforms but Q1 pressured (March 2, 2026)