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 Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

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 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012
Net fixed asset turnover 4.59 4.27 3.91 3.69 3.23 3.21 3.11 3.19 3.18 3.10 3.12 3.14 3.16 3.14 3.10 3.05 3.04 2.96
Total asset turnover 0.10 0.11 0.09 0.11 0.11 0.11 0.12 0.10 0.09 0.07 0.08 0.28 0.28 0.28 0.32 0.30 0.30 0.29
Equity turnover 0.15 0.17 0.14 0.17 0.17 0.17 0.18 0.15 0.14 0.12 0.13 0.36 0.36 0.36 0.38 0.35 0.35 0.34

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

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Yahoo! Inc. net fixed asset turnover ratio improved from Q3 2016 to Q4 2016 and from Q4 2016 to Q1 2017.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Yahoo! Inc. total asset turnover ratio improved from Q3 2016 to Q4 2016 but then slightly deteriorated from Q4 2016 to Q1 2017 not reaching Q3 2016 level.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Yahoo! Inc. equity turnover ratio improved from Q3 2016 to Q4 2016 but then slightly deteriorated from Q4 2016 to Q1 2017 not reaching Q3 2016 level.

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 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012
Selected Financial Data (US$ in thousands)
Revenue 1,327,270 1,469,140 1,305,206 1,307,637 1,087,152 1,273,393 1,225,673 1,243,265 1,225,970 1,253,072 1,148,140 1,084,191 1,132,730 1,265,795 1,138,973 1,135,244 1,140,368 1,345,807 1,201,732 1,217,794 1,221,233
Property and equipment, net 1,177,723 1,209,937 1,273,327 1,326,242 1,496,510 1,547,323 1,590,439 1,524,539 1,483,772 1,487,684 1,483,797 1,470,272 1,479,406 1,488,518 1,536,362 1,579,822 1,612,690 1,685,845 1,671,234 1,663,665 1,726,858
Long-term Activity Ratio
Net fixed asset turnover1 4.59 4.27 3.91 3.69 3.23 3.21 3.11 3.19 3.18 3.10 3.12 3.14 3.16 3.14 3.10 3.05 3.04 2.96
Benchmarks
Net Fixed Asset Turnover, Competitors2
Accenture PLC
Adobe Inc.
International Business Machines Corp.
Intuit Inc.
Microsoft Corp.
Oracle Corp.
Palo Alto Networks Inc.
Salesforce Inc.
ServiceNow Inc.
Synopsys 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
Net fixed asset turnover = (RevenueQ1 2017 + RevenueQ4 2016 + RevenueQ3 2016 + RevenueQ2 2016) ÷ Property and equipment, net
= (1,327,270 + 1,469,140 + 1,305,206 + 1,307,637) ÷ 1,177,723 = 4.59

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Yahoo! Inc. net fixed asset turnover ratio improved from Q3 2016 to Q4 2016 and from Q4 2016 to Q1 2017.

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 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012
Selected Financial Data (US$ in thousands)
Revenue 1,327,270 1,469,140 1,305,206 1,307,637 1,087,152 1,273,393 1,225,673 1,243,265 1,225,970 1,253,072 1,148,140 1,084,191 1,132,730 1,265,795 1,138,973 1,135,244 1,140,368 1,345,807 1,201,732 1,217,794 1,221,233
Total assets 55,368,726 48,083,079 54,671,626 44,214,295 44,158,229 45,203,966 41,134,999 50,191,816 50,491,706 61,960,344 57,297,599 16,456,813 16,592,915 16,804,959 14,905,749 16,226,423 16,490,979 17,103,253 20,414,127 14,658,229 14,963,240
Long-term Activity Ratio
Total asset turnover1 0.10 0.11 0.09 0.11 0.11 0.11 0.12 0.10 0.09 0.07 0.08 0.28 0.28 0.28 0.32 0.30 0.30 0.29
Benchmarks
Total Asset Turnover, Competitors2
Accenture PLC
Adobe Inc.
International Business Machines Corp.
Intuit Inc.
Microsoft Corp.
Oracle Corp.
Palo Alto Networks Inc.
Salesforce Inc.
ServiceNow Inc.
Synopsys 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
Total asset turnover = (RevenueQ1 2017 + RevenueQ4 2016 + RevenueQ3 2016 + RevenueQ2 2016) ÷ Total assets
= (1,327,270 + 1,469,140 + 1,305,206 + 1,307,637) ÷ 55,368,726 = 0.10

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Yahoo! Inc. total asset turnover ratio improved from Q3 2016 to Q4 2016 but then slightly deteriorated from Q4 2016 to Q1 2017 not reaching Q3 2016 level.

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 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012
Selected Financial Data (US$ in thousands)
Revenue 1,327,270 1,469,140 1,305,206 1,307,637 1,087,152 1,273,393 1,225,673 1,243,265 1,225,970 1,253,072 1,148,140 1,084,191 1,132,730 1,265,795 1,138,973 1,135,244 1,140,368 1,345,807 1,201,732 1,217,794 1,221,233
Total Yahoo! Inc. stockholders’ equity 35,435,717 31,049,283 34,836,272 28,363,894 28,478,347 29,043,537 28,245,950 33,532,602 33,658,896 38,741,837 36,713,567 12,691,988 12,905,183 13,074,909 12,494,111 13,808,864 14,139,916 14,560,200 15,561,503 12,472,997 12,818,578
Long-term Activity Ratio
Equity turnover1 0.15 0.17 0.14 0.17 0.17 0.17 0.18 0.15 0.14 0.12 0.13 0.36 0.36 0.36 0.38 0.35 0.35 0.34
Benchmarks
Equity Turnover, Competitors2
Accenture PLC
Adobe Inc.
International Business Machines Corp.
Intuit Inc.
Microsoft Corp.
Oracle Corp.
Palo Alto Networks Inc.
Salesforce Inc.
ServiceNow Inc.
Synopsys 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
Equity turnover = (RevenueQ1 2017 + RevenueQ4 2016 + RevenueQ3 2016 + RevenueQ2 2016) ÷ Total Yahoo! Inc. stockholders’ equity
= (1,327,270 + 1,469,140 + 1,305,206 + 1,307,637) ÷ 35,435,717 = 0.15

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Yahoo! Inc. equity turnover ratio improved from Q3 2016 to Q4 2016 but then slightly deteriorated from Q4 2016 to Q1 2017 not reaching Q3 2016 level.