ACTG 3000 Chapter Notes - Chapter 5: Nopat, Reserve Requirement, Earnings Before Interest, Taxes, Depreciation, And Amortization
Get access
Related Documents
Related Questions
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) |
I would love some help with finding the below ratios for Nike in 2017 10-K Section 4 – Ratio calculations and analysis http://s1.q4cdn.com/806093406/files/doc_financials/2017/ar/docs/nike-2017-form-10K.pdf
RATIO | FORMULA | CURRENT YEAR | PREVIOUS YEAR |
Current Ratio | Current Assets Current Liabilities | ||
Accounts Receivable Turnover | Net Total Sales Avg. Accounts Rec. | ||
Inventory Turnover | Cost of Goods Sold Average Inventory | ||
Gross Profit Margin | Gross Profit Net sales | ||
Net Profit Margin | Net Income Net Sales | ||
Return on Total Assets | Net Income Avg. Total Assets | ||
Return on Stockholders’ Equity | Net Income Avg. Stockholders’ Eq. | ||
Earnings Per Share | (given on annual report) | ||
Market Price Per Share at Year End | (available at Yahoo.com and other websites) | ||
Price/Earnings Ratio | Year End Market Price Earnings Per Share | ||
Debt Ratio | Total Liabilities Total Assets | ||
Equity Ratio | Total Stockholders’ Eq. Total Assets | ||
Times Interest Earned | Income before Int. + Tax Interest Expense |