1
answer
0
watching
141
views
10 Aug 2019

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)

For unlimited access to Homework Help, a Homework+ subscription is required.

Patrina Schowalter
Patrina SchowalterLv2
11 Aug 2019

Unlock all answers

Get 1 free homework help answer.
Already have an account? Log in

Related questions

Related Documents

Weekly leaderboard

Start filling in the gaps now
Log in