Question

Provide Amazon's financial data of last 5 years . Then calculate relevant Ratio's from them

• Liquidity ratios
• Leverage ratios
• Efficiency ratios
• Profitability ratios
• Market value ratios

and then present those Ratio's result in graph

Answer 1

Liquidity Ratios	2019	2018	2017	2016	2015	Definitions
Current Ratio	1.10	1.10	1.04	1.04	1.08	Current Assets/Current Liabilities
Quick Ratio	0.86	0.85	0.76	0.78	0.77	(Current Assets - Inventory)/Current Liabilities
Leverage Ratios	2019	2018	2017	2016	2015
Debt to Equity	2.63	2.73	3.74	3.32	3.89	Liabilities/Shareholder Value
Debt to Capital	0.72	0.73	0.79	0.77	0.80	Liabilities/Total Assets
Debt to Operating Income	11.22	9.59	25.23	15.32	23.31	Liabilities/Operating Income
Efficiency Ratio	2019	2018	2017	2016	2015
Inventory Turnover Ratio	8.08	8.10	6.98	7.70	7.00	Cost of Goods Sold/Average Inventory
Asset Turnover Ratio	1.25	1.43	1.35	1.63	1.64	Net Sales/Total Assets
Receivables Turnover Ratio	0.43	0.35	0.49	0.51	0.40	Credit Sales/Account Receivables
Profitaility Ratios	2019	2018	2017	2016	2015
Gross Profit Margin %	40.99	40.25	37.07	35.09	33.04	Gross Profit/Net Sales
Net Profit Margin %	4.13	4.33	1.71	1.74	0.56	Net Profit/Net Sales
EBIDTA Margin %	13.31	12.04	9.07	9.12	7.74	EBIDTA/Net Sales
ROC %	5.14	6.19	2.31	2.84	0.91	Net Income/Total Assets
ROE %	18.67	23.13	10.95	12.29	4.45	Net Income/Shareholders Capital
Market Value Ratios	2019	2018	2017	2016	2015
Earnings Per Share	23.46	20.39	6.14	4.80	1.21	Net Income/No of Shares
PE Ratio	78.77	73.66	190.48	156.24	560.22	Stock Price/Earnings Per Shares
Price to Book Value	14.71	17.04	20.85	19.21	24.95	Market Capitalisation/Shareholders Capital

Assets US$ in millions
	Dec 31, 2019	Dec 31, 2018	Dec 31, 2017	Dec 31, 2016	Dec 31, 2015
Cash and cash equivalents	36,092	31,750	20,522	19,334	15,890
Marketable securities	18,929	9,500	10,464	6,647	3,918
Inventories	20,497	17,174	16,047	11,461	10,243
Accounts receivable, net	17,663	13,310	9,692	6,561	4,400
Other	3,153	3,367	3,472	1,778	2,023
Accounts receivable, net and other	20,816	16,677	13,164	8,339	6,423
Current assets	96,334	75,101	60,197	45,781	36,474
Property and equipment, net	72,705	61,797	48,866	29,114	21,838
Operating leases	25,141	—	—	—	—
Goodwill	14,754	14,548	13,350	3,784	3,759
Other assets	16,314	11,202	8,897	4,723	3,373
Long-term assets	128,914	87,547	71,113	37,621	28,970
Total assets	225,248	162,648	131,310	83,402	65,444

Liabiities and shareholders capital US$ in millions
	Dec 31, 2019	Dec 31, 2018	Dec 31, 2017	Dec 31, 2016	Dec 31, 2015
Accounts payable	47,183	38,192	34,616	25,309	20,397
Current portion of lease liabilities, operating leases	3,139	—	—	—	—
Current portion of lease liabilities, finance leases	9,884	7,720	5,839	3,997	3,027
Current portion of long-term debt	1,307	1,371	100	1,056	238
Other	18,109	14,572	12,231	8,686	7,119
Accrued expenses and other	32,439	23,663	18,170	13,739	10,384
Unearned revenue	8,190	6,536	5,097	4,768	3,118
Current liabilities	87,812	68,391	57,883	43,816	33,899
Long-term lease liabilities, operating leases, excluding current portion	22,696	—	—	—	—
Long-term lease liabilities, finance leases, excluding current portion	17,095	9,650	8,438	5,080	4,212
Long-term lease liabilities, excluding current portion	39,791	9,650	8,438	5,080	4,212
Long-term debt, excluding current portion	23,414	23,495	24,743	7,694	8,235
Other long-term liabilities	12,171	17,563	12,537	7,527	5,714
Long-term liabilities	75,376	50,708	45,718	20,301	18,161
Total liabilities	163,188	119,099	103,601	64,117	52,060
Preferred stock, $0.01 par value; issued and outstanding shares — none	—	—	—	—	—
Common stock, $0.01 par value	5	5	5	5	5
Treasury stock, at cost	(1,837)	(1,837)	(1,837)	(1,837)	(1,837)
Additional paid-in capital	33,658	26,791	21,389	17,186	13,394
Accumulated other comprehensive loss	(986)	(1,035)	(484)	(985)	(723)
Retained earnings	31,220	19,625	8,636	4,916	2,545
Stockholders’ equity	62,060	43,549	27,709	19,285	13,384
Total liabilities and stockholders’ equity	225,248	162,648	131,310	83,402	65,444

