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 15 2 Months Ended Nov. 30, 2018 Nov. 30, 2017 Revenues Revenues $ 28,881 $17.510 Cruise 2.450 2.265 2,017 2,846 89 Selling and administrative Depreciation and amortization Goodwill and trademark impairment Operating costs and expenses xpenses Operating Income Nonoperating Income (Expense) g Income (Expense) Interest income 14,701 25,556 3,325 2,809 Interest expense, net of capitalized interest 194 (198) 35 Gains flosses) on fuel derivatives, net Other income, net Nonoperating Income (Expense) Income Before Income Taxes (143) 3.207 2.666 Income Tax Expense, Net 1600 Net Income 3.152 $ 2606 Earnings Per Share Basic USD per share Diluted (USD per share Dividends Declared Per Share (USD per share) S 195 S160 Carnival Corporation & PLC Consolidated Statements of Income - USD 15 2 Months Ended Nov. 30, 2018 Nov. 30, 2017 Revenues Revenues $ 28,881 $17.510 Cruise 2.450 2.265 2,017 2,846 89 Selling and administrative Depreciation and amortization Goodwill and trademark impairment Operating costs and expenses xpenses Operating Income Nonoperating Income (Expense) g Income (Expense) Interest income 14,701 25,556 3,325 2,809 Interest expense, net of capitalized interest 194 (198) 35 Gains flosses) on fuel derivatives, net Other income, net Nonoperating Income (Expense) Income Before Income Taxes (143) 3.207 2.666 Income Tax Expense, Net 1600 Net Income 3.152 $ 2606 Earnings Per Share Basic USD per share Diluted (USD per share Dividends Declared Per Share (USD per share) S 195 S160