>
Switch to:

# Hortonworks ROC %

: -46.20% (As of Sep. 2018)
View and export this data going back to 2014. Start your Free Trial

ROC % measures how well a company generates cash flow relative to the capital it has invested in its business. It is also called ROIC %. Hortonworks's annualized return on capital (ROC %) for the quarter that ended in Sep. 2018 was -46.20%.

As of today (2021-01-25), Hortonworks's WACC % is 0.00%. Hortonworks's ROC % is 0.00% (calculated using TTM income statement data). Hortonworks earns returns that do not match up to its cost of capital. It will destroy value as it grows.

## Hortonworks ROC % Historical Data

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

 Hortonworks Annual Data Apr12 Apr13 Dec14 Dec15 Dec16 Dec17 ROC % -532.85 -399.67 -153.16 -135.35 -83.16

## Hortonworks ROC % Calculation

Hortonworks's annualized Return on Capital (ROC %) for the fiscal year that ended in Dec. 2017 is calculated as:

 ROC % (A: Dec. 2017 ) = NOPAT / Average Invested Capital = Operating Income * ( 1 - Tax Rate % ) / ( (Invested Capital (A: Dec. 2016 ) + Invested Capital (A: Dec. 2017 )) / count ) = -198.849 * ( 1 - -1.23% ) / ( (211.359 + 272.783) / 2 ) = -201.2948427 / 242.071 = -83.16 %

where

 Invested Capital (A: Dec. 2016 ) = Total Assets - Accounts Payable & Accrued Expense - Excess Cash = Total Assets - Accounts Payable & Accrued Expense - ( Cash, Cash Equivalents, Marketable Securities - max(0, Total Current Liabilities - Total Current Assets + Cash, Cash Equivalents, Marketable Securities )) = 235.836 - 18.501 - ( 85.096 - max(0, 166.319 - 172.295 + 85.096 )) = 211.359

 Invested Capital (A: Dec. 2017 ) = Total Assets - Accounts Payable & Accrued Expense - Excess Cash = Total Assets - Accounts Payable & Accrued Expense - ( Cash, Cash Equivalents, Marketable Securities - max(0, Total Current Liabilities - Total Current Assets + Cash, Cash Equivalents, Marketable Securities )) = 250.733 - 17.082 - ( 72.512 - max(0, 234.466 - 195.334 + 72.512 )) = 272.783

Hortonworks's annualized Return on Capital (ROC %) for the quarter that ended in Sep. 2018 is calculated as:

 ROC % (Q: Sep. 2018 ) = NOPAT / Average Invested Capital = Operating Income * ( 1 - Tax Rate % ) / ( (Invested Capital (Q: Jun. 2018 ) + Invested Capital (Q: Sep. 2018 )) / count ) = -126.92 * ( 1 - -1.61% ) / ( (281.504 + 276.755) / 2 ) = -128.963412 / 279.1295 = -46.20 %

where

 Invested Capital (Q: Jun. 2018 ) = Total Assets - Accounts Payable & Accrued Expense - Excess Cash = Total Assets - Accounts Payable & Accrued Expense - ( Cash, Cash Equivalents, Marketable Securities - max(0, Total Current Liabilities - Total Current Assets + Cash, Cash Equivalents, Marketable Securities )) = 291.377 - 15.055 - ( 81.445 - max(0, 212.47 - 207.288 + 81.445 )) = 281.504

 Invested Capital (Q: Sep. 2018 ) = Total Assets - Accounts Payable & Accrued Expense - Excess Cash = Total Assets - Accounts Payable & Accrued Expense - ( Cash, Cash Equivalents, Marketable Securities - max(0, Total Current Liabilities - Total Current Assets + Cash, Cash Equivalents, Marketable Securities )) = 296.609 - 15.405 - ( 101.299 - max(0, 210.643 - 215.092 + 101.299 )) = 276.755

Note: The Operating Income data used here is four times the quarterly (Sep. 2018) data.

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

Hortonworks  (NAS:HDP) ROC % Explanation

ROC % measures how well a company generates cash flow relative to the capital it has invested in its business. It is also called ROIC %. The reason book values of debt and equity are used is because the book values are the capital the company received when issuing the debt or receiving the equity investments.

There are four key components to this definition. The first is the use of operating income or EBIT rather than net income in the numerator. The second is the tax adjustment to this operating income or EBIT, computed as a hypothetical tax based on an effective or marginal tax rate. The third is the use of book values for invested capital, rather than market values. The final is the timing difference; the capital invested is from the end of the prior year whereas the operating income or EBIT is the current year's number.

Why is ROC % important?

Because it costs money to raise capital. A firm that generates higher returns on investment than it costs the company to raise the capital needed for that investment is earning excess returns. A firm that expects to continue generating positive excess returns on new investments in the future will see its value increase as growth increases, whereas a firm that earns returns that do not match up to its cost of capital will destroy value as it grows.

As of today, Hortonworks's WACC % is 0.00%. Hortonworks's ROC % is 0.00% (calculated using TTM income statement data). Hortonworks earns returns that do not match up to its cost of capital. It will destroy value as it grows.

Be Aware

Like ROE % and ROA %, ROC % is calculated with only 12 months of data. Fluctuations in the company's earnings or business cycles can affect the ratio drastically. It is important to look at the ratio from a long term perspective.