Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 and Carnival's 2010 10-K filings are included as online exhibits in the Royal Caribbean 2010 folder at http://www.lundholmandsloan.com/new%20cases.html. You will need to import the case data into eVal. (Note: find the files RCL 2010 Data.xls and CCL 2010 Data.xls at http://www.lundholmandsloan.com/new%20cases.html. Copy the yellow block of data for the company, and then paste 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 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 the textbook. 1. Compare the size and growth rates of Royal Caribbean and Carnival Cruises. What are the advantages to being large in this industry? 2. Compute the 2010 net operating income, net financing expense, average net operating assets, and average net financial obligations from the financial statements in Royal Caribbean's 10-K 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. Suppose that 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?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

It seems youre working on a financial analysis project comparing Royal Caribbean Cruises and Carnival Cruises To assist you effectively I need access to the files mentioned in the prompt such as RCL 2... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Document Format ( 2 attachments)

PDF file Icon
66421014b5622_986632.pdf

180 KBs PDF File

Word file Icon
66421014b5622_986632.docx

120 KBs Word File

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: J. David Spiceland, Wayne Thomas, Don Herrmann

3rd edition

9780077506902, 78025540, 77506901, 978-0078025549

More Books

Students also viewed these Finance questions