Switch to:

# Splunk ROC %

: -13.79% (As of Oct. 2019)
View and export this data going back to 2012. Start your Free Trial

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

As of today (2020-01-19), Splunk's WACC % is 13.45%. Splunk's return on capital is -33.82% (calculated using TTM income statement data). Splunk earns returns that do not match up to its cost of capital. It will destroy value as it grows.

## Splunk ROC % Historical Data

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

 Splunk Annual Data Jan10 Jan11 Jan12 Jan13 Jan14 Jan15 Jan16 Jan17 Jan18 Jan19 ROC % 0.00 0.00 0.00 0.00 -144.62

 Splunk Quarterly Data Jan15 Apr15 Jul15 Oct15 Jan16 Apr16 Jul16 Oct16 Jan17 Apr17 Jul17 Oct17 Jan18 Apr18 Jul18 Oct18 Jan19 Apr19 Jul19 Oct19 ROC % -66.64 3.88 -120.76 -56.36 -13.79

## Splunk ROC % Calculation

Splunk's annualized Return on Capital (ROC) for the fiscal year that ended in Jan. 2019 is calculated as:

 Return on Capital (ROC) (A: Jan. 2019 ) = NOPAT / Average Invested Capital = Operating Income*(1-Tax Rate) / ( (Invested Capital (A: Jan. 2018 ) + Invested Capital (A: Jan. 2019 )) /2) = -251.173 * ( 1 - -4.71% ) / ( (-33.829 + 397.546) /2) = -263.0032483 / 181.8585 = -144.62 %

 Invested Capital (A: Jan. 2018 ) = Book Value of Debt + Book Value of Equity - Cash = Long-Term Debt & Capital Lease Obligation + Short-Term Debt & Capital Lease Obligation + Minority Interest + Total Stockholders Equity - Cash = 0 + 0 + 0 + 1131.321 - 1165.15 = -33.829

 Invested Capital (A: Jan. 2019 ) = Book Value of Debt + Book Value of Equity - Cash = Long-Term Debt & Capital Lease Obligation + Short-Term Debt & Capital Lease Obligation + Minority Interest + Total Stockholders Equity - Cash = 1634.474 + 0 + 0 + 1520.457 - 2757.385 = 397.546

Splunk's annualized Return on Capital (ROC) for the quarter that ended in Oct. 2019 is calculated as:

 Return on Capital (ROC) (Q: Oct. 2019 ) = NOPAT / Average Invested Capital = Operating Income*(1-Tax Rate) / ( (Invested Capital (Q: Jul. 2019 ) + Invested Capital (Q: Oct. 2019 )) /2) = -189.94 * ( 1 - 3.12% ) / ( (723.011 + 1945.223) /2) = -184.013872 / 1334.117 = -13.79 %

where

 Invested Capital (Q: {Q2}) = Book Value of Debt + Book Value of Equity - Cash = Long-Term Debt & Capital Lease Obligation + Short-Term Debt & Capital Lease Obligation + Minority Interest + Total Stockholders Equity - Cash = 1865.04 + 0 + 0 + 1433.84 - 2575.869 = 723.011

 Invested Capital (Q: Oct. 2019 ) = Book Value of Debt + Book Value of Equity - Cash = Long-Term Debt & Capital Lease Obligation + Short-Term Debt & Capital Lease Obligation + Minority Interest + Total Stockholders Equity - Cash = 1940.928 + 0 + 0 + 1826.117 - 1821.822 = 1945.223

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

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

Splunk  (NAS:SPLK) ROC % Explanation

Return on Capital 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 Return on Capital 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, Splunk's WACC % is 13.45%. Splunk's return on capital is {stock_data.stock.roic}}% (calculated using TTM income statement data). Splunk 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.