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)
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) |