excel sheet 1

excel sheet 2

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): 1. Profit Margin 2. Operating Profit over Revenue 3. Current ratio Return on Total Assets Present the above ratios in a TABLE and explain what your conclusions on the Amazon's recent performance are. Income Statement Balance Sheet 3090 2011 2010 2018 ws 79.25 04.665 118573 141.915 160.41 27.738 41,322 CAZOS 90.972 120,1 som 107.000 135.987 177 60 232.857 280.5: expenses 71,651 13410 5.254 32,265 17619 7,233 139,156 34.027 111.934 25.249 22.620 10.00 165.5 40.2: 35.9 and content 28.837 13.114 12.540 16.005 CUS Id administrative 1,747 2.432 3674 4393 52 ng expense 171 214 200 21 ting expenses 104.723 131,001 17370 220.450 2050 143 Income ome pense OS 4.100 202 4) 100 (484 1450 440 (1417) (1.61 me experient 1250 90 340 21 wering come (294 000 ( 10 11 3892 3.000 13.98 fore income taxes income 1950) (1425) (9) home city, (22) 14 . 2.371 3.03) 10.073 11 SE ings per share 1.28 105 S 6.32 5 EZ 1.251 49 5 6.15 20.14 234 werage shares in no carings per 457 474 480 487 4 493 500 Income Statement Balance Sheet 2018 3017 2018 2011 ASSETS Current assets Cash and cash equivalent 15.00 5 19.334 20522 31.750 3918 500 Marketable securities Inventories Accounts receivable, net and other 6647 11.461 10464 16 047 10.245 17,174 6.423 8.339 12164 15,677 Total current 44 45.783 60,197 75 101 Property and equipment.net 21.898 29.114 4 A6 61.797 Operating ses 14,548 Goodwill Other 3.759 3373 3.784 4723 BAUT 11.202 65.444 83.4021 1313101 162.640 2007 10.354 25.300 13.730 Totes LIABILITIES AND STOCKHOLDERS EQUITY Current Notes Accounts payable Accrued experts and other Uneared revenue Total current Long-term de Onering formatii 34,616 18.170 38,192 23,000 3.118 4.760 3.097 0.336 43.810 33.00 235 2:26 7.0 12.01 57.100 2014 20.575 6.31 2340 27213 Commitments and contingencies (7) Outstanding thes-471 ans 465 Treasury stock at cost Additional paid in 11.837 (1.837 11,837 1 13394 17.186 21,389 26.701 33 (723 005) (484 11.08 ) Accumulated other comprehensive Retained amongs 2.545 4.910 10.605 31. Total sector quity 13,384 10.285 27.700 43.540 62 Total abilities and stockholders equity 65.444 83,402 1313101 162.640