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
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)

API Chat

	1999 Y	2000 Y	2001 Y	2002 Y	2003 Y	2004 Y	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y
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	-126.39	- -	- -	- -	- -	-206.89	-247.28	-259.34	-272.23	-543.5	-887.07	-1,052.39
Long-Term Debt/Equity (%)	- -	- -	- -	- -	- -	- -	- -	6.09	- -	- -	- -	- -
Long-Term Debt/Capital (%)	-33.33	- -	- -	- -	-3.05	-1.18	-56.82	-0.63	-26.84	-11.49	- -	- -
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	- -	- -	-2.71	-3.05	-8.64	-60.83	-5.36	-29.79	-14.43	-4.87	-3.82
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	- -	- -	-2.71	-3.05	-8.54	-57.61	-4.47	-20.67	-13.45	-4.86	-3.76
EBITDA	- -	- -	- -	- -	- -	- -	- -	- -	- -	-1	2	- -
EBITDA-CapEx	- -	- -	- -	- -	- -	- -	- -	- -	- -	-1	2	- -
Operating Income (Loss)	- -	- -	- -	- -	- -	- -	- -	- -	- -	-3	- -	- -

Liquidity (USD)

API Chat

	1999 Y	2000 Y	2001 Y	2002 Y	2003 Y	2004 Y	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y
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	-126.39	- -	- -	- -	- -	-206.89	-247.28	-259.34	-272.23	-543.5	-887.07	-1,052.39
Long-Term Debt/Equity (%)	- -	- -	- -	- -	- -	- -	- -	6.09	- -	- -	- -	- -
Long-Term Debt/Capital (%)	-33.33	- -	- -	- -	-3.05	-1.18	-56.82	-0.63	-26.84	-11.49	- -	- -
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	- -	- -	-2.71	-3.05	-8.64	-60.83	-5.36	-29.79	-14.43	-4.87	-3.82
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.95	-2.95	-24.48	-9.07	-32.01	-47.61	-55.93

Working Capital (USD)

API Chat

	1999 Y	2000 Y	2001 Y	2002 Y	2003 Y	2004 Y	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y
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)

API Chat

	1999 Y	2000 Y	2001 Y	2002 Y	2003 Y	2004 Y	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y
Market Capitalization	6	2	1	3	- -	6	11	7	12	6	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	2	1	3	- -	6	12	7	14	8	2	2
Total Capital	- -	- -	- -	- -	- -	-1	-2	-8	-7	-14	-20	-21
Total Debt/Capital (%)	-166.67	- -	- -	-2.71	-3.05	-8.64	-60.83	-5.36	-29.79	-14.43	-4.87	-3.82
Total Debt / EV	0.07	- -	- -	- -	0.03	0.01	0.1	0.06	0.15	0.25	0.52	0.41
EV/Sales	8.56	1,547,682.24	975,735.62	- -	- -	23.55	9.3	4.44	6.77	2.94	0.51	0.84
EV/EBITDA	- -	- -	- -	- -	- -	330.29	237.92	22.18	39.93	- -	1.06	5.14
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.78	3.02	1.1	1.69	0.98	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)

API Chat

	1999 Y	2000 Y	2001 Y	2002 Y	2003 Y	2004 Y	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y
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	2	1	3	- -	6	12	7	14	8	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	1,547,682.24	975,735.62	- -	- -	23.55	9.3	4.44	6.77	2.94	0.51	0.84
EV/EBITDA	- -	- -	- -	- -	- -	330.29	237.92	22.18	39.93	- -	1.06	5.14
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	-7.94	-13.53	-5.04	-15.64	-1.07	-5.39	-3.32	-0.85	-1.34	-0.39	-0.04	-0.05
Price/Book Value Average	-10.59	-27.92	-12.83	-8.59	-9.46	-5.15	-2.56	-1.58	-0.96	-0.49	-0.28	-0.08
Price/Book Value High	-18.15	-59.61	-40.29	-23.47	-32.17	-12.01	-3.78	-2.75	-1.92	-0.85	-0.62	-0.42
Price/Book Value Low	-2.83	-10.84	-5.04	-3.52	-1.07	-0.39	-1.34	-0.82	-0.53	-0.23	-0.04	-0.01
Price/Tangible Book Value	-31.76	- -	- -	-534.19	-22.05	-6.79	-4.55	-3.67	-4.48	-1.34	-0.25	-0.33
Price/Tangible Book Value Average	-42.37	- -	- -	-293.44	-194.51	-6.48	-3.52	-6.83	-3.23	-1.67	-1.65	-0.47
Price/Tangible Book Value High	-72.59	- -	- -	-801.29	-661.52	-15.13	-5.19	-11.89	-6.41	-2.93	-3.57	-2.57
Price/Tangible Book Value Low	-11.32	- -	- -	-120.19	-22.05	-0.49	-1.84	-3.53	-1.79	-0.79	-0.25	-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	3,195,025.84	2,485,313.03	- -	- -	22.5	7.39	8.08	5.1	3.5	1.89	1.05
EV/Sales High	18.77	6,820,715	7,805,885	- -	- -	52.07	10.47	13.9	9.37	5.62	3.79	4.25
EV/Sales Low	3.46	1,240,130	975,735.62	- -	- -	2	4.31	4.28	3.17	2.01	0.51	0.46
EV/EBITDA Average	- -	- -	- -	- -	- -	315.58	189.22	40.35	30.07	-9.44	3.91	6.43
EV/EBITDA High	- -	- -	- -	- -	- -	730.24	267.85	69.41	55.27	-15.13	7.83	26.06
EV/EBITDA Low	- -	- -	- -	- -	- -	28.01	110.32	21.37	18.69	-5.41	1.06	2.79
EV/EBIT Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	-3.46	- -	- -
EV/EBIT High	- -	- -	- -	- -	- -	- -	- -	- -	- -	-5.54	- -	- -
EV/EBIT Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	-1.98	- -	- -
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	3	2	2	2	6	10	13	10	10	7	2
Enterprise Value High	15	7	8	5	7	14	14	22	19	16	14	10
Enterprise Value Low	3	1	1	1	- -	1	6	7	6	6	2	1

	1999 Y	2000 Y	2001 Y	2002 Y	2003 Y	2004 Y	2005 Y	2006 Y	2007 Y	2008 Y	2009 Y	2010 Y
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.07	0.01	- -	- -
Book Value per Share	-1.1	-0.23	-0.12	-0.13	-0.14	-0.32	-0.82	-1.24	-1.12	-1.92	-1.38	-1.23
Tangible Book Value per Share	-0.28	- -	- -	- -	-0.01	-0.26	-0.6	-0.29	-0.34	-0.56	-0.24	-0.2

Cistera Networks, Inc.

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)