ZuoTi.Pro
Question

12 Months Ended Consolidated Statements of Operations - USD ($) shares in Millions, $ in Millions Dec. 31, 2017 Dec. 31, 2016
F8 : x x 12 Months Ended Consolidated Statements of Operations - USD ($) shares in Millions, $ in Millions Dec. 31, 2017 Dec.
B Dec. 31, Dec. 31, $ 20,522 $ 19,334 10,4646 ,647 16,047 11,461 13,164 8,339 60,197 45,781 48,866 29,114 13,350 3,784 8,897
U DEF Dec. 31, Dec. 31, 1 $ 20,522 10,464 16,047 13,164 60,197 48,866 13,350 8,897 131,310 0 $ 19,334 0 6,647 0 11,461 0 8,33


The second and fourth pictures require percentages and formulas


In order: 1. Amazon Income Statement Horizontal, looking for just finances 2. Amazon Income Statement Vertical, looking for p


CHAPTER S. Basics of Analysis 201 EXHIBIT 5-1 Melcher Company Income Statement Illustration of Common-Sure Analysis (Vertical
CHAPTERS of Any 201 DONT 5-1 Melcher Company Incom ent of Comm u nicandal $100,000 $95.000 300 35,000 1000 11 12.00 103330 $7
business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

1.

Dec. 31, 2017 Dec. 31, 2016
Income Statement (Abstract)
Net Product Sales 118573 94665 23908 25.26% =+B4-C4 =+D4/C4
Net service sales 59293 41322 17971 43.49% =+B5-C5 =+D5/C5
Total net sales 177866 135987 41879 30.80% =+B6-C6 =+D6/C6
Operating expenses
Cost of sales 111934 88265 23669 26.82% =+B8-C8 =+D8/C8
Gross Profit 65932 47722 18210 38.16% =+B9-C9 =+D9/C9
Fulfilment 25249 17619 7630 43.31% =+B10-C10 =+D10/C10
Marketing 10069 7233 2836 39.21% =+B11-C11 =+D11/C11
Technology and content 22620 16085 6535 40.63% =+B12-C12 =+D12/C12
General and administrative 3674 2432 1242 51.07% =+B13-C13 =+D13/C13
Other operating expenses, net 214 167 47 28.14% =+B14-C14 =+D14/C14
Total Operating expenses 173760 131801 41959 31.84% =+B15-C15 =+D15/C15
Operating Income (Loss) 4106 4186 -80 -1.91% =+B16-C16 =+D16/C16
Interest Income 202 100 102 102.00% =+B17-C17 =+D17/C17
Interest Expense -848 -484 -364 75.21% =+B18-C18 =+D18/C18
Other Income (Expenses) 346 90 256 284.44% =+B19-C19 =+D19/C19
Total Non Operating Income (Expense) -300 -294 -6 2.04% =+B20-C20 =+D20/C20
Income before income taxes 3806 3892 -86 -2.21% =+B21-C21 =+D21/C21
Provision for income tax -769 -1425 656 -46.04% =+B22-C22 =+D22/C22
Equity Method Investment activity, net of tax -4 -96 92 -95.83% =+B23-C23 =+D23/C23
Net Income 3033 2371 662 27.92% =+B24-C24 =+D24/C24

2.

Dec. 31, 2017 Dec. 31, 2016
Income Statement (Abstract)
Net Product Sales 118573 66.66% =+B4/$B$6 94665 69.61% =+E4/$E$6
Net service sales 59293 33.34% =+B5/$B$6 41322 30.39% =+E5/$E$6
Total net sales 177866 100.00% =+B6/$B$6 135987 100.00% =+E6/$E$6
Operating expenses
Cost of sales 111934 62.93% =+B8/$B$6 88265 64.91% =+E8/$E$6
Gross Profit 65932 37.07% =+B9/$B$6 47722 35.09% =+E9/$E$6
Fulfilment 25249 14.20% =+B10/$B$6 17619 12.96% =+E10/$E$6
Marketing 10069 5.66% =+B11/$B$6 7233 5.32% =+E11/$E$6
Technology and content 22620 12.72% =+B12/$B$6 16085 11.83% =+E12/$E$6
General and administrative 3674 2.07% =+B13/$B$6 2432 1.79% =+E13/$E$6
Other operating expenses, net 214 0.12% =+B14/$B$6 167 0.12% =+E14/$E$6
Total Operating expenses 173760 97.69% =+B15/$B$6 131801 96.92% =+E15/$E$6
Operating Income (Loss) 4106 2.31% =+B16/$B$6 4186 3.08% =+E16/$E$6
Interest Income 202 0.11% =+B17/$B$6 100 0.07% =+E17/$E$6
Interest Expense -848 -0.48% =+B18/$B$6 -484 -0.36% =+E18/$E$6
Other Income (Expenses) 346 0.19% =+B19/$B$6 90 0.07% =+E19/$E$6
Total Non Operating Income (Expense) -300 -0.17% =+B20/$B$6 -294 -0.22% =+E20/$E$6
Income before income taxes 3806 2.14% =+B21/$B$6 3892 2.86% =+E21/$E$6
Provision for income tax -769 -0.43% =+B22/$B$6 -1425 -1.05% =+E22/$E$6
Equity Method Investment activity, net of tax -4 0.00% =+B23/$B$6 -96 -0.07% =+E23/$E$6
Net Income 3033 1.71% =+B24/$B$6 2371 1.74% =+E24/$E$6

3.

Balance Sheet Dec. 31, 2017 Dec. 31, 2016
Current Assets
Cash and Cash Equivalents 20522 19334 1188 6.14% =+B3-C3 =+D3/C3
Marketable Securities 10464 6647 3817 57.42% =+B4-C4 =+D4/C4
Inventories 16047 11461 4586 40.01% =+B5-C5 =+D5/C5
Accounts Receivable, net and other 13164 8339 4825 57.86% =+B6-C6 =+D6/C6
Total Current Assets 60197 45781 14416 31.49% =+B7-C7 =+D7/C7
Property and Equipment 48866 29114 19752 67.84% =+B8-C8 =+D8/C8
Goodwill 13350 3784 9566 252.80% =+B9-C9 =+D9/C9
Other Assets 8897 4723 4174 88.38% =+B10-C10 =+D10/C10
Total Assets 131310 83402 47908 57.44% =+B11-C11 =+D11/C11
Current Liabilities
Accounts Payable 34616 25309 9307 36.77% =+B13-C13 =+D13/C13
Accrued Liabilities & Other 18170 13739 4431 32.25% =+B14-C14 =+D14/C14
Unearned Revenue 5097 4768 329 6.90% =+B15-C15 =+D15/C15
Total Current Liabilities 57883 43816 14067 32.10% =+B16-C16 =+D16/C16
Long term Debt 24743 7694 17049 221.59% =+B17-C17 =+D17/C17
Other long term liabilities 20975 12607 8368 66.38% =+B18-C18 =+D18/C18
Commitments and Contingencies
Stockholders Equity
Preferred Stock 0 0
Common Stock 5 5
Treasury Stock -1837 -1837
Additional Paid in capital 21389 17186 4203 24.46% =+B24-C24 =+D24/C24
Accumulated Loss -484 -985 501 -50.86% =+B25-C25 =+D25/C25
Retained Earnings 8636 4916 3720 75.67% =+B26-C26 =+D26/C26
Total Stockholders Equity 27709 19285 8424 43.68% =+B27-C27 =+D27/C27
Total Liabilities & Stockholders Equity 131310 83402 47908 57.44% =+B28-C28 =+D28/C28

4.

Balance Sheet Dec. 31, 2017 Dec. 31, 2016
Current Assets
Cash and Cash Equivalents 20522 15.63% =+B3/$B$11 19334 23.18% =+E3/$E$11
Marketable Securities 10464 7.97% =+B4/$B$11 6647 7.97% =+E4/$E$11
Inventories 16047 12.22% =+B5/$B$11 11461 13.74% =+E5/$E$11
Accounts Receivable, net and other 13164 10.03% =+B6/$B$11 8339 10.00% =+E6/$E$11
Total Current Assets 60197 45.84% =+B7/$B$11 45781 54.89% =+E7/$E$11
Property and Equipment 48866 37.21% =+B8/$B$11 29114 34.91% =+E8/$E$11
Goodwill 13350 10.17% =+B9/$B$11 3784 4.54% =+E9/$E$11
Other Assets 8897 6.78% =+B10/$B$11 4723 5.66% =+E10/$E$11
Total Assets 131310 100.00% =+B11/$B$11 83402 100.00% =+E11/$E$11
Current Liabilities
Accounts Payable 34616 26.36% =+B13/$B$11 25309 30.35% =+E13/$E$11
Accrued Liabilities & Other 18170 13.84% =+B14/$B$11 13739 16.47% =+E14/$E$11
Unearned Revenue 5097 3.88% =+B15/$B$11 4768 5.72% =+E15/$E$11
Total Current Liabilities 57883 44.08% =+B16/$B$11 43816 52.54% =+E16/$E$11
Long term Debt 24743 18.84% =+B17/$B$11 7694 9.23% =+E17/$E$11
Other long term liabilities 20975 15.97% =+B18/$B$11 12607 15.12% =+E18/$E$11
Commitments and Contingencies
Stockholders Equity
Preferred Stock 0 0.00% =+B21/$B$11 0 0.00% =+E21/$E$11
Common Stock 5 0.00% =+B22/$B$11 5 0.01% =+E22/$E$11
Treasury Stock -1837 -1.40% =+B23/$B$11 -1837 -2.20% =+E23/$E$11
Additional Paid in capital 21389 16.29% =+B24/$B$11 17186 20.61% =+E24/$E$11
Accumulated Loss -484 -0.37% =+B25/$B$11 -985 -1.18% =+E25/$E$11
Retained Earnings 8636 6.58% =+B26/$B$11 4916 5.89% =+E26/$E$11
Total Stockholders Equity 27709 21.10% =+B27/$B$11 19285 23.12% =+E27/$E$11
Total Liabilities & Stockholders Equity 131310 100.00% =+B28/$B$11 83402 100.00% =+E28/$E$11

As per HOMEWORKLIB RULES, i have solved one question in complete. kindly post other question separately

0 0
Add a comment
Know the answer?
Add Answer to:
12 Months Ended Consolidated Statements of Operations - USD ($) shares in Millions, $ in Millions...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Amazon Financial Statement Consolidated Statements Of Operations - USD ($) shares in Millions, $ in Millions...

    Amazon Financial Statement Consolidated Statements Of Operations - USD ($) shares in Millions, $ in Millions 12 Months Ended Consolidated Balance Sheets - USD ($) $ in Millions Dec. 31, 2018 Dec. 31, 2017 Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended Dec. 31, 2018 Dec. 31, 2017 Dec. 31, 2016 Current assets: Dec. 31, 2018 Dec. 31, 2017 Dec. 31, 2016 Total net sales $ 232,887 $ 177,866 $ 135,987 Cash and cash...

  • 12 Months Ended Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions...

    12 Months Ended Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions Jan. 31, 2018 Jan. 31, 2017 99.08% 0 $ 495,761 4,582 500,343 $ 481,317 4,556 485,873 99.06% 0.94% 0 373,396 106,510 0 o 361,256 101,853 20,437 22,764 3 Revenues: 4 Net sales 5 Membership and other income 6 Total revenues 7 Costs and expenses: 8 Cost of sales Operating, selling, general and administrative 9 expenses 10 Operating income 11 Interest: 12 Debt 13 Capital...

  • 12 Months Ended Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions...

    12 Months Ended Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions Jan. 31, 2018 Jan. 31, 2017 $495,761 4,582 500,343 0 0 $481,317 4 ,556 0 485,873 373,396 106,510 0 o 361,256 101,853 20,437 22,764 Revenues: Net sales Membership and other income Total revenues Costs and expenses: Cost of sales Operating, selling, general and administrative expenses 0 Operating income 1 Interest: 2 Debt 3 Capital lease and financing obligations 4 Interest income 5 Interest, net...

  • 12 Months Ended Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions...

    12 Months Ended Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions Jan. 31, 2018 Jan. 31, 2017 $ 495,761 4,582 500,343 0 $ 481,317 0 4,556 0 485,873 373,396 106,510 0 0 361,256 101,853 20,437 o 22,764 3Revenues: Net sales 5 Membership and other income 5 Total revenues Costs and expenses: Cost of sales Operating, selling, general and administrative expenses 10 Operating income 11 Interest: -2 Debt 3 Capital lease and financing obligations 4 Interest...

  • 12 Months Ended Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions...

    12 Months Ended Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions Jan. 31, Jan. 31, You Must Use Excel Formulas in Yellow Boxes 2018 2017 Revenues: Horizontal Horizontal Dollar Value Percent $495,761 $481,317 Net sales Membership and other income 4,582 4,556 Total revenues 500,343 485,873 Costs and expenses: Cost of sales Gross Profit Operating, selling, general and 373,396 361,256 126,947 124,617 106,510 101,853 administrative expenses 20,437 22,764 Operating income Interest: Debt Capital lease and financing...

  • How we can calculate PP&E from the following balance sheet? Please explain with data provided on...

    How we can calculate PP&E from the following balance sheet? Please explain with data provided on the balance sheet. AMAZON.COM, INC. CONSOLIDATED BALANCE SHEETS (in millions, except per share data) December 31, 2016 2017 19,334 $ 6,647 11,461 8,339 45,781 29,114 3,784 4,723 83,402 $ 20,522 10,464 16,047 13,164 60,197 48,866 13,350 8,897 131,310 $ ASSETS Current assets: Cash and cash equivalents Marketable securities Inventories Accounts receivable, net and other Total current assets Property and equipment, net Goodwill Other assets...

  • The following financial information is available for International Technologies, Inc.: Consolidated Statements of Ops (USD $)...

    The following financial information is available for International Technologies, Inc.: Consolidated Statements of Ops (USD $) In Thousands Dec. 27, 2014 Dec. 28, 2013 Dec. 29, 2012 NET SALES $1,097,788 $929,810 $719,204 Cost of sales $839,946 $698,771 $542,700 GROSS PROFIT $257,842 $231,039 $176,504 Selling and administrative expenses $251,591 $205,797 $171,420 Other operating expense, net $2,441 $1,334 $184 Facility consolidation expenses $14,888 $0 $0 Impairment of assets $3,059 $0 $0 OPERATING INCOME (LOSS) ($14,137) $23,909 $4,901 Interest expense $11,615 $10,141 $8,494...

  • INCOME STATEMENTS - USD (5) 12 Months Ended shares in Million, 5 in Millione Jun 2020...

    INCOME STATEMENTS - USD (5) 12 Months Ended shares in Million, 5 in Millione Jun 2020 Jun 30, 2019 Jun 30, 2018 Raven 5140.015 $125 13 51500 Costafree 8095 42.910 38.353 Grossman 98937 82.933 72.007 Research and development 192 18818 14720 16213 17 400 General and native 5.111 4754 Operating income One income nel 77 1416 Income before income 50.00 43.688 414 Provision for income taxes 8.755 48 19.03 144281 39920 N $9.51 Earnings per shares 55.12 55.11 5215 3578...

  • Pepsi Consolidated Statement of Cash Flows - USD ($) $ in Millions 12 Months Ended Dec....

    Pepsi Consolidated Statement of Cash Flows - USD ($) $ in Millions 12 Months Ended Dec. 29, 2018 Dec. 30, 2017 Dec. 31, 2016 Operating Activities Net Income (Loss), Including Portion Attributable to Noncontrolling Interest $ 12,559 $ 4,908 $ 6,379 Depreciation and amortization 2,399 2,369 2,368 Share-based compensation expense 256 292 284 Restructuring and impairment charges 308 295 160 Cash payments for restructuring charges (255) (113) (125) Charge related to the transaction with Tingyi 0 0 373 Pension and...

  • Consolidated Statements of Income- USD (S) $ in Thousands 3 Months Ended 6 Months Ended Jun....

    Consolidated Statements of Income- USD (S) $ in Thousands 3 Months Ended 6 Months Ended Jun. 30, 2018 Jun. 30, 2017 2018 2017 REVENUES 103,219 $ s $91,599 5,728 $159,893 11,534 ees 179,917 Initial franchise and relicensing fees Procurement services Marketing and reservation 6,481 12,695 17,833 14,372 157,347 140,477 27,771 21,735 239,330 264,348 10,561 20,104 17,392 Total revenues OPERATING EXPENSES Selling, general and administrative Depreciation and Marketing and reservation 295,441 261,016 46,270 44,038 1,659 504,835 87,134 6,722 449,884 $54,951 77,783...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT