BUSI 352 MICROSOFT EXCEL HW

lwreavais24
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.