Magnolia Oil & Gas Corporation Financial Ratios — MGY Stock

Profitability (USD)

	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
Return on Common Equity (%)	- -	- -	- -	84.72	- -	- -	- -	115.59	59	37.82
Return on Assets (%)	- -	21.18	- -	1.45	-49.12	26.08	41.39	14.57	13.13	11.36
Return on Capital (%)	- -	- -	- -	2.75	- -	-114.24	234.56	36.9	30.34	24.97
Return on Invested Capital (%)	- -	23.42	- -	3.5	- -	44.4	59.88	20.11	17.75	14.84
Gross Margin (%)	54.7	56.97	- -	28.59	23.8	68.88	74.07	57.24	51.73	47.29
EBITDA Margin (%)	55.88	79.3	- -	70.69	-45.55	74.15	77.72	71.31	70.41	66.85
Operating Margin (%)	26.02	47.13	- -	13.58	-100.57	55.88	63.37	44.84	38.91	33.48
Incremental Operating Margin (%)	- -	55.14	47.13	13.58	- -	213.58	76.47	111.99	-43	1,801.71
Pretax Margin (%)	19.96	45.04	- -	10.59	-359.93	52.73	62.37	44.81	37.48	31.82
Profit Margin (%)	19.36	44.36	- -	5.33	-223.24	38.7	52.75	31.65	27.82	24.79
Net Income to Common Margin (%)	19.36	44.36	- -	5.33	-223.24	38.7	52.75	31.65	27.82	24.79
Effective Tax Rate (%)	3.04	1.51	- -	14.79	- -	1.56	0.63	19.5	19.43	19.2
Dvd Payout Ratio (%)	- -	- -	- -	- -	- -	2.01	6.23	17.73	22.77	32.38
Sustainable Growth Rate (%)	- -	- -	- -	84.72	- -	- -	- -	95.1	45.56	25.58

Credit (USD)

API Chat

	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
Total Debt	- -	- -	389	390	391	388	390	393	405	411
ST Debt	- -	- -	- -	- -	- -	- -	- -	- -	12	18
LT Debt	- -	- -	389	390	391	388	390	393	393	393
Total Debt/EBITDA	- -	- -	- -	0.59	-1.59	0.49	0.3	0.45	0.44	0.47
Net Debt/EBITDA	- -	- -	- -	0.31	-0.81	0.03	-0.22	-0.01	0.14	0.14
Total Debt/EBIT	- -	- -	- -	3.05	-0.72	0.64	0.36	0.71	0.79	0.94
Net Debt/EBIT	- -	- -	- -	1.62	-0.36	0.04	-0.27	-0.02	0.26	0.29
EBITDA to Interest Expense	- -	- -	- -	23.49	-8.59	25.79	56.18	26,515.45	64.47	40.57
EBITDA-CapEx/Interest Expense	- -	- -	- -	8.15	-16.33	18.17	36.34	13,640	30.6	18.85
EBIT to Interest Expense	- -	- -	- -	4.51	-18.97	19.44	45.81	16,673.33	35.63	20.32
Interest Expense	- -	- -	- -	28	29	31	23	- -	14	22
Common Equity/Total Assets	- -	- -	1.03	2.39	-77.43	-40.54	7.22	17.64	26.75	33.25
Long-Term Debt/Equity (%)	- -	- -	14.35	14.29	46.59	37.13	22.43	20.87	19.95	19.67
Long-Term Debt/Capital (%)	- -	- -	26.7	27.35	-88.28	-423.84	52.74	36.71	32.36	27.39
Long-Term Debt/Total Assets (%)	- -	- -	11.32	11.25	26.91	22.22	15.17	14.25	13.91	13.55
Total Debt/Equity (%)	- -	- -	14.35	14.29	46.59	37.13	22.43	20.87	20.57	20.58
Total Debt/Capital (%)	- -	- -	26.7	27.35	-88.28	-423.84	52.74	36.71	33.36	28.66
Total Debt/Total Assets (%)	- -	- -	11.32	11.25	26.91	22.22	15.17	14.25	14.35	14.17
Net Debt to Equity	- -	- -	9.34	7.59	23.65	2.02	-16.38	-0.44	6.73	6.33
Net Debt/Capital (%)	- -	- -	19.16	16.67	-31.24	-4.6	-440.11	-1.24	13.9	10.82
EBITDA	62	320	- -	666	-247	800	1,317	875	926	877
EBITDA-CapEx	36	72	- -	231	-469	563	852	450	440	407
Operating Income (Loss)	29	190	- -	128	-544	603	1,074	550	512	439

