Stock Analysis on Net
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 Investments

Microsoft Excel

Adjustment to Net Income (Loss): Mark to Market Available-for-sale Securities

Yahoo! Inc., adjustment to net income (loss) attributable to Yahoo! Inc.

US$ in thousands

Microsoft Excel
12 months ended: Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Net income (loss) attributable to Yahoo! Inc. (as reported) (214,321) (4,359,082) 7,521,731 1,366,281 3,945,479
Add: Net change in unrealized gains (losses) on available-for-sale securities, net of tax 1,458,426 (5,166,421) 22,069,855 5,980 16,659
Net income (loss) attributable to Yahoo! Inc. (adjusted) 1,244,105 (9,525,503) 29,591,586 1,372,261 3,962,138

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

Adjusted Profitability Ratios: Mark to Market Available-for-sale Securities (Summary)

Yahoo! Inc., adjusted profitability ratios

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Net Profit Margin
Reported net profit margin -4.15% -87.74% 162.87% 29.19% 79.12%
Adjusted net profit margin 24.07% -191.73% 640.77% 29.32% 79.46%
Return on Equity (ROE)
Reported ROE -0.69% -15.01% 19.42% 10.45% 27.10%
Adjusted ROE 4.01% -32.80% 76.38% 10.50% 27.21%
Return on Assets (ROA)
Reported ROA -0.45% -9.64% 12.14% 8.13% 23.07%
Adjusted ROA 2.59% -21.07% 47.76% 8.17% 23.17%

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

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Yahoo! Inc. adjusted net profit margin ratio deteriorated from 2014 to 2015 but then slightly improved from 2015 to 2016.
Adjusted ROE A profitability ratio calculated as adjusted net income divided by shareholders’ equity. Yahoo! Inc. adjusted ROE deteriorated from 2014 to 2015 but then slightly improved from 2015 to 2016.
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. Yahoo! Inc. adjusted ROA deteriorated from 2014 to 2015 but then slightly improved from 2015 to 2016.

Yahoo! Inc., Profitability Ratios: Reported vs. Adjusted

Adjusted Net Profit Margin

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
As Reported
Selected Financial Data (US$ in thousands)
Net income (loss) attributable to Yahoo! Inc. (214,321) (4,359,082) 7,521,731 1,366,281 3,945,479
Revenue 5,169,135 4,968,301 4,618,133 4,680,380 4,986,566
Profitability Ratio
Net profit margin1 -4.15% -87.74% 162.87% 29.19% 79.12%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in thousands)
Adjusted net income (loss) attributable to Yahoo! Inc. 1,244,105 (9,525,503) 29,591,586 1,372,261 3,962,138
Revenue 5,169,135 4,968,301 4,618,133 4,680,380 4,986,566
Profitability Ratio
Adjusted net profit margin2 24.07% -191.73% 640.77% 29.32% 79.46%

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

2016 Calculations

1 Net profit margin = 100 × Net income (loss) attributable to Yahoo! Inc. ÷ Revenue
= 100 × -214,321 ÷ 5,169,135 = -4.15%

2 Adjusted net profit margin = 100 × Adjusted net income (loss) attributable to Yahoo! Inc. ÷ Revenue
= 100 × 1,244,105 ÷ 5,169,135 = 24.07%

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Yahoo! Inc. adjusted net profit margin ratio deteriorated from 2014 to 2015 but then slightly improved from 2015 to 2016.

Adjusted Return on Equity (ROE)

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
As Reported
Selected Financial Data (US$ in thousands)
Net income (loss) attributable to Yahoo! Inc. (214,321) (4,359,082) 7,521,731 1,366,281 3,945,479
Total Yahoo! Inc. stockholders’ equity 31,049,283 29,043,537 38,741,837 13,074,909 14,560,200
Profitability Ratio
ROE1 -0.69% -15.01% 19.42% 10.45% 27.10%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in thousands)
Adjusted net income (loss) attributable to Yahoo! Inc. 1,244,105 (9,525,503) 29,591,586 1,372,261 3,962,138
Total Yahoo! Inc. stockholders’ equity 31,049,283 29,043,537 38,741,837 13,074,909 14,560,200
Profitability Ratio
Adjusted ROE2 4.01% -32.80% 76.38% 10.50% 27.21%

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

2016 Calculations

1 ROE = 100 × Net income (loss) attributable to Yahoo! Inc. ÷ Total Yahoo! Inc. stockholders’ equity
= 100 × -214,321 ÷ 31,049,283 = -0.69%

2 Adjusted ROE = 100 × Adjusted net income (loss) attributable to Yahoo! Inc. ÷ Total Yahoo! Inc. stockholders’ equity
= 100 × 1,244,105 ÷ 31,049,283 = 4.01%

Profitability ratio Description The company
Adjusted ROE A profitability ratio calculated as adjusted net income divided by shareholders’ equity. Yahoo! Inc. adjusted ROE deteriorated from 2014 to 2015 but then slightly improved from 2015 to 2016.

Adjusted Return on Assets (ROA)

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
As Reported
Selected Financial Data (US$ in thousands)
Net income (loss) attributable to Yahoo! Inc. (214,321) (4,359,082) 7,521,731 1,366,281 3,945,479
Total assets 48,083,079 45,203,966 61,960,344 16,804,959 17,103,253
Profitability Ratio
ROA1 -0.45% -9.64% 12.14% 8.13% 23.07%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in thousands)
Adjusted net income (loss) attributable to Yahoo! Inc. 1,244,105 (9,525,503) 29,591,586 1,372,261 3,962,138
Total assets 48,083,079 45,203,966 61,960,344 16,804,959 17,103,253
Profitability Ratio
Adjusted ROA2 2.59% -21.07% 47.76% 8.17% 23.17%

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

2016 Calculations

1 ROA = 100 × Net income (loss) attributable to Yahoo! Inc. ÷ Total assets
= 100 × -214,321 ÷ 48,083,079 = -0.45%

2 Adjusted ROA = 100 × Adjusted net income (loss) attributable to Yahoo! Inc. ÷ Total assets
= 100 × 1,244,105 ÷ 48,083,079 = 2.59%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. Yahoo! Inc. adjusted ROA deteriorated from 2014 to 2015 but then slightly improved from 2015 to 2016.