Common Size Balance Sheet Prepare a spreadsheet with common size balance sheets for the years ended November 30, 2017 and 2018 For 2018, each line item should be shown as a percentage of total assets on November 30, 2018 Likewise, for 2017, each item should be shown as a percentage of total assets on November 30, 2017 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 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 Carnival Corporation PLC Consolidated Statements of Income USD ($) 12 Months Ended Nov 30, 2018 Nov 30, 2017 Revenues Revenues $ 18,881 $ 17,510 Cruise Selling and administrative 2,450 2,265 Depreciation and amortization 2,017 1,846 Goodwill and trademark impairment 0 89 Operating costs and expenses 15,556 14,701 Operating Income 3,325 2,809 Nonoperating Income (Expense) Interest income 14 9 Interest expense, net of capitalized interest (194) (198) Gains (losses) on fuel derivatives, net 59 35 Other income, net 3 11 Nonoperating Income (Expense) (118) (143) Income Before Income Taxes 3,207 2,666 Income Tax Expense, Net (54) (60) Net Income $ 3,152 $ 2,606 Earnings Per Share Basic (USD per share) $ 4 45 $ 3 61 Diluted (USD per share) 4 44 3 59 Dividends Declared Per Share (USD per share) $ 1 95 $ 1 60

The Answer is in the image, click to view ...

Question: Common Size Balance Sheet Prepare a spreadsheet with common size balance sheets for the years ended November 30, 2017 and 2018. For 2018, each line

Common Size Balance Sheet

Prepare a spreadsheet with common size balance sheets for the years ended November 30, 2017 and 2018. For 2018, each line item should be shown as a percentage of total assets on November 30, 2018. Likewise, for 2017, each item should be shown as a percentage of total assets on November 30, 2017. 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%. 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.

Carnival Corporation & PLC Consolidated Statements of Income - USD ($)	12 Months Ended
	Nov. 30, 2018	Nov. 30, 2017
Revenues
Revenues	$ 18,881	$ 17,510
Cruise
Selling and administrative	2,450	2,265
Depreciation and amortization	2,017	1,846
Goodwill and trademark impairment	0	89
Operating costs and expenses	15,556	14,701
Operating Income	3,325	2,809
Nonoperating Income (Expense)
Interest income	14	9
Interest expense, net of capitalized interest	(194)	(198)
Gains (losses) on fuel derivatives, net	59	35
Other income, net	3	11
Nonoperating Income (Expense)	(118)	(143)
Income Before Income Taxes	3,207	2,666
Income Tax Expense, Net	(54)	(60)
Net Income	$ 3,152	$ 2,606
Earnings Per Share
Basic (USD per share)	$ 4.45	$ 3.61
Diluted (USD per share)	4.44	3.59
Dividends Declared Per Share (USD per share)	$ 1.95	$ 1.60