Perform financial ratio analysis on Amazon by using the attached financial data (Excel spreadsheet 1).
You are provided with the excel spreadsheet which includes simplified income statement and balance sheet for Amazon. Based on it, calculate the following financial ratios of Amazon for the last 5 years (Do NOT use the financial statements included in your case):
-
Profit Margin
-
Operating Profit over Revenue
-
Current ratio
-
Return on Total Assets
Present the above ratios in a TABLE and explain what your conclusions on the Amazons recent performance are.
excel spreadsheet 1:
excel spreadsheet 2:
2015 2015 2017 2015 2019 Net product sales $ 79,258 $ 94,665 $ 118,573 $ 141,915 $ 160,408 27,738 41,322 120,114 59,293 177,866 90,972 232.887 107,006 135,987 280,522 Net service sales Total revenues Operating expenses: Cost of sales Fulfillment Technology and content Marketing General and administrative 71,651 13.410 88.265 17.619 7,233 111,934 25,249 22,620 10,069 139,156 34,027 28.837 13,814 165,536 40,232 35,931 12.540 16,085 18,878 1,747 2,432 3,674 4,335 5,203 Other operating expense income).net 171 167 214 296 201 104,773 220,456 2.233 12,421 Total operating expenses Operating income Interest income Interest expense 131,801 4186 100 (484) 173,760 4,106 202 1848) 265,981 14,54 832 (1.600) 50 (1.417) (256) 90 346 (183) 203 Other income (expensel.net Total non-operating income expense) (665) 1294) (300) (1.160) (565) Income before income taxes 1,558 3,892 3,806 11,251 13,976 Provision for income taxes 1950) (1.425) (769) (1.197 12,374) Equity-method investment activity, net of tax (22) 196) 2,371 $ 3,033 $ 10,073 $ 11,588 596 128 5.01 $ 6.32 $ 20.58 $ 23.46 125 $ 6.15 $ 2014 $ 23.01 Net income Basic earnings per share Diluted earnings per share Weighted average shares used in computation of earnings per share: Basic Diluted 457 474 487 494 480 493 500 504 2015 ASSETS Curenta Cash and cash equivalents $ 15,90 $ 19,334 $ 20,522 $ 31,750 $ 36,092 30464 18,929 3,918 10,243 6,647 11,461 Marketable securities Inventories Accounts receivable net and other 9,500 17,174 $6,047 20,497 6,423 13,164 16,677 20,816 Total current 36424 45,781 60,197 75,101 96,314 21831 29,154 4R.266 61.797 72,705 3.79 3.784 1.350 RA 131310 14,543 11.202 25.141 14,754 16,314 225.24 83,400 Property and equipment, net Operating les Goodwill Other sets Total LIABILITIES AND STOCKHOLDERS' EQUITY Current abilities Accounts payable Accrued expenses and other Ureamed revenue Total current abilities Long term debet Other long-term abilities 20.397 10,384 25,109 11,719 34,616 16.170 192 2346 47,183 32,419 3,113 6,536 110 11499 5,017 SA 24,743 1,199 87,812 23.495 39,711 9,26 20.925 22.212 23,414 Commitments and contingencies Note 7) 12,171 5 5 5 (1.837 1 Stockholders guilty Outstanding shares - 41 and 465 Treasury stock, cont Additional paid in capital Accumulated other comprehensive loss Retained earnings 11837 33,658 13.394 17,186 21,309 26,791 1 (1,035 1723 2.545 1945) 4,916 1986 31.220 19.625 Total stockholders' uity 13.35 19,285 27,709 43.549 62,00 Total liabilities and stockholders' equity 5 65440 83,402 5 131,310 5 16248 225.248 2015 2015 2017 2015 2019 Net product sales $ 79,258 $ 94,665 $ 118,573 $ 141,915 $ 160,408 27,738 41,322 120,114 59,293 177,866 90,972 232.887 107,006 135,987 280,522 Net service sales Total revenues Operating expenses: Cost of sales Fulfillment Technology and content Marketing General and administrative 71,651 13.410 88.265 17.619 7,233 111,934 25,249 22,620 10,069 139,156 34,027 28.837 13,814 165,536 40,232 35,931 12.540 16,085 18,878 1,747 2,432 3,674 4,335 5,203 Other operating expense income).net 171 167 214 296 201 104,773 220,456 2.233 12,421 Total operating expenses Operating income Interest income Interest expense 131,801 4186 100 (484) 173,760 4,106 202 1848) 265,981 14,54 832 (1.600) 50 (1.417) (256) 90 346 (183) 203 Other income (expensel.net Total non-operating income expense) (665) 1294) (300) (1.160) (565) Income before income taxes 1,558 3,892 3,806 11,251 13,976 Provision for income taxes 1950) (1.425) (769) (1.197 12,374) Equity-method investment activity, net of tax (22) 196) 2,371 $ 3,033 $ 10,073 $ 11,588 596 128 5.01 $ 6.32 $ 20.58 $ 23.46 125 $ 6.15 $ 2014 $ 23.01 Net income Basic earnings per share Diluted earnings per share Weighted average shares used in computation of earnings per share: Basic Diluted 457 474 487 494 480 493 500 504 2015 ASSETS Curenta Cash and cash equivalents $ 15,90 $ 19,334 $ 20,522 $ 31,750 $ 36,092 30464 18,929 3,918 10,243 6,647 11,461 Marketable securities Inventories Accounts receivable net and other 9,500 17,174 $6,047 20,497 6,423 13,164 16,677 20,816 Total current 36424 45,781 60,197 75,101 96,314 21831 29,154 4R.266 61.797 72,705 3.79 3.784 1.350 RA 131310 14,543 11.202 25.141 14,754 16,314 225.24 83,400 Property and equipment, net Operating les Goodwill Other sets Total LIABILITIES AND STOCKHOLDERS' EQUITY Current abilities Accounts payable Accrued expenses and other Ureamed revenue Total current abilities Long term debet Other long-term abilities 20.397 10,384 25,109 11,719 34,616 16.170 192 2346 47,183 32,419 3,113 6,536 110 11499 5,017 SA 24,743 1,199 87,812 23.495 39,711 9,26 20.925 22.212 23,414 Commitments and contingencies Note 7) 12,171 5 5 5 (1.837 1 Stockholders guilty Outstanding shares - 41 and 465 Treasury stock, cont Additional paid in capital Accumulated other comprehensive loss Retained earnings 11837 33,658 13.394 17,186 21,309 26,791 1 (1,035 1723 2.545 1945) 4,916 1986 31.220 19.625 Total stockholders' uity 13.35 19,285 27,709 43.549 62,00 Total liabilities and stockholders' equity 5 65440 83,402 5 131,310 5 16248 225.248
