Below are the ratios (with excel formulas) calculated for Pepsi-Co, Inc. for you - all you need to do is calculate the Coca-Cola Company ratios
	Pepsi-Co, Inc.				The Coca-Cola Company
	Selected Financial Data				Selected Financial Data
	For years ended December 31				For years ended December 31
	2020	2019	2018		2020	2019	2018
Acid-test ratio (CA-inventory-prepaid)/CL	0.77	0.66	0.82		0.96	0.56	0.69
Current ratio (CA/CL)	0.98	0.86	0.99		1.32	0.76	0.87
Debt ratio	0.85	0.81	0.81		0.76	0.76	0.77
Earnings per share	5.14	5.23	8.84		1.8	2.09	1.51
Inventory turnover	8.47	9.32	9.39		4.04	4.53	4.25
Net income ($ in millions)	$ 7,120	$ 7,314	$ 12,515		$ 7,747	$ 8,920	$ 6,434
Accounts Receivables turnover	8.67	8.98	9.05		9.28	9.74	9.31
Return on assets	9.34%	10.31%	17.69%		7.61%	9.64%	6.83%
Operating income percentage	14.32%	15.32%	15.64%		27.25%	27.06%	26.68%
Revenues ($ in millions)	$ 70,372	$ 67,161	$ 64,661		$ 33,014	$ 37,266	$ 34,300
Working capital ($ in millions) CA-CL	(371)	(2,816)	(245)		4,639	6,562	3,852

Pepsi balance sheet & income

Consolidated Balance Sheet - USD ($) shares in Millions, $ in Millions	Dec. 26, 2020	Dec. 28, 2019	Dec. 29, 2018			Consolidated Statement of Income - USD ($) shares in Millions, $ in Millions	12 Months Ended
ASSETS							Dec. 26, 2020	Dec. 28, 2019	Dec. 29, 2018
Cash and cash equivalents	$ 8,185	$ 5,509	$8,721			Income Statement [Abstract]
Short-term Investments	1,366	229	272			Net Revenue	70,372	67,161	64,661
Restricted Cash	0	0	1,997			Cost of sales	31,797	30,132	29,381
Accounts and notes receivable, net	8,404	7,822	7,142			Gross profit	38,575	37,029	35,280
Inventories	4,172	3,338	3,128			Selling, general and administrative expenses	28,495	26,738	25,170
Prepaid expenses and other current assets	874	747	633			Operating Profit	10,080	10,291	10,110
Total current assets	23,001	17,645	21,893			Other pension and retiree medical benefits income/(expense)	117	(44)	298
Property, Plant and Equipment, net	21,369	19,305	17,589			Net interest expense and other	(1,128)	(935)	(1,219)
Amortizable Intangible Assets, net	1,703	1,433	1,644			Income before income taxes	9,069	9,312	9,189
Goodwill	18,757	15,501	14,808			Provision for/(benefit from) income taxes (See Note 5)	1,894	1,959	(3,370)
Other Indefinite-lived Intangible Assets	17,612	14,610	14,181			Net income	7,175	7,353	12,559
Indefinite-Lived Intangible Assets	36,369	30,111	28,989			Less: Net income attributable to noncontrolling interests	55	39	44
Investments in Noncontrolled Affiliates	2,792	2,683	2,409			Net Income Attributable to PepsiCo	7,120	7,314	12,515
Deferred Income Taxes	4,372	4,359	4,364			Net Income Attributable to PepsiCo per Common Share
Other Assets	3,312	3,011	760			Basic	5.14	5.23	8.84
Total Assets	92,918	78,547	77,648			Diluted	5.12	5.20	8.78
LIABILITIES AND EQUITY						Weighted-average common shares outstanding
Short-term debt obligations	3,780	2,920	4,026			Basic	1,385	1,399	1,415
Accounts payable and other current liabilities	19,592	17,541	18,112			Diluted	1,392	1,407	1,425
Total Current Liabiities	23,372	20,461	22,138			NOTES:
Long-Term Debt Obligations	40,370	29,148	28,295			Tax rate= Provision for Income Taxes/ Income before taxes	0.2088	0.2104	0
Deferred Income Taxes	4,284	4,091	3,499
Other Liabilities	11,340	9,979	9,114
Total Liabilities	79,366	63,679	63,046
PepsiCo Common Shareholders Equity
Common stock, par value 12/3 per share (authorized 3,600 shares, issued, net of repurchased common stock at par value: 1,380 and 1,391 shares, respectively)	$ 23	$ 23	23
Additional Paid in Capital, Common Stock	$ 3,910	$ 3,886	3,953
Retained Earnings (Accumulated Deficit)	63,443	61,946	59,947
Accumulated Other Comprehensive Income (Loss), Net of Tax	$ (15,476)	$ (14,300)	$ (15,119)
Treasury Stock, Value	(38,446)	(36,769)	(34,286)
TOTAL PepsiCo common shareholders' equity	$ 13,454	$ 14,786	$ 14,518
Noncontrolling interests	98	82	84
Total equity	$ 13,552	$ 14,868	$ 14,602
Total liabilities and Equity	92,918	78,547	77,648

2. Using the financial data for the three years for PepsiCo, Inc., discuss the company's
a. Ability to pay current liabilities;
b. Ability to sell inventory and collect receivables;
c. Ability to pay long-term debt; and
d. Profitability.