Stock Analysis on Net

Yahoo! Inc. (NASDAQ:YHOO)

This company has been moved to the archive! The financial data has not been updated since May 9, 2017.

Cash Flow Statement 
Quarterly Data

Yahoo! Inc., consolidated cash flow statement (quarterly data)

US$ in thousands

Microsoft Excel
3 months ended: Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012
Net income (loss) 99,940 163,907 163,300 (438,380) (98,290) (4,432,227) 78,136 (19,189) 22,173 169,281 6,776,393 272,557 313,911 351,670 298,994 335,008 390,894 273,652 3,161,016 228,456 287,478
Depreciation 95,703 99,017 95,270 105,677 107,377 117,354 118,846 119,633 117,061 118,454 116,946 116,446 123,185 119,839 127,356 141,426 143,864 148,213 146,483 131,789 122,750
Amortization of intangible assets 19,396 20,178 20,198 27,550 32,288 34,629 33,566 34,046 34,478 34,576 32,198 30,414 34,349 28,153 30,888 19,067 18,410 21,279 23,878 28,864 31,345
Accretion of convertible notes discount 17,167 16,944 16,723 16,504 16,290 16,077 15,867 15,660 15,457 15,255 15,057 14,860 14,666 4,846
Stock-based compensation expense 108,776 122,639 128,892 131,964 115,781 105,901 110,426 125,130 118,401 102,752 105,796 102,445 109,181 84,753 80,726 68,136 44,605 57,462 61,366 46,142 55,966
Non-cash asset impairment charge 2,682 41,699
Non-cash goodwill impairment charge 394,901 4,460,837 88,414 63,555
Non-cash intangible assets impairment charge 87,335 15,423
Non-cash restructuring charges (reversals) (149) 1,014 362 3,181 902 (74) (859) 3,637 (7,031) 547 69,434 1,824 38,638
Non-cash accretion on marketable securities 899 2,220 4,566 6,140 12,354 8,890 14,771 7,545 16,012
Foreign exchange (gain) loss (12,546) 18,618 (9,613) (29,909) (6,524) (5,961) (10,981) 3,085 18,233
(Gain) loss on sale of assets and other (9) (597) (888) (1,641) (190) 180 (3,030) (91) 63 7,623 9,183 15,117 3,550 2,403 6,819 1,270 11,905 6,468 6,199 (19,995) (4,512)
Gain from sale of Alibaba Group Shares (4,603,322)
Gain on sale of Alibaba Group ADSs (10,319,437)
Gain on sale of patents (120,059) (1,500) (9,100) (2,000) (35,094) (1,300) (61,500) (70,000) (9,950)
(Gain) loss on Hortonworks warrants (5,385) 116 8,493 2,287 39,150 (42) 12,781 (5,449) 11,909 (98,062)
Earnings in equity interests (113,688) (113,704) (116,228) (51,777) (81,574) (92,845) (95,195) (95,841) (99,690) (101,917) (398,692) (255,852) (301,402) (221,641) (232,756) (224,690) (217,588) (148,939) (175,265) (179,991) (172,243)
Dividend income related to Alibaba Group Preference Shares (15,475) (20,251) (20,000)
Tax benefits (detriments) from stock-based awards 14,854 (10,414) 624 1,192 18,739 26,607 (36,439) 32,822 34,649 34,234 19,161 57,667 15,167 24,169 188 9,537 (21,969) (5,536) (4,949) 1,014
Excess tax benefits from stock-based awards (16,264) 8,817 (3,034) (7,526) (24,923) (31,509) 35,620 (37,470) (35,190) (35,292) (19,544) (59,556) (17,214) (28,680) (5,706) (12,807) (5,093) (13,981) (8,609) (8,161)
Deferred income taxes (44,296) (48,753) (82,441) (55,749) (37,794) 10,264 (39,387) (30,227) 17,009 68,458 383,230 (303) 14,488 (9,321) (46,984) (7,839) (20,158) 121,968 (872,814) (14,075) (4,399)
Dividends received from equity investee 156,968 375 141,670 83,685 123,058 12,000 83,648
Accounts receivable 151,772 (149,290) 48,062 (114,478) 172,677 (73,368) 1,422 (57,042) 89,923 (113,370) (11,481) 55,725 98,404 (135,260) 102,949 657 57,853 (52,190) 96,850 (112,549) 102,641
Prepaid expenses and other 24,281 30,248 2,681 110,639 232,783 85,954 25,966 (25,833) (64,245) (99,659) 7,466 22,803 (9,211) 45,139 81,830 (119,275) 19,707 37,470 24,496 (61,298) 77,861
Accounts payable (5,099) 5,533 (8,979) (3,948) 2,844 (30,323) (67,147) 6,892 30,613 14,475 9,765 (29,567) 19,492 46,579 5,411 11,381 (71,135) 35,204 13,257 6,728 (42,442)
Accrued expenses and other liabilities (118,622) 92,703 (46,873) 202,155 (142,308) (108,261) (37,641) 165,744 89,934 12,821 322,160 38,033 (240,175) 84,853 (113,945) 53,711 (123,472) (2,373,163) 2,644,717 114,869 (130,624)
Income taxes payable related to sale of Alibaba Group ADSs (3,282,293) 3,282,293
Deferred revenue (3,834) (3,110) (3,511) (14,853) 8,376 (3,339) (59,199) (67,788) (65,002) (76,070) (39,327) (40,035) (39,488) (35,844) (38,767) (50,089) (25,229) (49,671) 537,140 (3,108) (19,221)
Changes in assets and liabilities, net of effects of acquisitions 48,498 (23,916) (8,620) 179,515 274,372 (129,337) (136,599) 21,973 (3,201,070) (261,803) 3,570,876 46,959 (170,978) 5,467 37,478 (103,615) (142,276) (2,402,350) 3,316,460 (55,358) (11,785)
Adjustments to reconcile net income (loss) to net cash provided by (used in) operating activities 114,515 91,352 54,606 848,310 464,058 4,541,049 59,139 327,141 (2,959,644) (58,248) (6,487,201) 84,857 (174,850) 6,007 (10,934) (4,180) (172,212) (2,173,527) (2,114,708) 46,104 9,975
Net cash provided by (used in) operating activities 214,455 255,259 217,906 409,930 365,768 108,822 137,275 307,952 (2,937,471) 111,033 289,192 357,414 139,061 357,677 288,060 330,828 218,682 (1,899,875) 1,046,308 274,560 297,453
Acquisition of property and equipment (61,147) (41,601) (43,172) (77,937) (76,399) (102,350) (161,450) (155,442) (134,921) (70,276) (127,262) (107,358) (84,655) (108,821) (77,653) (82,076) (69,581) (149,720) (139,865) (106,131) (109,791)
Proceeds from sales of property and equipment 937 698 1,202 247,587 300 107 11,069 2,396 15,008
Purchases of marketable securities (1,457,036) (2,137,201) (1,423,283) (2,385,685) (1,871,316) (1,733,658) (1,145,701) (1,614,068) (712,818) (6,327,504) (198,752) (451,739) (912,097) (975,888) (3,000) (763,009) (1,481,293) (1,681,467) (1,193,594) (469,046) (176,220)
Proceeds from sales of marketable securities 52,436 105,861 113,432 120,587 47,374 256,676 92,546 301,423 172,352 587,924 1,300,781 212,028 168,926 229,286 1,183,955 1,034,246 424,347 56,968 136,540 414,478 133,961
Proceeds from maturities of marketable securities 1,503,562 1,592,978 1,281,069 1,572,830 1,369,836 1,802,208 1,304,841 1,224,829 2,359,767 76,740 178,938 408,356 281,662 191,350 95,159 279,306 183,100 130,750 52,155 120,798 77,700
Proceeds related to sale of Alibaba Group shares, net 6,247,728
Proceeds from sale of Alibaba Group ADSs, net of underwriting discounts, commissions, and fees 9,404,974
Proceeds related to the redemption of Alibaba Group Preference Shares 800,000
Acquisitions, net of cash acquired (1,063) (153,339) 1,782 (23,073) (545,199) (292,176) (21,661) (60,315) (163,072) (1,014,010) (10,147) (5,716)
Proceeds from sales of patents 1,500 9,100 20,000 23,500 61,300 1,500 70,000 9,950
Purchases of intangible assets (52) (44) (36) (788) (1,177) (78) (122) (3,451) (1,160) (178) (306) (984) (1,190) (210) (238) (924) (1,128) (711) (1,286) (1,802)
Proceeds from settlement of derivative hedge contracts 8,223 1,192 1,787 36,028 26,497 55,915 45,140 19,627 68,417 12,821 170,457 2,801 306,207 548 1,411 4,100
Payments for settlement of derivative hedge contracts (1,078) (2,705) (1,848) (2,140) (3,024) (2,223) (2,712) (1,731) (2,151) (236) (602) (4,016) (600) (11,051) (3,937) (7,720)
Payments for equity investments in privately held companies (9) (14,000) (50,000) (10,399) (4,226)
Other investing activities, net 156 (34) (34) (35) (58) (53) (50) (115) (38) 3,391 1,879 (74) (566) 3,334 (291) (652) (278) 9,604 23,991 (7,280)
Net cash (used in) provided by investing activities 46,001 (482,048) (71,478) (523,803) (496,936) 246,063 10,097 (201,633) 1,697,585 (6,195,025) 10,306,603 228,170 (577,779) (356,108) 1,037,195 246,572 (950,880) (1,640,292) 5,102,964 (17,196) (83,432)
Proceeds from issuance of common stock 3,095 2,005 4,588 6,170 4,754 6,833 5,520 10,588 36,189 60,461 83,831 84,760 78,977 149,850 80,325 61,984 61,108 101,951 38,549 66,248 11,623
Repurchases of common stock (203,771) (1,612,995) (1,382,026) (718,628) (449,578) (231,278) (1,685,293) (652,750) (775,075) (1,451,462) (190,372) (455,507) (70,500)
Proceeds from issuance of convertible notes 1,412,344
Payments for note hedges (205,706)
Proceeds from issuance of warrants 124,775
Excess tax benefits from stock-based awards 16,264 (8,817) 3,034 7,526 24,923 31,509 (35,620) 37,470 35,190 35,292 19,544 59,556 17,214 28,680 5,706 12,807 5,093 13,981 8,609 8,161
Tax withholdings related to net share settlements of restricted stock awards and restricted stock units (67,901) (51,611) (66,017) (49,286) (42,139) (41,670) (66,101) (52,534) (97,426) (54,454) (66,844) (34,178) (125,403) (33,638) (55,040) (7,448) (43,689) (12,842) (9,603) (6,990) (31,504)
Distributions to noncontrolling interests (3,823) (5,948) (15,847) (22,344)
Proceeds from credit facility borrowings 150,000
Repayment of credit facility borrowings 150 (150,150)
Other financing activities, net (3,126) (3,791) (2,847) (3,930) (3,637) (3,767) (4,539) (4,442) (4,573) (4,387) (3,110) (3,037) (3,093) (3,047) (2,935) (1,373) (1,405) (1,373) (1,297) (1,209) (1,013)
Net cash used in financing activities (71,755) (37,133) (73,093) (49,960) (33,496) (13,681) (33,611) (97,855) (232,111) (1,576,185) (1,332,857) (673,883) (439,541) 1,230,664 (1,634,413) (593,881) (746,254) (1,358,633) (148,742) (388,849) (83,233)
Effect of exchange rate changes on cash and cash equivalents 20,743 (27,917) 12,569 9,633 12,357 9,547 (20,770) 5,048 (17,444) (17,192) (32,239) 4,869 (1,315) 2,929 9,363 (15,929) (14,693) 6,178 20,601 (49,214) 26,790
Net change in cash and cash equivalents 209,444 (291,839) 85,904 (154,200) (152,307) 350,751 92,991 13,512 (1,489,441) (7,677,369) 9,230,699 (83,430) (879,574) 1,235,162 (299,795) (32,410) (1,493,145) (4,892,622) 6,021,131 (180,699) 157,578

