XPLR Infrastructure, LP Financial Ratios — XIFR Stock

Profitability (USD)

	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Return on Common Equity (%)	- -	36.17	9.52	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Return on Assets (%)	- -	0.81	0.09	0.17	1.04	-0.71	2.15	-0.66	-0.4	0.87	2.27	0.88	-0.11	-0.14
Return on Capital (%)	- -	3.32	- -	0.07	-1.92	-3.54	6.55	- -	- -	-1.35	3.73	- -	- -	- -
Return on Invested Capital (%)	- -	2.23	- -	3.6	4.58	1.99	3.65	- -	- -	0.44	0.04	- -	- -	- -
Gross Margin (%)	81.72	74.3	77.99	77.45	72.15	69.27	66.67	60.7	60.41	48.2	45.61	51.76	59.02	58.08
EBITDA Margin (%)	77.42	70.39	76.6	74.25	69.56	66.67	63.94	65.96	68.59	65.65	59.96	56.31	59.76	59.34
Operating Margin (%)	52.69	40.22	49.03	41.72	39.12	38.66	37.61	27.25	27.81	9.56	0.83	-2.6	8.37	4.88
Incremental Operating Margin (%)	- -	26.74	57.78	23.24	34.32	28.57	61.11	-67.86	35.48	95.38	-24.7	- -	86.18	107.14
Pretax Margin (%)	7.53	15.64	23.12	27.94	56.99	34.82	35.41	-50.29	-28.03	41.97	116.62	-25.88	-36.91	-40.15
Profit Margin (%)	17.2	11.17	0.84	2	10.75	-7.56	24.9	-8.3	-5.45	18.98	49.23	18.55	-1.87	-2.36
Net Income to Common Margin (%)	17.2	11.17	0.84	2	10.75	-7.93	21.66	-10.29	-6	18.98	49.23	18.55	-1.87	-2.36
Effective Tax Rate (%)	- -	28.57	- -	23.57	12.95	59.43	2.2	- -	- -	12.21	14.25	- -	- -	- -
Dvd Payout Ratio (%)	875	720	599.39	550	99.85	106.29	87.7	-48.54	-103.02	111.93	39.43	-313.98	-102	-52.17
Sustainable Growth Rate (%)	- -	-224.26	-47.56	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Credit (USD)

API ChatGPT

	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Total Debt	1,403	1,799	1,893	3,447	3,586	4,317	3,435	4,144	3,388	5,327	5,288	6,289	5,314	6,202
ST Debt	22	370	86	113	78	99	707	12	12	33	38	1,348	705	762
LT Debt	1,381	1,429	1,807	3,334	3,508	4,218	2,728	4,132	3,376	5,294	5,250	4,941	4,609	5,440
Total Debt/EBITDA	19.49	14.28	6.88	9.27	6.68	8.02	6.97	7.35	5.39	11.24	9.1	10.36	7.23	8.8
Net Debt/EBITDA	19.19	14.06	6.5	8.83	6.4	7.74	6.67	7.12	5.21	10.93	8.71	9.91	6.84	6.35
Total Debt/EBIT	28.63	24.99	10.76	16.49	11.87	13.84	11.84	17.79	13.29	77.2	661	-224.61	51.59	106.93
Net Debt/EBIT	28.2	24.61	10.15	15.71	11.38	13.34	11.34	17.24	12.86	75.07	632.75	-214.82	48.84	77.24
EBITDA to Interest Expense	1.67	2.57	2.75	3.18	3.53	2.7	1.99	0.8	1.01	- -	0.68	1.76	5.07	1.61
EBITDA-CapEx/Interest Expense	1.67	2.57	2.75	3.18	3.53	2.7	1.99	0.8	1.01	- -	0.68	1.76	5.07	1.61
EBIT to Interest Expense	1.14	1.47	1.76	1.79	1.99	1.57	1.17	0.33	0.41	- -	0.01	-0.08	0.71	0.13
Interest Expense	43	49	100	117	152	199	248	702	620	- -	853	345	145	437
Common Equity/Total Assets	2.05	2.39	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Long-Term Debt/Equity (%)	196.84	200.42	110.66	176.22	136.71	189.66	49.26	58.48	43.8	47.44	35.54	35.15	35.82	49.91
Long-Term Debt/Capital (%)	95.18	76.75	60.68	75.6	79.56	96.94	41.16	45.77	38.62	39.19	31.37	29.45	30.8	39.11
Long-Term Debt/Total Assets (%)	59.5	54.27	41.66	46.13	40.5	50.07	29.01	33.71	26.87	27.9	22.77	21.95	22.71	27.76
Total Debt/Equity (%)	200.04	252.31	115.92	182.19	139.75	194.11	62.03	58.65	43.96	47.74	35.8	44.74	41.3	56.9
Total Debt/Capital (%)	96.72	96.62	63.57	78.16	81.33	99.22	51.83	45.91	38.76	39.43	31.6	37.49	35.51	44.58
Total Debt/Total Assets (%)	60.47	68.33	43.65	47.7	41.4	51.24	36.52	33.81	26.97	28.07	22.94	27.94	26.19	31.65
Net Debt to Equity	197.04	248.53	109.43	173.52	133.9	187.19	59.37	56.84	42.56	46.42	34.27	42.79	39.1	41.1
Net Debt/Capital (%)	96.67	96.57	62.22	77.32	80.68	99.19	50.74	45.13	37.99	38.77	30.66	36.45	34.27	34.59
EBITDA	72	126	275	372	537	538	493	564	629	474	581	607	735	705
EBITDA-CapEx	72	126	275	372	537	538	493	564	629	474	581	607	735	705
Operating Income (Loss)	49	72	176	209	302	312	290	233	255	69	8	-28	103	58

