Question

Requirements: Calculate Common Size Income Statement, column down in grey. Please include excel reference formulas.

-11 -AA == U.E.A.A. ESSE Percentage Wrap Text Merge Center - $ -% Number Conditional Formatas Cell Formatting Table - Styles Insert Delete com Alignment G Most recent financial Most recent financial Info Common Size Income Statement Info Income Statement [Abstract] Dec 31, 2017 Revenues Cost of Goods and Services Sold GROSS PROFIT Selling General and Administrative Expense Other Cost and Expense, Operating OPERATING INCOME Interest income Dec 31, 2018 Dec 31, 2017 Dec 31, 2018 $ 31,856 $ 35,410 11,770 13,255 20,086 22,155 10,307 12,654 1,079 1,902 8,700 7,599 1,008 Interest expense Equity income (loss) - net Other income (loss) - net INCOME BEFORE INCOME TAXES Income taxes (1,121) 8,350 1,623 841 1,071 (1,764 6,742 5,560 1,182 NET INCOME FROM CONTINUING OPERATIONS 6,727 (251) Income (Loss) from Discontinued Operations, Net of Tax, including Portion Attributable to Noncontrolling Interest CONSOLIDATED NET INCOME 6,476 1,283 35 $6,434 $ 1,248 Net Income (Loss) Attributable to Noncontrolling interest NET INCOME ATTRIBUTABLE TO SHAREOWNERS OF THE COCA COLA Ratios and Comparisont -ch ASPIRE

Answer 1

Income statement abstract		Most recent financial info	Most recent financial info	Common size Income statement
	UOM	Dec, 21 2018	Dec, 21 2017	Dec, 21 2018	Dec, 21 2017
Revenues	$	31856	35410	100%	100%
Cost of goods and services sold	$	11770	13255	37%	37%
Gross Profit	$	20086	22155	63%	63%
Selling general and Admin expenses	$	10307	12654	32%	36%
Other cost & expenses, operating	$	1079	1902	3%	5%
Operating Income	$	8700	7599	27%	21%
Interest Incomes	$	682	677	2%	2%
Interest Expense	$	919	841	3%	2%
Equity Income (loss)-net	$	1008	1071	3%	3%
Other Income (loss)-net	$	(1,121.00)	(1,764.00)	-4%	-5%
Income before income taxes	$	8350	6742	26%	19%
Income Tax	$	1623	5560	5%	16%
Net income from Continuing operation	$	6727	1182	21%	3%
Income (loss) from discontinued operation,net of tax including portion attributable to Non Controllign interest	$	(251.00)	101	-1%	0%
Consolidated Net Income	$	6476	1283	20%	4%
Net Income (Loss)attributable to Non Controlling interest	$	42	35	0%	0%
Net Income attributable to shareholders of coca cola company	$	6434	1248	20%	4%
Income(Loss) from continuing operations, per basic share	$	1.58	0.28	105%	93%
Discontinued operation, Income (loss) from Discontinued operation, Net of Tax per basic share	$	(0.07)	0.02	-5%	7%
Basic Net Income per share ( In $/ share)	$	1.51	0.3	100%	100%
Income(Loss) from continuing operations, per diluted share	$	1.57	0.27	105%	93%
Discontinued operation, Income (loss) from Discontinued operation, Net of Tax per diluted share	$	(0.07)	0.02	-5%	7%
Diluted Net income per share (in dollar per share)	$	1.50	0.29	100%	100%
Average Shares o/s in shares	$	4259	4272
Effect of dilutive securities (in shares)	$	40	52
Average shares Outstanding assuming dilution (in shares)	$	4299	4324