Splunk Inc
Ratios
USD
31.01.201431.01.201531.01.201631.01.201731.01.201831.01.2019
Profitability
ROA(8%)(17%)(18%)(21%)(9%)(6%)
ROC (Oper. Income/Debt+Equity)(10%)(27%)(34%)(43%)(16%)(8%)
ROTC (NI+Interest/Total Capital)(10%)(27%)(34%)(42%)(16%)(7%)
ROE (Return on Equity)(10%)(27%)(32%)(44%)(17%)(18%)
Margin Analysis
Gross Margin88%85%83%80%80%81%
SG&A Margin89%99%94%85%72%70%
EBITDA Margin(24%)(45%)(40%)(33%)(11%)(11%)
EBIT (Oper. Income) Margin(26%)(48%)(43%)(36%)(14%)(14%)
Income before XO Margin(26%)(48%)(42%)(37%)(15%)(15%)
Net Income Margin(26%)(48%)(42%)(37%)(15%)(15%)
Free Cash Flow Margin21%20%16%17%19%15%
Turnover
Total Asset Turnover0.3x0.4x0.4x0.6x0.6x0.4x
Fixed Asset Turnover19.5x9.0x5.0x5.7x8.1x11.4x
Accounts Receivable Turnover4x4x4x4x3x4x
Inventory Turnover (COGS)
Accounts Payable Turnover (COGS)17x18x23x25x23x17x
Short Term Liquidity
Current Ratio4.8x2.9x2.5x2.0x2.3x3.2x
Quick Ratio4.7x2.8x2.4x2.0x2.1x3.1x
Cash from Ops. To Curr Liab0.4x0.3x0.3x0.3x0.4x0.3x
Avg. Days Receivable Out.101d104d99d92d111d95d
Avg. Days Inventory Out.
Avg. Days Payable Out.21d20d16d14d16d22d
Avg. Cash Conversion Cycle
Long Term Solvency
Total Debt/Equity108%
Total Debt/Capital52%
LT Debt/Equity108%
LT Debt/Capital34%
Total Liabilities/Total Assets25%35%44%53%47%66%
Interest Coverage (EBIT/I)(122x)(21x)(6x)
EBITDA / Interest Exp.(110x)(16x)(5x)
(EBITDA-CAPEX) / Interest Exp.(126x)(19x)(5x)
Total Debt/EBITDA(8.0x)
Net Debt/EBITDA12.5x1.9x1.6x1.4x3.8x1.2x
Capex & Depreciation
Depreciation Expenses71321334148
Capital Expenditures(9)(14)(51)(45)(21)(23)
growth, % yoy3%50%268%(12%)(55%)(49%)
Asset Reinvestment Ratio1.4x1.1x2.5x1.4x0.5x0.5x
CAPEX/Sales3%3%8%5%2%1%
CAPEX/Total Assets1%1%3%3%1%1%