Question

Calculate common size balance sheet. Please include excel reference formulas.

glcons Screenshot - JW ADO- Charts Charts Мар- ✓ fi Dec 31, 2018 Paste Companies Financial Statements in Space proviced for each company: Make sure that you write if the info is in million COMPANY A: (Coca-Cola) Add most current fiscal year end date first last years Calculate Financial Info Common Size Balance Sheet Dec 31, 2018 Dec 31, 2017 Dec 31, 2018] Dec 31, 2017 Consolidated Balance Sheets (USD $) in Millions In Millions, unless otherwise specified $ 8,926 2,025 10,951 5,013 3,396 $6,006 9,352 15,358 5,317 3667 CURRENT ASSETS Cash and cash equivalents Short-term investments TOTAL CASH, CASH EQUIVALENTS AND SHORT-TERM INVESTMENTS Marketable securities Trade accounts receivable, less allowances of $489 and $477 respectively Inventories Prepaid expenses and other assets Assets held for sale Assets held for sale - discontinuing operations TOTAL CURRENT ASSETS EQUITY METHOD INVESTMENTS OTHER INVESTMENTS OTHER ASSETS Deferred Tax Assets, Net, Noncurrent 2,766 1,962 2,655 2,000 219 7,329 36,545 20,856 6,546 30,634 19,407 857 1,096 4,230 4,139 2,667 310 g Points Ratios and Comparison t ere to search BIO PIR VERTY TU

The requirement is to calculate a Common Size Balance Sheet. It is shown in green.

Answer 1

COMPANY A : COCO COLA
			Common Size Balance Sheet
Consolidated Balance Sheet (USD $) in millions	Dec 31 ,2018	Dec 31,2017	Dec 31 ,2018	Dec 31,2017
	Amount	Amount
	in millions	in millions
CURRENT ASSETS
Cash & Cash Equivalents	$            8,926	$            6,006	10.7%	6.8%		Formula: (Each item of Asset / Total Assets of that year)*100
Short Term Investments	$            2,025	$            9,352	2.4%	10.6%
Total Cash & Cash Equivalents and Short Term investments	$         10,951	$         15,358	13.2%	17.5%
Marketable Securities	$            5,013	$            5,317	6.0%	6.0%
Trade Accounts Receivable (Less Allowance of 489 and 487 respectively)	$            3,396	$            3,667	4.1%	4.2%
Inventories	$            2,766	$            2,655	3.3%	3.0%
Prepaid Expenses & Other Assets	$            1,962	$            2,000	2.4%	2.3%
Assets Held for Sale	$                   -	$               219	0.0%	0.2%
Assets Held for Sale- Discontinuing Operations	$            6,546	$            7,329	7.9%	8.3%
TOTAL CURRENT ASSETS	$         30,634	$         36,545	36.8%	41.6%
Equity Method Investments	$         19,407	$         20,856	23.3%	23.7%
Other investments	$               867	$            1,096	1.0%	1.2%
Other Assets	$            4,139	$            4,230	5.0%	4.8%
Deferred Tax Assets , Net , Non Current	$            2,667	$               330	3.2%	0.4%
Property , Plant & Equipments (Net)	$            8,232	$            8,203	9.9%	9.3%
Trademark with Indefinite lives	$            6,682	$            6,729	8.0%	7.7%
Bottlers Franchise Right with Indefinite Life	$                  51	$               138	0.1%	0.2%
Goodwill	$         10,263	$            9,401	12.3%	10.7%
Other Intangible Assets	$               274	$               368	0.3%	0.4%
Total Assets	$         83,216	$         87,896	100.0%	100.0%
CURRENT LIABILITIES
Accounts Payable & Accrued Expenses	$            8,932	$            8,748	10.7%	10.0%		Formula: (Each item of Liabilties & Equity / Total Liabilities & Equity of that year)*100
Notes & Loans Payable, Current	$         13,194	$         13,205	15.9%	15.0%
Current Maturities and long term debts	$            4,997	$            3,298	6.0%	3.8%
Accrued income taxes	$               378	$               410	0.5%	0.5%
Liabilities Held for sale	$                   -	$                  37	0.0%	0.0%
Liabilities Held for sale, Discontinued Operations	$            1,722	$            1,496	2.1%	1.7%
Total Current Liabilities	$         29,223	$         27,194	35.1%	30.9%
			0.0%	0.0%
Long term Debts	$         25,364	$         31,182	30.5%	35.5%
Other Liabilities	$            7,638	$            8,021	9.2%	9.1%
Deferred Income Taxes	$            1,933	$            2,522	2.3%	2.9%
THE COCO COLA COMPANY SHAREOWNERS EQUITY
Common Stock $0.25 par value, Authorised - 11200 shares, issued 7040 and 7040 shares respectively	$            1,760	$            1,760	2.1%	2.0%
Capital Surplus	$         16,520	$         15,864	19.9%	18.0%
Reinvested Earnings	$         63,234	$         60,430	76.0%	68.8%
Accumulated Other Comphrensive Income (Loss)	$       (12,814)	$       (10,305)	-15.4%	-11.7%
Treasury Stock, At cost- 2772 and 2781 shares, respectively	$       (51,719)	$       (50,677)	-62.2%	-57.7%
Equity Attributable to Non Controlling interests	$         16,981	$         17,072	20.4%	19.4%
Total Equity	$         19,058	$         18,977	22.9%	21.6%
Total Liabilities & Equity	$         83,216	$         87,896	100.0%	100.0%