Columbine Valley Resources, Inc. Financial Ratios — TRXO

Profitability (USD)

	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y
As of date	03/31/2005	03/31/2006	03/31/2007	03/31/2008	03/31/2009	03/31/2010	03/31/2011	03/31/2012	03/31/2013	03/31/2014	03/31/2015	03/31/2016	03/31/2017

Return on Common Equity (%)	- -	- -	-22.96	-18.14	-99.4	-145.35	-17.84	-28.64	-8.45	-1.03	-161.68	-232.91	- -
Return on Assets (%)	- -	-485.14	-21.35	-15.95	-77.66	-74.54	-5.51	-16.3	-5.79	-1.02	-131.97	-162.4	-172.19
Return on Capital (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Return on Invested Capital (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Gross Margin (%)	- -	- -	71.26	95.85	89.16	- -	- -	- -	- -	- -	- -	-622.31	-11.45
EBITDA Margin (%)	- -	- -	-407.73	-69.6	-11.67	- -	- -	- -	- -	- -	- -	-403.24	-230.79
Operating Margin (%)	- -	- -	-486.36	-139.83	-31.1	- -	- -	- -	- -	- -	- -	-1,026.89	-254.61
Incremental Operating Margin (%)	- -	- -	- -	- -	- -	9.25	- -	- -	- -	- -	- -	- -	- -
Pretax Margin (%)	- -	- -	-486.36	- -	- -	- -	- -	- -	- -	- -	- -	-2,870.2	-359.29
Profit Margin (%)	- -	- -	-749.02	-244.32	-752.13	- -	- -	- -	- -	- -	- -	-2,870.2	-359.29
Net Income to Common Margin (%)	- -	- -	-749.02	-244.32	-752.13	- -	- -	- -	- -	- -	- -	-2,882.6	-364.11
Effective Tax Rate (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Dvd Payout Ratio (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	0.43	1.32
Sustainable Growth Rate (%)	- -	- -	-22.96	-18.14	-99.4	-145.35	-17.84	-28.64	-8.45	-1.03	-161.68	-231.91	- -

Credit (USD)

Credit Ratios API ChatGPT

	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y
As of date	03/31/2005	03/31/2006	03/31/2007	03/31/2008	03/31/2009	03/31/2010	03/31/2011	03/31/2012	03/31/2013	03/31/2014	03/31/2015	03/31/2016	03/31/2017

Total Debt	- -	- -	- -	10	10	10	- -	- -	- -	- -	2	1	1
ST Debt	- -	- -	- -	10	10	10	- -	- -	- -	- -	2	1	1
LT Debt	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Total Debt/EBITDA	- -	- -	- -	-2.59	-13.68	-4.29	- -	- -	- -	- -	-0.6	-0.36	-0.43
Net Debt/EBITDA	0.15	0.37	1.08	-0.77	-12.4	-4.13	2.57	3.66	3.91	-8.36	-0.4	-0.16	-0.41
Total Debt/EBIT	- -	- -	- -	-1.29	-5.13	-4.06	- -	- -	- -	- -	-0.6	-0.14	-0.39
Net Debt/EBIT	0.15	0.37	0.91	-0.38	-4.65	-3.91	2.41	3.51	3.68	12.34	-0.4	-0.06	-0.37
EBITDA to Interest Expense	- -	- -	- -	- -	-0.52	-312.84	-92.49	-36.55	11.25	- -	- -	-25.16	-14.76
EBITDA-CapEx/Interest Expense	- -	- -	- -	- -	-0.52	-312.84	-92.85	-36.55	11.25	- -	- -	-41.78	-16.47
EBIT to Interest Expense	- -	- -	- -	- -	-1.4	-330.87	-98.62	-38.1	11.96	- -	- -	-64.07	-16.28
Interest Expense	- -	- -	- -	- -	1	- -	- -	- -	- -	- -	- -	- -	- -
Common Equity/Total Assets	-571.78	95.55	92.98	83.04	66.65	21.69	59.99	53.22	99.39	89.37	81.54	1.59	-93.6
Long-Term Debt/Equity (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Long-Term Debt/Capital (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Long-Term Debt/Total Assets (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Total Debt/Equity (%)	- -	- -	- -	14	41.24	250.32	- -	- -	- -	- -	14.34	1,755.21	-58.65
Total Debt/Capital (%)	- -	- -	- -	12.28	29.2	71.45	- -	- -	- -	- -	12.54	94.61	-141.82
Total Debt/Total Assets (%)	- -	- -	- -	11.62	27.49	54.29	- -	- -	- -	- -	11.69	28.13	54.89
Net Debt to Equity	14.95	-103.58	-6.77	4.14	37.39	241.09	-110.2	-122.3	-85.17	-100.08	9.62	795.59	-56
Net Debt/Capital (%)	13.01	2,890.9	-7.26	3.97	27.21	70.68	1,080.55	548.42	-574.33	126,500	8.78	88.83	-127.3
EBITDA	- -	- -	-5	-4	-1	-2	-2	-1	-1	- -	-3	-2	-3
EBITDA-CapEx	- -	- -	-6	-8	-1	-2	-2	-1	-1	- -	-5	-4	-3
Operating Income (Loss)	- -	- -	-6	-8	-2	-2	-2	-1	-1	- -	-3	-6	-3

Liquidity (USD)

Liquidity Ratios API ChatGPT

	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y
As of date	03/31/2005	03/31/2006	03/31/2007	03/31/2008	03/31/2009	03/31/2010	03/31/2011	03/31/2012	03/31/2013	03/31/2014	03/31/2015	03/31/2016	03/31/2017

Cash Ratio	0.13	22.26	1.09	0.53	0.09	0.03	3.2	3.04	138.45	8.41	0.23	0.25	0.02
Current Ratio	0.13	22.26	1.19	0.62	0.19	0.08	4	4.32	140.96	8.41	0.28	0.36	0.12
Quick Ratio	0.13	22.26	1.19	0.62	0.19	0.04	3.45	3.57	138.45	8.41	0.26	0.33	0.05
CFO/Avg Current Liab	- -	-7.3	-0.97	-0.52	-0.26	-0.05	-0.6	-0.57	-2.14	-0.55	-0.64	-0.97	-0.57
Common Equity/Total Assets	-571.78	95.55	92.98	83.04	66.65	21.69	59.99	53.22	99.39	89.37	81.54	1.59	-93.6
Long-Term Debt/Equity (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Long-Term Debt/Capital (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Long-Term Debt/Total Assets (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Total Debt/Equity (%)	- -	- -	- -	14	41.24	250.32	- -	- -	- -	- -	14.34	1,755.21	-58.65
Total Debt/Capital (%)	- -	- -	- -	12.28	29.2	71.45	- -	- -	- -	- -	12.54	94.61	-141.82
Total Debt/Total Assets (%)	- -	- -	- -	11.62	27.49	54.29	- -	- -	- -	- -	11.69	28.13	54.89
CFO/Total Liabilities	-78.52	-5,993.86	-39.96	-32.36	-24.85	-3.86	-166.31	-28.14	-7,687.59	-48.69	-28.97	-78.92	-31.63
CFO/CapEx	-28.15	- -	-2.71	-1.08	- -	- -	-663.63	- -	- -	- -	-0.48	-1.48	-4.18
Altman's Z-Score	-144.46	-23.57	-0.36	23.08	-1.47	-6.92	-9.73	-22.99	1,147.09	438.79	95.9	59.72	6.81

Working Capital (USD)

Working Capital Ratios API ChatGPT

	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y
As of date	03/31/2005	03/31/2006	03/31/2007	03/31/2008	03/31/2009	03/31/2010	03/31/2011	03/31/2012	03/31/2013	03/31/2014	03/31/2015	03/31/2016	03/31/2017

Accounts Receivable Turnover	- -	- -	5.12	6.63	7.02	- -	- -	- -	- -	- -	- -	6.51	10.95
Days Sales Outstanding	- -	- -	71.27	55.02	51.98	- -	- -	- -	- -	- -	- -	56.07	33.33
Inventory Turnover	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Days Inventory Outstanding	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Accounts Payable Turnover	- -	34.9	0.43	0.12	0.63	- -	- -	- -	- -	- -	- -	- -	- -
Accounts Payable Turnover Days	- -	10.46	844.35	2,985.32	577.73	- -	- -	- -	- -	- -	- -	- -	- -
Cash Conversion Cycle	- -	- -	-773.09	-2,930.31	-525.75	- -	- -	- -	- -	- -	- -	56.07	33.33
Inventory to Cash Days	- -	- -	71.27	55.02	51.98	- -	- -	- -	- -	- -	- -	56.07	33.33
Inventories	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Finished Goods	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Other Inventory	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Enterprise Value (USD)

Enterprise Value API ChatGPT

	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y
As of date	03/31/2005	03/31/2006	03/31/2007	03/31/2008	03/31/2009	03/31/2010	03/31/2011	03/31/2012	03/31/2013	03/31/2014	03/31/2015	03/31/2016	03/31/2017

Market Capitalization	- -	- -	- -	561	30	22	46	9	30	14	497	366	226
- Cash & Cash Equivalents	- -	- -	5	7	1	- -	4	3	2	- -	1	- -	- -
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Total Debt	- -	- -	- -	10	10	10	- -	- -	- -	- -	2	1	1
Enterprise Value	- -	- -	-5	564	39	32	42	6	28	14	498	366	227
Total Capital	- -	- -	76	79	34	14	4	3	2	- -	15	1	-1
Total Debt/Capital (%)	- -	- -	- -	12.28	29.2	71.45	- -	- -	- -	- -	12.54	94.61	-141.82
Total Debt / EV	- -	- -	- -	0.02	0.25	0.31	- -	- -	- -	- -	- -	- -	0.01
EV/Sales	- -	- -	765.15	104.69	6.28	- -	- -	- -	- -	- -	- -	669.29	191.74
EV/EBITDA	- -	- -	- -	- -	- -	- -	- -	- -	- -	716.86	- -	- -	- -
EV/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Cash Flow to Firm	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Free Cash Flow to Firm	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	511.12	- -	- -
Diluted Market Cap	- -	- -	894	536	29	22	46	9	30	14	95	370	213
Diluted Enterprise Value	- -	- -	889	539	38	32	42	6	28	14	96	370	214
EV per Share	- -	0.95	40,499.61	12,005.44	796.1	658.95	869.68	117.44	570.08	290.62	228.09	165.54	89.7
TTM Sales	- -	- -	1	5	6	- -	- -	- -	- -	- -	- -	1	1
TTM EBITDA	- -	- -	-5	-4	-1	-2	-2	-1	-1	- -	-3	-2	-3
TTM Operating Income	- -	- -	-6	-8	-2	-2	-2	-1	-1	- -	-3	-6	-3
TTM Cash Flow to Firm	- -	- -	-2	- -	- -	- -	- -	-1	-1	- -	-1	-2	-1
TTM Free Cash Flow to Firm	- -	- -	-1	- -	- -	- -	- -	-1	-1	- -	1	-1	-1

Multiples (USD)

Valuation Multiples API ChatGPT

	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y
As of date	03/31/2005	03/31/2006	03/31/2007	03/31/2008	03/31/2009	03/31/2010	03/31/2011	03/31/2012	03/31/2013	03/31/2014	03/31/2015	03/31/2016	03/31/2017

Price/Free Cash Flow	- -	- -	-619.42	-1,569.85	-9.81	-39.82	-11.85	-13.7	-25.92	-1,499.88	97.4	-525.12	-212.64
EV/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Enterprise Value	- -	- -	-5	564	39	32	42	6	28	14	498	366	227
Low Price	- -	- -	33,689.21	5,512.78	428.77	156.2	113.32	94.94	174.57	260.33	134.75	87.5	30.63
EV/Sales	- -	- -	765.15	104.69	6.28	- -	- -	- -	- -	- -	- -	669.29	191.74
EV/EBITDA	- -	- -	- -	- -	- -	- -	- -	- -	- -	716.86	- -	- -	- -
Price/Earnings	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Earnings Average	- -	- -	-154.83	-60.83	-5.45	-1.88	-40.37	-27.6	-101.84	-1,449.6	-10.79	-25.29	-61.69
Price/Earnings High	- -	- -	-267.29	-137.79	-17.27	-8.09	-143.82	-116.56	-341.2	-4,573.91	-21.17	-44.06	-101.87
Price/Earnings Low	- -	- -	-84.98	-18.79	-0.44	-0.38	-8.19	-5.24	-39.69	-948.26	-5.09	-12.41	-16.98
Price/Book Value	- -	- -	- -	8.09	1.25	5.55	13.12	3.39	12.29	86.86	36.83	8,272.37	-112.03
Price/Book Value Average	- -	- -	- -	12.08	10.83	9.47	7.72	9.23	8.99	117.58	46.21	8,919.66	-139.68
Price/Book Value High	- -	- -	- -	27.37	34.31	40.66	27.51	38.97	30.11	370.99	90.67	15,537.84	-230.65
Price/Book Value Low	- -	- -	- -	3.73	0.87	1.89	1.57	1.75	3.5	76.91	21.82	4,376.79	-38.45
Price/Tangible Book Value	- -	- -	- -	8.09	1.25	5.55	13.12	3.39	12.29	86.86	36.83	8,272.37	-112.03
Price/Tangible Book Value Average	- -	- -	- -	12.08	10.83	9.47	7.72	9.23	8.99	117.58	46.21	8,919.66	-139.68
Price/Tangible Book Value High	- -	- -	- -	27.37	34.31	40.66	27.51	38.97	30.11	370.99	90.67	15,537.84	-230.65
Price/Tangible Book Value Low	- -	- -	- -	3.73	0.87	1.89	1.57	1.75	3.5	76.91	21.82	4,376.79	-38.45
Price/Sales	- -	- -	769.57	99.47	4.72	- -	- -	- -	- -	- -	- -	676.21	180.16
Price/Sales Average	- -	- -	1,159.71	148.63	40.98	- -	- -	- -	- -	- -	- -	729.12	224.62
Price/Sales High	- -	- -	2,002.03	336.67	129.88	- -	- -	- -	- -	- -	- -	1,270.12	370.91
Price/Sales Low	- -	- -	636.48	45.91	3.31	- -	- -	- -	- -	- -	- -	357.77	61.83
Price/Cash Flow	- -	- -	-391.22	-116.86	-9.81	-39.82	-11.83	-13.7	-25.92	-1,499.88	-107.32	-171.11	-161.71
Price/Cash Flow Average	- -	- -	-589.55	-174.61	-85.17	-67.93	-6.96	-37.3	-18.96	-2,030.2	-134.63	-184.5	-201.62
Price/Cash Flow High	- -	- -	-1,017.75	-395.52	-269.9	-291.72	-24.8	-157.51	-63.51	-6,405.85	-264.17	-321.39	-332.94
Price/Cash Flow Low	- -	- -	-323.56	-53.94	-6.87	-13.54	-1.41	-7.08	-7.39	-1,328.06	-63.57	-90.53	-55.5
Price/Free Cash Flow Average	- -	- -	-933.45	-2,345.66	-85.17	-67.93	-6.97	-37.3	-18.96	-2,030.2	122.19	-566.21	-265.12
Price/Free Cash Flow High	- -	- -	-1,611.43	-5,313.35	-269.9	-291.72	-24.84	-157.51	-63.51	-6,405.85	239.75	-986.33	-437.79
Price/Free Cash Flow Low	- -	- -	-512.3	-724.55	-6.87	-13.54	-1.41	-7.08	-7.39	-1,328.06	57.69	-277.83	-72.98
EV/Sales Average	- -	- -	1,155.29	156.17	43.35	- -	- -	- -	- -	- -	- -	721.61	238.83
EV/Sales High	- -	- -	1,997.61	353.07	134.25	- -	- -	- -	- -	- -	- -	1,256.54	393.76
EV/Sales Low	- -	- -	632.07	48.61	4.83	- -	- -	- -	- -	- -	- -	354.42	66.43
EV/EBITDA Average	0.15	0.37	1.08	-224.39	-371.43	-20.37	-15.46	-23.94	-37.34	973.28	-194.12	-178.95	-103.49
EV/EBITDA High	0.15	0.37	1.08	-507.31	-1,150.19	-73.87	-61.69	-112.88	-134.29	3,088.99	-380.51	-311.61	-170.62
EV/EBITDA Low	0.15	0.37	1.08	-69.84	-41.36	-7.37	-1.08	-1.58	-12.17	633.79	-91.87	-87.89	-28.78
EV/EBIT Average	0.15	0.37	0.91	-111.69	-139.4	-19.26	-14.5	-22.97	-35.1	-1,437.2	-193.51	-70.27	-93.8
EV/EBIT High	0.15	0.37	0.91	-252.51	-431.68	-69.85	-57.85	-108.3	-126.24	-4,561.38	-379.32	-122.36	-154.65
EV/EBIT Low	0.15	0.37	0.91	-34.76	-15.52	-6.97	-1.02	-1.51	-11.44	-935.89	-91.58	-34.51	-26.09
Last Price	- -	- -	40,733.32	11,944.36	612.53	459.4	949.42	183.76	612.53	294.01	227.5	165.38	89.25
High Price	- -	- -	105,967.89	40,427.06	16,844.61	3,365.86	1,990.73	2,113.23	1,500.7	1,255.69	560	310.63	183.75
Enterprise Value Average	- -	- -	-5	841	267	48	23	21	20	19	625	395	282
Enterprise Value High	- -	- -	-5	1,902	827	174	93	100	71	61	1,225	687	466
Enterprise Value Low	- -	- -	-5	262	30	17	2	1	6	13	296	194	79

Shares Outstanding	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	2	2	3
Diluted Weighted Avg Shares	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	2	2
Basic Weighted Avg Shares	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	2	2
Revenue per Share	- -	- -	52.93	120.08	129.69	- -	- -	- -	- -	- -	- -	0.24	0.5
EBITDA per Share	-0.94	-9.28	-215.81	-83.57	-15.14	-48.25	-30.98	-18.13	-10.89	0.41	-7.71	-0.99	-1.14
Operating Income per Share	-0.95	-9.29	-257.43	-167.9	-40.33	-51.03	-33.04	-18.9	-11.58	-0.27	-7.74	-2.51	-1.26
Basic EPS, GAAP	-0.95	-9.29	-396.46	-293.39	-975.46	-415.96	-13.84	-18.13	-4.4	-0.27	-26.45	-7.05	-1.8
Basic EPS from Cont Ops	-0.95	-9.29	-396.46	-293.39	-975.46	-57.49	-63.02	-17.97	-4.4	-0.27	-26.45	-7.02	-1.78
Diluted EPS, GAAP	-0.95	-9.29	-396.46	-293.39	-975.46	-415.96	-13.84	-18.13	-4.4	-0.27	-26.45	-7.05	-1.8
Diluted EPS from Cont Ops	-0.95	-9.29	-396.46	-293.39	-975.46	-57.49	-63.02	-17.97	-4.4	-0.27	-26.45	-7.02	-1.78
Dividend per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Cash Flow per Share	-0.88	-9.26	-104.12	-102.21	-62.41	-11.54	-80.27	-13.42	-23.63	-0.2	-2.12	-0.97	-0.55
Free Cash Flow per Basic Share	-0.91	-9.26	-142.48	-196.81	-62.41	-11.54	-80.39	-13.42	-23.63	-0.2	-6.58	-1.62	-0.68
Cash & Equivalents per Share	0.09	0.14	- -	145.62	18.88	7.64	79.74	66.32	42.45	3.39	0.29	0.19	0.02
Book Value per Share	-0.58	0.14	- -	1,476.92	490.96	82.77	72.36	54.23	49.84	3.38	6.18	0.02	-0.8
Tangible Book Value per Share	-0.58	0.13	- -	1,476.92	490.96	82.77	72.36	54.23	49.84	3.38	6.18	0.02	-0.8

Columbine Valley Resources, Inc.

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)