Based on: 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31), 10-K (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-Q (reporting date: 2013-03-31), 10-K (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-Q (reporting date: 2012-03-31).


Net Income (Loss)
Net income exhibits significant volatility across the periods, with substantial positive peaks notably in September 2012 and September 2014, corresponding to unusually high gains potentially linked to asset sales or other non-operating activities. Conversely, the company experiences sizable net losses towards the end of 2015 and in 2016. The trend indicates periods of profitability interspersed with significant losses, reflecting underlying earnings instability.
Depreciation and Amortization
Depreciation expenses remain relatively stable over time with a slight downward trend starting from 2015 onward. Amortization of intangible assets shows a gradual decrease over the measured periods, indicating possible maturation or impairment of intangible assets. Accretion on convertible notes shows a consistent increase as expected due to its cumulative nature.
Stock-Based Compensation Expense
This expense generally trends upward from 2012 through mid-2016 with some fluctuations, suggesting increased issuance or valuation of stock awards over time. The high levels of expense may impact net profitability and cash flow.
Non-Cash Charges and Impairments
There are non-cash goodwill and intangible asset impairment charges recorded sporadically, notably large goodwill impairments in late 2015 and mid-2016, which heavily impact reported earnings. Restructuring charges and their reversals occur intermittently, pointing to ongoing organizational adjustments. Impairment charges contribute significantly to volatility in net income.
Gains and Losses on Asset Sales and Investments
Material gains are recorded from the sale of Alibaba Group shares and ADSs, particularly in 2012 and 2014, significantly boosting net income in respective quarters. Gains and losses on patents and warrants show mixed impacts, causing fluctuations in reported earnings. Foreign exchange gains and losses fluctuate considerably, affecting earnings and cash flow in some periods.
Earnings in Equity Interests and Dividend Income
Earnings in equity interests show persistent negative values indicating losses or expense recognition related to equity investments. Dividend income from Alibaba-related shares appears sporadically, suggesting cash inflow from investees but not a consistent revenue source.
Tax-Related Items
Tax benefits and excess tax benefits from stock-based awards fluctuate considerably. Deferred income taxes show erratic movements suggestive of changes in tax liabilities or benefits. At times, these tax adjustments appear to offset portions of stock-based compensation costs, impacting effective taxation.
Working Capital Components
Accounts receivable and accounts payable show volatile changes, with abrupt swings implying variability in sales and payment cycles. Prepaid expenses and other current assets/liabilities also fluctuate significantly, reflecting both operational volatility and possibly reclassification or timing impacts. Deferred revenue remains mostly negative, indicating advance receipts or contract liabilities that do not show a clear upward or downward trend.
Cash Flows from Operating Activities
Cash from operating activities is generally positive but volatile, with certain quarters experiencing steep declines consistent with net loss periods. Adjustments to reconcile net income to operating cash flows include large non-cash items and working capital changes, reinforcing the influence of impairments and accretion expenses on reported earnings versus actual cash movements.
Investing Activities
Investing cash flows are highly variable, showing significant proceeds from marketable securities sales and maturities in many quarters, offset by extensive purchases of marketable securities and property/equipment acquisitions. The proceeds from sales related to Alibaba Group shares and ADS sales significantly influence cash inflows during some periods. Acquisitions and asset purchases remain consistent but with varying amounts.
Financing Activities
Cash flows from financing activities demonstrate notable share repurchases, particularly between 2012 and 2014, contributing to large cash outflows. Issuances of common stock and convertible notes generate cash infusions intermittently. Repayments and borrowings of credit facilities occur but appear limited overall. Tax withholdings on stock awards represent a consistent cash outflow remitted to tax authorities.
Liquidity and Cash Position Changes
The net change in cash and cash equivalents follows a highly volatile pattern with large inflows driven mainly by asset sales and financing inflows early in the period, followed by substantial cash declines mid-to-late period. This volatility suggests a dynamic liquidity position influenced by significant investment and financing activities alongside operating cash flow variability.