Consolidated Income Statement
US$ in millions
12 months ended:	Dec 31, 2019	Dec 31, 2018	Dec 31, 2017	Dec 31, 2016	Dec 31, 2015
Net product sales	160,408	141,915	118,573	94,665	79,268
Net services sales	120,114	90,972	59,293	41,322	27,738
Net sales	280,522	232,887	177,866	135,987	107,006
Cost of sales	(165,536)	(139,156)	(111,934)	(88,265)	(71,651)
Gross profit	114,986	93,731	65,932	47,722	35,355
Fulfillment	(40,232)	(34,027)	(25,249)	(17,619)	(13,410)
Technology and content	(35,931)	(28,837)	(22,620)	(16,085)	(12,540)
Marketing	(18,878)	(13,814)	(10,069)	(7,233)	(5,254)
General and administrative	(5,203)	(4,336)	(3,674)	(2,432)	(1,747)
Other operating expense, net	(201)	(296)	(214)	(167)	(171)
Operating income	14,541	12,421	4,106	4,186	2,233
Interest income	832	440	202	100	50
Interest expense	(1,600)	(1,417)	(848)	(484)	(459)
Other income (expense), net	203	(183)	346	90	(256)
Non-operating income (expense)	(565)	(1,160)	(300)	(294)	(665)
Income before income taxes	13,976	11,261	3,806	3,892	1,568
Provision for income taxes	(2,374)	(1,197)	(769)	(1,425)	(950)
Equity-method investment activity, net of tax	(14)	9	(4)	(96)	(22)
Net income	11,588	10,073	3,033	2,371	596

Consolidated Cash Flow Statement
US$ in millions
12 months ended:	Dec 31, 2019	Dec 31, 2018	Dec 31, 2017	Dec 31, 2016	Dec 31, 2015
Net income	11,588	10,073	3,033	2,371	596
Depreciation and amortization of property and equipment and capitalized content costs, operating lease assets, and other	21,789	15,341	11,478	8,116	6,281
Stock-based compensation	6,864	5,418	4,215	2,975	2,119
Other operating expense, net	164	274	202	160	155
Other (income) expense, net	(249)	219	(292)	(20)	250
Deferred income taxes	796	441	(29)	(246)	81
Excess tax benefits from stock-based compensation	—	—	—	(829)	(119)
Inventories	(3,278)	(1,314)	(3,583)	(1,426)	(2,187)
Accounts receivable, net and other	(7,681)	(4,615)	(4,786)	(3,367)	(1,755)
Accounts payable	8,193	3,263	7,175	5,030	4,294
Accrued expenses and other	(1,383)	472	283	1,724	913
Unearned revenue	1,711	1,151	738	1,955	1,292
Changes in operating assets and liabilities	(2,438)	(1,043)	(173)	3,916	2,557
Adjustments to reconcile net income to net cash from operating activities	26,926	20,650	15,401	14,072	11,324
Net cash provided by operating activities	38,514	30,723	18,434	16,443	11,920
Purchases of property and equipment	(16,861)	(13,427)	(11,955)	(7,804)	(5,387)
Proceeds from property and equipment sales and incentives	4,172	2,104	1,897	1,067	798
Acquisitions, net of cash acquired, and other	(2,461)	(2,186)	(13,972)	(116)	(795)
Sales and maturities of marketable securities	22,681	8,240	9,988	4,733	3,025
Purchases of marketable securities	(31,812)	(7,100)	(13,777)	(7,756)	(4,091)
Net cash used in investing activities	(24,281)	(12,369)	(27,819)	(9,876)	(6,450)
Excess tax benefits from stock-based compensation	—	—	—	829	119
Proceeds from long-term debt and other	2,273	768	16,231	621	353
Repayments of long-term debt and other	(2,684)	(668)	(1,372)	(354)	(1,652)
Principal repayments of finance leases	(9,628)	(7,449)	(4,799)	(3,860)	(2,462)
Principal repayments of financing obligations	(27)	(337)	(200)	(147)	(121)
Net cash provided by (used in) financing activities	(10,066)	(7,686)	9,860	(2,911)	(3,763)
Foreign currency effect on cash, cash equivalents, and restricted cash	70	(351)	713	(212)	(374)
Net increase (decrease) in cash, cash equivalents, and restricted cash	4,237	10,317	1,188	3,444	1,333
Cash, cash equivalents, and restricted cash, beginning of period	32,173	21,856	19,334	15,890	14,557
Cash, cash equivalents, and restricted cash, end of period	36,410	32,173	20,522	19,334	15,890

	12/31/2019	12/31/2018	12/29/2017	12/30/2016	12/31/2015
Stock Price	1847.84	1501.97	1169.47	749.87	675.89
M Cap	9.1283E+11	7.41971E+11	5.77716E+11	3.70435E+11	3.33889E+11