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 Short-term (Operating) Activity Ratios
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

Yahoo! Inc., short-term (operating) 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
Turnover Ratios
Receivables turnover 5.75 4.77 5.26 4.94 5.50 4.74 5.05 4.94 5.10 4.47 5.57 5.61 5.31 4.78 5.64 5.12 5.20 4.94
Payables turnover 16.40 15.85 15.08 13.74 11.28 9.96 6.95 5.38 5.35 5.45 7.85 10.76 8.50 9.78 11.56 12.39 14.22 8.77
Working capital turnover 0.79 0.76 0.76 0.77 0.80 0.80 0.79 0.79 0.84 0.89 0.56 1.56 1.42 1.27 2.01 1.47 1.42 1.14
Average No. Days
Average receivable collection period 63 77 69 74 66 77 72 74 72 82 66 65 69 76 65 71 70 74
Average payables payment period 22 23 24 27 32 37 52 68 68 67 46 34 43 37 32 29 26 42

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

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Yahoo! Inc. receivables turnover ratio deteriorated from Q3 2016 to Q4 2016 but then improved from Q4 2016 to Q1 2017 exceeding Q3 2016 level.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Yahoo! Inc. payables turnover ratio increased from Q3 2016 to Q4 2016 and from Q4 2016 to Q1 2017.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Yahoo! Inc. working capital turnover ratio deteriorated from Q3 2016 to Q4 2016 but then improved from Q4 2016 to Q1 2017 exceeding Q3 2016 level.

Short-term activity ratio Description The company
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Yahoo! Inc. number of days of receivables outstanding deteriorated from Q3 2016 to Q4 2016 but then improved from Q4 2016 to Q1 2017 exceeding Q3 2016 level.
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. Yahoo! Inc. number of days of payables outstanding decreased from Q3 2016 to Q4 2016 and from Q4 2016 to Q1 2017.

Receivables Turnover

Yahoo! Inc., receivables 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
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
Short-term Activity Ratio
Receivables turnover1 5.75 4.77 5.26 4.94 5.50 4.74 5.05 4.94 5.10 4.47 5.57 5.61 5.31 4.78 5.64 5.12 5.20 4.94
Benchmarks
Receivables Turnover, Competitors2
Adobe Inc.
Cadence Design Systems Inc.
CrowdStrike Holdings 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), 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
Receivables turnover = (RevenueQ1 2017 + RevenueQ4 2016 + RevenueQ3 2016 + RevenueQ2 2016) ÷ Accounts receivable, net
= (1,327,270 + 1,469,140 + 1,305,206 + 1,307,637) ÷ 940,311 = 5.75

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Yahoo! Inc. receivables turnover ratio deteriorated from Q3 2016 to Q4 2016 but then improved from Q4 2016 to Q1 2017 exceeding Q3 2016 level.

Payables Turnover

Yahoo! Inc., payables 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)
Cost of revenue 750,276 770,617 702,958 734,969 510,350 587,109 526,075 496,162 468,402 335,587 321,000 314,974 326,753 339,500 330,227 335,578 344,075 412,107 394,910 415,478 398,071
Accounts payable 180,368 171,520 168,148 171,621 187,862 208,691 262,588 301,433 269,160 238,018 165,890 121,933 156,782 138,031 123,042 120,028 110,162 184,831 147,943 132,105 129,042
Short-term Activity Ratio
Payables turnover1 16.40 15.85 15.08 13.74 11.28 9.96 6.95 5.38 5.35 5.45 7.85 10.76 8.50 9.78 11.56 12.39 14.22 8.77
Benchmarks
Payables Turnover, Competitors2
Accenture PLC
Adobe Inc.
CrowdStrike Holdings Inc.
International Business Machines Corp.
Intuit Inc.
Microsoft Corp.
Oracle Corp.
Palantir Technologies Inc.
Palo Alto Networks Inc.
ServiceNow 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
Payables turnover = (Cost of revenueQ1 2017 + Cost of revenueQ4 2016 + Cost of revenueQ3 2016 + Cost of revenueQ2 2016) ÷ Accounts payable
= (750,276 + 770,617 + 702,958 + 734,969) ÷ 180,368 = 16.40

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Yahoo! Inc. payables turnover ratio increased from Q3 2016 to Q4 2016 and from Q4 2016 to Q1 2017.

Working Capital Turnover

Yahoo! Inc., working capital 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)
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
Less: 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
Working capital 6,859,813 6,838,736 6,522,516 6,320,494 6,066,214 6,229,939 6,247,240 6,174,248 5,624,248 5,170,526 8,201,546 2,963,963 3,286,999 3,685,545 2,373,100 3,280,189 3,461,937 4,362,481 6,179,497 2,193,153 2,412,440
 
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
Short-term Activity Ratio
Working capital turnover1 0.79 0.76 0.76 0.77 0.80 0.80 0.79 0.79 0.84 0.89 0.56 1.56 1.42 1.27 2.01 1.47 1.42 1.14
Benchmarks
Working Capital Turnover, Competitors2
Accenture PLC
Adobe Inc.
Cadence Design Systems Inc.
CrowdStrike Holdings 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), 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
Working capital turnover = (RevenueQ1 2017 + RevenueQ4 2016 + RevenueQ3 2016 + RevenueQ2 2016) ÷ Working capital
= (1,327,270 + 1,469,140 + 1,305,206 + 1,307,637) ÷ 6,859,813 = 0.79

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Working capital turnover An activity ratio calculated as revenue divided by working capital. Yahoo! Inc. working capital turnover ratio deteriorated from Q3 2016 to Q4 2016 but then improved from Q4 2016 to Q1 2017 exceeding Q3 2016 level.

Average Receivable Collection Period

Yahoo! Inc., average receivable collection period 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
Receivables turnover 5.75 4.77 5.26 4.94 5.50 4.74 5.05 4.94 5.10 4.47 5.57 5.61 5.31 4.78 5.64 5.12 5.20 4.94
Short-term Activity Ratio (no. days)
Average receivable collection period1 63 77 69 74 66 77 72 74 72 82 66 65 69 76 65 71 70 74
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Adobe Inc.
Cadence Design Systems Inc.
CrowdStrike Holdings 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), 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
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 5.75 = 63

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Yahoo! Inc. number of days of receivables outstanding deteriorated from Q3 2016 to Q4 2016 but then improved from Q4 2016 to Q1 2017 exceeding Q3 2016 level.

Average Payables Payment Period

Yahoo! Inc., average payables payment period 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
Payables turnover 16.40 15.85 15.08 13.74 11.28 9.96 6.95 5.38 5.35 5.45 7.85 10.76 8.50 9.78 11.56 12.39 14.22 8.77
Short-term Activity Ratio (no. days)
Average payables payment period1 22 23 24 27 32 37 52 68 68 67 46 34 43 37 32 29 26 42
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Accenture PLC
Adobe Inc.
CrowdStrike Holdings Inc.
International Business Machines Corp.
Intuit Inc.
Microsoft Corp.
Oracle Corp.
Palantir Technologies Inc.
Palo Alto Networks Inc.
ServiceNow 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
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 16.40 = 22

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. Yahoo! Inc. number of days of payables outstanding decreased from Q3 2016 to Q4 2016 and from Q4 2016 to Q1 2017.