Liquidity (USD)

API Chat

	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
Cash Ratio	- -	- -	0.69	1.04	1.49	1.68	1.98	1.27	0.9	0.93
Current Ratio	- -	1.41	1.48	1.67	2.18	2.37	2.5	1.88	1.42	1.54
Quick Ratio	- -	1.4	1.4	1.65	2.13	2.36	2.49	1.88	1.41	1.53
CFO/Avg Current Liab	- -	6.33	- -	3.48	2.04	4.54	4.64	2.61	3.04	3.04
Common Equity/Total Assets	- -	- -	1.03	2.39	-77.43	-40.54	7.22	17.64	26.75	33.25
Long-Term Debt/Equity (%)	- -	- -	14.35	14.29	46.59	37.13	22.43	20.87	19.95	19.67
Long-Term Debt/Capital (%)	- -	- -	26.7	27.35	-88.28	-423.84	52.74	36.71	32.36	27.39
Long-Term Debt/Total Assets (%)	- -	- -	11.32	11.25	26.91	22.22	15.17	14.25	13.91	13.55
Total Debt/Equity (%)	- -	- -	14.35	14.29	46.59	37.13	22.43	20.87	20.57	20.58
Total Debt/Capital (%)	- -	- -	26.7	27.35	-88.28	-423.84	52.74	36.71	33.36	28.66
Total Debt/Total Assets (%)	- -	- -	11.32	11.25	26.91	22.22	15.17	14.25	14.35	14.17
CFO/Total Liabilities	- -	282.4	- -	87.77	50.51	112.4	155.78	97.97	107.89	97.2
CFO/CapEx	1.17	1.04	- -	1.49	1.4	3.33	2.79	2.01	1.89	1.87
Altman's Z-Score	- -	5.84	0.05	2.13	-0.69	4.21	5.54	4.22	4.56	4.18

Working Capital (USD)

API Chat

	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
Accounts Receivable Turnover	- -	7.06	- -	7.66	5.78	9.32	10.57	6.81	8.4	10.92
Days Sales Outstanding	- -	51.69	- -	47.66	63.16	39.15	34.52	53.62	43.47	33.43
Inventory Turnover	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Days Inventory Outstanding	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Accounts Payable Turnover	- -	- -	- -	8.64	5.81	3.52	2.66	2.65	3.39	3.86
Accounts Payable Turnover Days	- -	- -	- -	42.24	62.85	103.62	137.37	137.78	107.54	94.66
Cash Conversion Cycle	- -	51.69	- -	5.42	0.31	-64.47	-102.85	-84.16	-64.06	-61.24
Inventory to Cash Days	- -	51.69	- -	47.66	63.16	39.15	34.52	53.62	43.47	33.43
Inventories	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Finished Goods	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Other Inventory	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Enterprise Value (USD)

API Chat

	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
