Question

I need the following 10 financial ratios, with work shown, for the company Amazon for 2017 & 2018

Profit margin on sales

operating profit margin

ROA

ROE

Total assets turnover

Fixed assets turnover

Current liquidity

Quick liquidity

Debt-to -asset ratio

P/E

Fiscal year is January-December. All values USD Millions.	2018	2017	2016	2015	2014	5-year trend
Sales/Revenue	232,887	177,866	135,987	107,006	88,988
Sales Growth	30.93%	30.80%	27.08%	20.25%	-
Cost of Goods Sold (COGS) incl. D&A	139,156	111,934	88,265	71,651	62,752
COGS excluding D&A	126,543	102,737	82,212	66,004	59,530
Depreciation & Amortization Expense	12,613	9,197	6,053	5,647	3,222
Depreciation	12,138	8,831	5,766	5,377	3,041
Amortization of Intangibles	475	366	287	270	181
Amortization of Deferred Charges	-	-	-	-	-
COGS Growth	24.32%	26.82%	23.19%	14.18%	-
Gross Income	93,731	65,932	47,722	35,355	26,236
Gross Income Growth	42.16%	38.16%	34.98%	34.76%	-
Gross Profit Margin	40.25%	-	-	-	-
SG&A Expense	81,014	61,612	43,369	32,951	25,925
Research & Development	28,837	22,620	16,085	12,540	9,275
Other SG&A	52,177	38,992	27,284	20,411	16,650
SGA Growth	31.49%	42.06%	31.62%	27.10%	-
Other Operating Expense	-	-	-	-	-
EBIT	12,717	-	4,353	-	311
Unusual Expense	131	(109)	(67)	-	-
Non Operating Income/Expense	(348)	23	(144)	(427)	(251)
Non-Operating Interest Income	440	202	100	50	39
Equity in Affiliates (Pretax)	-	-	-	-	-
Interest Expense	1,417	848	484	459	210
Interest Expense Growth	67.10%	75.21%	5.45%	118.57%	-
Gross Interest Expense	1,417	848	484	459	210
Interest Capitalized	-	-	-	-	-
Pretax Income	11,261	3,806	3,892	1,568	(111)
Pretax Income Growth	195.87%	-2.21%	148.21%	1512.61%	-
Pretax Margin	4.84%	-	-	-	-
Income Tax	1,197	769	1,425	950	167
Income Tax - Current Domestic	193	74	1,344	452	279
Income Tax - Current Foreign	563	724	327	417	204
Income Tax - Deferred Domestic	570	(228)	85	302	(136)
Income Tax - Deferred Foreign	(129)	199	(331)	(221)	(180)
Income Tax Credits	-	-	-	-	-
Equity in Affiliates	9	(4)	(96)	(22)	37
Other After Tax Income (Expense)	-	-	-	-	-
Consolidated Net Income	10,073	3,033	2,371	596	(241)
Minority Interest Expense	-	-	-	-	-
Net Income	10,073	3,033	2,371	596	(241)
Net Income Growth	232.11%	27.92%	297.82%	347.30%	-
Net Margin	4.33%	-	-	-	-
Extraordinaries & Discontinued Operations	-	-	-	-	-
Extra Items & Gain/Loss Sale Of Assets	-	-	-	-	-
Cumulative Effect - Accounting Chg	-	-	-	-	-
Discontinued Operations	-	-	-	-	-
Net Income After Extraordinaries	10,073	3,033	2,371	596	(241)
Preferred Dividends	-	-	-	-	-
Net Income Available to Common	10,073	3,033	2,371	596	(241)
EPS (Basic)	20.15	6.15	4.90	1.25	(0.52)
EPS (Basic) Growth	227.58%	25.51%	292.00%	340.38%	-
Basic Shares Outstanding	487	480	474	467	462
EPS (Diluted)	20.15	6.15	4.90	1.25	(0.52)
EPS (Diluted) Growth	227.46%	25.59%	292.07%	339.53%	-
Diluted Shares Outstanding	500	493	484	477	462
EBITDA	25,330	13,517	10,406	8,051	3,533
EBITDA Growth	87.39%	29.90%	29.25%	127.88%	-
EBITDA Margin	10.88%	-	-	-	-
EBIT	12,717	-	4,353	-	311

THANKS IN ADVANCE,

JB

Answer 1

Fig.in mlns.
Figures from Sec 10K- annual report --Pg.37 & 39	Year ended, Dec 31
	2017	2018
1.Profit margin on sales
Net income/sales
Net income	3033	10073
Sales	177866	232887
Profit margin on sales	1.71%	4.33%
2.Opg. Profit margin
EBIT/sales
EBIT	4106	12421
Sales	177866	232887
Opg.Profit margin on sales	2.31%	5.33%
3.ROA
Net income/Av. Total assets
Av. Total Assets=(Beg.+ending total assets)/2
Net income	3033	10073
Beg. Assets	83402	131310
Ending assets	131310	162648
Av. Total assets	107356	146979
ROA	2.83%	6.85%
4.ROE
Net income/Av. Total Equity
Av. Total equity=(Beg.+ending total equity)/2
Net income	3033	10073
Beg. Equity	19285	27709
Ending equity	27709	43549
Av. Total equity	23497	35629
ROE	12.91%	28.27%
5.Total assets T.O
Sales/Av. Total assets
Sales	177866	232887
Beg. Assets	83402	131310
Ending assets	131310	162648
Av. Total assets	107356	146979
Total assets T.O	1.66	1.58
(times)
6.Fixed assets T.O
Sales/Av. Fixed assets
Sales	177866	232887
Beg. Fixed Assets	37621	71113
Ending Fixed assets	10916	87547
Av. Total Fixed assets	24269	79330
Fixed assets T.O	7.33	2.94
(times)
7.Current lquidity
Current assets/Current Liabilities
Current assets	60197	75101
Current liabilities	57883	68391
CA/CL	1.04	1.10
8.Quick Liquidity
(Current assets-Inventory)/Current Liabilities
Current assets	60197	75101
Inventories	16047	17174
Quick assets	44150	57927
Current liabilities	57883	68391
QA/CL	0.76	0.85
9.Debt To Total assets ratio
Av. Debt/Av. Total assets
Beg. Debt	20301	45718
Ending debt	45718	50708
Av. Debt	33010	48213
Beg. Assets	83402	131310
Ending assets	131310	162648
Av. Total assets	107356	146979
Av. Debt/av. Assets	30.75%	32.80%
10.. P/E
Mkt.price/Earnings per share
Mkt.price	1189	1501.97
EPS	6.32	20.68
P/E	188	73
times