Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need the following 10 financial ratios, with work shown, for the company Amazon for 2017 & 2018 Profit margin on sales operating profit margin
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started