Company name:

Splunk Inc

  • IPO SHARE PRICE:
    $17.00
  • IPO DATE:
    April 19, 2012
  • TICKER:
    SPLK
  • MAIN STOCK EXCHANGE:
    NASDAQ
  • CURRENT HQ LOCATION:
    270 Brannan Street San Francisco California 94107
  • FISCAL YEAR END:
    January 31
  • INCORPORATION JURISDICTION:
    DE
  • ORGANIZED AS THE FOLLOWING LEGAL TYPE:
    Corporation
  • Investor Relations Webpage:
    Coming soon!
  • TAX RATE:
    USA federal corporate nominal income tax rate is 21%

Short Description

Splunk Inc

We are working hard and as soon as possible to provide company description soon. Feel free to reach out to request it sooner: improve@real-clear-investing.com

Statement of Cash Flow

(USD in thousand)
Selected Year:
31-Jan
2021
OPERATING ACTIVITIES
Cash received and spent on operating activites of business — buying materials, paying salaries, receiving payments from clients, etc
47.1% - Stock-based compensation
10.8% - Amortization of deferred commission costs
10.2% - Deferred revenue
7.5% - Amortization of debt original issue discount and issuance cost
7.1% - Depreciation and amortization
1.9% - Operating lease expense
0.3% - (Gain) loss on strategic investment
0.3% - Accrued expenses and other liabilities
0.1% - Disposal of property and equipment
SOURCEs
14.5% 7.1% 10.8% 10.2% 7.5% 47.1%
100 %
0%
USES
11.7% 12.2% 3.5% 69.1%
69.1% - Net income (loss)
12.2% - Deferred commissions
11.7% - Accounts receivable
3.5% - Prepaid expenses and other assets
1.7% - Repurchase of convertible senior notes attributable to the accreted interest related to debt discount
0.7% - Accounts payable
0.5% - (Gain) loss on on early reapyment of senior convertible notes
0.3% - Accrued compensation and employee benefits
0.3% - Deferred income taxes
0.1% - (Accretion) amortization of investment discount premium net
Selected Year:
Last Twelve Months LTM
Last Quarter Annualized LQA
Net income (loss)
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
($275,577) ($336,668) ($907,980) ($907,980) ($558,192)
Depreciation and amortization
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
52,430 67,661 93,666 93,666 105,588
Accelerated depreciation of property and equipment
-
-
-
-
$45,679
$45,679
$45,679
-
- - - - -
Operating lease expense
-
-
-
-
-
-
-
-
- 1,198 25,410 25,410 38,508
Amortization of deferred commission costs
-
-
-
-
-
-
$45,679
$45,679
77,867 104,353 142,095 142,095 171,512
Amortization of (discount) premium on investments
-
-
$45,679
$45,679
$45,679
$45,679
$45,679
-
- - - - -
Amortization of debt original issue discount and issuance cost Amortization of debt original issue discount and issuance cost
-
-
-
-
-
-
$45,679
$45,679
28,019 80,156 98,977 98,977 109,288
Facility exit charge
-
-
-
-
$45,679
-
-
-
- - - - -
Stock-based compensation
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
441,930 545,424 618,655 618,655 664,696
(Accretion) amortization of investment discount premium net (Accretion) amortization of investment discount premium net
-
-
-
-
-
-
-
$45,679
(4,743) (9,553) (667) (667) 892
Excess tax benefit related to stock-options compensation Excess tax benefit related to stock-options compensation
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
-
- - - - -
Deferred income taxes
-
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
(4,064) (6,120) (3,590) (3,590) (6,324)
Asset impairments
-
$45,679
$45,679
$45,679
-
-
-
-
- - - - -
Disposal of property and equipment
-
-
-
-
-
-
-
$45,679
- 1,974 1,045 1,045 256
(Gain) loss on strategic investment
-
-
-
-
-
-
-
-
- - 4,500 4,500 18,000
(Gain) loss on on early reapyment of senior convertible notes (Gain) loss on on early reapyment of senior convertible notes
-
-
-
-
-
-
-
-
- - (6,952) (6,952) -
Repurchase of convertible senior notes attributable to the accreted interest related to debt discount Repurchase of convertible senior notes attributable to the accreted interest related to debt discount
-
-
-
-
-
-
-
-
- - (22,149) (22,149) -
Change in fair value of preferred stock warrants
$45,679
$45,679
$45,679
-
-
-
-
-
- - - - -
Non-cash facility exit adjustment
-
-
-
-
-
$45,679
$45,679
$45,679
- - - - -
Accounts receivable
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
(220,940) (679,891) (153,724) (153,724) (1,378,468)
Prepaid expenses and other assets
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
6,970 (78,582) (45,476) (45,476) (124,080)
Accounts payable
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
9,240 (5,441) (9,082) (9,082) (15,612)
Accrued compensation and employee benefits
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
81,213 58,898 (3,805) (3,805) (16,460)
Deferred commissions
-
-
-
-
-
-
$45,679
$45,679
(130,485) (149,426) (160,001) (160,001) (240,920)
Accrued expenses and other liabilities
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
30,751 (187) 3,814 3,814 69,244
Deferred revenue
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
203,843 119,766 134,402 134,402 1,067,008
Net cash provided by (used in) operating activities
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$296,454 ($287,636) ($190,862) ($190,862) ($95,064)
Selected Year:
31-Jan
2021
INVESTING ACTIVITIES
Cash spent on acquiring plant, equipment and other businesses, cash recei0 from sale of plant, equipment and subsidiaries as well cash parked temporarily in different securities - government bonds typically
100.0% - Maturities of investment securities
SOURCEs
100.0%
100 %
0%
USES
80.0% 3.7% 8.7% 5.7%
8.7% - Purchases of investment securities
5.7% - Acquisitions
3.7% - (Purchase) sale of property and equipment
1.5% - Capitalized internal-use software development costs
0.3% - Other investing activities
Selected Year:
Last Twelve Months LTM
Last Quarter Annualized LQA
(Increase) decrease in restricted cash and deposits
$45,679
$45,679
$45,679
-
-
-
-
-
- - - - -
Purchases of investment securities
-
-
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
(1,109,852) (1,086,317) (87,135) (87,135) -
Maturities of investment securities
-
-
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
754,138 1,080,812 995,878 995,878 1,010,232
(Purchase) sale of property and equipment
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
(23,160) (101,119) (37,107) (37,107) (35,200)
Capitalized internal-use software development costs
-
-
-
-
-
-
-
$45,679
- (2,589) (14,602) (14,602) (15,596)
Acquisitions
-
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
(394,910) (594,870) (56,383) (56,383) (178,500)
Other investing activities
-
-
-
$45,679
$45,679
$45,679
$45,679
$45,679
(5,494) (3,898) (3,461) (3,461) -
Net cash provided by (used in) investing activities
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
($779,278) ($707,981) $797,190 $797,190 $780,936
Selected Year:
31-Jan
2021
FINANCING ACTIVITIES
Items in this group are concerned with borrowing funds, repaying debt, issuing equity, buying back shares, etc.
93.7% - Issuance of senior convertible notes
6.0% - Proceeds (payments) related to employee stock compensation plans (ESPP)
0.3% - Proceeds from issuance of common stock upon exercise of stock options
SOURCEs
93.7% 6.0%
100 %
0%
USES
28.8% 10.6% 50.3% 10.3%
50.3% - Partial repurchase of convertible senior notes
10.6% - Employee withholding taxes paid on share-based compensation
10.3% - Purchase of capped calls
Selected Year:
Last Twelve Months LTM
Last Quarter Annualized LQA
Initial Public Offering (IPO) net
$45,679
-
$45,679
-
-
-
-
-
- - - - -
Secondary (Follow-on) Public Offering net
-
$45,679
-
$45,679
-
-
-
-
- - - - -
Proceeds from issuance of common stock upon exercise of stock options Proceeds from issuance of common stock upon exercise of stock options
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
1,953 3,543 3,473 3,473 1,556
Proceeds from issuance of common stock upon early exercise of stock options Proceeds from issuance of common stock upon early exercise of stock options
$45,679
$45,679
-
-
-
-
-
-
- - - - -
Proceeds from exercise of warrants
$45,679
$45,679
$45,679
-
-
-
-
-
- - - - -
Proceeds (payments) related to employee stock compensation plans (ESPP) Proceeds (payments) related to employee stock compensation plans (ESPP)
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
46,342 60,383 79,949 79,949 142,940
Borrowing under term debt
-
$45,679
-
-
-
-
-
-
- - - - -
Repayment of term debt
$45,679
$45,679
$45,679
-
-
-
-
-
- - - - -
Issuance of senior convertible notes
-
-
-
-
-
-
$45,679
-
2,105,296 - 1,246,544 1,246,544 -
Partial repurchase of convertible senior notes
-
-
-
-
-
-
-
-
- - (668,929) (668,929) -
Repayments of lease financing obligations
-
-
-
-
$45,679
$45,679
$45,679
$45,679
(2,522) - - - -
Payments under sale and leaseback transactions
$45,679
$45,679
-
-
-
-
-
-
- - - - -
Employee withholding taxes paid on share-based compensation Employee withholding taxes paid on share-based compensation
-
$45,679
-
$45,679
$45,679
$45,679
$45,679
$45,679
(63,369) (164,160) (140,776) (140,776) (366,164)
Excess tax benefit from stock-based compensation
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
-
- - - - -
Purchase of capped calls
-
-
-
-
-
-
$45,679
-
(274,275) - (137,379) (137,379) -
Payment related to built-to-suit lease obligation
-
-
$45,679
-
-
-
-
-
- - - - -
Net cash provided by (used in) financing activities
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$1,813,425 ($100,234) $382,882 $382,882 ($221,668)
Selected Year:
31-Jan
2021
NET CHANGE IN CASH
Grand Total for sum of cash flows coming from operations, investing and financing
$992,411,000
Selected Year:
Last Twelve Months LTM
Last Quarter Annualized LQA
Cash and equivalents - Beginning of period
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$545,947 $1,876,165 $778,653 - $6,609,052
Effect of changes in foreign exchange rates on cash
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
(383) (1,661) 3,201 - 11,000
(Decrease) increase in cash and cash equivalents
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
1,330,218 (1,097,512) 992,411 - 475,204
Cash and equivalents - End of period
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$45,679
$1,876,165 $778,653 $1,771,064 - $7,084,256