Discuss how you might adjust the data to remove

Reference no: EM131386489

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

Reference no: EM131386489

Questions Cloud

New software application or business web app : Please read instructions carefully. Speaker notes must also be included. Original work only please. Resource: Ch. 10, "Designing Forms and Reports" Design two forms for a new software application or business web app that will collect data from its us..

Can mccullough rescind the agreement : She continued to operate the vehicle until the time of trial, some seventeen and one-half months (and twenty-three thousand miles) later. Can McCullough rescind the agreement?

Draw the aircraft door hinge component : Create a new drawing named hinge.dwg and draw the aircraft door hinge component shown in Fig. 30-15. Dimension the hinge using symmetrical tolerancing and specify tolerances as shown.

What are some methods used for usability testing : Define usability. What are some methods used for usability testing? Under what circumstances would an e-commerce site not need a shopping caret?

Discuss how you might adjust the data to remove : 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. Conceptual..

What are the rights of the parties : Larsen denied having received that oral notification.- On October 12, Peckham sent a written notice of revocation of acceptance to Larsen. What are the rights of the parties?

Write a paper regarding the statistical significance : Write a paper of 1,000-1,250 words regarding the statistical significance of outcomes as presented in the Messina et al. article, "The Relationship Between Patient Satisfaction and Inpatient Admissions Across Teaching and Nonteaching Hospitals."As..

What type of icmp attack : What type of ICMP attack would be the most difficult to prevent? and why?

Joc oil sues con ed for breach of contract judgment : Joc Oil immediately offered to substitute a conforming shipment of oil, although the time for performance had expired after the first shipment of oil. Con Ed refused to accept the substituted shipment. Joc Oil sues Con Ed for breach of contract Ju..

User Account

All Pages