GURUFOCUS.COM » STOCK LIST » Technology » Software » Hortonworks Inc (NAS:HDP) » Definitions » Altman Z-Score

Hortonworks (Hortonworks) Altman Z-Score : -2.63 (As of May. 06, 2024)


View and export this data going back to 2014. Start your Free Trial

What is Hortonworks Altman Z-Score?

The Altman Z-Score is a model designed to predict the likelihood of a company going bankrupt within the next two years. Created by American finance professor Edward Altman in 1968, the model is specifically designed for publicly traded manufacturing companies with assets greater than $1 million.

Hortonworks has a Altman Z-Score of -2.63, indicating it is in Distress Zones. This implies bankrupcy possibility in the next two years.

The zones of discrimination were as such:

When Altman Z-Score <= 1.8, it is in Distress Zones.
When Altman Z-Score >= 3, it is in Safe Zones.
When Altman Z-Score is between 1.8 and 3, it is in Grey Zones.

The historical rank and industry rank for Hortonworks's Altman Z-Score or its related term are showing as below:


Hortonworks Altman Z-Score Historical Data

The historical data trend for Hortonworks's Altman Z-Score can be seen below:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* Premium members only.

Hortonworks Altman Z-Score Chart

Hortonworks Annual Data
Trend Apr12 Apr13 Dec14 Dec15 Dec16 Dec17
Altman Z-Score
Get a 7-Day Free Trial - 4.94 -0.86 -5.51 -4.10

Hortonworks Quarterly Data
Apr12 Apr13 Jun14 Sep14 Dec14 Mar15 Jun15 Sep15 Dec15 Mar16 Jun16 Sep16 Dec16 Mar17 Jun17 Sep17 Dec17 Mar18 Jun18 Sep18
Altman Z-Score Get a 7-Day Free Trial Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only -5.35 -4.10 -2.05 -2.33 -1.30

Competitive Comparison of Hortonworks's Altman Z-Score

For the Software - Infrastructure subindustry, Hortonworks's Altman Z-Score, along with its competitors' market caps and Altman Z-Score data, can be viewed below:

* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap. Note that "N/A" values will not show up in the chart.


Hortonworks's Altman Z-Score Distribution in the Software Industry

For the Software industry and Technology sector, Hortonworks's Altman Z-Score distribution charts can be found below:

* The bar in red indicates where Hortonworks's Altman Z-Score falls into.



Hortonworks Altman Z-Score Calculation

Altman Z-Score model is an accurate forecaster of failure up to two years prior to distress. It can be considered the assessment of the distress of industrial corporations.

Hortonworks's Altman Z-Score for today is calculated with this formula:

Z=1.2*X1+1.4*X2+3.3*X3+0.6*X4+1.0*X5
=1.2*0.015+1.4*-3.1857+3.3*-0.5399+0.6*4.1532+1.0*1.1044
=-2.63

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency. GuruFocus does not calculate Altman Z-Score when X4 or X5 value is 0.

Trailing Twelve Months (TTM) ended in Sep. 2018:
Total Assets was $296.6 Mil.
Total Current Assets was $215.1 Mil.
Total Current Liabilities was $210.6 Mil.
Retained Earnings was $-944.9 Mil.
Pre-Tax Income was -31.073 + -40.487 + -41.739 + -46.843 = $-160.1 Mil.
Interest Expense was 0 + 0 + 0 + 0 = $0.0 Mil.
Revenue was 87.174 + 86.343 + 79.061 + 75.006 = $327.6 Mil.
Market Cap (Today) was $1,236.6 Mil.
Total Liabilities was $297.7 Mil.

* Note that for stock reported semi-annually or annually, GuruFocus uses latest annual data as the TTM data.

X1=Working Capital/Total Assets
=(Total Current Assets - Total Current Liabilities)/Total Assets
=(215.092 - 210.643)/296.609
=0.015

X2=Retained Earnings/Total Assets
=-944.894/296.609
=-3.1857

X3=Earnings Before Interest and Taxes/Total Assets
=(Pre-Tax Income - Interest Expense)/Total Assets
=(-160.142 - 0)/296.609
=-0.5399

X4=Market Value Equity/Book Value of Total Liabilities
=Market Cap/Total Liabilities
=1236.610/297.749
=4.1532

X5=Revenue/Total Assets
=327.584/296.609
=1.1044

The zones of discrimination were as such:

Distress Zones - 1.81 < Grey Zones < 2.99 - Safe Zones

Hortonworks has a Altman Z-Score of -2.63 indicating it is in Distress Zones.

