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.

Analysis of Liquidity Ratios 
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Yahoo! Inc., liquidity ratios (quarterly data)

Microsoft Excel
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
Current ratio 6.87 6.31 6.14 5.95 6.24 5.88 5.63 5.39 5.02 2.14 2.87 3.48 3.75 3.75 2.99 3.78 4.04 4.38 2.76 3.04 3.25
Quick ratio 6.72 6.14 5.95 5.78 5.92 5.41 5.09 4.84 4.44 1.99 2.75 2.99 3.20 3.27 2.24 3.03 3.47 4.02 2.67 2.74 2.94
Cash ratio 5.92 5.30 5.20 5.00 5.16 4.59 4.36 4.14 3.78 1.77 2.56 2.30 2.46 2.54 1.53 2.23 2.65 3.24 2.40 1.77 2.06

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


Current Ratio Trends
The current ratio exhibits considerable fluctuations over the examined periods. It initially declines from 3.25 at the end of Q1 2012 to a low of 2.14 by Q4 2014, indicating a reduction in short-term liquidity during that timeframe. Subsequently, there is a strong upward trend starting in Q1 2015, rising consistently to reach 6.87 by Q1 2017. This increase suggests an improvement in the company's ability to cover its short-term liabilities with current assets, reflecting enhanced liquidity management or accumulation of current assets.
Quick Ratio Patterns
The quick ratio follows a pattern similar to the current ratio, with an initial decrease from 2.94 in Q1 2012 to 1.99 in Q4 2014. This decline points to a tightening in the most liquid assets relative to current liabilities. Following this period, a marked improvement is observed, with the ratio increasing steadily to 6.72 by Q1 2017. The sharp rise suggests a significant increase in liquid assets such as cash and marketable securities relative to current liabilities, indicating improved short-term financial health excluding inventory.
Cash Ratio Developments
The cash ratio demonstrates a generally increasing trend over the period, albeit with some volatility. Starting at 2.06 in Q1 2012, it fluctuates moderately before reaching a low point of 1.77 in Q4 2014. From this low, the cash ratio ascends steadily to peak at 5.92 in Q1 2017. This progression signals an enhancement in the firm’s most liquid resources available to cover current obligations, highlighting cautious cash management and possibly a strategic buildup of cash reserves during the latter periods.
Overall Observations
All three liquidity ratios (current, quick, and cash) experienced a period of decline until late 2014, indicating a weakening in liquidity positions. After this point, there is a sustained and pronounced improvement across all metrics through early 2017. This pattern may reflect a strategic shift toward strengthening liquidity, reducing risk, or adapting to changes in operational or financial conditions. The increase in ratios to levels significantly above 1 illustrates a strong ability to meet short-term liabilities and suggests the company maintains a conservative liquidity posture in the most recent periods analyzed.

Current Ratio

Yahoo! Inc., current ratio calculation (quarterly data)

Microsoft Excel
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
Selected Financial Data (US$ in thousands)
Current assets 8,027,724 8,126,160 7,790,956 7,597,001 7,224,224 7,507,319 7,596,073 7,580,932 7,022,647 9,699,107 12,579,507 4,157,749 4,481,874 5,025,857 3,566,223 4,458,302 4,601,022 5,652,713 9,685,779 3,270,298 3,482,797
Current liabilities 1,167,911 1,287,424 1,268,440 1,276,507 1,158,010 1,277,380 1,348,833 1,406,684 1,398,399 4,528,581 4,377,961 1,193,786 1,194,875 1,340,312 1,193,123 1,178,113 1,139,085 1,290,232 3,506,282 1,077,145 1,070,357
Liquidity Ratio
Current ratio1 6.87 6.31 6.14 5.95 6.24 5.88 5.63 5.39 5.02 2.14 2.87 3.48 3.75 3.75 2.99 3.78 4.04 4.38 2.76 3.04 3.25
Benchmarks
Current Ratio, Competitors2
Accenture PLC
Adobe Inc.
Cadence Design Systems Inc.
CrowdStrike Holdings Inc.
Datadog Inc.
Fair Isaac Corp.
International Business Machines Corp.
Intuit Inc.
Microsoft Corp.
Oracle Corp.
Palantir Technologies Inc.
Palo Alto Networks Inc.
Salesforce Inc.
ServiceNow Inc.
Synopsys Inc.
Workday Inc.

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

1 Q1 2017 Calculation
Current ratio = Current assets ÷ Current liabilities
= 8,027,724 ÷ 1,167,911 = 6.87

2 Click competitor name to see calculations.


The analysis of the quarterly financial data reveals several noteworthy trends in liquidity and balance sheet composition over the period examined.

