Please help with vertical analysis for the following income statement & statement of cash flows. Do the analysis in Excel if you can. Thank you very much.
MICROSOFT CORPORATION INCOME STATEMENTS Years Ended June 30, (in millions, except per share amounts) Revenue Product Service and other Total revenue Cost of revenue Product Service and other Total cost of revenue Gross margin Research and development Sales and marketing General and administrative Impairment and restructuring Operating income Other income (expense), net Income before income taxes Provision for (benefit from) income taxes Net income Earnings per share: Basic Diluted Weighted average shares outstanding: Basic Diluted 2017 $57,190 32,760 89,950 15,175 19,086 34,261 55,689 13,037 15,539 4,481 306 22,326 823 23,149 1,945 $21,204 $2.74 $2.71 7,746 7,832 Cash dividends declared per common share $1.56 COMPREHENSIVE INCOME STATEMENTS (in millions) Years Ended June 30, Net income $ Other comprehensive income (loss): Net unrealized gains (losses) on derivatives (net of tax effects of $(5), $(12), and $20) Net unrealized losses on investments (net of tax effects of $(613), $(121), and $(197)) Translation adjustments and other (net of tax effects of $9, $(33), and $16) Other comprehensive loss Comprehensive income $ 2017 21,204 (218) (1,116) 228 (1,106) 20,098 RPORATION EMENTS 2016 2015 $61,502 23,818 85,320 $75,956 17,624 93,580 17,880 14,900 32,780 52,540 11,988 14,697 4,563 1,110 20,182 (431) 19,751 2,953 $16,798 21,410 11,628 33,038 60,542 12,046 15,713 4,611 10,011 18,161 346 18,507 6,314 $12,193 $2.12 $2.10 $1.49 $1.48 7,925 8,013 8,177 8,254 $1.44 $1.24 OME STATEMENTS 2016 $ $ 2015 16,798 $ 12,193 (238) 559 (228) (362) (519) (985) (1,383) (1,186) 15,813 $ 11,007 MICROSOFT CORPORATION CASH FLOWS STATEMENTS Years Ended June 30, (In millions) Operations Net income $ Adjustments to reconcile net income to net cash from operations: Goodwill and asset impairments Depreciation, amortization, and other Stock-based compensation expense Net recognized gains on investments and derivatives Deferred income taxes Deferral of unearned revenue Recognition of unearned revenue Changes in operating assets and liabilities: Accounts receivable Inventories Other current assets Other long-term assets Accounts payable Other current liabilities Other long-term liabilities Net cash from operations Financing Proceeds from issuance (repayments) of short-term debt, maturities of 90 days or less, net Proceeds from issuance of debt Repayments of debt Common stock issued Common stock repurchased Common stock cash dividends paid Other, net Net cash from (used in) financing Investing Additions to property and equipment Acquisition of companies, net of cash acquired, and 2017 21,204 0 8,778 3,266 (2,073) (3,296) 67,711 (57,735) (925) 50 1,066 (539) 81 386 1,533 39,507 (4,963) 44,344 (7,922) 772 (11,788) (11,845) (190) 8,408 (8,129) purchases of intangible and other assets Purchases of investments Maturities of investments Sales of investments Securities lending payable (25,944) (176,905) 28,044 136,350 (197) Net cash used in investing (46,781) Effect of foreign exchange rates on cash and cash equivalents 19 Net change in cash and cash equivalents Cash and cash equivalents, beginning of period Cash and cash equivalents, end of period 1,153 6,510 $ 7,663 RPORATION ATEMENTS 2016 $ 16,798 $ 2015 12,193 630 6,622 2,668 (223) 332 57,072 (48,498) 7,498 5,957 2,574 (443) 224 45,072 (44,920) (530) 600 (1,167) (41) 88 (260) (766) 1,456 (272) 62 346 (1,054) (624) 1,599 33,325 29,668 7,195 13,884 (2,796) 668 (15,969) (11,006) (369) 4,481 10,680 (1,500) 634 (14,443) (9,882) 362 (8,393) (9,668) (8,343) (5,944) $ (1,393) (129,758) 22,054 93,287 203 (3,723) (98,729) 15,013 70,848 (466) (23,950) (23,001) (67) (73) 915 5,595 (3,074) 8,669 6,510 $ 5,595