Liquidity (USD)

API ChatGPT

	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Cash Ratio	0.1	0.06	0.33	0.32	0.18	0.56	0.17	0.43	0.31	0.12	0.17	0.16	0.26	0.61
Current Ratio	1.77	0.53	1.51	0.69	0.45	1.44	0.4	1.44	1.18	1.12	1.4	1.33	0.79	0.91
Quick Ratio	0.52	0.51	1.14	0.61	0.37	1.18	0.34	1.32	1.07	1.07	1.14	1.21	0.57	0.76
CFO/Avg Current Liab	- -	0.3	0.47	0.69	0.62	0.76	0.64	0.6	2.04	0.84	0.6	0.49	0.58	0.56
Common Equity/Total Assets	2.05	2.39	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Long-Term Debt/Equity (%)	196.84	200.42	110.66	176.22	136.71	189.66	49.26	58.48	43.8	47.44	35.54	35.15	35.82	49.91
Long-Term Debt/Capital (%)	95.18	76.75	60.68	75.6	79.56	96.94	41.16	45.77	38.62	39.19	31.37	29.45	30.8	39.11
Long-Term Debt/Total Assets (%)	59.5	54.27	41.66	46.13	40.5	50.07	29.01	33.71	26.87	27.9	22.77	21.95	22.71	27.76
Total Debt/Equity (%)	200.04	252.31	115.92	182.19	139.75	194.11	62.03	58.65	43.96	47.74	35.8	44.74	41.3	56.9
Total Debt/Capital (%)	96.72	96.62	63.57	78.16	81.33	99.22	51.83	45.91	38.76	39.43	31.6	37.49	35.51	44.58
Total Debt/Total Assets (%)	60.47	68.33	43.65	47.7	41.4	51.24	36.52	33.81	26.97	28.07	22.94	27.94	26.19	31.65
CFO/Total Liabilities	1.73	5.31	6.73	5.4	6.81	6.66	9.36	6.67	13.7	8.66	9.37	8.65	10.77	8.5
CFO/CapEx	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Altman's Z-Score	0.22	0.09	0.26	0.17	0.17	0.28	0.15	0.19	0.19	0.07	0.08	0.08	0.07	0.13

Working Capital (USD)

API ChatGPT

	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Accounts Receivable Turnover	- -	1.22	2.94	8.28	9.25	9.38	10.42	12.04	11.32	7.41	8.46	9.33	11.23	11.48
Days Sales Outstanding	- -	299.36	124.04	44.08	39.48	38.9	35.03	30.31	32.24	49.29	43.13	39.11	32.49	31.8
Inventory Turnover	- -	13.73	11.29	9.42	13.44	12.72	24.48	33.6	16.5	11.51	11.71	7.94	5.31	4.72
Days Inventory Outstanding	- -	26.58	32.34	38.76	27.16	28.7	14.91	10.86	22.12	31.72	31.17	45.98	68.8	77.32
Accounts Payable Turnover	- -	0.48	0.87	0.51	0.69	1.41	13.11	5.39	2.77	0.7	0.58	1.18	7.74	8.02
Accounts Payable Turnover Days	- -	756	418.68	709.72	528.33	259.57	27.84	67.67	131.78	525.1	630.73	309.89	47.17	45.53
Cash Conversion Cycle	- -	-430.05	-262.3	-626.88	-461.69	-191.97	22.11	-26.5	-77.42	-444.09	-556.44	-224.8	54.12	63.59
Inventory to Cash Days	- -	272.78	91.7	5.32	12.32	10.2	20.12	19.45	10.12	17.57	11.96	-6.87	-36.31	-45.53
Inventories	3	4	10	14	18	21	- -	20	24	41	49	82	108	103
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Finished Goods	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Other Inventory	3	4	10	14	18	21	- -	20	24	41	49	82	108	103

