Switch to:

# Splunk Asset Turnover

: 0.10 (As of Apr. 2019)
View and export this data going back to 2012. Start your Free Trial

Asset Turnover measures how quickly a company turns over its asset through sales. It is calculated as Revenue divided by Total Assets. Splunk's Revenue for the three months ended in Apr. 2019 was \$425 Mil. Splunk's Total Assets for the quarter that ended in Apr. 2019 was \$4,453 Mil. Therefore, Splunk's asset turnover for the quarter that ended in Apr. 2019 was 0.10.

Asset Turnover is linked to ROE % through Du Pont Formula. Splunk's annualized ROE % for the quarter that ended in Apr. 2019 was -42.20%. It is also linked to ROA % through Du Pont Formula. Splunk's annualized ROA % for the quarter that ended in Apr. 2019 was -13.96%.

## Splunk Asset Turnover 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 Asset Turnover 0.39 0.48 0.58 0.68 0.54

Splunk Quarterly Data

 Jul14 Oct14 Jan15 Apr15 Jul15 Oct15 Jan16 Apr16 Jul16 Oct16 Jan17 Apr17 Jul17 Oct17 Jan18 Apr18 Jul18 Oct18 Jan19 Apr19 Asset Turnover 0.15 0.19 0.15 0.14 0.10

## Splunk Asset Turnover Calculation

Asset Turnover measures how quickly a company turns over its asset through sales.

Splunk's Asset Turnover for the fiscal year that ended in Jan. 2019 is calculated as

 Asset Turnover = Sales / Average Total Assets = Revenue (A: Jan. 2019 ) / ( (Total Assets (A: Jan. 2018 ) + Total Assets (A: Jan. 2019 )) / 2 ) = 1803.01 / ( (2139.445 + 4500.243) / 2 ) = 1803.01 / 3319.844 = 0.54

Splunk's Asset Turnover for the quarter that ended in Apr. 2019 is calculated as

 Asset Turnover = Sales / Average Total Assets = Revenue (Q: Apr. 2019 ) / ( (Total Assets (Q: Jan. 2019 ) + Total Assets (Q: Apr. 2019 )) / 2 ) = 424.85 / ( (4500.243 + 4406.744) / 2 ) = 424.85 / 4453.4935 = 0.10

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

Companies with low profit margins tend to have high asset turnover, while those with high profit margins have low asset turnover. Companies in the retail industry tend to have a very high turnover ratio.

Splunk  (NAS:SPLK) Asset Turnover Explanation

Asset Turnover is linked to Return on Equity (ROE) through Du Pont Formula.

Splunk's annulized ROE % for the quarter that ended in Apr. 2019 is

 ROE % (Q: Apr. 2019 ) = Net Income / Total Stockholders Equity = -621.716 / 1473.2415 = (Net Income / Revenue) * (Revenue / Total Assets) * (Total Assets / Total Stockholders Equity) = (-621.716 / 1699.4) * (1699.4 / 4453.4935) * (4453.4935/ 1473.2415) = Net Margin % * Asset Turnover * Leverage Ratio = -36.58 % * 0.3816 * 3.0229 = ROA % * Leverage Ratio = -13.96 % * 3.0229 = -42.20 %

Note: The Net Income data used here is four times the quarterly (Apr. 2019) net income data. The Revenue data used here is four times the quarterly (Apr. 2019) revenue data.

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

It is also linked to Return on Assets (ROA) through Du Pont Formula:

Splunk's annulized ROA % for the quarter that ended in Apr. 2019 is

 ROA % (Q: Apr. 2019 ) = Net Income / Total Assets = -621.716 / 4453.4935 = (Net Income / Revenue) * (Revenue / Total Assets) = (-621.716 / 1699.4) * (1699.4 / 4453.4935) = Net Margin % * Asset Turnover = -36.58 % * 0.3816 = -13.96 %

Note: The Net Income data used here is four times the quarterly (Apr. 2019) net income data. The Revenue data used here is four times the quarterly (Apr. 2019) revenue data.

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

Be Aware

In the article Joining The Dark Side: Pirates, Spies and Short Sellers, James Montier reported that In their US sample covering the period 1968-2003, Cooper et al find that firms with low asset growth outperformed firms with high asset growth by an astounding 20% p.a. equally weighted. Even when controlling for market, size and style, low asset growth firms outperformed high asset growth firms by 13% p.a. Therefore a company with fast asset growth may underperform.

Therefore, it is a good sign if a company's asset turnover is consistent or even increases. If a company's asset grows faster than sales, its asset turnover will decline, which can be a warning sign.