Ratio Analysis of Coca-Cola Company (KO)

ratio_analysis_worksheet.xlsx

Summary

	Financial Statement Analysis
	Coca-Cola Company
	For the Year Ending 12/31/2012
			Industry
	(Coca-Cola Company)	(Pepsi Co)	Norm
Liquidity
Current Ratio				times
Acid-test Ratio
Collection Period
Days to sell inventory
Capital Structure and Solvency
Total debt to equity
Long-term debt to equity
Times interest earned
Return on Investment
Return on assets
Return on common equity
Operating Performance
Gross profit margin
Operating profit margin (pretax)
Net profit margin
Asset Utilization
Cash turnover
Accounts receivable turnover
Inventory turnover
Working capital turnover
PPE turnover
Total asset turnover
Market Measures
Price-to-earnings
Earnings yield
Dividend yield
Dividend payout rate
Price-to-book
See pages 2 and 3 for calculations

	Financial Statement Analysis
	(XYZ Company)	Coca-Cola Company
	For the Year Ending xx/xx/xxxx	For the Year Ending 12/31/2012
Current Ratio	=	Current Assets	=	formula	=	times
		Current Liabilities
complete for all ratios

	Financial Statement Analysis
	(XYZ Company)	Pepsi Co, Inc
	For the Year Ending 12/29/2012
Current Ratio	=	Current Assets	=	formula	=	times
		Current Liabilities
complete for all ratios

	Financial Statement Analysis
	Coca-Cola Company
	For the Year Ending 12/31/2012
		Analysis of Results
1. Liquidity
2. Capital Structure and Solvency
3. Return on Investment
4. Operating Performance
5. Asset Utilization
6. Market Measures
7. Conclusion