I would love some help with finding the below ratios for Nike in 2017 10-K Secti
ID: 2583736 • Letter: I
Question
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
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
Explanation / Answer
Ratio Analysis
2017
2016
Ratios
current year
previous year
current ratio
current assets/current liabilities
2.934052
2.804218
current asset
16061
15025
current liabilities
5474
5358
Accounts receivable turnover
net sales/average accounts receivables
9.930616
9.989509
net sales
34350
32376
average accounts receivables = (opening + closing) /2
(3677+3241)/2
3459
3241
In previous year 2015 data is not available so only accounts receivables of 2016 is taken into consideration
inventory turnover ratio
cost of goods sold/average inventory
3.848782
3.59014
cost of goods sold
19038
17405
average inventory =(opening+closing)/2
(5055+4838)/2
4946.5
4848
Gross profit margin
gross profit/net sales
0.445764
0.46241
gross profit
15312
14971
net sales
34350
32376
net profit margin
net profit/sales
0.123435
0.116135
net profit
4240
3760
net sales
34350
32376
return on total assets
net income/average total assets
0.189973
0.175874
net income
4240
3760
average total assets
(opening +closing)/2
22319
21379
return on stockholders equity
0.343807
0.301222
net income
4240
3760
average stockholders equity
(opening +closing)/2
12332.5
12482.5
(12407+12258)/2
(12258+12707)/2
Earning per share
2.56
2.21
market price per share at year end
60.36
price earning ratio
market price/eps
23.57813
Debt ratio
totalliabilities/total assets
0.466572
0.426634
total liabilities
10852
9121
total assets
23259
21379
total liabilities
5474+3471+1907
5358+1993+1770
equity ratio
total of shareholders equity/ total assets
0.533428
0.573366
total shareholders equity
12407
12258
total assets
23259
21379
times interest earned
ebit/interest
80.49153
236.9474
ebit
4749
4502
interest
59
19
ebit
15312-10563
14971-10469
Ratio Analysis
2017
2016
Ratios
current year
previous year
current ratio
current assets/current liabilities
2.934052
2.804218
current asset
16061
15025
current liabilities
5474
5358
Accounts receivable turnover
net sales/average accounts receivables
9.930616
9.989509
net sales
34350
32376
average accounts receivables = (opening + closing) /2
(3677+3241)/2
3459
3241
In previous year 2015 data is not available so only accounts receivables of 2016 is taken into consideration
inventory turnover ratio
cost of goods sold/average inventory
3.848782
3.59014
cost of goods sold
19038
17405
average inventory =(opening+closing)/2
(5055+4838)/2
4946.5
4848
Gross profit margin
gross profit/net sales
0.445764
0.46241
gross profit
15312
14971
net sales
34350
32376
net profit margin
net profit/sales
0.123435
0.116135
net profit
4240
3760
net sales
34350
32376
return on total assets
net income/average total assets
0.189973
0.175874
net income
4240
3760
average total assets
(opening +closing)/2
22319
21379
return on stockholders equity
0.343807
0.301222
net income
4240
3760
average stockholders equity
(opening +closing)/2
12332.5
12482.5
(12407+12258)/2
(12258+12707)/2
Earning per share
2.56
2.21
market price per share at year end
60.36
price earning ratio
market price/eps
23.57813
Debt ratio
totalliabilities/total assets
0.466572
0.426634
total liabilities
10852
9121
total assets
23259
21379
total liabilities
5474+3471+1907
5358+1993+1770
equity ratio
total of shareholders equity/ total assets
0.533428
0.573366
total shareholders equity
12407
12258
total assets
23259
21379
times interest earned
ebit/interest
80.49153
236.9474
ebit
4749
4502
interest
59
19
ebit
15312-10563
14971-10469