Splunk Inc Income Statement - Real Clear Investing - You World of Transparent Investing

Selected Quarter:

31-Jan
2021

Gross receipts in the form of cash (great!) and promises to pay (Account Receivables - not so great as some of them will never be collected but reality of business!) from all its customers

100%

	2015 31-Oct	2016 31-Jan	2016 30-Apr	2016 31-Jul	2016 31-Oct	2017 31-Jan	2017 30-Apr	2017 31-Jul	2017 31-Oct	2018 31-Jan	2018 30-Apr	2018 31-Jul	2018 31-Oct	2019 31-Jan	2019 30-Apr	2019 31-Jul	2019 31-Oct	2020 31-Jan	2020 30-Apr	2020 31-Jul	2020 31-Oct	Selected Quarter: 2021 31-Jan	Last Twelve Months LTM 2021 31-Jan	Last Quarter Annualized LQA 2021 31-Jan
License revenue	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	202,862	279,279	373,684	517,542	148,385	176,814	240,225	405,954	971,378	1,623,816
Maintenance and professional services	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	159,933	166,828	172,213	174,228	173,540	188,974	173,633	167,728	703,875	670,912
Cloud services	-	-	-	-	-	-	-	-	-	-	-	-	-	-	62,055	70,451	80,439	99,412	112,152	125,870	144,714	171,396	554,132	685,584
Total Revenue	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$424,850	$516,558	$626,336	$791,182	$434,077	$491,658	$558,572	$745,078	$2,229,385	$2,980,312

Selected Quarter:

31-Jan
2021

Cost (labor, materials, depreciation, overhead, etc) for delivering service or manufacturing a product that business sells

111.6%

	2015 31-Oct	2016 31-Jan	2016 30-Apr	2016 31-Jul	2016 31-Oct	2017 31-Jan	2017 30-Apr	2017 31-Jul	2017 31-Oct	2018 31-Jan	2018 30-Apr	2018 31-Jul	2018 31-Oct	2019 31-Jan	2019 30-Apr	2019 31-Jul	2019 31-Oct	2020 31-Jan	2020 30-Apr	2020 31-Jul	2020 31-Oct	Selected Quarter: 2021 31-Jan	Last Twelve Months LTM 2021 31-Jan	Last Quarter Annualized LQA 2021 31-Jan
License costs	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	5,682	5,936	5,796	6,702	6,066	5,474	5,009	4,315	20,864	17,260
Maintenance and services	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	57,815	57,217	60,978	68,151	69,061	66,850	68,417	69,863	274,191	279,452
Cloud services	-	-	-	-	-	-	-	-	-	-	-	-	-	-	32,326	35,155	41,045	52,985	53,490	59,728	63,354	75,718	252,290	302,872
Total cost of revenue	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	95,823	98,308	107,819	127,838	128,617	132,052	136,780	149,896	547,345	599,584
Gross profit	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	$329,027	$418,250	$518,517	$663,344	$305,460	$359,606	$421,792	$595,182	$1,682,040	$2,380,728
Sales and marketing	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	278,961	298,773	319,023	367,116	319,224	323,687	323,146	369,999	1,336,056	1,479,996
Research and development	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	129,290	134,110	158,887	197,513	192,124	197,297	190,222	211,383	791,026	845,532
General and administrative	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	65,762	72,264	88,092	106,484	82,724	78,081	73,941	100,398	335,144	401,592
Total operating expenses	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	474,013	505,147	566,002	671,113	594,072	599,065	587,309	681,780	2,462,226	2,727,120

Selected Quarter:

31-Jan
2021

Income after excluding Operating Expenses from Total Revenue

11.6%

Key metric that shows earnings potential of the company's business model

	2015 31-Oct	2016 31-Jan	2016 30-Apr	2016 31-Jul	2016 31-Oct	2017 31-Jan	2017 30-Apr	2017 31-Jul	2017 31-Oct	2018 31-Jan	2018 30-Apr	2018 31-Jul	2018 31-Oct	2019 31-Jan	2019 30-Apr	2019 31-Jul	2019 31-Oct	2020 31-Jan	2020 30-Apr	2020 31-Jul	2020 31-Oct	Selected Quarter: 2021 31-Jan	Last Twelve Months LTM 2021 31-Jan	Last Quarter Annualized LQA 2021 31-Jan
