BUSI 352 MICROSOFT EXCEL HW

Homework1GoogleInc.xlsx

Home >Business & Finance homework help >Accounting homework help >BUSI 352 MICROSOFT EXCEL HW

INCOME STATEMENT

ALPHABET INC A (GOOGL) CashFlowFlag INCOME STATEMENT
		NORMAL INCOME STATEMENT					COMMON SIZE INCOME STATEMENT
Fiscal year ends in December. USD in millions except per share data.	2013	2014	2015	2016	2017	2013	2014	2015	2016	2017
Revenue	59825	66001	74989	90272	110855	100.00%	100.00%	100.00%	100.00%	100.00%
Cost of revenue	25858	25691	28164	35138	45583	43.22%	38.93%	37.56%	38.92%	41.12%
Gross profit	33967	40310	46825	55134	65272	56.78%	61.07%	62.44%	61.08%	58.88%
Operating expenses
Research and development	7952	9832	12282	13948	16625	13.29%	14.90%	16.38%	15.45%	15.00%
Sales, General and administrative	12049	13982	15183	17470	19765	20.14%	21.18%	20.25%	19.35%	17.83%
Total operating expenses	20001	23814	27465	31418	36390	33.43%	36.08%	36.63%	34.80%	32.83%
Operating income	13966	16496	19360	23716	28882	23.34%	24.99%	25.82%	26.27%	26.05%
Interest Expense	83	101	104	124	109	0.14%	0.15%	0.14%	0.14%	0.10%
Other income (expense)	613	864	395	558	-1580	1.02%	1.31%	0.53%	0.62%	-1.43%
Income before taxes	14496	17259	19651	24150	27193	24.23%	26.15%	26.21%	26.75%	24.53%
Provision for income taxes	2282	3331	3303	4672	14531	3.81%	5.05%	4.40%	5.18%	13.11%
Net income from continuing operations	12214	13928	16348	19478	12662	20.42%	21.10%	21.80%	21.58%	11.42%
Net income from discontinuing ops	706	516				1.18%	0.78%
Net income	12920	14444	16348	19478	12662	21.60%	21.88%	21.80%	21.58%	11.42%
Preferred dividend			522					0.70%
Net income available to common shareholders	12920	14444	15826	19478	12662	21.60%	21.88%	21.10%	21.58%	11.42%
Earnings per share
Basic	19.43	21.37	23.11	28.32	18.27	19.43	21.37	23.11	28.32	18.27
Diluted	19.08	21.02	22.84	27.85	18	19.08	21.02	22.84	27.85	18
Weighted average shares outstanding
Basic	665	676	685	688	693	665	676	685	688	693
Diluted	677	687	693	699	704	677	687	693	699	704
EBITDA	18518	22339	24818	30418	34217	30.95%	33.85%	33.10%	33.70%	30.87%

BALANCE SHEET

ALPHABET INC A (GOOGL) CashFlowFlag BALANCE SHEET
		NORMAL BALANCE SHEET					COMMON SIZE BALANCE SHEET
Fiscal year ends in December. USD in millions except per share data.	2013-12	2014-12	2015-12	2016-12	2017-12	2013	2014	2015	2017	2017
Assets
Current assets
Cash
Cash and cash equivalents	18898	18347	16549	12918	10715	17.04%	13.99%	11.22%	7.71%	5.43%
Short-term investments	39819	46048	56517	73415	91156	35.90%	35.12%	38.33%	43.83%	46.20%
Total cash	58717	64395	73066	86333	101871	52.94%	49.11%	49.55%	51.54%	51.63%
Receivables	8882	9383	11556	14137	18336	8.01%	7.16%	7.84%	8.44%	9.29%
Inventories	426			268	749	0.38%			0.16%	0.38%
Deferred income taxes	1526	1322				1.38%	1.01%
Prepaid expenses	2827	3412	3139	4575		2.55%	2.60%	2.13%	2.73%
Other current assets	508	2173	2353	95	3352	0.46%	1.66%	1.60%	0.06%	1.70%
Total current assets	72886	80685	90114	105408	124308	65.71%	61.53%	61.11%	62.93%	63.01%
Non-current assets
Property, plant and equipment
Gross property, plant and equipment	23837	32746	40146	47527	59647	21.49%	24.97%	27.22%	28.37%	30.23%
Accumulated Depreciation	-7313	-8863	-11130	-13293	-17264	-6.59%	-6.76%	-7.55%	-7.94%	-8.75%
Net property, plant and equipment	16524	23883	29016	34234	42383	14.90%	18.21%	19.68%	20.44%	21.48%
Equity and other investments	1976	3079	5183	5878	7813	1.78%	2.35%	3.51%	3.51%	3.96%
Goodwill	11492	15599	15869	16468	16747	10.36%	11.90%	10.76%	9.83%	8.49%
Intangible assets	6066	4607	3847	3307	2692	5.47%	3.51%	2.61%	1.97%	1.36%
Deferred income taxes			251	383	680			0.17%	0.23%	0.34%
Other long-term assets	1976	3280	3181	1819	2672	1.78%	2.50%	2.16%	1.09%	1.35%
Total non-current assets	38034	50448	57347	62089	72987	34.29%	38.47%	38.89%	37.07%	36.99%
Total assets	110920	131133	147461	167497	197295	100.00%	100.00%	100.00%	100.00%	100.00%
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt	3000	1999	3000			2.70%	1.52%	2.03%
Capital leases	9	10	225			0.01%	0.01%	0.15%
Accounts payable	2453	1715	1931	2041	3137	2.21%	1.31%	1.31%	1.22%	1.59%
Taxes payable	24	96	302	554	881	0.02%	0.07%	0.20%	0.33%	0.45%
Accrued liabilities	5484	6386	7097	4198	5464	4.94%	4.87%	4.81%	2.51%	2.77%
Deferred revenues	1062	752	788	1099	1432	0.96%	0.57%	0.53%	0.66%	0.73%
Other current liabilities	3876	5847	5967	8864	13269	3.49%	4.46%	4.05%	5.29%	6.73%
Total current liabilities	15908	16805	19310	16756	24183	14.34%	12.82%	13.09%	10.00%	12.26%
Non-current liabilities
Long-term debt	1990	2992	1995	3935	3943	1.79%	2.28%	1.35%	2.35%	2.00%
Capital leases	246	236			26	0.22%	0.18%			0.01%
Deferred taxes liabilities	1947	1971	189	226	430	1.76%	1.50%	0.13%	0.13%	0.22%
Deferred revenues	139	104	151	202	340	0.13%	0.08%	0.10%	0.12%	0.17%
Other long-term liabilities	3381	4525	5485	7342	15871	3.05%	3.45%	3.72%	4.38%	8.04%
Total non-current liabilities	7703	9828	7820	11705	20610	6.94%	7.49%	5.30%	6.99%	10.45%
Total liabilities	23611	26633	27130	28461	44793	21.29%	20.31%	18.40%	16.99%	22.70%
Stockholders' equity
Common stock	25922	28767	32982	36307	40247	23.37%	21.94%	22.37%	21.68%	20.40%
Retained earnings	61262	75706	89223	105131	113247	55.23%	57.73%	60.51%	62.77%	57.40%
Accumulated other comprehensive income	125	27	-1874	-2402	-992	0.11%	0.02%	-1.27%	-1.43%	-0.50%
Total stockholders' equity	87309	104500	120331	139036	152502	78.71%	79.69%	81.60%	83.01%	77.30%
Total liabilities and stockholders' equity	110920	131133	147461	167497	197295	100.00%	100.00%	100.00%	100.00%	100.00%

