Dec'05 | Dec'06 | Dec'07 | Dec'08 | Dec'09 | Dec'10 | Dec'11 | Dec'12 | Dec'13 | Dec'14 | Dec'15 | Dec'16 | Dec'17 | Dec'18 | Dec'19 | Dec'20 | Dec'21 | Dec'22 | Dec'23 | Dec'24 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
P/BV LTM | 1.7x | 1.4x | 1.4x | 0.4x | 0.7x | 1.3x | 0.6x | 0.8x | 1.2x | 2.0x | 2.7x | 2.0x | 2.4x | 1.7x | 2.2x | 2.0x | 3.0x | 3.9x | 7.2x | 8.5x |
Dec'05 | Dec'06 | Dec'07 | Dec'08 | Dec'09 | Dec'10 | Dec'11 | Dec'12 | Dec'13 | Dec'14 | Dec'15 | Dec'16 | Dec'17 | Dec'18 | Dec'19 | Dec'20 | Dec'21 | Dec'22 | Dec'23 | Dec'24 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
% growth | 4,903.2 7.6% | 5,229.6 6.7% | 6,149.1 17.6% | 6,532.5 6.2% | 5,889.8 (9.8%) | 6,752.5 14.6% | 7,537.3 11.6% | 7,688.0 2.0% | 7,959.9 3.5% | 8,073.9 1.4% | 8,299.1 2.8% | 8,496.4 2.4% | 8,777.8 3.3% | 9,493.8 8.2% | 10,950.7 15.3% | 2,208.8 (79.8%) | 1,532.1 (30.6%) | 8,840.5 477.0% | 13,900.0 57.2% | 16,484.0 18.6% |
Cost of Goods Sold (COGS) | 2,994.2 | 3,249.6 | 3,981.7 | 3,373.0 | 4,071.1 | 4,458.1 | 4,942.6 | 5,157.4 | 5,305.3 | 5,306.3 | 5,099.4 | 5,015.5 | 4,896.6 | 5,262.2 | 6,062.8 | 2,765.1 | 2,657.5 | 6,614.3 | 7,775.0 | 8,652.0 |
% margin | 1,908.9 38.9% | 1,980.0 37.9% | 2,167.4 35.2% | 3,159.5 48.4% | 1,818.7 30.9% | 2,294.4 34.0% | 2,594.7 34.4% | 2,530.6 32.9% | 2,654.6 33.3% | 2,767.6 34.3% | 3,199.7 38.6% | 3,480.9 41.0% | 3,881.3 44.2% | 4,231.6 44.6% | 4,887.9 44.6% | (556.3) (25.2%) | (1,125.4) (73.5%) | 2,226.2 25.2% | 6,125.0 44.1% | 7,832.0 47.5% |
Operating Expenses | 1,037.4 | 1,121.5 | 1,266.1 | 2,327.5 | 1,330.2 | 1,491.8 | 1,663.0 | 1,742.0 | 1,799.5 | 1,821.4 | 1,913.5 | 1,995.2 | 2,137.2 | 2,336.8 | 2,805.2 | 2,478.9 | 2,663.0 | 2,989.6 | 3,247.0 | 3,726.0 |
Research & Development Expenses (R&D) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
Selling, General & Administrative Expenses (SG&A) | 635.3 | 699.9 | 783.0 | 776.5 | 762.0 | 848.1 | 960.6 | 1,011.5 | 1,044.8 | 1,049.0 | 1,086.5 | 1,100.3 | 1,186.0 | 1,303.1 | 1,559.3 | 1,199.6 | 1,370.1 | 1,582.9 | 1,792.0 | 2,125.0 |
% margin | 871.6 17.8% | 858.4 16.4% | 901.3 14.7% | 832.0 12.7% | 488.5 8.3% | 802.6 11.9% | 931.6 12.4% | 403.1 5.2% | 798.1 10.0% | 941.9 11.7% | 874.9 10.5% | 1,477.2 17.4% | 1,744.1 19.9% | 1,894.8 20.0% | 2,082.7 19.0% | (4,601.6) (208.3%) | (3,870.3) (252.6%) | (847.9) (9.6%) | 2,878.0 20.7% | 4,106.0 24.9% |
Interest Income | 0.0 | 0.0 | 20.0 | 14.1 | 7.0 | 9.2 | 25.3 | 21.3 | 13.9 | 10.3 | 12.0 | 20.9 | 30.1 | 32.8 | 26.9 | 21.0 | 16.8 | 35.9 | 36.0 | 16.0 |
Interest Expense | 0.0 | 0.0 | 333.8 | 327.3 | 300.0 | 339.4 | 382.4 | 355.8 | 332.4 | 258.3 | 277.7 | 307.4 | 300.0 | 333.7 | 408.5 | 844.2 | 1,291.8 | 1,364.2 | 1,402.0 | 1,590.0 |
Pre-tax Income | 716.0 | 633.9 | 603.4 | 573.7 | 162.4 | 547.5 | 607.4 | 18.3 | 473.7 | 764.1 | 665.8 | 1,283.4 | 1,625.1 | 1,815.8 | 1,907.6 | (5,775.1) | (5,260.5) | (2,156.0) | 1,704.0 | 2,897.0 |
% effective tax rate | 155.6 21.7% | 224.5 35.4% | 297.9 49.4% | 258.3 45.0% | 326.1 200.8% | 255.2 46.6% | 324.2 53.4% | 312.9 1,711.1% | 330.7 69.8% | 328.5 43.0% | 334.3 50.2% | 271.7 21.2% | 294.7 18.1% | 254.7 14.0% | 412.7 21.6% | 729.5 (12.6%) | 1,312.0 (24.9%) | (56.1) 2.6% | 0.0 0.0% | (18.0) (0.6%) |
% margin | 716.0 14.6% | 633.9 12.1% | 603.4 9.8% | 573.7 8.8% | 162.4 2.8% | 547.5 8.1% | 607.4 8.1% | 18.3 0.2% | 473.7 6.0% | 764.1 9.5% | 665.8 8.0% | 1,283.4 15.1% | 1,625.1 18.5% | 1,811.0 19.1% | 1,494.9 13.7% | (6,504.6) (294.5%) | (6,572.5) (429.0%) | (2,099.8) (23.8%) | 1,697.0 12.2% | 2,877.0 17.5% |
EPS | 3.47 | 3.01 | 2.84 | 2.69 | 0.76 | 2.55 | 2.80 | 0.08 | 2.16 | 3.45 | 3.03 | 5.96 | 7.57 | 8.60 | 7.14 | (30.35) | (26.10) | (8.23) | 6.63 | 10.94 |
Diluted EPS | 3.26 | 2.94 | 2.82 | 2.68 | 0.75 | 2.51 | 2.77 | 0.08 | 2.14 | 3.43 | 3.02 | 5.93 | 7.53 | 8.56 | 7.12 | (30.35) | (26.10) | (8.23) | 6.00 | 10.31 |
% margin | 1,273.6 26.0% | 1,280.1 24.5% | 1,384.4 22.5% | 1,352.3 20.7% | 1,056.7 17.9% | 1,371.4 20.3% | 1,692.3 22.5% | 1,104.6 14.4% | 1,609.8 20.2% | 1,727.5 21.4% | 2,113.2 25.5% | 2,380.6 28.0% | 2,695.3 30.7% | 2,928.5 30.8% | 3,328.6 30.4% | (3,686.6) (166.9%) | (2,724.7) (177.8%) | 586.1 6.6% | 4,471.0 32.2% | 5,717.0 34.7% |
Discover the top 20 best undervalued stocks to buy for Mar 2025, listed on the Nasdaq or NYSE.
Discover the top 20 best undervalued large-cap growth stocks to buy for Mar 2025, listed on the Nasdaq or NYSE.
Discover the top 20 best undervalued high-yield dividend stock that offers both growth potential and attractive dividend returns for Mar 2025.
As of today, Microsoft Corp's last 12-month P/BV LTM is 8.5x, based on the financial report for Dec 30, 2024 (Q4’2024). The average annual P/BV LTM for Royal Caribbean Cruises Ltd. have been 5.4x over the past three years, and 4.5x over the past five years.
As of today, Royal Caribbean Cruises Ltd.'s P/BV LTM is 8.5x, which is higher than industry median of 2.0x. It indicates that Royal Caribbean Cruises Ltd.'s P/BV LTM is Bad.