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.

Common-Size Balance Sheet: Assets 

Yahoo! Inc., common-size consolidated balance sheet: assets

Microsoft Excel
Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012
Cash and cash equivalents 2.33 3.61 4.31 12.36 15.60
Short-term marketable securities 11.86 9.35 8.60 7.92 8.86
Accounts receivable, net of allowance 2.25 2.32 1.67 5.83 5.90
Prepaid expenses 0.15 0.19 0.21 0.61 0.43
Deferred income taxes 0.00 0.00 0.41 1.30 1.46
Foreign currency forward and option contract assets 0.02 0.19 0.20 1.27 0.03
Other receivables non-trade 0.07 0.37 0.13 0.22 0.21
Restricted cash 0.11 0.07 0.04 0.00 0.00
Income tax receivables 0.07 0.49 0.07 0.00 0.00
Other 0.03 0.03 0.02 0.39 0.55
Prepaid expenses and other current assets 0.46% 1.33% 1.08% 3.80% 2.69%
Current assets 16.90% 16.61% 15.65% 29.91% 33.05%
Long-term marketable securities 2.27 2.16 3.60 9.46 10.75
Alibaba Group Preference Shares 0.00 0.00 0.00 0.00 4.77
Property and equipment, net 2.52 3.42 2.40 8.86 9.86
Goodwill 0.86 1.79 8.33 27.85 22.37
Intangible assets, net 0.34 0.77 0.76 2.49 0.90
Deferred income taxes 0.04 0.05 0.04 0.14 0.81
Investments in privately-held companies 0.17 0.18 0.13 0.15 0.16
Hortonworks equity securities and warrants 0.13 0.36 0.33 0.00 0.00
Foreign currency forward and option contracts 0.00 0.00 0.13 0.00 0.00
Other 0.09 0.17 0.26 0.77 0.72
Other long-term assets and investments 0.43% 0.76% 0.89% 1.05% 1.69%
Investment in Alibaba Group 70.05 68.96 64.34 0.00 0.00
Investments in equity interests 6.64 5.54 4.02 20.39 16.61
Noncurrent assets 83.10% 83.39% 84.35% 70.09% 66.95%
Total assets 100.00% 100.00% 100.00% 100.00% 100.00%

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


Cash and cash equivalents
There is a consistent downward trend in cash and cash equivalents as a percentage of total assets, declining from 15.6% in 2012 to 2.33% in 2016, indicating a reduced cash position relative to overall assets over the period.
Short-term marketable securities
These fluctuate modestly but generally increase from 8.86% in 2012 to 11.86% in 2016, showing a growing preference for short-term liquid investments.
Accounts receivable, net of allowance
A significant drop occurred from 5.9% in 2012 to around 2.25% in 2016, with a sharp decline in 2014. This suggests improved collection efficiency or changes in sales mix impacting receivables.
Prepaid expenses and current assets
Prepaid expenses decreased steadily from 0.43% to 0.15%, and overall prepaid expenses and other current assets decline from 2.69% to 0.46%, indicating reduced prepayments or better matching of expenses to periods. The percentage of total current assets also fell markedly from 33.05% in 2012 to about 16.9% in 2016, suggesting a strategic shift toward higher noncurrent asset holdings.
Deferred income taxes
Deferred income taxes as a current asset decline from 1.46% in 2012 to nearly negligible by 2015-2016, while the long-term deferred tax asset also decreases from 0.81% to 0.04%, reflecting perhaps changes in tax positions or asset realizability.
Foreign currency forward and option contract assets
These assets fluctuate noticeably, peaking at 1.27% in 2013, then declining to almost zero by 2016, indicating reduced exposure or hedging activity in foreign currency instruments over time.
Other receivables and restricted cash
Other non-trade receivables remain low and variable, while restricted cash emerges from 0.04% in 2014 to 0.11% in 2016, reflecting the introduction of some cash restrictions or earmarked funds.
Long-term marketable securities
Long-term marketable securities show a sharp decline from 10.75% in 2012 to just over 2% by 2016, indicating a reduction in long-term liquid investments.
Alibaba Group Preference Shares and Investment in Alibaba Group
Alibaba Group preference shares were present at 4.77% in 2012 but disappeared afterwards. Instead, a substantial investment in Alibaba Group appears starting 2014 at 64.34% and further increasing to 70.05% by 2016, dominating the asset structure and suggesting a major strategic investment shift.
Property and equipment, net
The proportion of property and equipment to total assets declines sharply from 9.86% in 2012 to 2.52% in 2016, reflecting possible asset sales, write-offs, or reduced capital expenditure.
Goodwill and intangible assets
Goodwill experiences a dramatic reduction from 22.37% in 2012 to under 1% by 2016, highlighting significant impairment or divestitures related to acquisitions. Intangible assets also decrease from 0.9% to 0.34%, supporting the trend of asset write-downs or disposals.
Investments in equity interests
These investments decline from 16.61% in 2012 to around 6.64% in 2016, showing repositioning or disposals of equity holdings other than Alibaba Group.
Noncurrent vs current assets
Noncurrent assets increase as a proportion of total assets from 66.95% in 2012 to over 83% by 2016, while current assets decline considerably, indicating a strategic shift towards longer-term holdings and less liquidity.
Overall asset composition and trends
The asset structure changes markedly over five years, driven primarily by a significant increase in investment in Alibaba Group starting 2014 and decreases in cash, receivables, property, goodwill, and other investments. This reflects a focused investment strategy favoring a dominant equity holding and reduced diversification in other assets.