Stock Analysis on Net

Yahoo! Inc. (NASDAQ:YHOO)

$22.49

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

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Long-term Activity Ratios (Summary)

Yahoo! Inc., long-term (investment) activity 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
Net fixed asset turnover
Total asset turnover
Equity turnover

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


The analysis of the turnover ratios over the observed quarterly periods reveals distinct trends in asset utilization efficiency.

Net Fixed Asset Turnover

This ratio demonstrates a generally upward trend throughout the timeline. Starting near 3.04, it shows steady increases with minor fluctuations, reaching 4.59 by the final quarter. This indicates an improving efficiency in utilizing fixed assets to generate revenue, reflecting potentially enhanced operational performance or better asset management strategies over time.

Total Asset Turnover

This ratio remains relatively stable but at a much lower level compared to net fixed asset turnover, beginning at approximately 0.30. There is a noticeable decline starting around mid-2014, dropping sharply to as low as 0.07, before experiencing slight fluctuations and stabilizing around 0.10 in the latter periods. The initial stability followed by decline and minimal recovery suggests challenges in leveraging total asset base effectively to produce sales during those mid-period quarters.

Equity Turnover

The equity turnover ratio starts at approximately 0.35 and generally follows a pattern similar to total asset turnover, maintaining initial stability, then experiencing a substantial decrease from around 0.36 to about 0.12 in late 2014. It subsequently recovers modestly, fluctuating between 0.14 and 0.18, before ending near 0.15. This pattern may reflect changes in equity base or sales generation capacity relative to equity, possibly influenced by financial strategy or market conditions during the analyzed periods.


Net Fixed Asset Turnover

Yahoo! Inc., net fixed asset turnover 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
Selected Financial Data (US$ in thousands)
Revenue
Property and equipment, net
Long-term Activity Ratio
Net fixed asset turnover1
Benchmarks
Net Fixed Asset Turnover, Competitors2
Accenture PLC
Adobe Inc.
AppLovin Corp.
Cadence Design Systems Inc.
CrowdStrike Holdings Inc.
Datadog Inc.
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).

1 Q1 2017 Calculation
Net fixed asset turnover = (RevenueQ1 2017 + RevenueQ4 2016 + RevenueQ3 2016 + RevenueQ2 2016) ÷ Property and equipment, net
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


Revenue Trends
Revenue figures demonstrate fluctuations over the examined periods, with values ranging from a low near 1,082,000 thousand US$ to a high exceeding 1,469,000 thousand US$. The data shows a general pattern of seasonal variation, with peaks often observed in the fourth quarter of each year. After a decline from early 2013 into mid-2014, revenue climbs gradually from late 2014 through 2015, experiencing a slight dip in early 2016 before a notable rise in the final quarters of 2016 and early 2017. This trajectory suggests some recovery and growth momentum in the later periods.
Property and Equipment, Net
The net value of property and equipment exhibits a consistent downward trend throughout the entire timeline. Starting from approximately 1,612,000 thousand US$ in early 2013, it decreases steadily to roughly 1,178,000 thousand US$ by early 2017. This continuous decline indicates either depreciation exceeding asset additions or possible disposals and reduction in capital investments. Notably, the steepest declines appear between early 2016 and early 2017.
Net Fixed Asset Turnover Ratio
The net fixed asset turnover ratio displays a clear upward trend, improving from a level slightly above 3.0 in early 2013 to more than 4.5 by early 2017. This indicates a progressively more efficient use of fixed assets in generating revenue. The increase is gradual but becomes more pronounced from 2015 onward, suggesting enhanced asset utilization or improved operational efficiency during these periods.
Overall Insights
The combination of decreasing property and equipment net values and rising net fixed asset turnover ratio points to a possibly strategic reduction of asset base in favor of leveraging existing assets more effectively. While revenue exhibits variability, the upward turnover ratio implies that the company has enhanced its capacity to generate sales from its available fixed assets over time. This could reflect operational improvements, better asset management, or shifts in business structure aimed at optimizing asset utilization amidst fluctuating revenue.

Total Asset Turnover

Yahoo! Inc., total asset turnover 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
Selected Financial Data (US$ in thousands)
Revenue
Total assets
Long-term Activity Ratio
Total asset turnover1
Benchmarks
Total Asset Turnover, Competitors2
Accenture PLC
Adobe Inc.
AppLovin Corp.
Cadence Design Systems Inc.
CrowdStrike Holdings Inc.
Datadog Inc.
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).

1 Q1 2017 Calculation
Total asset turnover = (RevenueQ1 2017 + RevenueQ4 2016 + RevenueQ3 2016 + RevenueQ2 2016) ÷ Total assets
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