Enterprise Value (USD)

API ChatGPT

	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Market Capitalization	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	939
- Cash & Cash Equivalents	21	27	106	164	150	154	147	128	108	147	226	274	283	960
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	- -	1,085	963	823	34	3,192	4,883	5,353	8,182	11,447	10,488	9,651	7,709
+ Total Debt	1,403	1,799	1,893	3,447	3,586	4,317	3,435	4,144	3,388	5,327	5,288	6,289	5,314	6,202
Enterprise Value	1,382	1,772	2,872	4,246	4,259	4,197	6,480	8,899	8,633	13,362	16,509	16,503	14,682	13,890
Total Capital	1,451	1,862	2,978	4,410	4,409	4,351	6,627	9,027	8,741	13,509	16,735	16,777	14,965	13,911
Total Debt/Capital (%)	96.72	96.62	63.57	78.16	81.33	99.22	51.83	45.91	38.76	39.43	31.6	37.49	35.51	44.58
Total Debt / EV	1.02	1.02	0.66	0.81	0.84	1.03	0.53	0.47	0.39	0.4	0.32	0.38	0.36	0.45
EV/Sales	14.86	9.9	8	8.48	5.52	5.2	8.4	10.41	9.41	18.51	17.04	15.31	11.94	11.69
EV/EBITDA	19.19	14.06	10.44	11.41	7.93	7.8	13.14	15.78	13.72	28.19	28.41	27.19	19.98	19.7
EV/EBIT	28.2	24.61	16.32	20.32	14.1	13.45	22.34	38.19	33.85	193.65	2,063.62	- -	142.54	239.48
EV/Cash Flow to Firm	10.94	12.93	9.61	11.25	7.78	8.5	10.72	8.85	6.97	19.74	10.95	15.79	15.76	12.58
EV/Free Cash Flow to Firm	10.94	12.93	9.61	11.25	7.78	8.5	10.72	8.85	6.97	19.74	10.95	15.79	15.76	12.58
Diluted Market Cap	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	939
Diluted Enterprise Value	1,382	1,772	2,872	4,246	4,259	4,197	6,480	8,899	8,633	13,362	16,509	16,503	14,682	13,890
EV per Share	85.04	109.05	153.58	186.23	97.24	77.44	118.03	151.34	127.14	173.08	194.45	180.16	157.03	147.92
TTM Sales	93	179	359	501	772	807	771	855	917	722	969	1,078	1,230	1,188
TTM EBITDA	72	126	275	372	537	538	493	564	629	474	581	607	735	705
TTM Operating Income	49	72	176	209	302	312	290	233	255	69	8	-28	103	58
TTM Cash Flow to Firm	126	137	299	377	547	494	605	1,006	1,239	677	1,507	1,045	932	1,105
TTM Free Cash Flow to Firm	126	137	299	377	547	494	605	1,006	1,239	677	1,507	1,045	932	1,105

Multiples (USD)

API ChatGPT

	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Price/Free Cash Flow	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	1.27
