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 Reportable Segments

Microsoft Excel

Segment Profit Margin

Yahoo! Inc., profit margin by reportable segment

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Americas 64.93% 80.17% 95.27% 95.43% 94.73%
Europe, Middle East, and Africa (EMEA) 63.66% 83.33% 90.16% 88.86% 75.80%
Asia Pacific 92.81% 95.14% 98.05% 93.54% 78.90%

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

Segment profitability ratio Reportable segment The company
Segment profit margin Americas Americas segment profit margin ratio deteriorated from 2014 to 2015 and from 2015 to 2016.
Europe, Middle East, and Africa (EMEA) Europe, Middle East, and Africa (EMEA) segment profit margin ratio deteriorated from 2014 to 2015 and from 2015 to 2016.
Asia Pacific Asia Pacific segment profit margin ratio deteriorated from 2014 to 2015 and from 2015 to 2016.

Segment Profit Margin: Americas

Yahoo! Inc.; Americas; segment profit margin calculation

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Selected Financial Data (US$ in thousands)
Revenue ex-TAC 2,709,615 3,188,045 3,351,316 3,322,528 3,279,122
Revenue 4,172,836 3,976,770 3,517,861 3,481,502 3,461,633
Segment Profitability Ratio
Segment profit margin1 64.93% 80.17% 95.27% 95.43% 94.73%

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

1 2016 Calculation
Segment profit margin = 100 × Revenue ex-TAC ÷ Revenue
= 100 × 2,709,615 ÷ 4,172,836 = 64.93%

Segment profitability ratio Reportable segment The company
Segment profit margin Americas Americas segment profit margin ratio deteriorated from 2014 to 2015 and from 2015 to 2016.

Segment Profit Margin: Europe, Middle East, and Africa (EMEA)

Yahoo! Inc.; Europe, Middle East, and Africa (EMEA); segment profit margin calculation

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Selected Financial Data (US$ in thousands)
Revenue ex-TAC 253,221 286,362 337,966 342,271 357,831
Revenue 397,768 343,646 374,833 385,186 472,061
Segment Profitability Ratio
Segment profit margin1 63.66% 83.33% 90.16% 88.86% 75.80%

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

1 2016 Calculation
Segment profit margin = 100 × Revenue ex-TAC ÷ Revenue
= 100 × 253,221 ÷ 397,768 = 63.66%

Segment profitability ratio Reportable segment The company
Segment profit margin Europe, Middle East, and Africa (EMEA) Europe, Middle East, and Africa (EMEA) segment profit margin ratio deteriorated from 2014 to 2015 and from 2015 to 2016.

Segment Profit Margin: Asia Pacific

Yahoo! Inc.; Asia Pacific; segment profit margin calculation

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Selected Financial Data (US$ in thousands)
Revenue ex-TAC 555,513 616,380 711,320 761,139 830,707
Revenue 598,531 647,885 725,439 813,692 1,052,872
Segment Profitability Ratio
Segment profit margin1 92.81% 95.14% 98.05% 93.54% 78.90%

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

1 2016 Calculation
Segment profit margin = 100 × Revenue ex-TAC ÷ Revenue
= 100 × 555,513 ÷ 598,531 = 92.81%

Segment profitability ratio Reportable segment The company
Segment profit margin Asia Pacific Asia Pacific segment profit margin ratio deteriorated from 2014 to 2015 and from 2015 to 2016.

Segment Return on Assets (Segment ROA)

Yahoo! Inc., ROA by reportable segment

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Americas 241.24% 220.12% 242.25% 246.47% 220.80%
Europe, Middle East, and Africa (EMEA) 892.88% 843.73% 975.40% 761.01% 602.25%
Asia Pacific 951.76% 947.77% 1,021.26% 797.25% 587.76%

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

Segment profitability ratio Reportable segment The company
Segment ROA Americas Americas segment ROA deteriorated from 2014 to 2015 but then improved from 2015 to 2016 not reaching 2014 level.
Europe, Middle East, and Africa (EMEA) Europe, Middle East, and Africa (EMEA) segment ROA deteriorated from 2014 to 2015 but then slightly improved from 2015 to 2016.
Asia Pacific Asia Pacific segment ROA deteriorated from 2014 to 2015 but then slightly improved from 2015 to 2016.

Segment ROA: Americas

Yahoo! Inc.; Americas; segment ROA calculation

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Selected Financial Data (US$ in thousands)
Revenue ex-TAC 2,709,615 3,188,045 3,351,316 3,322,528 3,279,122
Property and equipment, net 1,123,210 1,448,348 1,383,384 1,348,072 1,485,094
Segment Profitability Ratio
Segment ROA1 241.24% 220.12% 242.25% 246.47% 220.80%

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

1 2016 Calculation
Segment ROA = 100 × Revenue ex-TAC ÷ Property and equipment, net
= 100 × 2,709,615 ÷ 1,123,210 = 241.24%

Segment profitability ratio Reportable segment The company
Segment ROA Americas Americas segment ROA deteriorated from 2014 to 2015 but then improved from 2015 to 2016 not reaching 2014 level.

Segment ROA: Europe, Middle East, and Africa (EMEA)

Yahoo! Inc.; Europe, Middle East, and Africa (EMEA); segment ROA calculation

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Selected Financial Data (US$ in thousands)
Revenue ex-TAC 253,221 286,362 337,966 342,271 357,831
Property and equipment, net 28,360 33,940 34,649 44,976 59,416
Segment Profitability Ratio
Segment ROA1 892.88% 843.73% 975.40% 761.01% 602.25%

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

1 2016 Calculation
Segment ROA = 100 × Revenue ex-TAC ÷ Property and equipment, net
= 100 × 253,221 ÷ 28,360 = 892.88%

