Red Hat Financial Statements Trends

Red Hat Inc -- USA Stock  

USD 120.76  0.36  0.3%

This module enables investors to look at Red Hat 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 Consolidated Income of 199.8 M, Cost of Revenue of 306.8 M or Earning Before Interest and Taxes EBIT of 296.3 M, but also many exotic indicators such as Interest Coverage of 138, Long Term Debt to Equity of 0.5778 or Calculated Tax Rate of 29.9677. This module is a perfect complement to use when analyzing Red Hat Valuation or Volatility. It can also complement various Red Hat Technical models. Additionally take a look at analysis of Red Hat Correlation with competitors.

Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Accumulated Other Comprehensive Income(71.1 M)(74.4 M)(24.2 M)
Decreasing
Slightly volatile
Total Assets4.2 B3.8 B2.7 B
Increasing
Slightly volatile
Current Assets1.9 B1.9 B1.3 B
Increasing
Slightly volatile
Assets Non Current2.2 B2.3 B1.4 B
Increasing
Slightly volatile
Cash and Equivalents1.7 B927.8 M710.5 M
Increasing
Slightly volatile
Cash and Equivalents USD1 B927.8 M658.8 M
Increasing
Slightly volatile
Total Debt756.7 M723.9 M641.5 M
Increasing
Slightly volatile
Debt Current670.6 M570 M531 M
Increasing
Slightly volatile
Debt Non Current751 M723.9 M652 M
Increasing
Slightly volatile
Total Debt USD751 M723.9 M641 M
Increasing
Slightly volatile
Deferred Revenue1.7 B1.7 B1 B
Increasing
Slightly volatile
Shareholders Equity1.4 B1.3 B1.2 B
Increasing
Slightly volatile
Shareholders Equity USD1.4 B1.3 B1.2 B
Increasing
Slightly volatile
Goodwill and Intangible Assets1.2 B1.2 B756.7 M
Increasing
Slightly volatile
Inventory940 K799 K817.9 K
Increasing
Stable
Investments962.6 M1.1 B715.9 M
Increasing
Slightly volatile
Investments Current261.3 M281.1 M260.2 M
Increasing
Slightly volatile
Investments Non Current701.3 M786.5 M455.7 M
Increasing
Slightly volatile
Total Liabilities2.8 B2.8 B1.5 B
Increasing
Slightly volatile
Current Liabilities1.6 B1.3 B972.6 M
Increasing
Slightly volatile
Liabilities Non Current1.3 B1.3 B560.8 M
Increasing
Slightly volatile
Trade and Non Trade Payables275 M284.8 M141.4 M
Increasing
Slightly volatile
Property Plant and Equipment Net178.4 M166.9 M116.3 M
Increasing
Slightly volatile
Trade and Non Trade Receivables514.6 M509.7 M293.3 M
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit1.1 B1.1 B494 M
Increasing
Slightly volatile
Tax Assets110.7 M111.5 M89.8 M
Increasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income199.8 M199.4 M122 M
Increasing
Slightly volatile
Cost of Revenue306.8 M309.6 M190.9 M
Increasing
Slightly volatile
Earning Before Interest and Taxes EBIT296.3 M298 M183.5 M
Increasing
Slightly volatile
Earning Before Interest and Taxes USD296.3 M298 M183.5 M
Increasing
Slightly volatile
Gross Profit2.1 B1.7 B1.1 B
Increasing
Slightly volatile
Interest Expense17.1 M23.1 M11.8 M
Increasing
Slightly volatile
Net Income303.8 M199.4 M130.7 M
Increasing
Slightly volatile
Net Income Common Stock199.8 M199.4 M122 M
Increasing
Slightly volatile
Net Income Common Stock USD199.8 M199.4 M122 M
Increasing
Slightly volatile
Net Income from Discontinued Operations12.2 M10.4 M10.5 M
Increasing
Slightly volatile
Operating Expenses1.4 B1.5 B877.3 M
Increasing
Slightly volatile
Operating Income283.2 M288 M167.2 M
Increasing
Slightly volatile
Revenues2.6 B2.1 B1.3 B
Increasing
Slightly volatile
Revenues USD2 B2.1 B1.2 B
Increasing
Slightly volatile
Research and Development Expense411.1 M413.3 M246.9 M
Increasing
Slightly volatile
Selling General and Administrative Expense1 B1 B620.3 M
Increasing
Slightly volatile
Weighted Average Shares177.5 M182.8 M186.5 M
Decreasing
Very volatile
Weighted Average Shares Diluted197.6 M186.1 M194.6 M
Decreasing
Stable
Income Tax Expense79.4 M75.5 M54.9 M
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(56.5 M)(55.5 M)(54.3 M)
Decreasing
Slightly volatile
Depreciation Amortization and Accretion80.2 M76.1 M60.3 M
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents147.9 M(119.7 M)33.3 M
Increasing
Stable
Net Cash Flow Business Acquisitions and Disposals(222.4 M)(126.5 M)(130.2 M)
Decreasing
Slightly volatile
Issuance Purchase of Equity Shares(432.8 M)(326 M)(202 M)
Decreasing
Slightly volatile
Issuance Repayment of Debt Securities 413.2 M(1.8 M)52.9 M
Increasing
Slightly volatile
Net Cash Flow from Financing(83.9 M)(307.6 M)(140.8 M)
Decreasing
Very volatile
Net Cash Flow from Investing(440.6 M)(512.1 M)(243.7 M)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals(166.2 M)(327.3 M)(87.6 M)
Decreasing
Slightly volatile
Net Cash Flow from Operations855.4 M716.1 M440.5 M
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (32.3 M)(16.1 M)(10.2 M)
Decreasing
Slightly volatile
Share Based Compensation158.7 M166.2 M75.1 M
Increasing
Slightly volatile
Cash Beginning of Year891.7 M1 B640.7 M
Increasing
Slightly volatile
Cash End of Year1 B927.8 M698.1 M
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.55630.5260.4423
Increasing
Slightly volatile
Book Value per Share7.55167.3286.4878
Increasing
Slightly volatile
Current Ratio1.31.2011.6079
Decreasing
Slightly volatile
Debt to Equity Ratio54.02.1145.5075
Increasing
Slightly volatile
Share Dilution Ratio1.06951.01771.0421
Decreasing
Slightly volatile
EBITDA Margin0.19630.1820.1157
Increasing
Slightly volatile
Earnings per Basic Share1.08421.090.6429
Increasing
Slightly volatile
Earnings per Diluted Share1.461.070.66
Increasing
Slightly volatile
EPS Diluted Growth0.0730.09470.2882
Decreasing
Slightly volatile
EPS Growth0.07810.1158(0.1312)
Increasing
Slightly volatile
Earnings per Basic Share USD1.08421.090.6429
Increasing
Slightly volatile
Enterprise Value over EBIT45.263239.035.4386
Increasing
Slightly volatile
Enterprise Value over EBITDA35.783731.33627.259
Increasing
Slightly volatile
Free Cash Flow per Share9.383.6132.4855
Increasing
Slightly volatile
Gross Margin0.89260.8490.8317
Increasing
Slightly volatile
Financial Leverage1.00470.92260.9781
Decreasing
Stable
Leverage Ratio2.65742.85282.0497
Increasing
Slightly volatile
NCFO Growth0.18950.1626(6.7121)
Increasing
Slightly volatile
Net Income Growth0.05290.0927(0.1462)
Increasing
Slightly volatile
Profit Margin0.11490.097(0.0408)
Increasing
Slightly volatile
Price to Book Value16.478.9447.0556
Increasing
Slightly volatile
Price to Earnings Ratio82.9559.95456.0543
Increasing
Slightly volatile
Price to Sales Ratio8.135.8227.4107
Decreasing
Stable
Revenue Growth0.16180.1430.2126
Decreasing
Slightly volatile
Return on Average Assets0.05730.0510.0201
Increasing
Slightly volatile
Return on Average Equity0.22350.1480.0785
Increasing
Slightly volatile
Return on Invested Capital0.32210.2470.3058
Increasing
Slightly volatile
Return on Sales0.15420.1450.0081
Increasing
Slightly volatile
Weighted Average Share Growth(0.0187)(0.0118)(0.0043)
Decreasing
Slightly volatile
Sales per Share10.957911.2266.5987
Increasing
Slightly volatile
Tax Efficiency0.74790.70560.7263
Decreasing
Stable
Tangible Assets Book Value per Share16.427916.37410.6666
Increasing
Slightly volatile
Total Assets Per Share22.974622.932815.3505
Increasing
Slightly volatile
Cash Flow Per Share3.86593.95232.39
Increasing
Slightly volatile
Return on Investment14.866814.182211.4708
Increasing
Slightly volatile
Operating Margin15.1414.035914.473
Increasing
Stable
Calculated Tax Rate29.967727.46830.251
Decreasing
Slightly volatile
Receivables Turnover4.47674.18654.8536
Decreasing
Slightly volatile
PPandE Turnover11.797412.073211.0457
Increasing
Slightly volatile
Cash and Equivalents Turnover2.20252.07231.8346
Increasing
Slightly volatile
Accounts Payable Turnover26.345122.68124.7608
Increasing
Slightly volatile
Accrued Expenses Turnover12.873711.966315.1198
Decreasing
Slightly volatile
Interest Coverage13825.1614137
Increasing
Stable
Long Term Debt to Equity0.57780.54250.5666
Decreasing
Slightly volatile
Quick Ratio1.26261.10231.4746
Decreasing
Slightly volatile
Net Current Assets as percentage of Total Assets12.76367.539117.4624
Decreasing
Slightly volatile
Revenue to Assets0.50760.49390.4207
Increasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets3.8 B3.9 B2.6 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA489.8 M374.1 M253.2 M
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD376.4 M374.1 M243.8 M
Increasing
Slightly volatile
Earnings before Tax279.1 M274.9 M176.9 M
Increasing
Slightly volatile
Average Equity1.4 B1.3 B1.2 B
Increasing
Slightly volatile
Enterprise Value18.7 B11.7 B8.5 B
Increasing
Slightly volatile
Free Cash Flow648.2 M660.6 M373.7 M
Increasing
Slightly volatile
Invested Capital1.2 B1.2 B709.1 M
Increasing
Slightly volatile
Invested Capital Average1 B1.2 B638.5 M
Increasing
Slightly volatile
Market Capitalization21.5 B11.9 B9.1 B
Increasing
Slightly volatile
Tangible Asset Value3 B3 B2 B
Increasing
Slightly volatile
Working Capital313.3 M549.4 M365 M
Increasing
Stable
Revenue Per Employee251.4 K232.6 K238.8 K
Increasing
Slightly volatile
Net Income Per Employee24.9 K22.6 K27.9 K
Decreasing
Slightly volatile