Operating income	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	($144,986)	($86,897)	($47,485)	($7,769)	($288,612)	($239,459)	($165,517)	($86,598)	($780,186)	($346,392)

Selected Quarter:

31-Jan
2021

Cost usually unrelated to delivering service or manufacturing a product that business sells

2.2%

	2015 31-Oct	2016 31-Jan	2016 30-Apr	2016 31-Jul	2016 31-Oct	2017 31-Jan	2017 30-Apr	2017 31-Jul	2017 31-Oct	2018 31-Jan	2018 30-Apr	2018 31-Jul	2018 31-Oct	2019 31-Jan	2019 30-Apr	2019 31-Jul	2019 31-Oct	2020 31-Jan	2020 30-Apr	2020 31-Jul	2020 31-Oct	Selected Quarter:	Last Twelve Months LTM 2021 31-Jan	Last Quarter Annualized LQA 2021 31-Jan
Other expense or income	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	(539)	(654)	(215)	(999)	(674)	5,917	(710)	(16,169)	(11,636)	(64,676)
Total non-operating income (expense)	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	(539)	(654)	(215)	(999)	(674)	5,917	(710)	(16,169)	(11,636)	(64,676)

Selected Quarter:

31-Jan
2021

Income after excluding Operating and Non-operating Expenses from Total Revenue

13.8%

Another income metric but unlike Operating Income it is closer to the ultimate income metric - Net Income by removing expenses that are not related to earning Revenue as they are supposed to be accidental and transitory

	2015 31-Oct	2016 31-Jan	2016 30-Apr	2016 31-Jul	2016 31-Oct	2017 31-Jan	2017 30-Apr	2017 31-Jul	2017 31-Oct	2018 31-Jan	2018 30-Apr	2018 31-Jul	2018 31-Oct	2019 31-Jan	2019 30-Apr	2019 31-Jul	2019 31-Oct	2020 31-Jan	2020 30-Apr	2020 31-Jul	2020 31-Oct	Selected Quarter: 2021 31-Jan	Last Twelve Months LTM 2021 31-Jan	Last Quarter Annualized LQA 2021 31-Jan
EBIT	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	($145,525)	($87,551)	($47,700)	($8,768)	($289,286)	($233,542)	($166,227)	($102,767)	($791,822)	($411,068)

Selected Quarter:

31-Jan
2021

Expenses driven mostly by company management's choices, nature of business (capital intensive vs not) about financing (debt vs equity) and legal structure

4.9%

	2015 31-Oct	2016 31-Jan	2016 30-Apr	2016 31-Jul	2016 31-Oct	2017 31-Jan	2017 30-Apr	2017 31-Jul	2017 31-Oct	2018 31-Jan	2018 30-Apr	2018 31-Jul	2018 31-Oct	2019 31-Jan	2019 30-Apr	2019 31-Jul	2019 31-Oct	2020 31-Jan	2020 30-Apr	2020 31-Jul	2020 31-Oct	Selected Quarter: 2021 31-Jan	Last Twelve Months LTM 2021 31-Jan	Last Quarter Annualized LQA 2021 31-Jan
Interest expense (income)	45,679	45,679	45,679	45,679	45,679	-	45,679	45,679	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Interest expense	-	-	-	-	-	-	-	-	45,679	45,679	45,679	45,679	45,679	45,679	(23,017)	(24,104)	(24,406)	(24,722)	(24,437)	(30,148)	(33,972)	(34,519)	(123,076)	(138,076)
Interest income	-	-	-	-	-	-	-	-	45,679	45,679	45,679	45,679	45,679	45,679	16,346	16,415	12,612	8,769	6,475	3,581	2,382	1,412	13,850	5,648
Total interest and other income or expenses	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	(7,210)	(8,343)	(12,009)	(16,952)	(18,636)	(20,650)	(32,300)	(49,276)	(120,862)	(197,104)
Income before income taxes	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	(152,196)	(95,240)	(59,494)	(24,721)	(307,248)	(260,109)	(197,817)	(135,874)	(901,048)	(543,496)
Income tax expense or benefit	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	45,679	3,233	5,632	(1,855)	(1,993)	(1,669)	1,213	3,714	3,674	6,932	14,696

