Stock Analysis on Net

Yahoo! Inc. (NASDAQ:YHOO)

$22.49

This company has been moved to the archive! The financial data has not been updated since May 9, 2017.

Common-Size Balance Sheet: Assets
Quarterly Data

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Yahoo! Inc., common-size consolidated balance sheet: assets (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
Cash and cash equivalents
Short-term marketable securities
Accounts receivable, net
Prepaid expenses and other current assets
Current assets
Long-term marketable securities
Alibaba Group Preference Shares
Property and equipment, net
Goodwill
Intangible assets, net
Other long-term assets and investments
Investment in Alibaba Group
Investments in equity interests
Noncurrent assets
Total assets

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


Cash and Cash Equivalents
The proportion of cash and cash equivalents relative to total assets shows a general decline over the period. It peaked at 37.04% in September 2012, followed by a sharp drop and remained mostly below 5% from 2014 onwards, stabilizing around 2-3% by early 2017.
Short-term Marketable Securities
The percentage of short-term marketable securities fluctuated but generally remained within the 3%-12% range, with some volatility observed around 2014 when there was a dip to around 1.48% in September 2014. It picked up afterwards, showing a tendency to increase through 2016 and early 2017.
Accounts Receivable, Net
Accounts receivable as a portion of total assets decreased significantly starting in late 2013, from approximately 5-6% to below 2% by 2014. It stayed low and relatively stable around 1.5% to 2.4% through the end of the reporting period.
Prepaid Expenses and Other Current Assets
This item fluctuated mildly, peaking at nearly 6% in mid-2013 but then declining steadily to less than 0.5% by the end of 2016 and early 2017. The trend indicates diminished reliance or lower balances in prepaid expenses over time.
Current Assets
Current assets as a percentage of total assets exhibited a substantial decline between 2012 and 2014, from over 47% at its peak down to around 14-18% post-2014. This indicates a shift in the asset composition from liquid or short-term assets to other asset types.
Long-term Marketable Securities
Long-term marketable securities showed an initial rise, reaching approximately 14-15% of total assets in early to mid-2013, then a sharp decline by late 2014 where it dropped to about 2-3%, remaining relatively low thereafter. This suggests a reduction in longer-term liquid investments during this timeframe.
Alibaba Group Preference Shares
Data for Alibaba Group preference shares appear only for a few periods in 2012 and 2013, showing a modest percentage (approximately 3.9% to 5%), then ceasing to appear, indicating either divestment or reclassification following those periods.
Property and Equipment, Net
Property and equipment as a share of total assets declined sharply between 2012 and 2014, dropping from around 11% to below 3%. After 2014, the ratio fluctuated around 2-4%, showing a reduced emphasis on physical assets.
Goodwill
Goodwill dropped dramatically between 2013 and 2016, from a high of over 31% to under 1% by early 2017, suggesting significant impairment charges, divestitures, or write-offs impacting reported goodwill.
Intangible Assets, Net
Intangible assets maintained a small proportion throughout, mostly under 3%, with a slight decrease evident toward the end of the period, dropping from nearly 3% in 2013 to around 0.3% by early 2017.
Other Long-term Assets and Investments
This category remained relatively stable and minor, generally below 1.1% of total assets, with a slight declining trend towards the end of the timeline.
Investment in Alibaba Group
Investment in Alibaba Group emerged prominently starting in late 2014, quickly becoming a dominant asset component, rising from about 59% to a peak of 74% of total assets by late 2016, maintaining a strong presence through early 2017. This indicates a major strategic investment and a shift in asset concentration toward this holding.
Investments in Equity Interests
Equity investments showed a marked decline from over 33% in early 2012 down to around 5-6% by 2016 and early 2017, reflecting divestitures or reclassifications in the investment portfolio outside the Alibaba Group holding.
Noncurrent Assets
Noncurrent assets rose substantially from approximately 53% in 2012 to consistently above 80% from 2014 onward, indicating a strong shift towards long-term assets, driven mainly by the major Alibaba investment and decreased current assets.
Overall Asset Composition
The data reflect a significant transition over the five years. The company progressively reduced its holdings in cash, goodwill, property, and certain equity interests, reallocating capital heavily toward the investment in Alibaba Group. This has led to an increase in noncurrent assets as a share of total assets and a corresponding decrease in more liquid or physical assets.