Cistera Networks, Inc. Financial Ratios — CNWT Stock

Profitability (USD)

	1999 Y	2000 Y	2001 Y	2002 Y	2003 Y	2004 Y	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y
As of date	03/31/1999	03/31/2000	03/31/2001	03/31/2002	03/31/2003	03/31/2004	03/31/2005	03/31/2006	03/31/2007	03/31/2008	03/31/2009	03/31/2010

Return on Common Equity (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Return on Assets (%)	- -	- -	- -	- -	- -	-335.93	-230.18	-207.91	-36.56	-163.43	-170.09	-15.29
Return on Capital (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Return on Invested Capital (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Gross Margin (%)	- -	100	-7,994,600	- -	- -	78.84	82.87	78.81	84.53	65.88	74.21	72.6
EBITDA Margin (%)	- -	- -	- -	- -	- -	7.13	3.91	20.03	16.96	-37.12	48.38	16.29
Operating Margin (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	-101.33	- -	- -
Incremental Operating Margin (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	346.91	- -
Pretax Margin (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Profit Margin (%)	-75	100	-7,994,700	- -	- -	-349.59	-165.66	-287.93	-57.39	-182.72	-124.6	-14.79
Net Income to Common Margin (%)	-75	100	-7,994,700	- -	- -	-349.59	-165.66	-287.93	-57.39	-182.72	-124.6	-14.79
Effective Tax Rate (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Dvd Payout Ratio (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Sustainable Growth Rate (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Credit (USD)

Credit Ratios API ChatGPT

	1999 Y	2000 Y	2001 Y	2002 Y	2003 Y	2004 Y	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y
As of date	03/31/1999	03/31/2000	03/31/2001	03/31/2002	03/31/2003	03/31/2004	03/31/2005	03/31/2006	03/31/2007	03/31/2008	03/31/2009	03/31/2010

Total Debt	- -	- -	- -	- -	- -	- -	1	- -	2	2	1	1
ST Debt	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	1	1
LT Debt	- -	- -	- -	- -	- -	- -	1	- -	2	2	- -	- -
Total Debt/EBITDA	- -	- -	- -	- -	- -	4.8	24.42	1.26	6.08	-1.96	0.55	2.12
Net Debt/EBITDA	- -	- -	- -	- -	- -	4.75	23.56	1.06	4.54	-1.84	0.55	2.09
Total Debt/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	-0.72	- -	- -
Net Debt/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	-0.68	- -	- -
EBITDA to Interest Expense	- -	- -	- -	- -	- -	- -	- -	- -	- -	-3.43	7.68	1.57
EBITDA-CapEx/Interest Expense	- -	- -	- -	- -	- -	- -	- -	- -	- -	-4.44	7.45	1.56
EBIT to Interest Expense	- -	- -	- -	- -	- -	- -	- -	- -	- -	-9.36	- -	- -
Interest Expense	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Common Equity/Total Assets	-31.6	- -	- -	- -	- -	-99.6	-155.01	25.54	-13.34	-92.44	-80.06	-97.82
Long-Term Debt/Equity (%)	- -	- -	- -	- -	- -	- -	- -	6.09	- -	- -	- -	- -
Long-Term Debt/Capital (%)	33.33	- -	- -	- -	-154.92	-2.71	-142.1	4.02	114.57	-228.43	- -	- -
Long-Term Debt/Total Assets (%)	15.8	- -	- -	- -	- -	2.25	87.36	1.56	56.3	54.59	- -	- -
Total Debt/Equity (%)	-250	- -	- -	-90.08	-60.77	-16.53	-60.34	51.63	-468.47	-74.15	-51.43	-39.62
Total Debt/Capital (%)	166.67	- -	- -	-907.76	-154.92	-19.8	-152.13	34.05	127.14	-286.81	-105.87	-65.62
Total Debt/Total Assets (%)	78.99	- -	- -	- -	- -	16.46	93.53	13.18	62.48	68.54	41.17	38.76
Net Debt to Equity	-250	- -	- -	-90.08	-60.77	-16.35	-58.21	43.49	-349.66	-69.72	-51.35	-38.97
Net Debt/Capital (%)	166.67	- -	- -	-907.76	-154.92	-19.55	-140.23	30.24	140.05	-230.21	-105.54	-63.87
EBITDA	- -	- -	- -	- -	- -	- -	- -	- -	- -	-1	2	- -
EBITDA-CapEx	- -	- -	- -	- -	- -	- -	- -	- -	- -	-1	2	- -
Operating Income (Loss)	- -	- -	- -	- -	- -	- -	- -	- -	- -	-3	- -	- -

Liquidity (USD)

Liquidity Ratios API ChatGPT

	1999 Y	2000 Y	2001 Y	2002 Y	2003 Y	2004 Y	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y
As of date	03/31/1999	03/31/2000	03/31/2001	03/31/2002	03/31/2003	03/31/2004	03/31/2005	03/31/2006	03/31/2007	03/31/2008	03/31/2009	03/31/2010

Cash Ratio	- -	- -	- -	- -	- -	- -	0.02	0.03	0.29	0.03	- -	- -
Current Ratio	0.14	- -	- -	- -	- -	0.17	0.41	0.17	0.52	0.18	0.08	0.1
Quick Ratio	0.14	- -	- -	- -	- -	0.16	0.4	0.13	0.47	0.11	0.04	0.06
CFO/Avg Current Liab	- -	- -	- -	- -	-0.24	-0.18	-0.55	-0.28	-0.63	-0.41	-0.24	0.01
Common Equity/Total Assets	-31.6	- -	- -	- -	- -	-99.6	-155.01	25.54	-13.34	-92.44	-80.06	-97.82
Long-Term Debt/Equity (%)	- -	- -	- -	- -	- -	- -	- -	6.09	- -	- -	- -	- -
Long-Term Debt/Capital (%)	33.33	- -	- -	- -	-154.92	-2.71	-142.1	4.02	114.57	-228.43	- -	- -
Long-Term Debt/Total Assets (%)	15.8	- -	- -	- -	- -	2.25	87.36	1.56	56.3	54.59	- -	- -
Total Debt/Equity (%)	-250	- -	- -	-90.08	-60.77	-16.53	-60.34	51.63	-468.47	-74.15	-51.43	-39.62
Total Debt/Capital (%)	166.67	- -	- -	-907.76	-154.92	-19.8	-152.13	34.05	127.14	-286.81	-105.87	-65.62
Total Debt/Total Assets (%)	78.99	- -	- -	- -	- -	16.46	93.53	13.18	62.48	68.54	41.17	38.76
CFO/Total Liabilities	12.01	- -	- -	- -	-11.2	-8.5	-26.38	-26.56	-32.32	-19.52	-21.68	0.55
CFO/CapEx	0.5	- -	- -	- -	- -	-5.67	-7.82	-25.68	-19.44	-3.64	-16.82	7.76
Altman's Z-Score	2.93	- -	- -	- -	- -	-8.5	-2.61	-24.01	-9.05	-31.99	-47.59	-55.93

Working Capital (USD)

Working Capital Ratios API ChatGPT

	1999 Y	2000 Y	2001 Y	2002 Y	2003 Y	2004 Y	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y
As of date	03/31/1999	03/31/2000	03/31/2001	03/31/2002	03/31/2003	03/31/2004	03/31/2005	03/31/2006	03/31/2007	03/31/2008	03/31/2009	03/31/2010

Accounts Receivable Turnover	- -	- -	- -	- -	- -	3.74	5.27	5.7	7.99	10.22	18.59	13.48
Days Sales Outstanding	- -	- -	- -	- -	- -	97.72	69.22	64.07	45.71	35.7	19.63	27.07
Inventory Turnover	- -	- -	- -	- -	- -	25.27	20.46	16.49	6.41	7.44	6.13	7.41
Days Inventory Outstanding	- -	- -	- -	- -	- -	14.45	17.84	22.14	56.98	49.07	59.56	49.26
Accounts Payable Turnover	- -	- -	- -	- -	- -	0.14	0.17	0.23	0.47	2.26	1.91	1.26
Accounts Payable Turnover Days	- -	- -	- -	- -	- -	2,618.33	2,122.06	1,566.98	771.19	161.19	191.28	288.59
Cash Conversion Cycle	- -	- -	- -	- -	- -	-2,506.17	-2,035	-1,480.78	-668.5	-76.42	-112.09	-212.25
Inventory to Cash Days	- -	- -	- -	- -	- -	83.28	51.38	41.93	-11.28	-13.37	-39.93	-22.19
Inventories	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Finished Goods	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Other Inventory	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Enterprise Value (USD)

Enterprise Value API ChatGPT

	1999 Y	2000 Y	2001 Y	2002 Y	2003 Y	2004 Y	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y
As of date	03/31/1999	03/31/2000	03/31/2001	03/31/2002	03/31/2003	03/31/2004	03/31/2005	03/31/2006	03/31/2007	03/31/2008	03/31/2009	03/31/2010

Market Capitalization	6	5	1	3	1	7	13	8	12	7	1	1
- Cash & Cash Equivalents	- -	- -	- -	- -	- -	- -	- -	- -	1	- -	- -	- -
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Total Debt	- -	- -	- -	- -	- -	- -	1	- -	2	2	1	1
Enterprise Value	7	5	1	3	1	7	14	9	14	9	2	2
Total Capital	- -	- -	- -	- -	- -	- -	-1	1	2	-1	-1	-1
Total Debt/Capital (%)	166.67	- -	- -	-907.76	-154.92	-19.8	-152.13	34.05	127.14	-286.81	-105.87	-65.62
Total Debt / EV	0.07	- -	- -	- -	0.01	0.01	0.09	0.05	0.15	0.24	0.49	0.41
EV/Sales	8.56	4,671,192.24	975,735.62	- -	- -	26.64	10.75	5.56	6.85	2.99	0.55	0.85
EV/EBITDA	- -	- -	- -	- -	- -	373.55	275.13	27.73	40.37	- -	1.13	5.22
EV/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Cash Flow to Firm	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Free Cash Flow to Firm	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Diluted Market Cap	6	2	1	3	- -	6	11	7	12	6	1	1
Diluted Enterprise Value	7	2	1	3	- -	6	12	7	14	8	2	2
EV per Share	9.44	3.12	0.62	2	0.15	1.77	2.98	1.09	1.69	0.97	0.12	0.11
TTM Sales	1	- -	- -	- -	- -	- -	1	2	2	3	4	2
TTM EBITDA	- -	- -	- -	- -	- -	- -	- -	- -	- -	-1	2	- -
TTM Operating Income	- -	- -	- -	- -	- -	- -	- -	- -	- -	-3	- -	- -
TTM Cash Flow to Firm	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
TTM Free Cash Flow to Firm	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Multiples (USD)

Valuation Multiples API ChatGPT

	1999 Y	2000 Y	2001 Y	2002 Y	2003 Y	2004 Y	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y
As of date	03/31/1999	03/31/2000	03/31/2001	03/31/2002	03/31/2003	03/31/2004	03/31/2005	03/31/2006	03/31/2007	03/31/2008	03/31/2009	03/31/2010

Price/Free Cash Flow	21.17	- -	- -	- -	-196.95	-79.81	-13.99	-11.59	-10.47	-7.8	-1.05	45.8
EV/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Enterprise Value	7	5	1	3	1	7	14	9	14	9	2	2
Low Price	3.12	2.5	0.62	0.45	0.15	0.12	1.1	1.01	0.6	0.44	0.06	0.02
EV/Sales	8.56	4,671,192.24	975,735.62	- -	- -	26.64	10.75	5.56	6.85	2.99	0.55	0.85
EV/EBITDA	- -	- -	- -	- -	- -	373.55	275.13	27.73	40.37	- -	1.13	5.22
Price/Earnings	- -	1,547,682.24	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Earnings Average	-14.12	3,195,025.84	-31.09	-293.44	-432.61	-6.34	-3.91	-2.73	-7.55	-1.54	-1.31	-4.79
Price/Earnings High	-24.2	6,820,715	-97.64	-801.29	-1,471.27	-14.8	-5.76	-4.75	-14.99	-2.7	-2.83	-26.41
Price/Earnings Low	-3.77	1,240,130	-12.2	-120.19	-49.04	-0.47	-2.04	-1.41	-4.18	-0.72	-0.2	-0.78
Price/Book Value	-31.76	- -	- -	-534.19	-56.51	-12.69	-6.21	10.89	-27.63	-2.34	-0.55	-0.58
Price/Book Value Average	-42.37	- -	- -	-293.44	-498.52	-12.11	-4.8	20.28	-19.93	-2.93	-3.57	-0.83
Price/Book Value High	-72.59	- -	- -	-801.29	-1,695.41	-28.27	-7.08	35.28	-39.6	-5.13	-7.74	-4.59
Price/Book Value Low	-11.32	- -	- -	-120.19	-56.51	-0.91	-2.51	10.48	-11.05	-1.38	-0.55	-0.13
Price/Tangible Book Value	-31.76	- -	- -	-534.19	-56.51	-7.69	-5.34	-4.64	-4.53	-1.37	-0.29	-0.34
Price/Tangible Book Value Average	-42.37	- -	- -	-293.44	-498.52	-7.34	-4.13	-8.63	-3.27	-1.71	-1.87	-0.48
Price/Tangible Book Value High	-72.59	- -	- -	-801.29	-1,695.41	-17.14	-6.09	-15.02	-6.49	-2.99	-4.04	-2.64
Price/Tangible Book Value Low	-11.32	- -	- -	-120.19	-56.51	-0.55	-2.16	-4.46	-1.81	-0.8	-0.29	-0.08
Price/Sales	7.94	1,547,682.24	975,735.62	- -	- -	23.21	8.37	4.23	6	2.26	0.25	0.5
Price/Sales Average	10.59	3,195,025.84	2,485,313.03	- -	- -	22.16	6.47	7.87	4.33	2.82	1.63	0.71
Price/Sales High	18.15	6,820,715	7,805,885	- -	- -	51.73	9.54	13.69	8.61	4.93	3.52	3.91
Price/Sales Low	2.83	1,240,130	975,735.62	- -	- -	1.66	3.39	4.07	2.4	1.32	0.25	0.11
Price/Cash Flow	63.52	- -	- -	- -	-196.95	-65.73	-12.2	-11.13	-9.94	-5.65	-0.99	51.7
Price/Cash Flow Average	84.74	- -	- -	- -	-1,737.35	-62.76	-9.43	-20.72	-7.17	-7.07	-6.47	73.56
Price/Cash Flow High	145.18	- -	- -	- -	-5,908.58	-146.49	-13.9	-36.05	-14.24	-12.36	-14.02	405.68
Price/Cash Flow Low	22.65	- -	- -	- -	-196.95	-4.7	-4.93	-10.71	-3.97	-3.32	-0.99	11.93
Price/Free Cash Flow Average	28.25	- -	- -	- -	-1,737.35	-76.2	-10.81	-21.56	-7.56	-9.74	-6.88	65.16
Price/Free Cash Flow High	48.39	- -	- -	- -	-5,908.58	-177.85	-15.94	-37.52	-15.01	-17.05	-14.91	359.36
Price/Free Cash Flow Low	7.55	- -	- -	- -	-196.95	-5.7	-5.66	-11.14	-4.19	-4.57	-1.05	10.57
EV/Sales Average	11.22	9,643,180.95	2,485,313.03	- -	- -	25.45	8.52	10.16	5.15	3.56	2.11	1.07
EV/Sales High	18.77	20,586,183.75	7,805,885	- -	- -	58.94	12.12	17.51	9.48	5.72	4.25	4.35
EV/Sales Low	3.46	3,742,942.5	975,735.62	- -	- -	2.22	4.9	5.35	3.2	2.03	0.55	0.46
EV/EBITDA Average	- -	- -	- -	- -	- -	356.89	217.97	50.69	30.39	-9.59	4.35	6.55
EV/EBITDA High	- -	- -	- -	- -	- -	826.65	310.26	87.4	55.9	-15.4	8.79	26.68
EV/EBITDA Low	- -	- -	- -	- -	- -	31.1	125.37	26.72	18.87	-5.48	1.13	2.81
EV/EBIT Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	-3.51	- -	- -
EV/EBIT High	- -	- -	- -	- -	- -	- -	- -	- -	- -	-5.64	- -	- -
EV/EBIT Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	-2.01	- -	- -
Last Price	8.75	3.12	0.62	2	0.15	1.75	2.72	1.05	1.5	0.75	0.06	0.06
High Price	20	13.75	5	3	4.5	3.9	3.1	3.4	2.15	1.64	0.85	0.51
Enterprise Value Average	9	10	2	2	5	7	11	16	11	10	8	2
Enterprise Value High	15	21	8	5	18	16	16	28	19	16	16	10
Enterprise Value Low	3	4	1	1	1	1	6	8	7	6	2	1

Shares Outstanding	1	1	2	2	4	4	5	8	8	9	17	18
Diluted Weighted Avg Shares	1	- -	2	2	2	4	4	6	8	9	15	18
Basic Weighted Avg Shares	1	- -	2	2	2	4	4	6	8	9	15	18
Revenue per Share	1.1	- -	- -	- -	- -	0.08	0.32	0.25	0.25	0.33	0.24	0.13
EBITDA per Share	- -	- -	- -	- -	- -	0.01	0.01	0.05	0.04	-0.12	0.12	0.02
Operating Income per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	-0.34	- -	- -
Basic EPS, GAAP	-0.83	- -	-0.05	- -	- -	-0.26	-0.54	-0.72	-0.14	-0.61	-0.3	-0.02
Basic EPS from Cont Ops	-0.83	- -	-0.05	- -	- -	-0.26	-0.54	-0.72	-0.14	-0.61	-0.3	-0.02
Diluted EPS, GAAP	-0.83	- -	-0.05	- -	- -	-0.26	-0.54	-0.72	-0.14	-0.61	-0.3	-0.02
Diluted EPS from Cont Ops	-0.83	- -	-0.05	- -	- -	-0.26	-0.54	-0.72	-0.14	-0.61	-0.3	-0.02
Dividend per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Cash Flow per Share	0.14	- -	- -	- -	- -	-0.03	-0.22	-0.09	-0.15	-0.13	-0.06	- -
Free Cash Flow per Basic Share	-0.14	- -	- -	- -	- -	-0.03	-0.25	-0.1	-0.16	-0.17	-0.06	- -
Cash & Equivalents per Share	- -	- -	- -	- -	- -	- -	0.01	0.01	0.06	0.01	- -	- -
Book Value per Share	-0.28	- -	- -	- -	- -	-0.14	-0.44	0.1	-0.05	-0.32	-0.11	-0.11
Tangible Book Value per Share	-0.28	- -	- -	- -	- -	-0.23	-0.51	-0.23	-0.33	-0.55	-0.21	-0.19

Cistera Networks, Inc.

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)