Market Capitalization	- -	791	- -	2,037	1,174	3,290	4,395	4,006	4,360	4,062
- Cash & Cash Equivalents	- -	- -	136	183	193	367	675	401	260	267
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	- -	1,031	952	291	228	164	191	54	59
+ Total Debt	- -	- -	389	390	391	388	390	393	405	411
Enterprise Value	- -	791	1,284	3,196	1,664	3,540	4,274	4,189	4,558	4,266
Total Capital	- -	- -	1,455	1,425	-443	-92	740	1,070	1,213	1,436
Total Debt/Capital (%)	- -	- -	26.7	27.35	-88.28	-423.84	52.74	36.71	33.36	28.66
Total Debt / EV	- -	- -	0.3	0.12	0.24	0.11	0.09	0.09	0.09	0.1
EV/Sales	- -	1.96	- -	3.39	3.07	3.28	2.52	3.41	3.46	3.25
EV/EBITDA	- -	2.48	- -	4.8	- -	4.43	3.25	4.79	4.92	4.86
EV/EBIT	- -	4.16	- -	24.98	- -	5.87	3.98	7.61	8.9	9.71
EV/Cash Flow to Firm	- -	3.07	- -	4.76	4.93	4.32	3.24	4.89	4.89	4.76
EV/Free Cash Flow to Firm	- -	1.57	- -	2.89	2.97	3.35	2.39	3.27	3.21	3.12
Diluted Market Cap	- -	791	- -	2,101	1,174	3,309	4,406	4,010	4,360	4,063
Diluted Enterprise Value	- -	791	1,284	3,261	1,664	3,559	4,285	4,193	4,559	4,267
EV per Share	- -	9.74	- -	19.74	10.01	20.3	22.8	22.26	24.44	22.99
TTM Sales	111	403	- -	942	541	1,078	1,694	1,227	1,316	1,312
TTM EBITDA	62	320	- -	666	-247	800	1,317	875	926	877
TTM Operating Income	29	190	- -	128	-544	603	1,074	550	512	439
TTM Cash Flow to Firm	30	257	- -	672	338	819	1,320	856	932	896
TTM Free Cash Flow to Firm	56	505	- -	1,107	560	1,055	1,785	1,281	1,419	1,366

Multiples (USD)

API Chat

	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
Price/Free Cash Flow	- -	1.57	- -	1.94	2.21	3.23	2.5	3.13	3.1	3.01
EV/EBIT	- -	4.16	- -	24.98	- -	5.87	3.98	7.61	8.9	9.71
Enterprise Value	- -	791	1,284	3,196	1,664	3,540	4,274	4,189	4,558	4,266
Low Price	- -	9.66	9.67	9.27	3.23	7.04	18.01	18.72	19.16	19.09
EV/Sales	- -	1.96	- -	3.39	3.07	3.28	2.52	3.41	3.46	3.25
EV/EBITDA	- -	2.48	- -	4.8	- -	4.43	3.25	4.79	4.92	4.86
Price/Earnings	- -	4.42	- -	40.57	- -	7.88	4.92	10.32	11.91	12.49
Price/Earnings Average	- -	4.46	- -	37.36	-0.9	6.11	4.9	10.55	12.58	13.26
Price/Earnings High	- -	4.66	- -	45.57	-1.83	9.23	6.36	11.77	14.78	15.31
Price/Earnings Low	- -	4.39	- -	29.9	-0.44	2.94	3.78	9.07	9.76	10.89
Price/Book Value	- -	- -	- -	24.55	-1.04	-4.65	23.67	8.24	5.78	4.21
Price/Book Value Average	- -	- -	- -	22.6	-0.97	-3.6	23.58	8.43	6.1	4.47
Price/Book Value High	- -	- -	- -	27.57	-1.96	-5.44	30.59	9.4	7.17	5.16
Price/Book Value Low	- -	- -	- -	18.09	-0.48	-1.73	18.18	7.25	4.73	3.67
Price/Tangible Book Value	- -	0.5	- -	0.75	1.41	3.15	2.53	2.13	2.22	2.03
Price/Tangible Book Value Average	- -	0.5	- -	0.69	1.31	2.44	2.52	2.18	2.34	2.16
Price/Tangible Book Value High	- -	0.52	- -	0.85	2.66	3.68	3.26	2.43	2.75	2.49
Price/Tangible Book Value Low	- -	0.49	- -	0.55	0.65	1.17	1.94	1.87	1.82	1.77
Price/Sales	- -	1.96	- -	2.16	2.17	3.05	2.59	3.27	3.31	3.1
Price/Sales Average	- -	1.98	- -	1.99	2.01	2.36	2.58	3.34	3.5	3.29
Price/Sales High	- -	2.07	- -	2.43	4.08	3.57	3.35	3.73	4.11	3.8
Price/Sales Low	- -	1.95	- -	1.59	0.99	1.14	1.99	2.87	2.72	2.7
Price/Cash Flow	- -	3.07	- -	3.14	3.79	4.17	3.39	4.68	4.73	4.62
Price/Cash Flow Average	- -	3.1	- -	2.9	3.51	3.23	3.38	4.79	5	4.91
Price/Cash Flow High	- -	3.24	- -	3.53	7.13	4.88	4.38	5.34	5.88	5.67
Price/Cash Flow Low	- -	3.05	- -	2.32	1.73	1.56	2.6	4.12	3.88	4.03
Price/Free Cash Flow Average	- -	1.58	- -	1.79	2.05	2.5	2.49	3.2	3.27	3.2
Price/Free Cash Flow High	- -	1.65	- -	2.18	4.15	3.78	3.23	3.57	3.84	3.7
Price/Free Cash Flow Low	- -	1.55	- -	1.43	1.01	1.2	1.92	2.75	2.54	2.63
EV/Sales Average	- -	1.98	- -	3.22	2.92	2.59	2.51	3.49	3.65	3.44
EV/Sales High	- -	2.07	- -	3.66	4.99	3.8	3.28	3.87	4.26	3.95
EV/Sales Low	- -	1.95	- -	2.82	1.9	1.37	1.92	3.02	2.87	2.86
EV/EBITDA Average	- -	2.49	- -	4.56	-6.41	3.5	3.23	4.89	5.18	5.15
EV/EBITDA High	- -	2.6	- -	5.18	-10.95	5.13	4.22	5.43	6.05	5.91
EV/EBITDA Low	- -	2.45	- -	3.99	-4.16	1.85	2.47	4.23	4.07	4.27
EV/EBIT Average	- -	4.19	- -	23.72	-2.9	4.64	3.97	7.78	9.38	10.28
EV/EBIT High	- -	4.38	- -	26.94	-4.96	6.81	5.18	8.64	10.96	11.81
EV/EBIT Low	- -	4.13	- -	20.79	-1.89	2.45	3.03	6.73	7.37	8.53
Last Price	- -	9.74	11.21	12.58	7.06	18.87	23.45	21.29	23.38	21.89
High Price	- -	10.25	15.23	14.13	13.29	22.09	30.31	24.29	29.02	26.84
Enterprise Value Average	- -	797	1,284	3,035	1,579	2,798	4,258	4,281	4,801	4,516
Enterprise Value High	- -	833	1,284	3,447	2,700	4,101	5,560	4,753	5,610	5,185
Enterprise Value Low	- -	785	1,284	2,660	1,027	1,477	3,255	3,705	3,771	3,747

	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