Current Assets
Current assets display significant fluctuations, with notable peaks and troughs throughout the timeline. Initially, the value decreased from approximately 3.48 billion US dollars in March 2012 to 3.28 billion in June 2012, followed by a sharp increase to nearly 9.69 billion by September 2012. Subsequently, assets fluctuated around the 4.5 to 5.6 billion range until September 2014, when a spike to over 12.57 billion was recorded. After this peak, current assets declined substantially but stabilized between roughly 7 billion and 8.1 billion in subsequent periods, with minor growth towards early 2017, ending at approximately 8 billion.
Current Liabilities
Current liabilities similarly exhibited variability but within a narrower range compared to current assets. The data shows a gradual increase from about 1.07 billion in early 2012 to a peak of nearly 4.38 billion by September 2014, coinciding with the peak in current assets. Following this peak, liabilities significantly decreased and generally remained between 1.16 billion and 1.45 billion for the remainder of the periods, showing a relatively stable liability profile toward the end of the timeline.
Current Ratio
The current ratio demonstrates an overall strengthening in short-term liquidity throughout the observed timeframe. Starting at a healthy 3.25 in March 2012, the ratio experienced fluctuations but remained above 2.7 until early 2014. At the end of 2014, there was a notable dip to around 2.14, followed by a marked and sustained increase to values exceeding 5.0 from early 2015 onward. The highest current ratio recorded was 6.87 in March 2017, indicating a substantial increase in the company's capacity to cover short-term obligations with current assets.

In summary, the data reflects periods of high volatility in current assets and liabilities, particularly with substantial spikes around late 2012 and late 2014. Despite these fluctuations, the consistent improvement in the current ratio from 2015 to 2017 suggests enhanced liquidity management and a more robust short-term financial position over time.


Quick Ratio

Yahoo! Inc., quick ratio calculation (quarterly data)

Microsoft Excel
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
Selected Financial Data (US$ in thousands)
Cash and cash equivalents 1,328,913 1,119,469 1,411,308 1,325,404 1,479,604 1,631,911 1,281,160 1,188,169 1,174,657 2,667,916 10,345,285 1,114,586 1,198,016 2,077,590 842,428 1,142,223 1,174,633 2,667,778 7,560,400 1,539,269 1,719,968
Short-term marketable securities 5,582,149 5,700,925 5,189,207 5,055,683 4,497,046 4,225,112 4,600,889 4,636,152 4,109,789 5,327,412 848,558 1,629,869 1,741,494 1,330,304 987,870 1,486,591 1,838,527 1,516,175 852,816 371,204 489,912
Accounts receivable, net 940,311 1,084,267 945,659 991,185 878,135 1,047,504 980,301 985,105 924,411 1,032,704 831,393 824,472 879,992 979,559 844,118 941,811 943,658 1,008,448 953,671 1,040,893 941,590
Total quick assets 7,851,373 7,904,661 7,546,174 7,372,272 6,854,785 6,904,527 6,862,350 6,809,426 6,208,857 9,028,032 12,025,236 3,568,927 3,819,502 4,387,453 2,674,416 3,570,625 3,956,818 5,192,401 9,366,887 2,951,366 3,151,470
 
Current liabilities 1,167,911 1,287,424 1,268,440 1,276,507 1,158,010 1,277,380 1,348,833 1,406,684 1,398,399 4,528,581 4,377,961 1,193,786 1,194,875 1,340,312 1,193,123 1,178,113 1,139,085 1,290,232 3,506,282 1,077,145 1,070,357
Liquidity Ratio
Quick ratio1 6.72 6.14 5.95 5.78 5.92 5.41 5.09 4.84 4.44 1.99 2.75 2.99 3.20 3.27 2.24 3.03 3.47 4.02 2.67 2.74 2.94
Benchmarks
Quick Ratio, Competitors2
Accenture PLC
Adobe Inc.
Cadence Design Systems Inc.
CrowdStrike Holdings Inc.
Datadog Inc.
Fair Isaac Corp.
International Business Machines Corp.
Intuit Inc.
Microsoft Corp.
Oracle Corp.
Palantir Technologies Inc.
Palo Alto Networks Inc.
Salesforce Inc.
ServiceNow Inc.
Synopsys Inc.
Workday Inc.

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

1 Q1 2017 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 7,851,373 ÷ 1,167,911 = 6.72

2 Click competitor name to see calculations.


The analysis of the quarterly financial data reveals several notable trends related to liquidity and current liabilities over the examined periods.

Total Quick Assets
The total quick assets exhibit significant fluctuations across quarters. Initial values around 3.15 billion US dollars in early 2012 decline slightly before a sharp rise to over 9.36 billion in September 2012. Subsequently, quick assets fall to approximately 2.67 billion by September 2013 before rising again to peak around 12.03 billion in late 2014. Following this period, quick assets decrease gradually and stabilize around the 6.8 to 7.9 billion range from early 2015 through early 2017, showing a relatively steady trend with minor variations.
Current Liabilities
Current liabilities remain comparatively stable in the earlier periods, fluctuating around 1.07 to 1.35 billion US dollars from 2012 through mid-2013, with a noticeable spike exceeding 4.37 billion in the third quarter of 2014. After this peak, liabilities rapidly decline and stabilize close to 1.1 to 1.4 billion from late 2014 through the first quarter of 2017. The large spike in late 2014 suggests an unusual temporary increase in obligations during that timeframe.
Quick Ratio
The quick ratio generally demonstrates an improving liquidity position over time. Despite some volatility in the earlier quarters, including a dip below 2.0 in late 2014, the ratio steadily increases from 2015 onwards, moving from around 4.44 in the first quarter of 2015 to 6.72 by the first quarter of 2017. This upward trend indicates an enhanced ability to cover current liabilities with liquid assets over the observed period.

