Question
This assignment requires you to submit an excel file . Using the annual report and excel file of financial statements for Carnival, prepare the following
This assignment requires you to submit an excel file .
Using the annual report and excel file of financial statements for Carnival, prepare the following items. Use the spreadsheets provided and modify them with your calculations. Just be sure to change the file name to something with your name in it. You must use spreadsheets for this assignment.
Prepare a spreadsheet with common size balance sheets for the years ended2017 and2018.For 2017, each line item should be shown as a percentage of total assets on December 31, 2017. Likewise, for 2018, each item should be shown as a percentage of total assets on2018. In your calculations,round each percentage to three digits. For example if cash as a percentage of total assets is .054029834, your answer should be shown as 5.4%. Remember, these numbers on the financial statements are rounded to the nearest million, so it is a bit silly to show calculations with more precision than the underlying data.
Vertical Analysis or Common Size statement
Prepare a spreadsheet with common size income statements for the 2018 and 2017 fiscal years. In this case, your denominator will be Net Sales. Again, remember to round.
Horizontal Analysis of both financial statements
Prepare a horizontal analysis of the balance sheet and income statement, showing the percentage change from 2017 to 2018 (the dollar amounts, not the percentages you calculated in the common size statements). This is calculated as follows:
2018 amount - 2017 amount
2017amount
Thus, each line item on the balance sheet and income statement should show a percentage increase or decrease. A negative number, or decrease, can be formatted to show in parentheses, which is the preferable notation in accounting circles.
Ratios
Calculate all of ratios listed in on the Ratio sheet inRoyal Caribbean 10-k data analyzed -2.xls
The listed items should be submitted in an Excel file, with separate tabs for the income statement (including common size 2017 and 2018, as well as the horizontal analysis in one tab), balance sheet (common size 2017 and 2018 plus horizontal analysis in another tab), and ratios in another tab (clearly labelled!).
HERE IS THE CARNIVAL FILEWHICH YOU WILL USE TO submit ASSIGNMENT:
Carnival 10-K data Final Revised- Final.xls
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started