Segment profitability ratio Reportable segment The company
Segment ROA Europe, Middle East, and Africa (EMEA) Europe, Middle East, and Africa (EMEA) segment ROA deteriorated from 2014 to 2015 but then slightly improved from 2015 to 2016.

Segment ROA: Asia Pacific

Yahoo! Inc.; Asia Pacific; segment ROA calculation

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Selected Financial Data (US$ in thousands)
Revenue ex-TAC 555,513 616,380 711,320 761,139 830,707
Property and equipment, net 58,367 65,035 69,651 95,470 141,335
Segment Profitability Ratio
Segment ROA1 951.76% 947.77% 1,021.26% 797.25% 587.76%

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

1 2016 Calculation
Segment ROA = 100 × Revenue ex-TAC ÷ Property and equipment, net
= 100 × 555,513 ÷ 58,367 = 951.76%

Segment profitability ratio Reportable segment The company
Segment ROA Asia Pacific Asia Pacific segment ROA deteriorated from 2014 to 2015 but then slightly improved from 2015 to 2016.

Segment Asset Turnover

Yahoo! Inc., asset turnover by reportable segment

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Americas 3.72 2.75 2.54 2.58 2.33
Europe, Middle East, and Africa (EMEA) 14.03 10.13 10.82 8.56 7.95
Asia Pacific 10.25 9.96 10.42 8.52 7.45

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

Segment activity ratio Reportable segment The company
Segment asset turnover Americas Americas segment asset turnover ratio improved from 2014 to 2015 and from 2015 to 2016.
Europe, Middle East, and Africa (EMEA) Europe, Middle East, and Africa (EMEA) segment asset turnover ratio deteriorated from 2014 to 2015 but then improved from 2015 to 2016 exceeding 2014 level.
Asia Pacific Asia Pacific segment asset turnover ratio deteriorated from 2014 to 2015 but then improved from 2015 to 2016 not reaching 2014 level.

Segment Asset Turnover: Americas

Yahoo! Inc.; Americas; segment asset turnover calculation

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Selected Financial Data (US$ in thousands)
Revenue 4,172,836 3,976,770 3,517,861 3,481,502 3,461,633
Property and equipment, net 1,123,210 1,448,348 1,383,384 1,348,072 1,485,094
Segment Activity Ratio
Segment asset turnover1 3.72 2.75 2.54 2.58 2.33

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

1 2016 Calculation
Segment asset turnover = Revenue ÷ Property and equipment, net
= 4,172,836 ÷ 1,123,210 = 3.72

Segment activity ratio Reportable segment The company
Segment asset turnover Americas Americas segment asset turnover ratio improved from 2014 to 2015 and from 2015 to 2016.

Segment Asset Turnover: Europe, Middle East, and Africa (EMEA)

Yahoo! Inc.; Europe, Middle East, and Africa (EMEA); segment asset turnover calculation

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Selected Financial Data (US$ in thousands)
Revenue 397,768 343,646 374,833 385,186 472,061
Property and equipment, net 28,360 33,940 34,649 44,976 59,416
Segment Activity Ratio
Segment asset turnover1 14.03 10.13 10.82 8.56 7.95

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

1 2016 Calculation
Segment asset turnover = Revenue ÷ Property and equipment, net
= 397,768 ÷ 28,360 = 14.03

Segment activity ratio Reportable segment The company
Segment asset turnover Europe, Middle East, and Africa (EMEA) Europe, Middle East, and Africa (EMEA) segment asset turnover ratio deteriorated from 2014 to 2015 but then improved from 2015 to 2016 exceeding 2014 level.

Segment Asset Turnover: Asia Pacific

Yahoo! Inc.; Asia Pacific; segment asset turnover calculation

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Selected Financial Data (US$ in thousands)
Revenue 598,531 647,885 725,439 813,692 1,052,872
Property and equipment, net 58,367 65,035 69,651 95,470 141,335
Segment Activity Ratio
Segment asset turnover1 10.25 9.96 10.42 8.52 7.45

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

1 2016 Calculation
Segment asset turnover = Revenue ÷ Property and equipment, net
= 598,531 ÷ 58,367 = 10.25

Segment activity ratio Reportable segment The company
Segment asset turnover Asia Pacific Asia Pacific segment asset turnover ratio deteriorated from 2014 to 2015 but then improved from 2015 to 2016 not reaching 2014 level.

Revenue

Yahoo! Inc., revenue by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Americas 4,172,836 3,976,770 3,517,861 3,481,502 3,461,633
Europe, Middle East, and Africa (EMEA) 397,768 343,646 374,833 385,186 472,061
Asia Pacific 598,531 647,885 725,439 813,692 1,052,872
Total 5,169,135 4,968,301 4,618,133 4,680,380 4,986,566

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).


Revenue ex-TAC

Yahoo! Inc., revenue ex-tac by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Americas 2,709,615 3,188,045 3,351,316 3,322,528 3,279,122
Europe, Middle East, and Africa (EMEA) 253,221 286,362 337,966 342,271 357,831
Asia Pacific 555,513 616,380 711,320 761,139 830,707
Total 3,518,349 4,090,787 4,400,602 4,425,938 4,467,660

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).


Property and equipment, net

Yahoo! Inc., property and equipment, net by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Americas 1,123,210 1,448,348 1,383,384 1,348,072 1,485,094
Europe, Middle East, and Africa (EMEA) 28,360 33,940 34,649 44,976 59,416
Asia Pacific 58,367 65,035 69,651 95,470 141,335
Total 1,209,937 1,547,323 1,487,684 1,488,518 1,685,845

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).