Bluestem Group Inc. Financial Ratios — BGRP Stock

Profitability (USD)

	2011 Y	2012 Y	2013 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y
As of date	12/31/2011	12/31/2012	01/31/2013	12/31/2013	01/31/2014	01/31/2015	01/31/2016	01/31/2017	01/31/2018

Return on Common Equity (%)	- -	- -	- -	- -	53.77	45.91	4.71	- -	- -
Return on Assets (%)	- -	2.13	1.94	11.9	14.72	11.17	0.96	-27.32	-22.51
Return on Capital (%)	- -	- -	22.22	- -	- -	- -	- -	- -	- -
Return on Invested Capital (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -
Gross Margin (%)	- -	100	44.21	100	100	46.31	46.2	46.19	47.09
EBITDA Margin (%)	- -	- -	8.94	- -	68.6	9.31	6.42	2.84	2.98
Operating Margin (%)	- -	- -	7.09	- -	68.3	4.73	1.77	-2	-0.35
Incremental Operating Margin (%)	- -	- -	10.33	8.67	419.82	-24.83	0.65	- -	- -
Pretax Margin (%)	- -	51.15	8.2	77.88	68.3	0.04	-1.57	-21.32	-13.19
Profit Margin (%)	- -	55.55	5.16	72.1	64.45	22.77	0.82	-18.46	-11.33
Net Income to Common Margin (%)	- -	55.55	5.16	72.1	64.45	22.75	0.81	-18.5	-11.33
Effective Tax Rate (%)	- -	- -	37.01	- -	- -	- -	- -	- -	- -
Dvd Payout Ratio (%)	- -	2,356.39	- -	1,231.51	1,163.92	-0.13	-0.81	0.21	-37.42
Sustainable Growth Rate (%)	- -	- -	- -	- -	-572.09	45.97	4.75	- -	- -

Credit (USD)

API ChatGPT

	2011 Y	2012 Y	2013 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y
As of date	12/31/2011	12/31/2012	01/31/2013	12/31/2013	01/31/2014	01/31/2015	01/31/2016	01/31/2017	01/31/2018

Total Debt	1,460	222	2	130	107	372	562	516	447
ST Debt	- -	- -	- -	- -	- -	18	48	48	26
LT Debt	1,460	222	2	130	107	354	514	469	420
Total Debt/EBITDA	- -	- -	0.03	- -	1.03	8.35	5.02	8.66	7.94
Net Debt/EBITDA	- -	- -	7.09	- -	-0.33	2.54	3.33	5.01	5.71
Total Debt/EBIT	- -	- -	0.03	- -	1.03	16.43	18.21	-12.31	-67.01
Net Debt/EBIT	- -	- -	8.93	- -	-0.34	4.99	12.1	-7.12	-48.19
EBITDA to Interest Expense	- -	- -	- -	- -	- -	7.19	2.86	1.23	1.24
EBITDA-CapEx/Interest Expense	- -	- -	- -	- -	- -	7.08	1.94	0.34	0.79
EBIT to Interest Expense	- -	- -	- -	- -	- -	3.66	0.79	-0.87	-0.15
Interest Expense	- -	- -	- -	- -	- -	6	39	48	45
Common Equity/Total Assets	-0.37	3.15	-5.88	26.74	28.03	22.45	18.47	-6.91	-40.91
Long-Term Debt/Equity (%)	51.45	16	- -	32.03	26.42	54.11	76.32	219.4	8,241.12
Long-Term Debt/Capital (%)	90.83	59.32	-3.3	37.67	33.34	52.95	58.86	106.6	269.87
Long-Term Debt/Total Assets (%)	16.98	7.73	0.19	19.15	16.52	27.22	30.99	39.71	58.09
Total Debt/Equity (%)	51.45	16	-3.2	32.03	26.42	56.83	83.45	241.62	8,759.43
Total Debt/Capital (%)	90.83	59.32	-3.3	37.67	33.34	55.61	64.35	117.4	286.85
Total Debt/Total Assets (%)	16.98	7.73	0.19	19.15	16.52	28.58	33.89	43.74	61.75
Net Debt to Equity	-44.85	-90.54	-876.63	0.96	-8.58	17.27	55.46	139.81	6,299.71
Net Debt/Capital (%)	113.1	113.78	-899.16	1.78	-22.8	27.25	54.35	131.68	993.43
EBITDA	- -	- -	63	- -	104	45	112	60	56
EBITDA-CapEx	- -	- -	49	- -	84	44	76	16	36
Operating Income (Loss)	- -	- -	50	- -	104	23	31	-42	-7

Liquidity (USD)

API ChatGPT

	2011 Y	2012 Y	2013 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y
As of date	12/31/2011	12/31/2012	01/31/2013	12/31/2013	01/31/2014	01/31/2015	01/31/2016	01/31/2017	01/31/2018

Cash Ratio	- -	- -	- -	- -	8.14	1.32	0.52	0.5	0.48
Current Ratio	- -	- -	1.24	- -	13.37	2.38	1.73	1.41	1.6
Quick Ratio	- -	- -	1.07	- -	8.36	1.7	0.74	0.67	0.57
CFO/Avg Current Liab	- -	- -	-0.07	2.39	38.89	0.87	0.35	0.37	0.43
Common Equity/Total Assets	-0.37	3.15	-5.88	26.74	28.03	22.45	18.47	-6.91	-40.91
Long-Term Debt/Equity (%)	51.45	16	- -	32.03	26.42	54.11	76.32	219.4	8,241.12
Long-Term Debt/Capital (%)	90.83	59.32	-3.3	37.67	33.34	52.95	58.86	106.6	269.87
Long-Term Debt/Total Assets (%)	16.98	7.73	0.19	19.15	16.52	27.22	30.99	39.71	58.09
Total Debt/Equity (%)	51.45	16	-3.2	32.03	26.42	56.83	83.45	241.62	8,759.43
Total Debt/Capital (%)	90.83	59.32	-3.3	37.67	33.34	55.61	64.35	117.4	286.85
Total Debt/Total Assets (%)	16.98	7.73	0.19	19.15	16.52	28.58	33.89	43.74	61.75
CFO/Total Liabilities	- -	415.26	-2.73	293.1	166.02	14.34	9.67	15.02	20.29
CFO/CapEx	- -	- -	-1.79	- -	20.35	134.79	2.65	3.35	7.12
Altman's Z-Score	-0.01	0.13	1.15	0.62	1.7	1.8	3.13	2.68	3.13

Working Capital (USD)

API ChatGPT

	2011 Y	2012 Y	2013 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y
As of date	12/31/2011	12/31/2012	01/31/2013	12/31/2013	01/31/2014	01/31/2015	01/31/2016	01/31/2017	01/31/2018

Accounts Receivable Turnover	- -	- -	1.94	0.35	64.12	16.66	35.88	44.46	64.05
Days Sales Outstanding	- -	- -	187.71	1,033.25	5.69	21.91	10.17	8.21	5.7
Inventory Turnover	- -	- -	11.89	- -	- -	4.65	4.39	3.79	3.93
Days Inventory Outstanding	- -	- -	30.69	- -	- -	78.44	83.14	96.31	92.83
Accounts Payable Turnover	- -	- -	8.59	-1.24	- -	8.95	8.71	5.44	4.98
Accounts Payable Turnover Days	- -	- -	42.48	-295.03	- -	40.77	41.89	67.13	73.32
Cash Conversion Cycle	- -	- -	175.93	- -	- -	59.59	51.42	37.39	25.21
Inventory to Cash Days	- -	- -	157.01	- -	- -	-56.52	-72.97	-88.1	-87.13
Inventories	- -	- -	66	- -	- -	110	317	280	229
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	- -	- -	- -	- -	- -	- -	- -	- -	- -
Finished Goods	- -	- -	- -	- -	- -	96	264	230	195
Other Inventory	- -	- -	66	- -	- -	14	53	50	35

Enterprise Value (USD)

API ChatGPT

	2011 Y	2012 Y	2013 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y
As of date	12/31/2011	12/31/2012	01/31/2013	12/31/2013	01/31/2014	01/31/2015	01/31/2016	01/31/2017	01/31/2018

Market Capitalization	- -	19	- -	26	28	31	26	12	13
- Cash & Cash Equivalents	2,733	1,479	- -	127	169	254	186	213	123
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	5	5	5	5
+ Minority/Non Controlling Interest	179	62	- -	34	33	- -	- -	- -	- -
+ Total Debt	1,460	222	2	130	107	372	562	516	447
Enterprise Value	-1,094	-1,181	1	58	-1	153	407	320	341
Total Capital	1,608	374	-49	346	322	669	873	440	156
Total Debt/Capital (%)	90.83	59.32	-3.3	37.67	33.34	55.61	64.35	117.4	286.85
Total Debt / EV	-1.33	-0.19	1.28	2.24	-144.62	2.42	1.38	1.61	1.31
EV/Sales	- -	- -	- -	0.46	0.43	0.32	0.23	0.15	0.18
EV/EBITDA	- -	- -	0.02	- -	0.63	3.45	3.64	5.36	6.06
EV/EBIT	- -	- -	0.03	- -	0.63	6.78	13.19	- -	- -
EV/Cash Flow to Firm	- -	- -	- -	0.07	0.16	0.07	5.44	1.71	1.85
EV/Free Cash Flow to Firm	- -	- -	- -	0.07	0.16	0.07	3.68	1.39	1.66
Diluted Market Cap	- -	19	- -	26	29	31	26	12	13
Diluted Enterprise Value	-1,094	-1,176	1	63	-1	154	407	320	341
EV per Share	- -	- -	- -	0.58	0.66	1.42	2.99	2.41	2.58
TTM Sales	- -	220	700	127	152	478	1,743	2,101	1,892
TTM EBITDA	- -	- -	63	- -	104	45	112	60	56
TTM Operating Income	- -	- -	50	- -	104	23	31	-42	-7
TTM Cash Flow to Firm	- -	6,158	-25	803	404	2,271	75	187	185
TTM Free Cash Flow to Firm	- -	6,158	-11	803	424	2,271	111	231	205

Multiples (USD)

API ChatGPT

	2011 Y	2012 Y	2013 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y
As of date	12/31/2011	12/31/2012	01/31/2013	12/31/2013	01/31/2014	01/31/2015	01/31/2016	01/31/2017	01/31/2018

Price/Free Cash Flow	- -	- -	- -	0.03	0.07	0.33	0.2	0.06	0.08
EV/EBIT	- -	- -	0.03	- -	0.63	6.78	13.19	- -	- -
Enterprise Value	-1,094	-1,181	1	58	-1	153	407	320	341
Low Price	13	12	11.91	4	4	3	2.5	0.01	0.34
EV/Sales	- -	- -	- -	0.46	0.43	0.32	0.23	0.15	0.18
EV/EBITDA	- -	- -	0.02	- -	0.63	3.45	3.64	5.36	6.06
Price/Earnings	- -	0.16	- -	0.28	0.29	0.28	1.86	- -	- -
Price/Earnings Average	- -	0.14	- -	0.24	0.24	0.31	2.98	-0.04	-0.05
Price/Earnings High	- -	21.64	- -	14.28	13.38	5.72	65.2	-1.04	-0.83
Price/Earnings Low	- -	9.8	- -	4.35	4.07	2.98	24.15	- -	-0.21
Price/Book Value	- -	0.21	- -	0.14	0.16	0.11	0.09	-0.14	-0.04
Price/Book Value Average	- -	0.18	- -	0.12	0.13	0.11	0.14	-0.18	-0.03
Price/Book Value High	- -	29.19	- -	7.19	7.19	2.13	3	-4.97	-0.6
Price/Book Value Low	- -	13.22	- -	2.19	2.19	1.11	1.11	-0.02	-0.15
Price/Tangible Book Value	- -	0.01	- -	0.06	0.07	0.44	-0.16	-0.06	-0.06
Price/Tangible Book Value Average	- -	0.01	- -	0.05	0.06	0.47	-0.26	-0.07	-0.05
Price/Tangible Book Value High	- -	1.9	- -	3.21	3.22	8.87	-5.75	-2	-0.89
Price/Tangible Book Value Low	- -	0.86	- -	0.98	0.98	4.63	-2.13	-0.01	-0.22
Price/Sales	- -	0.09	- -	0.2	0.19	0.06	0.02	0.01	0.01
Price/Sales Average	- -	0.08	- -	0.18	0.15	0.07	0.02	0.01	0.01
Price/Sales High	- -	12.02	- -	10.3	8.62	1.3	0.53	0.19	0.09
Price/Sales Low	- -	5.44	- -	3.14	2.63	0.68	0.2	- -	0.02
Price/Cash Flow	- -	- -	- -	0.03	0.07	0.33	0.28	0.08	0.09
Price/Cash Flow Average	- -	- -	- -	0.03	0.06	0.36	0.44	0.1	0.07
Price/Cash Flow High	- -	0.43	- -	1.63	3.24	6.71	9.66	2.79	1.22
Price/Cash Flow Low	- -	0.19	- -	0.5	0.99	3.5	3.58	0.01	0.31
Price/Free Cash Flow Average	- -	- -	- -	0.03	0.05	0.36	0.32	0.08	0.06
Price/Free Cash Flow High	- -	0.43	- -	1.63	3.09	6.73	7.01	2.15	1.07
Price/Free Cash Flow Low	- -	0.19	- -	0.5	0.94	3.51	2.6	0.01	0.27
EV/Sales Average	- -	- -	- -	0.47	0.31	0.33	0.24	0.15	0.18
EV/Sales High	- -	6.58	- -	10.59	8.43	1.56	0.75	0.34	0.27
EV/Sales Low	- -	- -	- -	3.43	2.43	0.94	0.41	0.15	0.2
EV/EBITDA Average	- -	- -	0.02	- -	-0.06	3.5	3.78	5.42	6.01
EV/EBITDA High	- -	- -	0.02	- -	12.29	16.74	11.61	11.96	9
EV/EBITDA Low	- -	- -	0.02	- -	3.55	10.05	6.44	5.2	6.63
EV/EBIT Average	- -	- -	0.03	- -	-0.06	6.89	13.7	-7.71	-50.75
EV/EBIT High	- -	- -	0.03	- -	12.34	32.91	42.14	-17.02	-76.02
EV/EBIT Low	- -	- -	0.03	- -	3.56	19.76	23.38	-7.39	-55.99
Last Price	0.12	0.19	0.19	0.26	0.29	0.28	0.19	0.09	0.1
High Price	17	26.5	26.5	13.13	13.13	5.75	6.75	3.05	1.35
Enterprise Value Average	-1,094	-1,178	1	60	-6	156	423	323	338
Enterprise Value High	-1,094	1,445	1	1,347	1,280	745	1,300	714	507
Enterprise Value Low	-1,094	- -	1	437	370	447	721	310	373

Shares Outstanding	100	100	- -	100	6	136	137	132	133
Diluted Weighted Avg Shares	- -	100	- -	100	100	109	136	133	132
Basic Weighted Avg Shares	- -	100	- -	100	100	108	136	133	132
Revenue per Share	- -	2.2	- -	1.28	1.52	4.42	12.8	15.81	14.31
EBITDA per Share	- -	- -	- -	- -	1.04	0.41	0.82	0.45	0.43
Operating Income per Share	- -	- -	- -	- -	1.04	0.21	0.23	-0.32	-0.05
Basic EPS, GAAP	- -	1.22	- -	0.92	0.98	1.01	0.1	-2.92	-1.62
Basic EPS from Cont Ops	- -	1.14	- -	1	1.05	0.65	0.1	-2.92	-1.62
Diluted EPS, GAAP	- -	1.22	- -	0.92	0.98	1	0.1	-2.92	-1.62
Diluted EPS from Cont Ops	- -	1.14	- -	1	1.05	0.64	0.1	-2.92	-1.62
Dividend per Share	- -	14.6	- -	10.55	10.55	- -	- -	- -	0.61
Cash Flow per Share	- -	61.82	- -	8.05	4.05	0.86	0.7	1.09	1.1
Free Cash Flow per Basic Share	- -	61.82	- -	8.05	3.85	0.85	0.43	0.77	0.95
Cash & Equivalents per Share	- -	14.89	- -	1.32	1.69	2.35	1.37	1.6	0.93
Book Value per Share	- -	0.91	- -	1.83	1.83	2.7	2.25	-0.61	-2.24
Tangible Book Value per Share	- -	13.94	- -	4.08	4.07	0.65	-1.17	-1.52	-1.51

Bluestem Group Inc.

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)