Red Hat Financial Statements Trends

Red Hat Inc -- USA Stock  

USD 142.71  2.64  1.88%

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 234.5 M, Cost of Revenue of 364.3 M or Earning Before Interest and Taxes EBIT of 350.6 M, but also many exotic indicators such as Interest Coverage of 29.6017, Long Term Debt to Equity of 0.6382 or Calculated Tax Rate of 32.3153. 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(87.6 M)(74.4 M)(29.3 M)
Decreasing
Slightly volatile
Total Assets4.2 B4.2 B2.9 B
Increasing
Slightly volatile
Current Assets1.9 B1.9 B1.4 B
Increasing
Slightly volatile
Assets Non Current2.7 B2.3 B1.5 B
Increasing
Slightly volatile
Cash and Equivalents1.7 B927.8 M731.8 M
Increasing
Slightly volatile
Cash and Equivalents USD1.1 B927.8 M683.4 M
Increasing
Slightly volatile
Total Debt762.4 M723.9 M648.3 M
Increasing
Slightly volatile
Debt Current670.6 M570 M534 M
Increasing
Slightly volatile
Debt Non Current851.7 M723.9 M665.3 M
Increasing
Slightly volatile
Total Debt USD851.7 M723.9 M655.1 M
Increasing
Slightly volatile
Deferred Revenue2 B1.7 B1.1 B
Increasing
Slightly volatile
Shareholders Equity1.6 B1.3 B1.2 B
Increasing
Slightly volatile
Shareholders Equity USD1.6 B1.3 B1.2 B
Increasing
Slightly volatile
Goodwill and Intangible Assets1.4 B1.2 B804.5 M
Increasing
Slightly volatile
Inventory940 K799 K816.5 K
Increasing
Stable
Investments1.3 B1.1 B765.5 M
Increasing
Slightly volatile
Investments Current330.8 M281.1 M267.1 M
Increasing
Slightly volatile
Investments Non Current925.3 M786.5 M498.4 M
Increasing
Slightly volatile
Total Liabilities3.3 B2.8 B1.7 B
Increasing
Slightly volatile
Current Liabilities1.6 B1.6 B1 B
Increasing
Slightly volatile
Liabilities Non Current1.5 B1.3 B630.7 M
Increasing
Slightly volatile
Trade and Non Trade Payables335.1 M284.8 M157 M
Increasing
Slightly volatile
Property Plant and Equipment Net196.3 M166.9 M121.6 M
Increasing
Slightly volatile
Trade and Non Trade Receivables599.7 M509.7 M316.5 M
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit1.3 B1.1 B559.1 M
Increasing
Slightly volatile
Tax Assets131.1 M111.5 M93.1 M
Increasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income234.5 M199.4 M130.6 M
Increasing
Slightly volatile
Cost of Revenue364.3 M309.6 M204.4 M
Increasing
Slightly volatile
Earning Before Interest and Taxes EBIT350.6 M298 M196.5 M
Increasing
Slightly volatile
Earning Before Interest and Taxes USD350.6 M298 M196.5 M
Increasing
Slightly volatile
Gross Profit2.1 B1.7 B1.1 B
Increasing
Slightly volatile
Interest Expense27.2 M23.1 M13.5 M
Increasing
Slightly volatile
Net Income337.2 M199.4 M138.5 M
Increasing
Slightly volatile
Net Income Common Stock234.5 M199.4 M130.6 M
Increasing
Slightly volatile
Net Income Common Stock USD234.5 M199.4 M130.6 M
Increasing
Slightly volatile
Net Income from Discontinued Operations12.2 M10.4 M10.5 M
Increasing
Slightly volatile
Operating Expenses1.7 B1.5 B943.2 M
Increasing
Slightly volatile
Operating Income338.9 M288 M180.8 M
Increasing
Slightly volatile
Revenues2.8 B2.1 B1.4 B
Increasing
Slightly volatile
Revenues USD2.4 B2.1 B1.3 B
Increasing
Slightly volatile
Research and Development Expense486.3 M413.3 M265.5 M
Increasing
Slightly volatile
Selling General and Administrative Expense1.2 B1 B668.4 M
Increasing
Slightly volatile
Weighted Average Shares177 M182.8 M186.2 M
Decreasing
Stable
Weighted Average Shares Diluted219 M186.1 M195.6 M
Decreasing
Very volatile
Income Tax Expense88.8 M75.5 M57.2 M
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(65.3 M)(55.5 M)(55 M)
Decreasing
Slightly volatile
Depreciation Amortization and Accretion89.5 M76.1 M62.2 M
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents(140.8 M)(119.7 M)(724.1 K)
Decreasing
Stable
Net Cash Flow Business Acquisitions and Disposals(148.8 M)(126.5 M)(124.2 M)
Decreasing
Slightly volatile
Issuance Purchase of Equity Shares(383.5 M)(326 M)(207.8 M)
Decreasing
Slightly volatile
Issuance Repayment of Debt Securities (2.2 M)(1.8 M)16.8 M
Increasing
Stable
Net Cash Flow from Financing(361.8 M)(307.6 M)(175 M)
Decreasing
Slightly volatile
Net Cash Flow from Investing(602.5 M)(512.1 M)(276.8 M)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals(385.1 M)(327.3 M)(122.9 M)
Decreasing
Slightly volatile
Net Cash Flow from Operations589.1 M716.1 M441.2 M
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (19 M)(16.1 M)(9.6 M)
Decreasing
Slightly volatile
Share Based Compensation195.6 M166.2 M85 M
Increasing
Slightly volatile
Cash Beginning of Year1.2 B1 B698.2 M
Increasing
Slightly volatile
Cash End of Year1.1 B927.8 M719.7 M
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.61880.5260.4535
Increasing
Slightly volatile
Book Value per Share8.62127.3286.6347
Increasing
Slightly volatile
Current Ratio1.371.2011.582
Decreasing
Slightly volatile
Debt to Equity Ratio53.22.1145.1849
Increasing
Slightly volatile
Share Dilution Ratio1.19731.01771.0501
Decreasing
Very volatile
EBITDA Margin0.21410.1820.1222
Increasing
Slightly volatile
Earnings per Basic Share1.28241.090.6925
Increasing
Slightly volatile
Earnings per Diluted Share1.851.070.7215
Increasing
Slightly volatile
EPS Diluted Growth0.11150.09470.2763
Decreasing
Slightly volatile
EPS Growth0.13620.1158(0.1077)
Increasing
Slightly volatile
Earnings per Basic Share USD1.28241.090.6925
Increasing
Slightly volatile
Enterprise Value over EBIT45.882439.035.7602
Increasing
Slightly volatile
Enterprise Value over EBITDA36.865931.33627.6558
Increasing
Slightly volatile
Free Cash Flow per Share9.693.6132.5961
Increasing
Slightly volatile
Gross Margin0.99880.8490.8412
Increasing
Slightly volatile
Financial Leverage1.08540.92260.98
Decreasing
Very volatile
Leverage Ratio3.35622.85282.1653
Increasing
Slightly volatile
NCFO Growth0.19130.1626(6.1832)
Increasing
Slightly volatile
Net Income Growth0.10910.0927(0.1235)
Increasing
Slightly volatile
Profit Margin0.12140.097(0.0297)
Increasing
Slightly volatile
Price to Book Value17.38.9447.2647
Increasing
Slightly volatile
Price to Earnings Ratio75.6759.95455.7943
Increasing
Slightly volatile
Price to Sales Ratio8.935.8227.35
Decreasing
Stable
Revenue Growth0.16820.1430.2078
Decreasing
Slightly volatile
Return on Average Assets0.06190.0510.0228
Increasing
Slightly volatile
Return on Average Equity0.24930.1480.0858
Increasing
Slightly volatile
Return on Invested Capital0.29060.2470.2988
Increasing
Slightly volatile
Return on Sales0.17060.1450.0199
Increasing
Slightly volatile
Weighted Average Share Growth(0.0139)(0.0118)(0.0045)
Decreasing
Slightly volatile
Sales per Share13.207111.2267.1276
Increasing
Slightly volatile
Tax Efficiency0.83010.70560.7311
Decreasing
Very volatile
Tangible Assets Book Value per Share19.263516.37411.3237
Increasing
Slightly volatile
Total Assets Per Share26.979822.932816.2419
Increasing
Slightly volatile
Cash Flow Per Share4.64973.95232.5704
Increasing
Slightly volatile
Return on Investment16.684914.182211.8192
Increasing
Slightly volatile
Operating Margin19.1214.035914.7455
Increasing
Slightly volatile
Calculated Tax Rate32.315327.46830.2175
Decreasing
Slightly volatile
Receivables Turnover4.92524.18654.8367
Decreasing
Slightly volatile
PPandE Turnover14.203712.073211.3099
Increasing
Slightly volatile
Cash and Equivalents Turnover2.4382.07231.871
Increasing
Slightly volatile
Accounts Payable Turnover26.683622.68124.6269
Increasing
Stable
Accrued Expenses Turnover14.07811.966314.9699
Decreasing
Slightly volatile
Interest Coverage29.601725.1614120
Decreasing
Very volatile
Long Term Debt to Equity0.63820.54250.5694
Decreasing
Stable
Quick Ratio1.29681.10231.4486
Decreasing
Slightly volatile
Net Current Assets as percentage of Total Assets8.86957.539116.3996
Decreasing
Slightly volatile
Revenue to Assets0.58110.49390.432
Increasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets4.6 B3.9 B2.7 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA531 M374.1 M265.7 M
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD440.1 M374.1 M258.7 M
Increasing
Slightly volatile
Earnings before Tax323.4 M274.9 M187.9 M
Increasing
Slightly volatile
Average Equity1.6 B1.3 B1.2 B
Increasing
Slightly volatile
Enterprise Value22.8 B11.7 B9.1 B
Increasing
Slightly volatile
Free Cash Flow777.1 M660.6 M405.7 M
Increasing
Slightly volatile
Invested Capital1.4 B1.2 B761.3 M
Increasing
Slightly volatile
Invested Capital Average1.4 B1.2 B712.9 M
Increasing
Slightly volatile
Market Capitalization24.8 B11.9 B9.5 B
Increasing
Slightly volatile
Tangible Asset Value3.5 B3 B2.1 B
Increasing
Slightly volatile
Working Capital313.3 M313.3 M361 M
Increasing
Stable
Revenue Per Employee273.6 K232.6 K240.1 K
Increasing
Slightly volatile
Net Income Per Employee26.6 K22.6 K27.6 K
Decreasing
Slightly volatile