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