Required - Using the attached- below- financial statements for Coca-Cola calculate the following ratios for 2014 - Hint: use excel to set up the formulas and amounts to calculate (see below chart)

https://www.sec.gov/Archives/edgar/data/21344/000002134415000005/a2014123110-k.htm

Liquidity ratio
Current assets	92023
Current liabilities	32374
Current ratio is current asset/current liabilities	92023/32374= 2.84
Quick assets=current assets- inventory + prepaid expenses	92023-3100+3066= 91989
Quick ratio is quick assets/current liabilities	91989/32374= 2.84
Calculate debt to equity ratio= Total liabilities/ total stockholder equity
Times interest earned= Earnings before interest and taxes (EBIT)/interest expense
Return on Net Operating Assets RNOA Net Operating assets RNOA= NPOAT/Average NOA
Net Operating Profit After Taxes NOPAT Net operating profit after taxes= net income- (nonperatinge revenues-nonoperating expenses)x(1-marginal tax rates)
Net Operating Profit Margin NOPM NPOM= NOPAT/Sales Revenue
Net Operating Asset Turnover NOAT NOAT= Sales/Average NOA

Note 1	Coca-Cola
	Operating Assets
	Total assets - Non-operating assets
	(ie NOA = Total assets less Short-term investments + Other investments
	Operating Liabilities
	Total liabilities - Non-operating liabilities
	ie NOL = Total liabilities - Loans and notes payable + Current maturities of long-term debt+Long-term debt)