Overall, the data indicates that liquidity as measured by the quick ratio has strengthened notably over the years. While total quick assets and current liabilities have experienced periods of volatility, the significant improvement in the quick ratio suggests more efficient management of short-term solvency and a stronger financial position entering 2017 compared to earlier periods.


Cash Ratio

Yahoo! Inc., cash ratio calculation (quarterly data)

Microsoft Excel
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
Selected Financial Data (US$ in thousands)
Cash and cash equivalents 1,328,913 1,119,469 1,411,308 1,325,404 1,479,604 1,631,911 1,281,160 1,188,169 1,174,657 2,667,916 10,345,285 1,114,586 1,198,016 2,077,590 842,428 1,142,223 1,174,633 2,667,778 7,560,400 1,539,269 1,719,968
Short-term marketable securities 5,582,149 5,700,925 5,189,207 5,055,683 4,497,046 4,225,112 4,600,889 4,636,152 4,109,789 5,327,412 848,558 1,629,869 1,741,494 1,330,304 987,870 1,486,591 1,838,527 1,516,175 852,816 371,204 489,912
Total cash assets 6,911,062 6,820,394 6,600,515 6,381,087 5,976,650 5,857,023 5,882,049 5,824,321 5,284,446 7,995,328 11,193,843 2,744,455 2,939,510 3,407,894 1,830,298 2,628,814 3,013,160 4,183,953 8,413,216 1,910,473 2,209,880
 
Current liabilities 1,167,911 1,287,424 1,268,440 1,276,507 1,158,010 1,277,380 1,348,833 1,406,684 1,398,399 4,528,581 4,377,961 1,193,786 1,194,875 1,340,312 1,193,123 1,178,113 1,139,085 1,290,232 3,506,282 1,077,145 1,070,357
Liquidity Ratio
Cash ratio1 5.92 5.30 5.20 5.00 5.16 4.59 4.36 4.14 3.78 1.77 2.56 2.30 2.46 2.54 1.53 2.23 2.65 3.24 2.40 1.77 2.06
Benchmarks
Cash Ratio, Competitors2
Accenture PLC
Adobe Inc.
Cadence Design Systems Inc.
CrowdStrike Holdings Inc.
Datadog Inc.
Fair Isaac Corp.
International Business Machines Corp.
Intuit Inc.
Microsoft Corp.
Oracle Corp.
Palantir Technologies Inc.
Palo Alto Networks Inc.
Salesforce Inc.
ServiceNow Inc.
Synopsys Inc.
Workday Inc.

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

1 Q1 2017 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 6,911,062 ÷ 1,167,911 = 5.92

2 Click competitor name to see calculations.


The analysis of the quarterly financial data reveals several notable trends and patterns over the observed periods.

Total Cash Assets
Total cash assets exhibit considerable fluctuations throughout the periods, with values ranging from approximately 1.8 billion US dollars to over 11 billion US dollars. There is a peak observed in September 2014 with cash assets exceeding 11 billion US dollars, which is substantially higher than surrounding quarters. Following this peak, total cash assets decline sharply in subsequent quarters but generally stabilize around the 5 to 7 billion US dollar mark from early 2015 onward. From March 2016 through March 2017, a gradual increase is apparent, culminating in an amount approaching 6.9 billion US dollars.
Current Liabilities
Current liabilities remain relatively steady in the earlier quarters, mostly fluctuating between approximately 1.0 billion to 1.3 billion US dollars; however, significant spikes occur in the periods of September 2012 and late 2013 to 2014. The liabilities peak in September 2014, reaching nearly 4.4 billion US dollars, coinciding with the peak in total cash assets. After this period, current liabilities contract sharply and resume a more stable range just above 1 billion US dollars, with minor variation through early 2017. This suggests a reduction in short-term obligations following the peak in 2014.
Cash Ratio
The cash ratio, which indicates the company's ability to cover its current liabilities with its cash assets, reveals a generally improving trend across the periods. The ratio starts near 2.06 in March 2012, indicating that cash assets are slightly more than double current liabilities at that time. Despite fluctuations, there is a notable upward trajectory beginning around early 2015, where the ratio increases from 3.78 to a peak of approximately 5.92 by March 2017. This rising trend implies a strengthening liquidity position and possibly more conservative short-term funding management. The highest values coincide with periods where total cash assets remain stable or increase, and current liabilities are relatively low.

Overall, the financial data indicate a period of volatility in both cash and liabilities around 2012 to 2014, marked by significant cash accumulation and elevated liabilities. However, post-2014, the company appears to achieve greater financial stability, characterized by steady cash reserves, controlled liabilities, and a markedly better liquidity position as evidenced by an increasing cash ratio. This improvement in liquidity suggests enhanced capacity to meet short-term obligations without the need for additional financing or asset liquidation.