Osage Exploration and Development, Inc. Financial Ratios — OEDVQ

Profitability (USD)

	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y	2011 Y	2012 Y	2013 Y	2014 Y
As of date	12/31/2006	12/31/2007	12/31/2008	12/31/2009	12/31/2010	12/31/2011	12/31/2012	12/31/2013	12/31/2014

Return on Common Equity (%)	- -	-168.87	-115.54	-63.64	-79.47	93	-8.59	37.66	- -
Return on Assets (%)	- -	-128.45	-80.93	-47.03	-58.51	64.15	-5.11	15.94	-100.72
Return on Capital (%)	- -	- -	- -	- -	- -	97.92	- -	- -	- -
Return on Invested Capital (%)	- -	- -	- -	- -	- -	-13.7	- -	- -	- -
Gross Margin (%)	15.56	66.73	73.49	65.77	64.76	69.62	88.57	80.72	84.74
EBITDA Margin (%)	-510.5	-79.32	-91.48	-2.38	-69.31	1.23	-17.77	48.16	36.11
Operating Margin (%)	-512.15	-279.01	-97.03	-15.67	-88.48	-10.99	-42.89	19.26	-16.97
Incremental Operating Margin (%)	- -	- -	- -	- -	- -	- -	49.05	43.68	- -
Pretax Margin (%)	-594.19	-612.38	-120.48	-82.31	-88.42	73.8	-105.13	-43.76	-272.19
Profit Margin (%)	-594.19	-612.38	-120.48	-82.31	-88.42	72.12	-22.82	48.02	-272.19
Net Income to Common Margin (%)	-594.19	-612.38	-120.48	-82.31	-88.42	72.12	-22.82	48.02	-272.19
Effective Tax Rate (%)	- -	- -	- -	- -	- -	2.27	- -	- -	- -
Dvd Payout Ratio (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -
Sustainable Growth Rate (%)	- -	-168.87	-115.54	-63.64	-79.47	93	-8.59	37.66	- -

Credit (USD)

Credit Ratios API ChatGPT

	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y	2011 Y	2012 Y	2013 Y	2014 Y
As of date	12/31/2006	12/31/2007	12/31/2008	12/31/2009	12/31/2010	12/31/2011	12/31/2012	12/31/2013	12/31/2014

Total Debt	- -	- -	- -	- -	- -	- -	5	20	25
ST Debt	- -	- -	- -	- -	- -	- -	3	20	25
LT Debt	- -	- -	- -	- -	- -	- -	2	- -	- -
Total Debt/EBITDA	-0.14	-2	- -	-0.05	- -	- -	-13	5.17	5.48
Net Debt/EBITDA	-0.01	1.01	0.35	17.51	0.24	-43.99	-11.79	4.45	4.36
Total Debt/EBIT	-0.14	-0.57	- -	-0.01	- -	- -	-5.38	12.93	-11.67
Net Debt/EBIT	-0.01	0.29	0.33	2.66	0.19	4.93	-4.88	11.13	-9.27
EBITDA to Interest Expense	- -	- -	-3.77	-12.57	-611.94	0.32	-0.29	0.85	1.02
EBITDA-CapEx/Interest Expense	- -	- -	-4.86	-370.02	-615.15	-27.23	-9.49	-3.07	-3.13
EBIT to Interest Expense	- -	- -	-3.99	-82.85	-781.16	-2.82	-0.7	0.34	-0.48
Interest Expense	- -	- -	1	- -	- -	- -	1	5	4
Common Equity/Total Assets	46	78.94	66.74	89.43	53.42	75.9	53.48	37.45	-35.15
Long-Term Debt/Equity (%)	- -	0.37	0.07	- -	- -	- -	28.29	- -	- -
Long-Term Debt/Capital (%)	- -	0.3	0.07	- -	- -	- -	17	- -	0.39
Long-Term Debt/Total Assets (%)	- -	0.29	0.05	- -	- -	- -	15.13	- -	0.14
Total Debt/Equity (%)	65.08	23.13	0.15	0.13	- -	- -	66.36	158.81	-204.58
Total Debt/Capital (%)	39.42	18.79	0.15	0.13	- -	- -	39.89	61.36	195.62
Total Debt/Total Assets (%)	29.93	18.26	0.1	0.11	- -	- -	35.49	59.47	71.91
Net Debt to Equity	3.74	-11.69	-21.82	-42.11	-23.68	-45.84	60.19	136.71	-162.59
Net Debt/Capital (%)	2.27	-13.24	-27.92	-72.74	-31.02	-84.62	37.57	57.76	256.56
EBITDA	-1	- -	-3	- -	-1	- -	- -	4	5
EBITDA-CapEx	-1	- -	-4	-2	-1	-4	-13	-14	-14
Operating Income (Loss)	-1	-1	-3	- -	-2	- -	-1	2	-2

Liquidity (USD)

Liquidity Ratios API ChatGPT

	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y	2011 Y	2012 Y	2013 Y	2014 Y
As of date	12/31/2006	12/31/2007	12/31/2008	12/31/2009	12/31/2010	12/31/2011	12/31/2012	12/31/2013	12/31/2014

Cash Ratio	- -	1.37	0.51	4.31	0.29	1.51	0.11	0.13	0.11
Current Ratio	0.13	4.2	0.86	5.02	0.39	1.84	0.86	0.38	0.23
Quick Ratio	0.13	1.39	0.54	4.88	0.3	1.8	0.19	0.27	0.18
CFO/Avg Current Liab	- -	-1.76	0.05	0.55	-0.5	0.05	0.67	0.01	0.24
Common Equity/Total Assets	46	78.94	66.74	89.43	53.42	75.9	53.48	37.45	-35.15
Long-Term Debt/Equity (%)	- -	0.37	0.07	- -	- -	- -	28.29	- -	- -
Long-Term Debt/Capital (%)	- -	0.3	0.07	- -	- -	- -	17	- -	0.39
Long-Term Debt/Total Assets (%)	- -	0.29	0.05	- -	- -	- -	15.13	- -	0.14
Total Debt/Equity (%)	65.08	23.13	0.15	0.13	- -	- -	66.36	158.81	-204.58
Total Debt/Capital (%)	39.42	18.79	0.15	0.13	- -	- -	39.89	61.36	195.62
Total Debt/Total Assets (%)	29.93	18.26	0.1	0.11	- -	- -	35.49	59.47	71.91
CFO/Total Liabilities	-347.1	-103.29	2.95	207.29	-29.93	4.37	28.63	0.38	17.48
CFO/CapEx	-5.5	-23.19	0.08	0.36	-50.94	0.02	0.15	- -	0.44
Altman's Z-Score	457.56	50.55	-0.83	-0.55	-6.84	8.51	2.94	1.16	-2.4

Working Capital (USD)

Working Capital Ratios API ChatGPT

	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y	2011 Y	2012 Y	2013 Y	2014 Y
As of date	12/31/2006	12/31/2007	12/31/2008	12/31/2009	12/31/2010	12/31/2011	12/31/2012	12/31/2013	12/31/2014

Accounts Receivable Turnover	- -	22.22	81.53	25.48	22.07	19.09	6.2	5.11	3.98
Days Sales Outstanding	- -	16.42	4.48	14.32	16.54	19.12	58.84	71.39	91.62
Inventory Turnover	- -	- -	- -	- -	- -	- -	- -	- -	- -
Days Inventory Outstanding	- -	- -	- -	- -	- -	- -	- -	- -	- -
Accounts Payable Turnover	- -	2.52	0.75	0.82	3.05	4.06	0.95	4	0.22
Accounts Payable Turnover Days	- -	144.69	483.76	445.26	119.82	89.97	382.3	91.25	1,650.66
Cash Conversion Cycle	- -	-128.26	-479.28	-430.94	-103.28	-70.85	-323.46	-19.86	-1,559.04
Inventory to Cash Days	- -	16.42	4.48	14.32	16.54	19.12	58.84	71.39	91.62
Inventories	- -	- -	- -	- -	- -	- -	- -	- -	- -
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	- -	- -	- -	- -	- -	- -	- -	- -	- -
Finished Goods	- -	- -	- -	- -	- -	- -	- -	- -	- -
Other Inventory	- -	- -	- -	- -	- -	- -	- -	- -	- -

Enterprise Value (USD)

Enterprise Value API ChatGPT

	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y	2011 Y	2012 Y	2013 Y	2014 Y
As of date	12/31/2006	12/31/2007	12/31/2008	12/31/2009	12/31/2010	12/31/2011	12/31/2012	12/31/2013	12/31/2014

Market Capitalization	101	46	6	1	1	22	44	49	18
- Cash & Cash Equivalents	- -	1	1	1	- -	2	- -	3	5
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Total Debt	- -	- -	- -	- -	- -	- -	5	20	25
Enterprise Value	101	46	5	- -	1	20	48	67	38
Total Capital	- -	2	5	3	1	4	13	33	13
Total Debt/Capital (%)	39.42	18.79	0.15	0.13	- -	- -	39.89	61.36	195.62
Total Debt / EV	- -	0.01	- -	0.02	- -	- -	0.11	0.3	0.65
EV/Sales	1,004.9	158.2	1.47	0.05	0.6	5.59	21.39	8.29	3.04
EV/EBITDA	- -	- -	- -	- -	- -	453.82	32.75	17.22	8.41
EV/EBIT	- -	- -	- -	- -	- -	- -	53.65	43.04	- -
EV/Cash Flow to Firm	- -	- -	5.55	0.21	- -	102.45	14.45	14.32	3.03
EV/Free Cash Flow to Firm	- -	- -	2.76	0.06	- -	4.95	3	2.95	1.23
Diluted Market Cap	20	36	5	1	1	21	43	49	18
Diluted Enterprise Value	20	36	5	- -	1	19	48	66	38
EV per Share	2.5	1.12	0.11	- -	0.02	0.41	0.99	1.34	0.66
TTM Sales	- -	- -	3	3	2	4	2	8	13
TTM EBITDA	-1	- -	-3	- -	-1	- -	- -	4	5
TTM Operating Income	-1	-1	-3	- -	-2	- -	-1	2	-2
TTM Cash Flow to Firm	- -	-1	1	1	- -	- -	3	5	13
TTM Free Cash Flow to Firm	- -	-1	2	3	- -	4	16	23	31

Multiples (USD)

Valuation Multiples API ChatGPT

	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y	2011 Y	2012 Y	2013 Y	2014 Y
As of date	12/31/2006	12/31/2007	12/31/2008	12/31/2009	12/31/2010	12/31/2011	12/31/2012	12/31/2013	12/31/2014

Price/Free Cash Flow	-53.14	-69.29	6.15	0.5	-4.16	5.54	2.92	2.74	0.67
EV/EBIT	- -	- -	- -	- -	- -	- -	53.65	43.04	- -
Enterprise Value	101	46	5	- -	1	20	48	67	38
Low Price	0.51	0.41	0.1	0.01	0.02	0.02	0.4	0.86	0.27
EV/Sales	1,004.9	158.2	1.47	0.05	0.6	5.59	21.39	8.29	3.04
EV/EBITDA	- -	- -	- -	- -	- -	453.82	32.75	17.22	8.41
Price/Earnings	- -	- -	- -	- -	- -	8.39	- -	12.78	- -
Price/Earnings Average	-29.81	-31.4	-5.94	-1.05	-1.13	5.76	-95.28	16.7	-1.54
Price/Earnings High	-45.72	-46.23	-20.95	-4.74	-2.24	11.56	-221.93	23.88	-2.23
Price/Earnings Low	-6.66	-7.43	-1.05	-0.2	-0.55	0.37	-37.46	11.1	-0.44
Price/Book Value	916.83	23.15	1.26	0.47	1.08	5.19	5.55	3.92	-1.5
Price/Book Value Average	836.82	35.48	5.11	0.9	1.43	3.56	6.34	5.12	-4.45
Price/Book Value High	1,283.56	52.24	18.03	4.05	2.84	7.15	14.77	7.32	-6.44
Price/Book Value Low	187.03	8.4	0.9	0.17	0.7	0.23	2.49	3.4	-1.28
Price/Tangible Book Value	916.83	23.15	1.26	0.47	1.08	5.19	5.55	3.92	-1.5
Price/Tangible Book Value Average	836.82	35.48	5.11	0.9	1.43	3.56	6.34	5.12	-4.45
Price/Tangible Book Value High	1,283.56	52.24	18.03	4.05	2.84	7.15	14.77	7.32	-6.44
Price/Tangible Book Value Low	187.03	8.4	0.9	0.17	0.7	0.23	2.49	3.4	-1.28
Price/Sales	194.06	125.46	1.77	0.46	0.75	6.05	19.02	6.14	1.41
Price/Sales Average	177.12	192.28	7.16	0.87	1	4.16	21.74	8.02	4.18
Price/Sales High	271.68	283.11	25.24	3.9	1.98	8.34	50.65	11.47	6.06
Price/Sales Low	39.59	45.52	1.26	0.16	0.49	0.27	8.55	5.33	1.2
Price/Cash Flow	-43.47	-66.3	83.08	1.88	-4.08	369.09	21.95	612.05	2.17
Price/Cash Flow Average	-39.68	-101.61	336.59	3.58	-5.42	253.52	25.09	799.71	6.43
Price/Cash Flow High	-60.86	-149.61	1,186.8	16.13	-10.73	508.52	58.45	1,143.74	9.32
Price/Cash Flow Low	-8.87	-24.06	59.34	0.67	-2.65	16.49	9.86	531.68	1.85
Price/Free Cash Flow Average	-48.51	-106.19	24.91	0.94	-5.53	3.81	3.34	3.58	1.98
Price/Free Cash Flow High	-74.4	-156.36	87.82	4.25	-10.95	7.64	7.77	5.12	2.87
Price/Free Cash Flow Low	-10.84	-25.14	4.39	0.18	-2.7	0.25	1.31	2.38	0.57
EV/Sales Average	917.26	242.88	7.09	0.47	0.85	3.67	24.16	10.18	5.88
EV/Sales High	1,406.57	358	25.8	3.59	1.84	7.9	53.49	13.63	7.81
EV/Sales Low	205.57	56.89	0.99	- -	0.33	- -	10.77	7.48	2.82
EV/EBITDA Average	-179.68	-306.19	-7.75	-19.88	-1.22	297.95	-135.93	21.13	16.29
EV/EBITDA High	-275.53	-451.32	-28.2	-150.95	-2.66	641.88	-300.97	28.3	21.64
EV/EBITDA Low	-40.27	-71.72	-1.08	10.49	-0.47	-21.75	-60.59	15.54	7.8
EV/EBIT Average	-179.1	-87.05	-7.31	-3.02	-0.96	-33.38	-56.32	52.82	-34.68
EV/EBIT High	-274.64	-128.31	-26.59	-22.9	-2.08	-71.91	-124.7	70.76	-46.05
EV/EBIT Low	-40.14	-20.39	-1.02	1.59	-0.37	2.44	-25.11	38.85	-16.61
Last Price	2.5	1.13	0.14	0.03	0.03	0.45	0.89	0.99	0.32
High Price	3.5	2.55	2	0.24	0.08	0.62	2.37	1.85	1.36
Enterprise Value Average	93	70	22	1	2	13	55	82	75
Enterprise Value High	142	103	80	10	3	28	121	109	99
Enterprise Value Low	21	16	3	-1	1	-1	24	60	36

Shares Outstanding	41	41	41	47	47	48	49	50	58
Diluted Weighted Avg Shares	8	32	39	46	46	47	48	50	56
Basic Weighted Avg Shares	8	32	39	46	46	47	48	50	56
Revenue per Share	0.01	0.01	0.08	0.06	0.04	0.07	0.05	0.16	0.22
EBITDA per Share	-0.07	-0.01	-0.07	- -	-0.03	- -	-0.01	0.08	0.08
Operating Income per Share	-0.07	-0.03	-0.08	-0.01	-0.04	-0.01	-0.02	0.03	-0.04
Basic EPS, GAAP	-0.08	-0.06	-0.1	-0.05	-0.04	0.05	-0.01	0.08	-0.61
Basic EPS from Cont Ops	-0.08	-0.06	-0.1	-0.05	-0.04	0.05	-0.05	-0.07	-0.61
Diluted EPS, GAAP	-0.08	-0.06	-0.1	-0.05	-0.04	0.05	-0.01	0.08	-0.61
Diluted EPS from Cont Ops	-0.08	-0.06	-0.1	-0.05	-0.04	0.05	-0.05	-0.07	-0.61
Dividend per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -
Cash Flow per Share	-0.06	-0.02	- -	0.01	-0.01	- -	0.04	- -	0.15
Free Cash Flow per Basic Share	-0.07	-0.02	-0.02	-0.03	-0.01	-0.08	-0.22	-0.36	-0.18
Cash & Equivalents per Share	- -	0.02	0.03	0.03	0.01	0.04	0.01	0.06	0.09
Book Value per Share	- -	0.05	0.11	0.06	0.03	0.09	0.16	0.25	-0.21
Tangible Book Value per Share	- -	0.05	0.11	0.06	0.03	0.09	0.16	0.25	-0.21

Osage Exploration and Development, Inc.

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)