Yahoo Financial Statements Trends

This module enables investors to look at Yahoo various fundamental indicators over time in order to gain insight into the company future performance. Macroaxis historical fundamental analysis tools allow evaluation of not only typical financial statement drivers such as Cost of Revenue of 2.1 B, Gross Profit of 2.9 B or Net Income to Non Controlling Interests of 8 M, but also many exotic indicators such as Interest Coverage of 1.0589, Long Term Debt to Equity of 0.0425 or Calculated Tax Rate of 987650 B. This module is a perfect complement to use when analyzing Yahoo Valuation or Volatility. It can also complement various Yahoo Technical models. See also analysis of Yahoo Correlation with competitors.

Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Accumulated Other Comprehensive Income16.6 B16.6 B5.8 B
Increasing
Slightly volatile
Total Assets54.7 B45.2 B25.3 B
Increasing
Slightly volatile
Current Assets7.8 B7.5 B5.3 B
Increasing
Slightly volatile
Assets Non Current37.7 B37.7 B19.3 B
Increasing
Slightly volatile
Cash and Equivalents6.6 B1.6 B2.1 B
Increasing
Slightly volatile
Cash and Equivalents USD1.6 B1.6 B1.7 B
Increasing
Slightly volatile
Total Debt1.3 B1.2 B682.2 M
Increasing
Slightly volatile
Debt Current749.6 M749.6 M749.6 M
Steady
Stable
Debt Non Current1.2 B1.2 B624.7 M
Increasing
Slightly volatile
Total Debt USD1.2 B1.2 B678.6 M
Increasing
Slightly volatile
Deferred Revenue161.8 M161.8 M373.4 M
Decreasing
Slightly volatile
Shareholders Equity29 B29 B17.3 B
Increasing
Slightly volatile
Shareholders Equity USD29 B29 B17.3 B
Increasing
Slightly volatile
Goodwill and Intangible Assets1.2 B1.2 B3.4 B
Decreasing
Slightly volatile
Investments38.9 B38.9 B16.3 B
Increasing
Slightly volatile
Investments Current4.2 B4.2 B2.2 B
Increasing
Slightly volatile
Investments Non Current34.7 B34.7 B14.1 B
Increasing
Slightly volatile
Total Liabilities16.1 B16.1 B7.2 B
Increasing
Slightly volatile
Current Liabilities1.3 B1.3 B1.7 B
Increasing
Stable
Liabilities Non Current11.5 B11.5 B4.8 B
Increasing
Slightly volatile
Trade and Non Trade Payables208.7 M208.7 M163.2 M
Increasing
Slightly volatile
Property Plant and Equipment Net1.5 B1.5 B1.4 B
Increasing
Slightly volatile
Trade and Non Trade Receivables1 B1 B966.3 M
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit4.6 B4.6 B4 B
Increasing
Slightly volatile
Tax Liabilities13.5 B13.5 B5 B
Increasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income(4.4 B)(4.4 B)367.3 M
Decreasing
Stable
Cost of Revenue2.1 B2.1 B2 B
Decreasing
Stable
Earning Before Interest and Taxes EBIT(4.4 B)(4.4 B)957 M
Decreasing
Stable
Earning Before Interest and Taxes USD(4.4 B)(4.4 B)957 M
Decreasing
Stable
Gross Profit2.9 B2.9 B3.3 B
Decreasing
Very volatile
Net Income(4.8 B)(4.4 B)327.5 M
Decreasing
Slightly volatile
Net Income Common Stock(4.4 B)(4.4 B)362.2 M
Decreasing
Stable
Net Income Common Stock USD(4.4 B)(4.4 B)362.2 M
Decreasing
Stable
Net Income to Non Controlling Interests8 M8 M8.7 M
Increasing
Stable
Operating Expenses7.6 B7.6 B4 B
Increasing
Slightly volatile
Operating Income(4.7 B)(4.7 B)(695.5 M)
Decreasing
Slightly volatile
Revenues5 B5 B5.3 B
Decreasing
Very volatile
Revenues USD5 B5 B5.3 B
Decreasing
Very volatile
Research and Development Expense1.2 B1.2 B1 B
Increasing
Slightly volatile
Selling General and Administrative Expense1.8 B1.8 B1.7 B
Increasing
Stable
Weighted Average Shares954.1 M939.1 M1.2 B
Decreasing
Slightly volatile
Weighted Average Shares Diluted939.1 M939.1 M1.2 B
Decreasing
Slightly volatile
Income Tax Expense(89.6 M)(89.6 M)594.8 M
Increasing
Stable

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(547.8 M)(547.8 M)(536.1 M)
Increasing
Very volatile
Depreciation Amortization and Accretion609.6 M609.6 M610.6 M
Increasing
Stable
Net Cash Flow or Change in Cash and Cash Equivalents(1 B)(1 B)(129.3 M)
Decreasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals(175.7 M)(175.7 M)904.6 M
Increasing
Stable
Issuance Purchase of Equity Shares(144.6 M)(144.6 M)(1.1 B)
Decreasing
Stable
Issuance Repayment of Debt Securities 1.4 B1.4 B1.4 B
Increasing
Slightly volatile
Net Cash Flow from Financing(377.3 M)(377.3 M)(993.7 M)
Decreasing
Stable
Net Cash Flow from Investing1.8 B1.8 B554.3 M
Increasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals2.4 B2.4 B167.1 M
Increasing
Stable
Net Cash Flow from Operations1.1 B(2.4 B)589.7 M
Decreasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (23.6 M)(23.6 M)(9.3 M)
Decreasing
Slightly volatile
Share Based Compensation443.3 M443.3 M340.2 M
Increasing
Stable
Cash Beginning of Year2.7 B2.7 B1.9 B
Increasing
Slightly volatile
Cash End of Year1.6 B1.6 B1.8 B
Increasing
Stable

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.1060.1060.3336
Decreasing
Slightly volatile
Book Value per Share30.78530.78516.3668
Increasing
Slightly volatile
Current Ratio6.145.8773.4993
Increasing
Slightly volatile
Debt to Equity Ratio0.040.5550.2974
Increasing
Stable
Share Dilution Ratio1.00651.00651.0193
Decreasing
Slightly volatile
EBITDA Margin(0.0615)(0.773)0.3702
Decreasing
Very volatile
Earnings per Basic Share(4.64)(4.64)0.1523
Decreasing
Slightly volatile
Earnings per Diluted Share(5.08)(4.64)0.0946
Decreasing
Slightly volatile
EPS Diluted Growth(0.9538)(0.9538)0.6434
Decreasing
Stable
EPS Growth(0.9561)(0.9561)0.6738
Decreasing
Stable
Earnings per Basic Share USD(4.64)(4.64)0.1523
Decreasing
Slightly volatile
Enterprise Value over EBIT(7.0)(7.0)16.8462
Decreasing
Slightly volatile
Enterprise Value over EBITDA(8.165)(8.165)10.4267
Decreasing
Slightly volatile
Free Cash Flow per Share6.92(3.121)0.4123
Increasing
Very volatile
Gross Margin0.5820.5820.6289
Decreasing
Stable
Financial Leverage1.01.01.0
Steady
Stable
Leverage Ratio1.51871.51871.324
Increasing
Slightly volatile
NCFO Growth(3.101)(3.101)(1.208)
Decreasing
Slightly volatile
Net Income Growth(0.9686)(0.9686)0.654
Decreasing
Stable
Profit Margin(0.9674)(0.877)0.0697
Decreasing
Stable
Price to Book Value1.151.0812.2958
Decreasing
Slightly volatile
Price to Earnings Ratio118(7.168)36.7907
Decreasing
Slightly volatile
Price to Sales Ratio8.086.2876.6173
Decreasing
Very volatile
Revenue Growth0.06850.06850.0647
Decreasing
Slightly volatile
Return on Average Assets(0.004)(0.093)0.0567
Decreasing
Stable
Return on Average Equity(0.1522)(0.14)0.0586
Decreasing
Slightly volatile
Return on Invested Capital(0.109)(0.109)0.1673
Decreasing
Stable
Return on Sales(0.895)(0.895)0.2
Decreasing
Stable
Weighted Average Share Growth(0.0531)(0.0531)(0.035)
Decreasing
Slightly volatile
Sales per Share5.295.294.5223
Increasing
Slightly volatile
Tax Efficiency1.10631.10630.8038
Increasing
Slightly volatile
Tangible Assets Book Value per Share46.6946.6920.6565
Increasing
Slightly volatile
Total Assets Per Share47.791747.791723.9864
Increasing
Slightly volatile
Cash Flow Per Share(2.5199)(2.5199)0.1635
Decreasing
Slightly volatile
Return on Investment(13.5622)(13.5622)0.738
Decreasing
Slightly volatile
Operating Margin(6.15)(95.7992)(7.755)
Decreasing
Slightly volatile
Calculated Tax Rate922337.2 B922337.2 B227919.2 B
Increasing
Slightly volatile
Receivables Turnover4.2634.2635.5914
Decreasing
Slightly volatile
PPandE Turnover3.2743.2744.2483
Decreasing
Slightly volatile
Cash and Equivalents Turnover2.31092.31093.1871
Decreasing
Slightly volatile
Accounts Payable Turnover22.24422.24438.6046
Decreasing
Slightly volatile
Accrued Expenses Turnover9.04289.04287.904
Increasing
Slightly volatile
Interest Coverage1.05891.05891.0589
Steady
Stable
Long Term Debt to Equity0.04250.04250.0705
Decreasing
Slightly volatile
Quick Ratio5.53615.53613.2511
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets13.781813.781816.8622
Decreasing
Stable
Revenue to Assets0.10990.10990.3369
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets46.8 B46.8 B22.7 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA90.4 M(3.8 B)1.9 B
Decreasing
Very volatile
Earnings Before Interest Taxes and Depreciation Amortization USD(3.8 B)(3.8 B)1.6 B
Decreasing
Stable
Earnings before Tax(4.4 B)(4.4 B)957 M
Decreasing
Stable
Average Equity31.1 B31.1 B16.5 B
Increasing
Slightly volatile
Enterprise Value35 B31.3 B27.9 B
Increasing
Slightly volatile
Free Cash Flow(2.9 B)(2.9 B)(216.6 M)
Decreasing
Slightly volatile
Invested Capital34.1 B34.1 B16.5 B
Increasing
Slightly volatile
Invested Capital Average40.8 B40.8 B16 B
Increasing
Slightly volatile
Market Capitalization40.3 B31.4 B30.2 B
Increasing
Slightly volatile
Tangible Asset Value44 B44 B21.1 B
Increasing
Slightly volatile
Working Capital6.5 B6.2 B3.6 B
Increasing
Slightly volatile
Revenue Per Employee441.2 K441.2 K456 K
Decreasing
Slightly volatile
Net Income Per Employee(387.1 K)(387.1 K)23.5 K
Decreasing
Slightly volatile