EV/EBIT	28.2	24.61	16.32	20.32	14.1	13.45	22.34	38.19	33.85	193.65	2,063.62	- -	142.54	239.48
Enterprise Value	1,382	1,772	2,872	4,246	4,259	4,197	6,480	8,899	8,633	13,362	16,509	16,503	14,682	13,890
Low Price	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	7.53
EV/Sales	14.86	9.9	8	8.48	5.52	5.2	8.4	10.41	9.41	18.51	17.04	15.31	11.94	11.69
EV/EBITDA	19.19	14.06	10.44	11.41	7.93	7.8	13.14	15.78	13.72	28.19	28.41	27.19	19.98	19.7
Price/Earnings	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Earnings Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	-32.74
Price/Earnings High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	-64.66
Price/Earnings Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	-25.25
Price/Book Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Book Value Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Book Value High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Book Value Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Tangible Book Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	0.1
Price/Tangible Book Value Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	0.1
Price/Tangible Book Value High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	0.2
Price/Tangible Book Value Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	0.08
Price/Sales	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	0.79
Price/Sales Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	0.77
Price/Sales High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	1.52
Price/Sales Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	0.6
Price/Cash Flow	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	1.27
Price/Cash Flow Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	1.24
Price/Cash Flow High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	2.45
Price/Cash Flow Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	0.96
Price/Free Cash Flow Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	1.24
Price/Free Cash Flow High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	2.45
Price/Free Cash Flow Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	0.96
EV/Sales Average	14.86	9.9	8	8.48	5.52	5.2	8.4	10.41	9.41	18.51	17.04	15.31	11.94	11.67
EV/Sales High	14.86	9.9	8	8.48	5.52	5.2	8.4	10.41	9.41	18.51	17.04	15.31	11.94	12.43
EV/Sales Low	14.86	9.9	8	8.48	5.52	5.2	8.4	10.41	9.41	18.51	17.04	15.31	11.94	11.5
EV/EBITDA Average	19.19	14.06	10.44	11.41	7.93	7.8	13.14	15.78	13.72	28.19	28.41	27.19	19.98	19.67
EV/EBITDA High	19.19	14.06	10.44	11.41	7.93	7.8	13.14	15.78	13.72	28.19	28.41	27.19	19.98	20.94
EV/EBITDA Low	19.19	14.06	10.44	11.41	7.93	7.8	13.14	15.78	13.72	28.19	28.41	27.19	19.98	19.37
EV/EBIT Average	28.2	24.61	16.32	20.32	14.1	13.45	22.34	38.19	33.85	193.65	2,063.62	-589.39	142.54	239.1
EV/EBIT High	28.2	24.61	16.32	20.32	14.1	13.45	22.34	38.19	33.85	193.65	2,063.62	-589.39	142.54	254.51
EV/EBIT Low	28.2	24.61	16.32	20.32	14.1	13.45	22.34	38.19	33.85	193.65	2,063.62	-589.39	142.54	235.48
Last Price	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	10
High Price	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	19.28
Enterprise Value Average	1,382	1,772	2,872	4,246	4,259	4,197	6,480	8,899	8,633	13,362	16,509	16,503	14,682	13,868
Enterprise Value High	1,382	1,772	2,872	4,246	4,259	4,197	6,480	8,899	8,633	13,362	16,509	16,503	14,682	14,761
Enterprise Value Low	1,382	1,772	2,872	4,246	4,259	4,197	6,480	8,899	8,633	13,362	16,509	16,503	14,682	13,658

Shares Outstanding	16	16	19	31	54	54	56	66	76	84	86	93	94	94
Diluted Weighted Avg Shares	16	16	19	23	44	54	75	76	68	77	85	92	94	94
Basic Weighted Avg Shares	16	16	19	23	44	54	55	59	68	77	85	92	94	94
Revenue per Share	5.72	11.02	19.2	21.97	17.63	14.89	14.04	14.54	13.5	9.35	11.41	11.77	13.16	12.65
EBITDA per Share	4.43	7.75	14.71	16.32	12.26	9.93	8.98	9.59	9.26	6.14	6.84	6.63	7.86	7.51
Operating Income per Share	3.02	4.43	9.41	9.17	6.89	5.76	5.28	3.96	3.76	0.89	0.09	-0.31	1.1	0.62
Basic EPS, GAAP	0.98	1.23	0.16	0.44	1.89	-1.18	3.04	-1.5	-0.81	1.77	5.62	2.18	-0.25	-0.3
Basic EPS from Cont Ops	0.98	1.23	5.19	4.69	8.74	2.1	4.86	-6.87	-3.51	3.45	11.41	-2.77	-4.41	-4.25
Diluted EPS, GAAP	0.98	1.23	0.16	0.44	1.89	-1.18	2.24	-1.16	-0.81	1.77	5.62	2.18	-0.25	-0.3
Diluted EPS from Cont Ops	0.98	1.23	5.19	4.69	8.74	2.1	3.58	-5.33	-3.51	3.44	11.41	-2.77	-4.41	-4.25
Dividend per Share	8.62	8.86	52.25	49.21	15.57	5.66	5.52	6.51	6.61	8.02	7.49	8.09	8.73	4.48
Cash Flow per Share	1.72	6.28	9.73	12.63	9.47	7.62	6.59	5.88	9.79	8.77	9.14	7.98	8.56	7.87
Free Cash Flow per Basic Share	1.72	6.28	9.73	12.63	9.47	7.62	6.59	5.88	9.79	8.77	9.14	7.98	8.56	7.87
Cash & Equivalents per Share	1.29	1.66	5.67	7.19	3.42	2.84	2.68	2.18	1.59	1.9	2.66	2.99	3.03	10.22
Book Value per Share	2.93	3.88	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Tangible Book Value per Share	43.16	43.88	87.33	25.18	28.77	17.12	67.27	71	72.4	97.15	140.75	122.67	115.47	98.52

XPLR Infrastructure, LP

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)