Shares Outstanding	- -	81	156	167	163	179	192	183	189	181
Diluted Weighted Avg Shares	75	81	- -	167	166	175	188	188	186	186
Basic Weighted Avg Shares	75	81	- -	162	166	174	187	188	186	186
Revenue per Share	1.48	4.96	- -	5.82	3.26	6.18	9.04	6.52	7.06	7.07
EBITDA per Share	0.83	3.94	- -	4.11	-1.48	4.59	7.03	4.65	4.97	4.73
Operating Income per Share	0.38	2.34	- -	0.79	-3.27	3.46	5.73	2.92	2.75	2.37
Basic EPS, GAAP	0.29	2.2	- -	0.31	-7.27	2.39	4.77	2.06	1.96	1.75
Basic EPS from Cont Ops	0.29	2.2	- -	0.53	-11.24	3.21	5.6	2.35	2.13	1.82
Diluted EPS, GAAP	0.29	2.2	- -	0.3	-7.27	2.38	4.76	2.06	1.96	1.75
Diluted EPS from Cont Ops	0.29	2.2	- -	0.51	-11.24	3.19	5.59	2.35	2.13	1.82
Dividend per Share	- -	- -	- -	- -	- -	0.08	0.4	0.47	0.52	0.61
Cash Flow per Share	0.41	3.17	- -	4	1.87	4.52	6.92	4.55	4.94	4.73
Free Cash Flow per Basic Share	0.06	0.12	- -	1.31	0.53	3.17	4.44	2.29	2.33	2.2
Cash & Equivalents per Share	- -	- -	- -	1.13	1.16	2.1	3.6	2.13	1.39	1.44
Book Value per Share	- -	- -	- -	0.51	-6.77	-4.06	0.99	2.58	4.05	5.2
Tangible Book Value per Share	- -	19.67	- -	16.71	4.99	5.99	9.28	10	10.55	10.77

Magnolia Oil & Gas Corporation

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)