CASH FLOW AND FOOTNOTES

ALPHABET INC A (GOOGL) Statement of CASH FLOW
Fiscal year ends in December. USD in millions except per share data.	2015	2016	2017
Cash Flows From Operating Activities
Net income	16348	19478	12662
Depreciation & amortization	5063	6144	6915
Investments losses (gains)	334	275	194
Deferred income taxes	-179	-38	258
Stock based compensation	5203	6703	7679
Change in working capital	-409	3300	9246
Accounts receivable	-2094	-2578	-3768
Inventory
Prepaid expenses	-318	312
Accounts payable	203	110	731
Accrued liabilities	1936	2108	5846
Other working capital	-136	3348	6437
Other non-cash items	-336	174	137
Net cash provided by operating activities	26024	36036	37091
Cash Flows From Investing Activities
Investments in property, plant, and equipment	-9915	-10212	-13184
Property, plant, and equipment reductions		240	99
Acquisitions, net
Purchases of investments	-76540	-85618	-93940
Sales/Maturities of investments	63330	67839	74492
Purchases of intangibles	-236	-986	-287
Other investing activities	-350	-2428	1419
Net cash used for investing activities	-23711	-31165	-31401
Cash Flows From Financing Activities
Debt issued	13705	8729	4291
Debt repayment	-13728	-10064	-4377
Common stock issued			800
Common stock repurchased	-1780	-3693	-4846
Excess tax benefit from stock based compensation	548
Other financing activities	-2422	-3304	-4166
Net cash provided by (used for) financing activities	-3677	-8332	-8298
Effect of exchange rate changes	-434	-170	405
Net change in cash	-1798	-3631	-2203
Cash at beginning of period	18347	16549	12918
Cash at end of period	16549	12918	10715
Free Cash Flow
Operating cash flow	26024	36036	37091
Capital expenditure	-10151	-11198	-13471
Free cash flow	15873	24838	23620
RETAINED EARNINGS	89233	105131	113247

ACCOUNTING FOOTNOTES

			ALPHABET INC A (GOOGL) ACCOUNTING FOOTNOTES
	The income of the organization was on the upward trend between 2015 and 2016 but experienced a decrease in 2017. The depreciation and amortization, stock-based compensation and deferred income taxes of the firm has been on the increase for the three years. Accounts receivable and accounts payable for the period increased throughout the three years. The accrued liabilities of the organization of the organization have also increased over the same period. The net cash provided by the operating activities rose from $26,024 in 2015 up to $ 37,091 in 2017 (Alphabet Inc., 2019).
	The second item that is included in the cash flow is the net cash used for investing activities (Fraser, Ormiston & Fraser, 2010). The net cash has the different item that changed within the course of the period. Investments in property, plant, and equipment, Maturities of investments and Purchases of investments increased in the period between 2015 and 2017. Purchases of intangibles and other investing activities have reduced from the year 2015 to the year 2017. The changes led to the increase in the net cash used for investment from $23,711 in 2015 to $31,401 in 2017.
	The last item in the cash flow is the Net cash provided used for financing activities (Fraser, Ormiston & Fraser, 2010). The net cash provided for investment was affected by the changes in the exchange rates. The net cash provided used for financing activities increased from $3,677 in 2015 to $8,332 in 2016 but decreased in 2017 up to $8,289. The free cash flow increased from $15,873in 2015 to $24,838 in 2016 but decreased in 2017 up to $23,620 (Alphabet Inc., 2019).
	References
	Alphabet Inc. (2019). GOOGL Alphabet Inc. A Stock Quote Price \| Morningstar. Retrieved from https://www.morningstar.com/stocks/xnas/googl/quote.html
	Fraser, L. M., Ormiston, A., & Fraser, L. M. (2010). Understanding financial statements. Pearson.