CASE - Forecasting for the Love Boat: Royal Caribbean Cruises in 1998
PART A: COMPREHENSIVE FINANCIAL ANALYSIS
Your task for this part of the case is to conduct a comprehensive financial analysis of Royal Caribbean Cruises and to compare their performance with Carnival Cruises. Excerpts from Royal Caribbean's 20-F filing and Carnival's 10-K filing are included as online exhibits at https://www.lundholmandsloan.com.
You will need to import the case data into eVal. (Note: case data can be imported by going to the Case Data sheet in eVal and selecting the yellow block of data for the company, and then pasting this block of data into the yellow cells at the bottom of the Financial Statements sheet using Paste Special - Values from the Edit menu.) You should compare the financial statements in eVal with the ones in the 20-F and 10-K filings so that you can see exactly what data are used to compute each ratio and make any necessary adjustments. The definitions of each ratio are given in this textbook. Note that Royal Caribbean paid a preferred stock dividend of $12.5 million in 1998 but that this amount is not in the eVal data. You will have to correct the financial statements once they are loaded into eVal.
1. Compare the growth rates of Royal Caribbean and Carnival Cruises. What are the advantages to being large in this industry?
2. Compute the 1998 net operating income, net financing expense, average net operating assets, and average net financial obligations from the financial statements in Royal Caribbean's 20-F filing.
3. Using your answers to the previous question, compute return on equity (ROE) and then decompose ROE using the advanced Dupont decomposition: ROE = RNOA + Leverage × Spread
How does your decomposition compare to the one provided by eVal?
4. Using the financial ratios provided by eVal, evaluate any trends in Royal Caribbean's return on equity, compare it with Carnival Cruise's return on equity, and discuss the main causes of any differences.
5. Now consider each of the main drivers of return on equity: margins, turnovers, and leverage. Using eVal's output as a starting point, evaluate any trends and compare Royal Caribbean with Carnival Cruises in each of these areas. Only note what is exceptional-do not discuss every possible ratio.
6. Does a dollar of revenue increase bring about a constant increase in expenses for Royal Caribbean, or do they enjoy economies of scale? Estimate any economies of scale that might be present.
7. Approximately 35 percent of Carnival Cruise's passengers also book their air travel through the cruise company (as an "air and sea" package) while only 25 percent of Royal Caribbean's passengers include the air portion in their booking. Conceptually, how will this affect your ratio comparison of the two companies and discuss how you might adjust the data to remove this distortion?
PART B: FINANCIAL FORECASTS
1. Based on all the information provided in the case, forecast Royal Caribbean's gross revenue for 1999, 2000, and 2001. Please explain your reasoning.
2. Forecast the remaining portions of the income statement for 1999, 2000, and 2001. Comment only on the forecast components that differ significantly from past trends or ratios-do not discuss each line item if you don't have anything substantive to say.
3. Forecast complete balance sheets for the end of 1999, 2000, and 2001. Comment only on the forecast components that differ significantly from past trends or ratios-do not discuss each line item if you don't have anything substantive to say.
4. Can Royal Caribbean afford to purchase the ships that it has on order in the next three years? How do you anticipate that these acquisitions will be financed?
5. For this question, do not use eVal (because it is easier not to). Suppose your analysis indicated that Royal Caribbean will spend $810,261 thousand on additions to property and equipment in 1999. Given this, estimate the ending balance of property and equipment for 1999.
6. For this question, do not use eVal (because it is easier not to). Suppose your analysis indicated that Royal Caribbean's 1999 ending balance of customer deposits was $515,308 thousand. Estimate the amount of cash collected from customers in 1999.
Answer question 6 and 7 in part A.
Attachment:- Assignment.zip