Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, please complete and add on to the Excel project attached below. The instructions are on the Fin document. The company is Amazon . Thank
Hi, please complete and add on to the Excel project attached below. The instructions are on the "Fin" document. The company is Amazon.
Thank you.
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% 1. Financial Data Using the same company you selected in Module Three, add another two years offinancial statement data so that you have three years of annual data to review for historical analysis. In allI your Excel file must include the following: 0 Three worksheels of annual balance sheet data 0 Three worksheels of annual income statement data a Three worksheels of annual statement of cash flow data Important Note: Be sure to label each worksheet in Excel with the appropriate year, as you did in the Module Three assignmentStep 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