Selected Quarter:

31-Jan
2021

Ultimate measure of Income - Net result after excluding all expenses from Total Revenue

18.7%

It is a residue that is left from Total Revenue after paying all kind of expenses and belongs to all equity holders in the company. Some of these shareholders such Non-controlling interest or Preferred equity gets their share before Common shareholders

	2015 31-Oct	2016 31-Jan	2016 30-Apr	2016 31-Jul	2016 31-Oct	2017 31-Jan	2017 30-Apr	2017 31-Jul	2017 31-Oct	2018 31-Jan	2018 30-Apr	2018 31-Jul	2018 31-Oct	2019 31-Jan	2019 30-Apr	2019 31-Jul	2019 31-Oct	2020 31-Jan	2020 30-Apr	2020 31-Jul	2020 31-Oct	Selected Quarter: 2021 31-Jan	Last Twelve Months LTM 2021 31-Jan	Last Quarter Annualized LQA 2021 31-Jan
Net income (loss)	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	$45,679	($155,429)	($100,872)	($57,639)	($22,728)	($305,579)	($261,322)	($201,531)	($139,548)	($907,980)	($558,192)

Basic shares outstanding as of certain dates reported by Company on its annual and quarterly filings, these numbers are NOT used calculation of basic EPS. They help to see share issuance by company in perspective

	2015 31-Oct	2016 23-Mar	2016 30-Apr	2016 31-Jul	2016 01-Dec	2017 21-Mar	2017 31-May	2017 30-Aug	2017 29-Nov	2018 22-Mar	2018 30-May	2018 29-Aug	2018 29-Nov	2019 18-Mar	2019 30-May	2019 29-Aug	2019 26-Nov	2020 19-Mar	2020 26-May	2020 28-Aug	2020 01-Dec	2021 19-Mar	2021 19-Mar	2021 19-Mar
Common	-	45,678,795	-	-	45,678,795	45,678,795	45,678,795	45,678,795	45,678,795	45,678,795	45,678,795	45,678,795	45,678,795	45,678,795	150,171,710	151,348,574	155,969,418	158,619,718	158,868,955	160,393,964	161,720,841	163,839,113	163,839,113	163,839,113

Selected Quarter:

31-Jan
2021

Net Income / Shares Outstanding = EPS before dilution or Basic EPS; Net Income/ ( Shares Outstanding + potentially available shares from conversion of various option instruments)

	2015 31-Oct	2016 31-Jan	2016 30-Apr	2016 31-Jul	2016 31-Oct	2017 31-Jan	2017 30-Apr	2017 31-Jul	2017 31-Oct	2018 31-Jan	2018 30-Apr	2018 31-Jul	2018 31-Oct	2019 31-Jan	2019 30-Apr	2019 31-Jul	2019 31-Oct	2020 31-Jan	2020 30-Apr	2020 31-Jul	2020 31-Oct	Selected Quarter: 2021 31-Jan	Last Twelve Months LTM 2021 31-Jan	Last Quarter Annualized LQA 2021 31-Jan
Net Income per basic share	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	($1.04)	($0.67)	($4.83)	($1.22)	($1.94)	($1.64)	($0.38)	($3.60)	($5.68)	($14.40)
Net Income per diluted share	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	$45,678,795.00	($1.04)	($0.67)	($4.83)	($1.22)	($1.94)	($1.64)	($0.38)	($3.60)	($5.68)	($14.40)

Splunk Inc

Short Description

Income Statement

License revenue

Cloud services

Maintenance and professional services

Sales and marketing

Research and development

General and administrative

Cloud services

Maintenance and services

License costs

Operating Income

Other expense or income

EBIT

Interest income

Income tax expense or benefit

Interest expense

Net income (loss)