View the "Fin 320 - Excel 1" attachment and answer thetwo questions on"Fin Written Assignment" about the Fin 320 - Excel 1 attachment.

I will give a good tip at the end.

AMAZON.COM, INC. CONSOLIDATED STATEMENTS OF OPERATIONS (in millions, except per share data) (slightly modified) Year Ended December 31, 2015 Net product sales Net service sales Total net sales Operating expenses: Cost of sales Fulfillment Marketing Technology and content General and administrative Other operating expense, net Total operating expenses Operating income Interest income Interest expense Other income (expense), net Total non-operating income (expense) Income (loss) before income taxes Provision for income taxes Equity-method investment activity, net of tax Net income (loss) 79268 27738 107006 71651 13410 5254 12540 1747 171 104773 2233 50 (459) (256) (665) 1568 (950) (22) 596 References : FORM 10-K Amazon-Item 8 Consolidated Statements of Comprehensive Income (Loss) https://www.sec.gov/Archives/edgar/data/1018724/000101872416000172/amzn-20151231x10k.htm#s72E3776A647627199433ABB21290C044 ) 47627199433ABB21290C044 AMAZON.COM, INC. CONSOLIDATED BALANCE SHEETS (in millions, except per share data) (slightly modified) December 31,2015 ASSETS Current assets: Cash and cash equivalents 15890 Marketable securities 3918 Inventories 10243 Accounts receivable, net and other 6423 Total current assets 36474 Property and equipment, net 21838 Goodwill 3759 Other assets 3373 Total assets 65444 LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable 20397 Accrued expenses and other 10384 Unearned revenue 3118 Total current liabilities 33899 Long-term debt 8235 Other long-term liabilities 9926 Commitments and contingencies (Note 7) Stockholders' equity: Preferred stock, $0.01 par value: Issued and outstanding shares none Common stock, $0.01 par value: Authorized shares 5,000 Issued shares 494 and 500 Outstanding shares 471 and 477 Treasury stock, at cost Additional paid-in capital Accumulated other comprehensive loss Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 5 (1837) 13394 (723) 2545 13384 65444 References : FORM 10-K Amazon-Item 8 Consolidated Balance Sheets https://www.sec.gov/Archives/edgar/data/1018724/000101872416000172/amzn-20151231x10k.htm#sBBA2585445624EC7F128ABB211D2FD8A AMAZON.COM, INC. CONSOLIDATED STATEMENTS OF CASH FLOWS Year Ended December 31, 2015 (in millions) CASH AND CASH EQUIVALENTS, BEGINNING OF PERIOD OPERATING ACTIVITIES: Net income (loss) Adjustments to reconcile net income (loss) to net cash from operating activities. Depreciation of property and equipment, including internal-use software and website development, and other amortization, including capitalized content costs Stock-based compensation Other operating expense (income), net Losses (gains) on sales of marketable securities, net Other expense (income), net Deferred income taxes Excess tax benefits from stock-based compensation Changes in operating assets and liabilities: Inventories Accounts receivable net and othe Accounts payable Accrued expenses and other Additions to unearned revenue Additions to unearned revenue Net cash provided by (used in) operating activities INVESTING ACTIVITIES: Purchases of property and equipment, including internal-use software and website development, net Acquisitions. net of cash acquired. and other Sales and maturities of marketable senuities Purchases of marketable securities Net cash provided by (used in) investing activities FINANCING ACTIVITIES: Excess tax benefits from suck-based compensation Proceeds from long-tern debt and othe Repayments of long-tem debt and other Principal repayments of capital lease obligations Principal repayments of finance lease obligations Net cash provided by (used in) financing activities Foreign-currency effect on cash and cash equivalents Net increase (decrease) in cash and cash equivalents CASH AND CASH EQUIVALENTS, END OF PERIOD SUPPLEMENTAL CASH FLOW INFORMATION: Cash paid for interest on long-texadebt Cash paid for interest on capital and finance lease obligations Cash paid for income taxes (net ofrefimds) Property and equipment acquired under capital leases Property and equipment acquired under build-to-suit leases References : FORM 10-K Amazon-Item 8 Consolidated Statements of Cash Flows https://www.sec.gov/Archives/edgar/data/1018724/000101872416000172/amzn-20151231x10k.htm#s3AEEDED19187D1 14,557 596 6,281 2119. 155 5 245 81 (119) (2,187) (1,755) 4294 913 7,401 (6,109) 11,920 (4,589) (795) 3,025 (4,091) (6,450) 119 353 (1,652) (2,462) (121) (3,763) (374) 1,333 15,890 325 153 273 4,717 544 htm#s3AEEDED19187D11AC542ABB20E896DC9 Historical Stock Price And Return Close Rate Of return in % Base 28-Mar-17 856 -1.07 27-Mar-17 846.82 -0.14 24-Mar-17 845.61 0.21 23-Mar-17 847.38 0.08 22-Mar-17 848.06 -0.57 21-Mar-17 843.2 1.63 20-Mar-17 856.97 -0.54 17-Mar-17 852.31 Date References : :Amazon.com, Inc. Common Stock Historical Stock Prices http://www.nasdaq.com/symbol/amzn/historical Current Ratio Debt Equity Ratio Free Cash flow Earnning Per Share Price /Earnning Ratio Return on Equity Net Profit Margin Ratio Price of Share on31/03/2015 References : :Amazon.com, Inc. Com Current/Current Liabilities Debt / Equity (Net cash provided by (used in) operating activities) - (Purchases of property and equipment, including internal-use software and website development, ne)t Net income/Weighted average no of share Price of share*/EPS Net Income/shareholder equity Net Income/Net Sales 675.89 http://www.nasdaq.com/symbol/amzn/historical 1.08 3.89 $ 7,331.00 in Million 1.28 529.60 4.5% 0.56% 3. written Responses Using the Write Submission area of Blackboard for this part otthe assignment, respond to the following: 0 Describe how and why each of the ratios has changed overthe threeyear period. For example. did the current ratio increase or decrease? Why? 0 Describe how three of the ratios you calculated for your company compare to the general industry. Find general industry data by entering your specific compa ny's ticker symbol here. ifyou are not familiar with the Write Submission feature, see the screen shot below. Southern N ew Hampsllai University mmemMMMIwwmmmulm Click 'Wi'ta Submission" and input your rascal-lass to Part 3 anti: assiunmanL a:.::.'.'::::*"\" d-'-\"-\" F\" AMCh your corrptotod Excel le by picking the "Browse My Computer button. 4. Professionalism, References, and Mechanics Format the data on all worksheetsso that the file has a neat and professional appearance. Include links and properly formatted citations referencing the location of the data used. Yourwritten responses should be free of errors in organization, gram marI and style. Guidelines for Submnclon: Submit an Excel le that meets the criteria described in the prompt. The written responses should be done in the Write Submission area of Blackboard. Citations should be formatted according to APA style