Finance

profilesasssssa
financial.xlsx
Home>Business & Finance homework help>Finance

WRDS

Global Company Key Data Date Data Year - Fiscal Industry Format Level of Consolidation - Company Annual Descriptor Population Source Data Format Ticker Symbol Company Name ISO Currency Code Acquired Assets - Inventory Current Assets - Total Accounts Payable - Trade Accounts Receivable/Debtors - Total Assets - Total Cash Cost of Goods Sold Total Debt Including Current Earnings Before Interest and Taxes Earnings Before Interest Interest and Related Income - Total Current Liabilities - Total Liabilities - Total Net Income (Loss) Accounts Receivable - Decrease (Increase) Sales/Turnover (Net) Stockholders Equity - Total Active/Inactive Status Marker North America Industrial Classification System - Historical Standard Industry Classification Code
8020 20151231 2015 INDL C D STD NVO NOVO NORDISK A/S USD 8023.515 716.936 13357.828 2462.494 1974.448 0 6688.008 7069.103 8.149 5947.499 6523.289 5072.538 15704.64 6834.539 A 325412 2834
8020 20161231 2016 INDL C D STD NVO NOVO NORDISK A/S USD 8482.019 853.084 13842.781 2652.495 2062.388 0 6768.897 7145.128 7.38 6732.139 7418.183 5382.334 -673.98 15863.87 6424.598 A 325412 2834
8020 20171231 2017 INDL C D STD NVO NOVO NORDISK A/S USD 9700.806 905.817 16526.73 3043.935 2333.166 0 7738.363 8252.144 7597.888 8483.361 6156.653 18034.973 8043.369 A 2834
30536 20151231 2015 INDL C D STD GEO GEO GROUP INC USD 438.346 77.523 3503.342 59.638 1363.738 2135.857 238.729 345.529 11.578 278.624 2496.505 139.438 1843.307 1006.837 A 531120 6798
30536 20161231 2016 INDL C D STD GEO GEO GROUP INC USD 697.669 79.637 3749.409 68.038 1654.897 2419.803 265.584 375.884 28.496 504.058 2774.452 148.715 2179.49 974.957 A 531120 6798
64768 20151231 2015 INDL C D STD AMZN AMAZON.COM INC USD 36474 20397 65444 15890 66751 17547 2176 7304 50 33899 52060 596 107006 13384 A 454111 5961
64768 20161231 2016 INDL C D STD AMZN AMAZON.COM INC USD 45781 25309 83402 19334 81865 20410 4066 10753 100 43816 64117 2371 135987 19285 A 454111 5961
64768 20171231 2017 INDL C D STD AMZN AMAZON.COM INC USD 60197 34616 131310 20522 100456 24743 4320 15798 202 57883 103601 3033 177866 27709 A 5961
176362 20160430 2015 INDL C D STD AVAV AEROVIRONMENT INC USD 349.703 17.712 410.393 124.287 149.529 0.449 6.128 12.201 46.345 49.133 8.966 -23.803 264.098 361.26 A 336411 3721
176362 20170430 2016 INDL C D STD AVAV AEROVIRONMENT INC USD 354.085 20.283 432.5 79.904 155.711 0.449 12.605 19.657 48.063 50.307 12.479 -13.848 264.873 382.193 A 336411 3721
Company Name : Novo Nordisk a/s Company Name : Amazon
Stock Ticker : NVO Stock Ticker : AMZN
NAICS 325412 NAICS 454111
SIC 2834 SIC 5961
Ratios 2015 2016 2017 Ratios 2015 2016 2017
Liquidity (short-term solvency) Liquidity (short-term solvency)
Current ratio 1.3490569734 1.2599292736 1.2767766516 Current ratio 1.0759609428 1.0448466314 1.0399771954
Quick ratio 1.03 0.95 0.87 Quick ratio 0.77 0.78 0.76
Long-term Solvency Long-term Solvency
Total Debt-Equity ratio 0.4883495281 0.5358882005 0.5133115262 Total Debt-Equity ratio 0.7954892733 0.7687705331 0.7889802757
Times Interest Earned 867.4810406185 968.1745257453 ERROR:#DIV/0! Times Interest Earned 146.08 107.53 78.2079207921
Cash Coverage Ratio Cash Coverage Ratio
Asset Management Asset Management
Asset Turnover 1.1756881433 1.1460031044 1.0912608241 Asset Turnover 1.635077318 1.6305004676 1.3545503008
Inventory Turnover 1.34 1.27 1.21 Inventory Turnover 7.73 8.13 8.14
Profitability Profitability
Profit Margin 0.3229961336 0.3392825332 0.341373009 Profit Margin 0.0055697811 0.0174354902 0.0170521629
Return on Assets 0.3797427246 0.3888188363 0.3725269911 Return on Assets 0.0091070228 0.0284285749 0.0230980123
Return on Equity 0.7421916826 0.8377697717 0.7654321218 Return on Equity 0.0215092569 0.3690503281 0.1094590205
Market Value Market Value
Price-Earnings 17.5 14.87 14.23 Price-Earnings 909.1 172.4 225.4
Market-to-Book Market-to-Book