Revenue Trends
The revenue displayed moderate fluctuations over the analyzed quarters. Initial revenue figures hovered around 1.14 billion US dollars in early 2013, exhibiting slight declines and recoveries through 2014. Notably, revenue decreased to approximately 1.08 billion in mid-2014 before rebounding towards the end of the year. A more pronounced increase occurred in late 2016, peaking at nearly 1.47 billion US dollars in the fourth quarter of 2016, before slightly declining to about 1.33 billion in the first quarter of 2017. Overall, revenue showed a general upward trend in the latter part of the period.
Total Assets Patterns
Total assets exhibited substantial variation throughout the period. Initially stable around 16 to 17 billion US dollars in 2013 and early 2014, total assets surged dramatically in the latter part of 2014 to approximately 57 billion, continuing a marked increase into early 2015 at over 61 billion. This peak was followed by a steep decline through 2015, bottoming near 41 billion US dollars. The asset base then fluctuated, rising again to mid-54 billion levels by early 2016 and the end of 2016, illustrating significant volatility and large-scale asset repositioning during these years.
Total Asset Turnover Analysis
The total asset turnover ratio remained relatively low throughout the timeframe, beginning at about 0.30 in the first quarter of 2013. A declining trend emerged in 2014, reaching a low of 0.07 to 0.08 during mid to late 2014, coinciding with the substantial asset base increase. Subsequently, turnover ratios gradually improved to levels around 0.10 to 0.12 from 2015 through 2016, reflecting more efficient utilization of assets relative to revenue generation. Nonetheless, turnover remained below the initial values, indicating that asset increases were not matched proportionally by revenue growth.
Insights and Implications
The sharp increase and subsequent fluctuations in total assets suggest significant investments, acquisitions, or revaluations during the period, particularly noticeable in late 2014 and early 2015. Despite these changes, revenue growth was modest with occasional spikes, implying that the asset-intensive strategy did not instantly translate into proportionate revenue gains. The persistently low total asset turnover ratios point toward challenges in efficiently leveraging the enlarged asset base. This may warrant further investigation into asset deployment effectiveness and potential operational adjustments to enhance revenue generation relative to asset levels.

Equity Turnover

Yahoo! Inc., equity turnover 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
Selected Financial Data (US$ in thousands)
Revenue
Total Yahoo! Inc. stockholders’ equity
Long-term Activity Ratio
Equity turnover1
Benchmarks
Equity Turnover, Competitors2
Accenture PLC
Adobe Inc.
AppLovin Corp.
Cadence Design Systems Inc.
CrowdStrike Holdings Inc.
Datadog Inc.
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).

1 Q1 2017 Calculation
Equity turnover = (RevenueQ1 2017 + RevenueQ4 2016 + RevenueQ3 2016 + RevenueQ2 2016) ÷ Total Yahoo! Inc. stockholders’ equity
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


Revenue Analysis
Over the observed periods, revenue exhibits a fluctuating pattern with notable variability across quarters. Initial quarters in 2013 show stable revenue figures around 1,130,000 to 1,265,000 thousand US dollars, with a pronounced peak at the close of 2013. The first three quarters of 2014 reflect a decline in revenue, bottoming in mid-2014 before recovering towards the end of 2014. In 2015, revenue maintains a relatively consistent level, oscillating slightly around 1,225,000 to 1,275,000 thousand US dollars. However, 2016 introduces further volatility, with a sharp dip in the first quarter followed by a rising trend, culminating in the highest recorded revenue in the later quarters of 2016. The latest quarter in early 2017 shows a moderate decrease compared to the peak at the end of 2016, but revenue remains higher than most earlier periods.
Total Stockholders’ Equity
The total stockholders’ equity demonstrates significant shifts, notably around 2014, indicating structural changes affecting equity. Initial values from 2013 to early 2014 are relatively stable, ranging near 12 to 14 billion US dollars. A substantive increase occurs starting mid-2014, where equity more than doubles, reaching over 38 billion US dollars by the year-end. This elevated equity level is sustained into early 2015, followed by a downward adjustment but remaining above pre-2014 values through 2016. Fluctuations during 2015 and 2016 suggest potential equity revaluations, capital restructurings, or other corporate actions affecting the equity base. By early 2017, equity rebounds to levels slightly above those seen in mid-2016.
Equity Turnover Ratio
The equity turnover ratio, which assesses the efficiency in generating revenue from stockholders’ equity, shows a declining trend over the period. Starting from a ratio of approximately 0.35 in early 2013, it remains relatively stable until early 2014. Following the significant increase in total equity around mid-2014, the ratio sharply declines to near 0.12 to 0.13, indicating that revenue growth did not keep pace with the expanded equity base. In subsequent years, the equity turnover ratio modestly recovers but remains below the levels observed before mid-2014. This pattern suggests a decrease in capital utilization efficiency or a change in business scale, where increased equity has not translated proportionally into revenue generation.
Overall Insights
The financial trends point to a period of considerable transformation for the company, marked by a major equity base expansion around mid-2014. While revenue exhibits cyclical behavior with peaks toward the end of each year, the growth does not fully correspond to the increased equity, as evidenced by the lower equity turnover ratio following 2014. This disparity could reflect an investment phase, acquisitions, or balance sheet restructuring that temporarily depress operational efficiency metrics. The restoration of higher revenue levels in late 2016 and early 2017 indicates a potential rebound in operational performance, but efficiency in utilizing equity remains below earlier benchmarks.