SOUTHWEST IOWA RENEWABLE ENERGY LLC Financial Ratios — SWIOU

Profitability (USD)

	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y
As of date	09/30/2014	09/30/2015	09/30/2016	09/30/2017	09/30/2018	09/30/2019	09/30/2020	09/30/2021	09/30/2022

Return on Common Equity (%)	- -	13.61	4.98	12.5	-2.58	-9.08	-0.57	12.25	59.15
Return on Assets (%)	- -	8.57	3.32	8.94	-1.86	-5.99	-0.31	5.78	36.46
Return on Capital (%)	- -	10.48	4.51	10.83	- -	- -	- -	7.88	42.32
Return on Invested Capital (%)	- -	14.31	4.85	10.53	- -	- -	- -	7.13	38.21
Gross Margin (%)	21.81	9.85	5	8.55	1.69	-0.93	2.88	5.06	15.7
EBITDA Margin (%)	24.15	13.54	8.25	11.89	4.7	1.59	5.71	6.86	16.79
Operating Margin (%)	20.41	8.71	2.94	6.37	-0.62	-3.16	0.28	3.17	13.83
Incremental Operating Margin (%)	- -	57	77.28	- -	320.78	- -	- -	8.67	52.11
Pretax Margin (%)	15.21	5.68	2.28	6.12	-1.26	-3.92	-0.22	2.83	14.92
Profit Margin (%)	15.21	5.68	2.28	6.12	-1.26	-3.92	-0.22	2.83	14.92
Net Income to Common Margin (%)	15.21	5.68	2.28	6.12	-1.26	-3.92	-0.22	2.83	14.92
Effective Tax Rate (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -
Dvd Payout Ratio (%)	- -	96.85	65.42	33.7	-246.41	- -	- -	- -	19.42
Sustainable Growth Rate (%)	- -	0.43	1.72	8.29	-8.93	-9.08	-0.57	12.25	47.66

Credit (USD)

Credit Ratios API ChatGPT

	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y
As of date	09/30/2014	09/30/2015	09/30/2016	09/30/2017	09/30/2018	09/30/2019	09/30/2020	09/30/2021	09/30/2022

Total Debt	57	36	31	20	22	26	63	66	19
ST Debt	6	7	7	7	7	1	11	13	10
LT Debt	51	29	25	13	15	26	52	53	10
Total Debt/EBITDA	0.74	1.09	1.7	0.75	2.17	7.68	5.58	3.16	0.3
Net Debt/EBITDA	0.62	1	1.53	0.69	2.02	7.37	4.9	2.87	0.13
Total Debt/EBIT	0.87	1.69	4.76	1.4	-16.44	-3.85	114.01	6.84	0.36
Net Debt/EBIT	0.73	1.55	4.28	1.29	-15.36	-3.69	100.01	6.23	0.16
EBITDA to Interest Expense	11.88	19.34	18.04	27.5	6.05	3.44	11.37	10.26	42.83
EBITDA-CapEx/Interest Expense	11.38	17.93	13.2	19.38	2.72	-6.38	3.01	6.18	39.69
EBIT to Interest Expense	10.05	12.45	6.43	14.73	-0.8	-6.87	0.56	4.74	35.26
Interest Expense	6	2	1	1	2	1	1	2	2
Common Equity/Total Assets	60.49	65.59	67.83	75.25	68.57	63.4	46.73	47.55	75.4
Long-Term Debt/Equity (%)	50.43	28.85	24.02	11.63	15.68	28.93	79.24	70.83	7.96
Long-Term Debt/Capital (%)	32.24	21.33	18.43	9.9	12.81	22.32	40.36	37.63	6.87
Long-Term Debt/Total Assets (%)	30.5	18.92	16.29	8.75	10.75	18.34	37.03	33.68	6.01
Total Debt/Equity (%)	56.43	35.27	30.34	17.47	22.39	29.58	96.33	88.23	15.89
Total Debt/Capital (%)	36.07	26.07	23.28	14.87	18.29	22.82	49.06	46.87	13.71
Total Debt/Total Assets (%)	34.13	23.13	20.58	13.15	15.35	18.75	45.01	41.96	11.98
Net Debt to Equity	47.24	32.28	27.29	16.14	20.91	28.37	84.5	80.32	7.26
Net Debt/Capital (%)	32.08	24.4	21.44	13.9	17.3	22.1	43.42	43.27	6.6
EBITDA	77	33	18	26	10	3	11	21	65
EBITDA-CapEx	74	30	13	18	5	-6	3	13	60
Operating Income (Loss)	65	21	7	14	-1	-7	1	10	54

Liquidity (USD)

Liquidity Ratios API ChatGPT

	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y
As of date	09/30/2014	09/30/2015	09/30/2016	09/30/2017	09/30/2018	09/30/2019	09/30/2020	09/30/2021	09/30/2022

Cash Ratio	0.63	0.17	0.18	0.08	0.08	0.05	0.06	0.08	0.28
Current Ratio	2.03	1.25	1.52	1.57	1.55	1.28	1.29	1.8	2.16
Quick Ratio	1.04	0.38	0.93	0.82	0.75	0.48	0.52	0.58	0.82
CFO/Avg Current Liab	- -	2.01	0.68	1.24	0.54	0.25	0.35	0.29	2.53
Common Equity/Total Assets	60.49	65.59	67.83	75.25	68.57	63.4	46.73	47.55	75.4
Long-Term Debt/Equity (%)	50.43	28.85	24.02	11.63	15.68	28.93	79.24	70.83	7.96
Long-Term Debt/Capital (%)	32.24	21.33	18.43	9.9	12.81	22.32	40.36	37.63	6.87
Long-Term Debt/Total Assets (%)	30.5	18.92	16.29	8.75	10.75	18.34	37.03	33.68	6.01
Total Debt/Equity (%)	56.43	35.27	30.34	17.47	22.39	29.58	96.33	88.23	15.89
Total Debt/Capital (%)	36.07	26.07	23.28	14.87	18.29	22.82	49.06	46.87	13.71
Total Debt/Total Assets (%)	34.13	23.13	20.58	13.15	15.35	18.75	45.01	41.96	11.98
CFO/Total Liabilities	105.69	61.91	25.08	60.72	22.02	9.69	9.52	7.76	164.3
CFO/CapEx	21.26	13.7	2.48	2.9	1.77	0.51	0.86	0.77	13.62
Altman's Z-Score	4	2.82	2.43	2.91	2.33	1.94	1.82	2.6	5.36

Working Capital (USD)

Working Capital Ratios API ChatGPT

	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y
As of date	09/30/2014	09/30/2015	09/30/2016	09/30/2017	09/30/2018	09/30/2019	09/30/2020	09/30/2021	09/30/2022

Accounts Receivable Turnover	- -	49.63	25.71	16.34	16.56	19.74	22.31	28.5	28.95
Days Sales Outstanding	- -	7.35	14.2	22.34	22.04	18.49	16.36	12.81	12.61
Inventory Turnover	- -	16.5	17.51	17.36	15.81	14.27	12.63	13.68	11.41
Days Inventory Outstanding	- -	22.12	20.85	21.02	23.09	25.58	28.89	26.69	31.98
Accounts Payable Turnover	- -	59.46	47.86	53.87	62.69	60.55	51.4	55.57	36.01
Accounts Payable Turnover Days	- -	6.14	7.63	6.78	5.82	6.03	7.1	6.57	10.13
Cash Conversion Cycle	- -	23.34	27.42	36.59	39.31	38.04	38.15	32.93	34.46
Inventory to Cash Days	- -	-14.77	-6.65	1.32	-1.05	-7.08	-12.53	-13.88	-19.37
Inventories	12	14	10	13	14	17	13	29	29
Raw Materials	5	6	6	8	9	9	7	15	16
Work In Process	1	1	1	1	1	2	2	3	3
Finished Goods	6	6	2	4	3	6	5	11	9
Other Inventory	- -	- -	- -	- -	- -	- -	- -	- -	- -

Enterprise Value (USD)

Enterprise Value API ChatGPT

	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y
As of date	09/30/2014	09/30/2015	09/30/2016	09/30/2017	09/30/2018	09/30/2019	09/30/2020	09/30/2021	09/30/2022

Market Capitalization	63	57	48	49	49	42	42	30	74
- Cash & Cash Equivalents	9	3	3	1	1	1	1	2	7
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Total Debt	57	36	31	20	22	26	63	66	19
Enterprise Value	110	89	77	67	70	68	104	93	86
Total Capital	158	137	134	132	120	116	129	140	140
Total Debt/Capital (%)	36.07	26.07	23.28	14.87	18.29	22.82	49.06	46.87	13.71
Total Debt / EV	0.52	0.4	0.41	0.29	0.31	0.39	0.61	0.7	0.22
EV/Sales	0.35	0.37	0.34	0.31	0.32	0.31	0.53	0.31	0.22
EV/EBITDA	1.43	2.72	4.16	2.58	6.9	19.63	9.2	4.49	1.32
EV/EBIT	1.69	4.23	11.65	4.82	- -	- -	187.87	9.73	1.6
EV/Cash Flow to Firm	1.45	2.58	5.77	2.89	- -	- -	- -	11.11	1.29
EV/Free Cash Flow to Firm	1.52	2.77	9.18	4.32	- -	- -	- -	701.55	1.39
Diluted Market Cap	172	97	72	79	73	63	47	30	74
Diluted Enterprise Value	220	129	100	97	94	88	109	93	86
EV per Share	12,309.97	9,943.79	8,534.48	7,514.15	7,778.89	7,523.06	11,638.27	10,396.16	9,535.82
TTM Sales	320	242	223	220	215	217	199	303	387
TTM EBITDA	77	33	18	26	10	3	11	21	65
TTM Operating Income	65	21	7	14	-1	-7	1	10	54
TTM Cash Flow to Firm	76	35	13	23	- -	- -	- -	8	66
TTM Free Cash Flow to Firm	73	32	8	16	- -	- -	- -	- -	62

Multiples (USD)

Valuation Multiples API ChatGPT

	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y
As of date	09/30/2014	09/30/2015	09/30/2016	09/30/2017	09/30/2018	09/30/2019	09/30/2020	09/30/2021	09/30/2022

Price/Free Cash Flow	2.6	3.17	9.82	5.4	17.01	-13.01	-38.84	-15.65	1.23
EV/EBIT	1.69	4.23	11.65	4.82	- -	- -	187.87	9.73	1.6
Enterprise Value	110	89	77	67	70	68	104	93	86
Low Price	7,000	6,300	5,400	5,000	5,200	4,700	4,700	3,300	3,303
EV/Sales	0.35	0.37	0.34	0.31	0.32	0.31	0.53	0.31	0.22
EV/EBITDA	1.43	2.72	4.16	2.58	6.9	19.63	9.2	4.49	1.32
Price/Earnings	1.9	6.1	14.13	5.45	- -	- -	- -	3.45	1.27
Price/Earnings Average	1.9	6.37	14.97	5.2	- -	- -	- -	3.45	0.89
Price/Earnings High	1.9	7.26	15.97	5.46	- -	- -	- -	3.45	1.27
Price/Earnings Low	1.9	6.1	14.13	4.96	- -	- -	- -	3.45	0.51
Price/Book Value	0.62	0.56	0.47	0.44	0.5	0.47	0.64	0.4	0.61
Price/Book Value Average	0.62	0.58	0.5	0.42	0.5	0.51	0.64	0.4	0.43
Price/Book Value High	0.62	0.66	0.53	0.44	0.51	0.55	0.64	0.4	0.61
Price/Book Value Low	0.62	0.56	0.47	0.4	0.48	0.47	0.64	0.4	0.25
Price/Tangible Book Value	0.62	0.56	0.47	0.44	0.5	0.47	0.64	0.4	0.61
Price/Tangible Book Value Average	0.62	0.58	0.5	0.42	0.5	0.51	0.64	0.4	0.43
Price/Tangible Book Value High	0.62	0.66	0.53	0.44	0.51	0.55	0.64	0.4	0.61
Price/Tangible Book Value Low	0.62	0.56	0.47	0.4	0.48	0.47	0.64	0.4	0.25
Price/Sales	0.29	0.35	0.32	0.33	0.34	0.29	0.23	0.1	0.19
Price/Sales Average	0.29	0.36	0.34	0.32	0.34	0.31	0.23	0.1	0.13
Price/Sales High	0.29	0.41	0.36	0.33	0.35	0.34	0.23	0.1	0.19
Price/Sales Low	0.29	0.35	0.32	0.3	0.32	0.29	0.23	0.1	0.08
Price/Cash Flow	1.33	2.55	5.87	3.28	7.43	12.53	6.51	4.65	1.14
Price/Cash Flow Average	1.33	2.66	6.22	3.13	7.36	13.6	6.51	4.65	0.8
Price/Cash Flow High	1.33	3.04	6.63	3.28	7.56	14.67	6.51	4.65	1.14
Price/Cash Flow Low	1.33	2.55	5.87	2.98	7.02	12.53	6.51	4.65	0.46
Price/Free Cash Flow Average	2.6	3.31	10.41	5.15	16.86	-14.12	-38.84	-15.65	0.86
Price/Free Cash Flow High	2.6	3.77	11.1	5.41	17.32	-15.23	-38.84	-15.65	1.23
Price/Free Cash Flow Low	2.6	3.17	9.82	4.91	16.08	-13.01	-38.84	-15.65	0.49
EV/Sales Average	0.35	0.38	0.36	0.3	0.32	0.33	0.53	0.31	0.16
EV/Sales High	0.35	0.41	0.37	0.31	0.33	0.34	0.53	0.31	0.22
EV/Sales Low	0.35	0.37	0.34	0.29	0.31	0.31	0.53	0.31	0.11
EV/EBITDA Average	1.43	2.8	4.31	2.49	6.86	20.67	9.2	4.49	0.98
EV/EBITDA High	1.43	3.05	4.5	2.58	6.99	21.71	9.2	4.49	1.32
EV/EBITDA Low	1.43	2.72	4.16	2.41	6.64	19.63	9.2	4.49	0.64
EV/EBIT Average	1.69	4.35	12.09	4.66	- -	- -	187.87	9.73	1.19
EV/EBIT High	1.69	4.74	12.61	4.82	- -	- -	187.87	9.73	1.6
EV/EBIT Low	1.69	4.23	11.65	4.5	- -	- -	187.87	9.73	0.78
Last Price	7,000	6,300	5,400	5,500	5,500	4,700	4,700	3,300	8,200
High Price	7,000	7,500	6,102	5,505	5,600	5,500	4,700	3,300	8,200
Enterprise Value Average	110	92	79	65	69	71	104	93	64
Enterprise Value High	110	100	83	67	71	75	104	93	86
Enterprise Value Low	110	89	77	63	67	68	104	93	42

Per Share Data Items (USD)

Per-Share Data API ChatGPT

	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y
As of date	09/30/2014	09/30/2015	09/30/2016	09/30/2017	09/30/2018	09/30/2019	09/30/2020	09/30/2021	09/30/2022

Shares Outstanding	- -	- -	- -	- -	- -	- -	- -	- -	- -
Diluted Weighted Avg Shares	- -	- -	- -	- -	- -	- -	- -	- -	- -
Basic Weighted Avg Shares	- -	- -	- -	- -	- -	- -	- -	- -	- -
Revenue per Share	24,199.02	18,167.4	16,757.41	16,490.43	16,131.91	16,282.21	20,064.05	33,740.39	43,133.7
EBITDA per Share	5,843.7	2,460.04	1,383.06	1,960.23	758.76	258.12	1,146.58	2,315.77	7,243.9
Operating Income per Share	4,939.72	1,582.95	493.36	1,050.12	-99.95	-514.82	56.17	1,068.75	5,963.9
Basic EPS, GAAP	3,681.03	1,032.57	382.16	1,008.85	-202.9	-637.58	-44.65	956.43	6,435.88
Basic EPS from Cont Ops	3,681.03	1,032.57	382.16	1,008.85	-202.9	-637.58	-44.65	956.43	6,435.88
Diluted EPS, GAAP	1,973.93	896.37	382.16	934.07	-202.9	-637.58	-44.65	956.43	6,435.88
Diluted EPS from Cont Ops	1,973.93	896.37	382.16	934.07	-202.9	-637.58	-44.65	956.43	6,435.88
Dividend per Share	- -	1,000	250.02	339.99	499.96	- -	- -	- -	1,249.92
Cash Flow per Share	5,274.9	2,469.72	920.09	1,678.47	740.68	375.03	721.69	709.75	7,222.51
Free Cash Flow per Basic Share	5,026.81	2,289.49	549.64	1,099.8	323.33	-361.15	-121.02	-210.81	6,692.03
Cash & Equivalents per Share	1,032.53	337.6	349.75	165.68	160.45	119.78	124.35	216.71	805.46
Book Value per Share	11,240.33	11,288.69	11,484.9	12,478.11	10,897.16	9,950.42	7,331.92	8,288.36	13,474.32
Tangible Book Value per Share	11,240.33	11,288.69	11,484.9	12,478.11	10,897.16	9,950.42	7,331.92	8,288.36	13,474.32