Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed

image text in transcribed

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)/ 2017 amount

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.

Brian Spina AutoSave O Camival 10-K data (1) Excel X Crth Page Layout Review Help Tell me what you want to do Share Comments File Home Insert raw Formulas Data View fax D8 A A C P F G H 12 Months Ended Carnival Corporation & PLCC Consolidated Statements of Income USD ($) 2 Nov. 30, 2018 Nov. 30, 2017 Nov. 30, 2016 3 Revenues $18,881,000,000 $17,510,000,000 $16,389,000,000 4 Revenues 5 ruise 2,197,000,000 6 Selling and administrative 2,450,000,000 2,265,000,000 7 Depreciation and amortization BGoodwill and trademark impairment 9 Operating costs and expenses 2,017,000,000 1,846,000,000 1,738,000,000 0 89,000,000 0 15,556,000,000 14,701,000,000 13,318,000,000 10 Operating Income 11 Nonoperating Income (Expense) 12 Interest income 3,071,000,000 3.325,000,000 2,809,000,000 9,000,000 14,000,000 6,000,000 (194,000,000 (223.000.000) 13 Interest expense, net of capitalized interest 14 Gains (losses) on fuel derivatives, net (198,000,000) 35,000,000 (47,000,000) 59,000,000 15 Other income, net 3,000,000 (118,000,000) 11,000,000 (143,000,000) 21,000,000 16 Nonoperating Income (Expense) (243,000,000) 17 Income Before Income Taxes 3,207,000,000 2,666,000,000 2,828,000,000 (60,000,000) 49,000,000 $2,779,000,000 18 Income Tax Expense, Net (54,000,000 $3,152,000,000 19 Net Income $ 2,606,000,0ao 20 Earnings Per Share $4.45 $3.61 $3.73 21 Basic (USD per share) 22 Diluted (USD per share) 23 Dividends Declared Per Share (USD per share) 4.44 3.59 3.72 $1.35 $1.95 $1.60 24 25. Document and Entity Information Carnival Corporation & PLC Cons Canival Carporation &PLC Co_3 . 100% 7:04 PM Type here to search ] 4 8/29/2019 X D8 A L LH C G J M N P 12 Mu ths Ended Documant and Entity Information - USD ($) $ in Billions Jan. 17, 21 ay 31, 2018 Nav. 3D, 2018 3 Ducure Type Amendment Flag Docue Period Crd Dae 10-K false Nov. 30, 2018 5 Dacumen: Fiscal Year Focus 2.016 ocumentHiscal Period Hocus Trading Symbol 9Entity Registrant Name 10 Entity Central Index Key CCL CAHNIVAL CORP 815,097 11 Current Fiscal Year End Date -11-30 12 Entity Wel-known Seasoned Issuer Yes 13 Entity Current Reporting Status 14 Entity Valuntary Filers 15 Entity Filer Category 16 Entity Shell Company Yes No Large Accelerated Fler false false 17 Entity Emergig Growth Company 1 Entity Small Business fasc 19 Entity Common Stock, Shares Outstand ing 525,719.955 23.8 20 Entity Public Fleat 21 Carnivel PLC 22 Trading Symbol 23 Entity Registrant Nare 24 Fntity Crntral Index Kny CUK CARNIVAL PLC 1,125,59 25 CueFiscal Year End Dele --11-30 Fntity Well lenawn Seasaned lssuer 27 Cily Cure! L Repurting Statu 28 Entity Voluntary Filers 29 Cily riler Caleory 30 Entity Shell Company 31 Cnuly Cmerging Growth Company Entity Small Business 33 Cntity Common Stack, Shares Outstand ing 34 Entity Publlc Hloat Yea Yes No Large cceleraed Fle false fase false 191,875,647 $11.5 35 36 37 Carnival Corporation & PLC Cons Canival Corporation & PLC Co 3 Document and Entity Information . 7:13 PM Type here to search 4 8/29/2019 Brian Spina AutoSave o Camival 10-K data (1) Excel X Crth O Tell me what you want to do Page Layout Help Share Comments File Home Insert raw Formulas Data Review View fx 1 A A B C F G Carnival Corporation & PLC Consolidated Balance Sheets USD ($) $ In Millilons 1 Nov. 30, 2018 Nov. 30, 2017 2 Current Assets 3 Cash and cash equivalents $982 $395 4 Trade and other receivables, net 358 312 5 Inventories 387 450 6 Prepaid expenses and other 502 436 7 Total current assets 2,225 1,596 8 Property and Equipment, Net 35,336 34,430 9 Goodwill 2,925 2,967 10 Other Intangibles 1,176 1,200 11 Other Assets 738 585 42,401 12 Assets 40,778 13 Current Liabilities 14 Short-term borrawings 848 485 15 Current portion of long-term debt 16 Accounts payable 1,578 1,717 730 762 1,877 17 Accrued liabilities and other 1,654 18 Customer deposits 4,395 3,958 19 Total current liabilities 9,204 8,800 20 Long-Term Debt 7,897 6,993 21 Other Long-Term Liabilities 856 769 22 Commitments and Contingencies 23 Shareholders' Equity 24 Additional paid-in capital 8,756 8,690 25 Retained earnings 25.066 23 292 Carnival Corporation & PLC Cons Carnival Corporation & PLC Co 3 Document and Entity Information 100% 7:05 PM Type here to search ] 4 8/29/2019

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

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

Interpretation And Application Of International Standards On Auditing

Authors: Steven Collings

1st Edition

0470661127, 978-0470661123

More Books

Students also viewed these Accounting questions

Question

Describe the seven standard parts of a letter.

Answered: 1 week ago

Question

Explain how to develop effective Internet-based messages.

Answered: 1 week ago

Question

Identify the advantages and disadvantages of written messages.

Answered: 1 week ago