Study by Altman found that companies that are in Distress Zone have more than 80% of chances of bankruptcy in two years.


Hortonworks  (NAS:HDP) Altman Z-Score Explanation

X1: The Working Capital/Total Assets (WC/TA) ratio is a measure of the net liquid assets of the firm relative to the total capitalization. Working capital is defined as the difference between current assets and current liabilities. Ordinarily, a firm experiencing consistent operating losses will have shrinking current assets in relation to total assets. Altman found this one proved to be the most valuable liquidity ratio comparing with the current ratio and the quick ratio. This is however the least significant of the five factors.

X2: Retained Earnings/Total Assets: the RE/TA ratio measures the leverage of a firm. Retained earnings is the account which reports the total amount of reinvested earnings and/or losses of a firm over its entire life. Those firms with high RE, relative to TA, have financed their assets through retention of profits and have not utilized as much debt.

X3, Earnings Before Interest and Taxes/Total Assets (EBIT/TA): This ratio is a measure of the true productivity of the firm's assets, independent of any tax or leverage factors. Since a firm's ultimate existence is based on the earning power of its assets, this ratio appears to be particularly appropriate for studies dealing with corporate failure. This ratio continually outperforms other profitability measures, including cash flow.

X4, Market Value of Equity/Book Value of Total Liabilities (MVE/TL): The measure shows how much the firm's assets can decline in value (measured by market value of equity plus debt) before the liabilities exceed the assets and the firm becomes insolvent.

X5, Revenue/Total Assets (S/TA): The capital-turnover ratio is a standard financial ratio illustrating the sales generating ability of the firm's assets.

Read more about Altman Z-Score and the original research.


Be Aware

Altman Z-Score does not apply to financial companies.


Hortonworks Altman Z-Score Related Terms

Thank you for viewing the detailed overview of Hortonworks's Altman Z-Score provided by GuruFocus.com. Please click on the following links to see related term pages.


Hortonworks (Hortonworks) Business Description

Traded in Other Exchanges
N/A
Address
Hortonworks Inc is a provider of data management software solutions that allows corporations to harness the power of big data. The firm's Data at Rest solution is an enterprise-scale platform built for interactive, real-time workloads to be executed simultaneously on a single data set. The Data in Motion solution provides customers the ability to ingest any type of data from multiple data sources. These solutions can centrally manage new and existing data types, run multiple applications simultaneously, and provide security, data governance, stability and scalability. The company derives revenue from subscriptions to software offerings and professional fees. A large majority of the firm's revenue is generated in the United States.
Executives
Martin Fink director C/O WESTERN DIGITAL CORPORATION, 5601 GREAT OAKS PARKWAY, SAN JOSE CA 95119
Scott Reasoner officer: See Remarks C/O QUEST SOFTWARE, INC. 5 POLARIS WAY ALISO VIEJO CA 92656
Peter H Fenton director 2480 SAND HILL ROAD, SUITE 200, MENLO PARK CA 94025
Scott E Gnau officer: Chief Technology Officer 17095 VIA DEL CAMPO, SAN DIEGO CA 92127
Scott Davidson officer: See Remarks 5470 GREAT AMERICA PARKWAY, SANTA CLARA CA 95054
Robert G Bearden director, officer: President & CEO I2 11701 LUNA ROAD DALLAS TX 75234
Kevin Klausmeyer director 2101 CITYWEST BLVD, HOUSTON TX 77042-2827
Paul J Cormier director C/O RED HAT, INC, 100 EAST DAVIE STREET, RALEIGH NC 27601
Michelangelo Volpi director C/O HORTONWORKS, INC., 3640 W. BAYSHORE RD., PALO ALTO CA 94303
Alexandre Balkanski 10 percent owner 2480 SAND HILL ROAD, SUITE 200, MENLO PARK CA 94025
Matt Cohler 10 percent owner 2480 SAND HILL ROAD, SUITE 200, MENLO PARK CA 94025
Kevin Harvey 10 percent owner 2480 SAND HILL ROAD, SUITE 200, MENLO PARK CA 94025
Bruce Dunlevie 10 percent owner 2480 SAND HILL ROAD, SUITE 200, MENLO PARK CA 94025
Steven M Spurlock 10 percent owner 2480 SAND HILL ROAD, SUITE 200, MENLO PARK CA 94025
J William Gurley 10 percent owner 2480 SAND HILL ROAD, SUITE 200, MENLO PARK CA 94025

Hortonworks (Hortonworks) Headlines