Elastic N.V. Financial Ratios — ESTC Stock

Profitability (USD)

	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	04/30/2017	04/30/2018	04/30/2019	04/30/2020	04/30/2021	04/30/2022	04/30/2023	04/30/2024	04/30/2025	04/30/2026

Return on Common Equity (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Return on Assets (%)	- -	-32.21	-30.6	-25.93	-14.57	-15.58	-13.95	3.1	-4.47	12.8
Return on Capital (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Return on Invested Capital (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Gross Margin (%)	77.49	74.53	71.28	71.31	73.53	73.08	72.25	73.95	74.39	76.07
EBITDA Margin (%)	-49.92	-26.84	-35.21	-37.01	-18.45	-17.85	-15.68	-8.44	-2.86	-1.24
Operating Margin (%)	-53.5	-30.01	-37.31	-40.01	-21.28	-20.14	-17.58	-9.86	-3.69	-1.92
Incremental Operating Margin (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Pretax Margin (%)	-54.16	-30.86	-36.04	-39.55	-20	-22.94	-20.29	-9.69	-2.13	-0.13
Profit Margin (%)	-58.94	-32.97	-37.66	-39.09	-21.27	-23.64	-22.09	4.87	-7.29	21.14
Net Income to Common Margin (%)	-58.94	-32.97	-37.66	-39.09	-21.27	-23.64	-22.09	4.87	-7.29	21.14
Effective Tax Rate (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Dvd Payout Ratio (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Sustainable Growth Rate (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Credit (USD)

API ChatGPT

	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	04/30/2017	04/30/2018	04/30/2019	04/30/2020	04/30/2021	04/30/2022	04/30/2023	04/30/2024	04/30/2025	04/30/2026

Total Debt	- -	- -	- -	35	28	594	594	594	595	592
ST Debt	- -	- -	- -	8	9	11	13	12	9	7
LT Debt	- -	- -	- -	28	20	583	581	582	586	585
Total Debt/EBITDA	- -	- -	- -	-0.22	-0.25	-3.86	-3.54	-5.55	-14.04	-27.33
Net Debt/EBITDA	1.35	1.19	3.12	1.88	3.57	1.91	0.46	-0.26	3.72	9.14
Total Debt/EBIT	- -	- -	- -	-0.21	-0.22	-3.42	-3.16	-4.75	-10.88	-17.67
Net Debt/EBIT	1.26	1.06	2.94	1.74	3.1	1.7	0.41	-0.23	2.89	5.91
EBITDA to Interest Expense	- -	- -	- -	- -	-606.71	-7.43	-6.66	-4.09	-1.67	-0.86
EBITDA-CapEx/Interest Expense	- -	- -	- -	- -	-629.57	-7.55	-6.77	-4.23	-1.85	-1.06
EBIT to Interest Expense	- -	- -	- -	- -	-699.88	-8.38	-7.47	-4.78	-2.16	-1.33
Interest Expense	- -	- -	- -	- -	- -	21	25	26	25	25
Common Equity/Total Assets	-112.24	-117.34	-65.12	-60.13	-62.93	-49.68	-60.36	-44.17	-42.37	-23.18
Long-Term Debt/Equity (%)	- -	- -	- -	6.73	4.36	140.34	145.77	78.78	63.21	45.83
Long-Term Debt/Capital (%)	- -	- -	- -	-6.21	-3.36	-262.67	-126.94	-146.54	-116.38	-420.16
Long-Term Debt/Total Assets (%)	- -	- -	- -	3.46	2.02	35.49	33.35	25.93	22.6	18.56
Total Debt/Equity (%)	- -	- -	- -	8.57	6.25	143.04	148.97	80.43	64.17	46.34
Total Debt/Capital (%)	- -	- -	- -	-7.92	-4.82	-267.72	-129.73	-149.61	-118.15	-424.86
Total Debt/Total Assets (%)	- -	- -	- -	4.41	2.9	36.17	34.08	26.47	22.95	18.76
Net Debt to Equity	46.4	33.18	-113.3	-71.82	-88.91	-70.87	-19.21	3.82	-17.02	-15.5
Net Debt/Capital (%)	26.91	19.17	48.51	39.88	40.69	27.19	6.95	-3.01	12.82	21.79
EBITDA	-44	-43	-96	-158	-112	-154	-168	-107	-42	-22
EBITDA-CapEx	-45	-46	-99	-163	-116	-156	-170	-110	-47	-27
Operating Income (Loss)	-47	-48	-101	-171	-129	-174	-188	-125	-55	-33

Liquidity (USD)

API ChatGPT

	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	04/30/2017	04/30/2018	04/30/2019	04/30/2020	04/30/2021	04/30/2022	04/30/2023	04/30/2024	04/30/2025	04/30/2026

Cash Ratio	1.17	0.41	1.46	0.89	0.89	1.45	1.28	1.24	1.39	1.14
Current Ratio	1.89	1.06	2.11	1.44	1.42	1.96	1.78	1.76	1.92	1.68
Quick Ratio	1.64	0.83	1.86	1.28	1.25	1.81	1.64	1.62	1.76	1.52
CFO/Avg Current Liab	- -	-0.22	-0.15	-0.11	0.06	0.01	0.05	0.19	0.28	0.3
Common Equity/Total Assets	-112.24	-117.34	-65.12	-60.13	-62.93	-49.68	-60.36	-44.17	-42.37	-23.18
Long-Term Debt/Equity (%)	- -	- -	- -	6.73	4.36	140.34	145.77	78.78	63.21	45.83
Long-Term Debt/Capital (%)	- -	- -	- -	-6.21	-3.36	-262.67	-126.94	-146.54	-116.38	-420.16
Long-Term Debt/Total Assets (%)	- -	- -	- -	3.46	2.02	35.49	33.35	25.93	22.6	18.56
Total Debt/Equity (%)	- -	- -	- -	8.57	6.25	143.04	148.97	80.43	64.17	46.34
Total Debt/Capital (%)	- -	- -	- -	-7.92	-4.82	-267.72	-129.73	-149.61	-118.15	-424.86
Total Debt/Total Assets (%)	- -	- -	- -	4.41	2.9	36.17	34.08	26.47	22.95	18.76
CFO/Total Liabilities	-5.9	-6.19	-10.75	-7.83	4.32	0.46	2.65	9.89	15.98	17.42
CFO/CapEx	-19.11	-7.01	-6.94	-6.04	5.33	2.28	13.29	43.12	61.26	64.2
Altman's Z-Score	-1.74	-1.87	12.14	6.62	11.47	3.31	2.19	4.2	3.6	2.13

Working Capital (USD)

API ChatGPT

	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	04/30/2017	04/30/2018	04/30/2019	04/30/2020	04/30/2021	04/30/2022	04/30/2023	04/30/2024	04/30/2025	04/30/2026

Accounts Receivable Turnover	- -	3.84	4.04	4.07	4.21	4.59	4.49	4.34	4.25	4.14
Days Sales Outstanding	- -	95.08	90.36	89.61	86.71	79.5	81.29	84.09	85.96	88.14
Inventory Turnover	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Days Inventory Outstanding	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Accounts Payable Turnover	- -	20.5	23.55	15.4	17.19	13.03	9.33	10.78	17.58	32.31
Accounts Payable Turnover Days	- -	17.81	15.5	23.7	21.23	28.02	39.1	33.85	20.77	11.3
Cash Conversion Cycle	- -	77.27	74.86	65.91	65.48	51.47	42.19	50.24	65.19	76.84
Inventory to Cash Days	- -	95.08	90.36	89.61	86.71	79.5	81.29	84.09	85.96	88.14
Inventories	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Finished Goods	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Other Inventory	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Enterprise Value (USD)

API ChatGPT

	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	04/30/2017	04/30/2018	04/30/2019	04/30/2020	04/30/2021	04/30/2022	04/30/2023	04/30/2024	04/30/2025	04/30/2026

Market Capitalization	- -	- -	4,696	5,054	10,519	7,047	5,481	10,186	8,936	4,891
- Cash & Cash Equivalents	60	51	298	297	401	861	644	540	728	769
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Total Debt	- -	- -	- -	35	28	594	594	594	595	592
Enterprise Value	-75	-51	4,398	4,793	10,146	6,780	5,160	9,695	8,133	4,112
Total Capital	-162	-215	-316	-448	-584	-222	-458	-397	-504	-139
Total Debt/Capital (%)	- -	- -	- -	-7.92	-4.82	-267.72	-129.73	-149.61	-118.15	-424.86
Total Debt / EV	- -	- -	- -	0.01	- -	0.09	0.12	0.06	0.07	0.14
EV/Sales	- -	- -	16.19	11.21	16.67	7.86	4.83	7.65	5.48	2.36
EV/EBITDA	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Cash Flow to Firm	- -	- -	- -	- -	446.15	250.89	81.82	71.49	23.05	- -
EV/Free Cash Flow to Firm	- -	- -	- -	- -	376.2	229.76	78.48	69.71	22.77	- -
Diluted Market Cap	- -	- -	4,696	5,054	10,519	7,047	5,481	10,629	8,936	4,978
Diluted Enterprise Value	-60	-51	4,398	4,793	10,146	6,780	5,431	10,682	8,803	4,801
EV per Share	- -	- -	80.12	60.82	116.35	73.26	53.9	97.3	78.46	39.04
TTM Sales	88	160	272	428	608	862	1,069	1,267	1,483	1,739
TTM EBITDA	-44	-43	-96	-158	-112	-154	-168	-107	-42	-22
TTM Operating Income	-47	-48	-101	-171	-129	-174	-188	-125	-55	-33
TTM Cash Flow to Firm	-16	-21	-24	-31	23	27	63	136	353	-3,692
TTM Free Cash Flow to Firm	-15	-18	-20	-26	27	30	66	139	357	-3,686

Multiples (USD)

API ChatGPT

	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	04/30/2017	04/30/2018	04/30/2019	04/30/2020	04/30/2021	04/30/2022	04/30/2023	04/30/2024	04/30/2025	04/30/2026

Price/Free Cash Flow	- -	- -	-229.19	-198.2	392.88	863.86	142.92	69.83	33.03	15
EV/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Enterprise Value	-75	-51	4,398	4,793	10,146	6,780	5,160	9,695	8,133	4,112
Low Price	- -	- -	58.55	39.01	60.68	66.39	46.18	54.06	69	42.05
EV/Sales	- -	- -	16.19	11.21	16.67	7.86	4.83	7.65	5.48	2.36
EV/EBITDA	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Earnings	- -	- -	- -	- -	- -	- -	- -	165.03	- -	13.3
Price/Earnings Average	- -	- -	-41.26	-35.36	-77.08	-57.74	-26.39	140.25	-94.31	21.57
Price/Earnings High	- -	- -	-53.89	-49.07	-118.91	-86.19	-37.01	219.67	-118.86	27.52
Price/Earnings Low	- -	- -	-31.42	-18.39	-40.88	-30.14	-18.72	87.28	-66.16	12.04
Price/Book Value	- -	- -	-14.85	-10.46	-17.18	-8.63	-5.21	-10.28	-8.13	-6.69
Price/Book Value Average	- -	- -	-13.34	-12.23	-16.29	-14.42	-5.92	-8.74	-9.28	-10.85
Price/Book Value High	- -	- -	-17.43	-16.97	-25.13	-21.53	-8.31	-13.69	-11.7	-13.85
Price/Book Value Low	- -	- -	-10.16	-6.36	-8.64	-7.53	-4.2	-5.44	-6.51	-6.06
Price/Tangible Book Value	- -	- -	19.86	30.57	48.77	107.21	82.85	25.58	14.98	5.39
Price/Tangible Book Value Average	- -	- -	17.85	35.75	46.25	179.08	94.22	21.74	17.1	8.74
Price/Tangible Book Value High	- -	- -	23.32	49.62	71.36	267.3	132.12	34.05	21.55	11.16
Price/Tangible Book Value Low	- -	- -	13.59	18.59	24.53	93.48	66.83	13.53	11.99	4.88
Price/Sales	- -	- -	17.29	11.82	17.29	8.17	5.13	8.04	6.02	2.81
Price/Sales Average	- -	- -	15.54	13.82	16.4	13.65	5.83	6.83	6.87	4.56
Price/Sales High	- -	- -	20.29	19.18	25.29	20.37	8.18	10.7	8.66	5.82
Price/Sales Low	- -	- -	11.83	7.19	8.7	7.12	4.14	4.25	4.82	2.55
Price/Cash Flow	- -	- -	-196.19	-165.36	466.57	1,242.34	153.68	68.47	33.57	14.96
Price/Cash Flow Average	- -	- -	-176.34	-193.39	442.51	2,075.17	174.78	58.19	38.31	24.26
Price/Cash Flow High	- -	- -	-230.31	-268.39	682.69	3,097.52	245.08	91.14	48.28	30.96
Price/Cash Flow Low	- -	- -	-134.27	-100.58	234.72	1,083.25	123.96	36.21	26.87	13.55
Price/Free Cash Flow Average	- -	- -	-206	-231.79	372.61	1,442.98	162.54	59.34	37.69	24.32
Price/Free Cash Flow High	- -	- -	-269.06	-321.68	574.86	2,153.87	227.93	92.95	47.5	31.03
Price/Free Cash Flow Low	- -	- -	-156.86	-120.54	197.64	753.24	115.29	36.93	26.44	13.58
EV/Sales Average	- -	- -	14.44	13.21	15.78	13.34	5.78	6.87	6.78	4.46
EV/Sales High	- -	- -	19.2	18.57	24.68	20.06	8.13	10.74	8.57	5.72
EV/Sales Low	- -	- -	10.73	6.58	8.08	6.82	4.09	4.29	4.73	2.44
EV/EBITDA Average	1.35	1.19	-41.01	-35.7	-85.56	-74.72	-36.88	-81.41	-237.44	-358.3
EV/EBITDA High	1.35	1.19	-54.51	-50.18	-133.81	-112.39	-51.84	-127.22	-300.07	-459.4
EV/EBITDA Low	1.35	1.19	-30.48	-17.77	-43.83	-38.18	-26.07	-50.85	-165.64	-196.48
EV/EBIT Average	1.26	1.06	-38.7	-33.02	-74.17	-66.23	-32.91	-69.68	-183.98	-231.64
EV/EBIT High	1.26	1.06	-51.45	-46.41	-115.99	-99.62	-46.26	-108.9	-232.51	-297
EV/EBIT Low	1.26	1.06	-28.77	-16.44	-37.99	-33.84	-23.26	-43.53	-128.35	-127.02
Last Price	- -	- -	85.55	64.14	120.62	76.14	57.25	102.22	86.2	46.43
High Price	- -	- -	100.43	104.1	176.49	189.84	91.3	136.06	123.96	96.07
Enterprise Value Average	-60	-51	3,923	5,649	9,604	11,504	6,183	8,709	10,063	7,754
Enterprise Value High	-60	-51	5,215	7,941	15,019	17,302	8,690	13,611	12,717	9,942
Enterprise Value Low	-60	-51	2,916	2,812	4,919	5,877	4,371	5,440	7,020	4,252

Shares Outstanding	69	69	74	83	91	94	97	102	106	105
Diluted Weighted Avg Shares	62	62	55	79	87	93	96	104	104	107
Basic Weighted Avg Shares	62	62	55	79	87	93	96	100	104	105
Revenue per Share	1.42	2.58	4.95	5.43	6.98	9.32	11.17	12.72	14.31	16.51
EBITDA per Share	-0.71	-0.69	-1.74	-2.01	-1.29	-1.66	-1.75	-1.07	-0.41	-0.21
Operating Income per Share	-0.76	-0.78	-1.85	-2.17	-1.48	-1.88	-1.96	-1.25	-0.53	-0.32
Basic EPS, GAAP	-0.84	-0.85	-1.86	-2.12	-1.48	-2.2	-2.47	0.62	-1.04	3.49
Basic EPS from Cont Ops	-0.84	-0.85	-1.86	-2.12	-1.48	-2.2	-2.47	0.62	-1.04	3.49
Diluted EPS, GAAP	-0.84	-0.85	-1.86	-2.12	-1.48	-2.2	-2.47	0.59	-1.04	3.43
Diluted EPS from Cont Ops	-0.84	-0.85	-1.86	-2.12	-1.48	-2.2	-2.47	0.59	-1.04	3.43
Dividend per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Cash Flow per Share	-0.26	-0.34	-0.44	-0.39	0.26	0.06	0.37	1.49	2.57	3.1
Free Cash Flow per Basic Share	-0.27	-0.38	-0.5	-0.45	0.21	0.03	0.34	1.46	2.53	3.06
Cash & Equivalents per Share	1.21	0.82	5.43	3.77	4.6	9.3	9.56	10.88	13.48	13.01
Book Value per Share	-2.62	-3.47	-5.76	-6.13	-7.02	-8.82	-10.99	-9.94	-10.6	-6.94
Tangible Book Value per Share	-2.31	-2.92	4.31	2.1	2.47	0.71	0.69	4	5.75	8.61

Elastic N.V.

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)