Need Help with Financing Class

jazzyone1

annual_report.docx

Home >Business & Finance homework help >Need Help with Financing Class

Top of Form

SIC

Line of Business

NAICS

Group By

Industry Quartiles	2009	2010	2011	2012	2013
Statement Sampling	Samples: 94	Samples: 102	Samples: 115	Samples: 123	Samples: 107
Solvency	Upper	Median	Lower	Upper	Median	Lower	Upper	Median	Lower	Upper	Median	Lower	Upper	Median	Lower
Quick Ratio	1.30	0.60	0.40	1.40	0.70	0.30	1.60	0.70	0.40	1.20	0.70	0.40	1.20	0.70	0.40
Current Ratio	1.90	1.10	0.60	2.20	1.10	0.60	2.10	1.10	0.60	1.80	1.00	0.60	1.50	1.00	0.70
Current Liabilities / Net Worth (%)	12.50	22.40	50.60	11.90	20.80	45.10	13.50	23.50	44.90	14.40	25.50	46.50	12.80	22.10	43.20
Current Liabilities / Inventory (%)	448.70	615.70	999.90	696.60	999.90	999.90	614.50	930.20	999.90	708.60	999.90	999.90	695.10	999.90	999.90
Total Liabilities / Net Worth (%)	44.60	106.70	164.20	24.80	93.10	142.30	46.40	98.00	151.80	61.70	109.50	170.90	60.10	109.30	181.00
Fixed Assets / Net Worth (%)	70.30	142.60	207.40	91.30	138.60	200.70	77.90	144.20	200.20	85.40	161.30	221.40	107.30	161.60	225.10
Efficiency	Upper	Median	Lower	Upper	Median	Lower	Upper	Median	Lower	Upper	Median	Lower	Upper	Median	Lower
Collection Period (days)	36.90	53.90	83.10	35.40	50.70	70.30	37.60	52.90	78.50	36.90	55.90	78.70	36.20	50.70	77.60
Sales / Inventory (times)	48.10	22.30	11.30	101.20	36.60	21.30	90.40	41.60	22.60	133.00	38.10	19.00	137.60	35.00	18.60
Assets / Sales (%)	232.00	369.70	587.70	248.30	399.90	585.20	236.90	348.50	498.40	233.20	382.50	633.70	232.50	363.90	500.70
Sales / Net Working Capital (times)	10.20	3.90	1.40	10.20	3.70	1.20	7.00	2.90	1.30	7.50	3.80	1.60	14.20	8.00	3.40
Accounts Payable / Sales (%)	8.90	15.40	28.40	7.80	17.80	31.30	7.20	14.10	28.00	7.90	16.30	35.50	6.90	14.90	27.60
Profitability	Upper	Median	Lower	Upper	Median	Lower	Upper	Median	Lower	Upper	Median	Lower	Upper	Median	Lower
Return on Sales (%)	2.90	-12.90	-61.60	24.00	8.80	-25.50	24.80	13.40	-1.80	20.10	3.60	-48.60	15.70	5.90	-27.80
Return on Assets (%)	1.60	-1.70	-14.20	7.00	2.20	-5.00	8.00	3.60	-2.60	6.00	0.60	-8.80	5.10	1.60	-6.60
Return on Net Worth (%)	6.70	-2.30	-22.30	15.50	6.70	-4.10	16.20	9.70	-0.70	13.00	3.70	-12.60	13.80	4.90	-7.00

Median Variance	2009	2010	2011	2012	2013
Solvency	Median	2010	2011	2012	2013	Median	2009	2011	2012	2013	Median	2009	2010	2012	2013	Median	2009	2010	2011	2013	Median	2009	2010	2011	2012
Quick Ratio	0.60	-16.7	-16.7	-16.7	-16.7	0.70	16.7	0.0	0.0	0.0	0.70	16.7	0.0	0.0	0.0	0.70	16.7	0.0	0.0	0.0	0.70	16.7	0.0	0.0	0.0
Current Ratio	1.10	0.0	0.0	9.1	9.1	1.10	0.0	0.0	9.1	9.1	1.10	0.0	0.0	9.1	9.1	1.00	-9.1	-9.1	-9.1	0.0	1.00	-9.1	-9.1	-9.1	0.0
Current Liabilities / Net Worth (%)	22.40	1.6	-1.1	-3.1	0.3	20.80	-1.6	-2.7	-4.7	-1.3	23.50	1.1	2.7	-2	1.4	25.50	3.1	4.7	2	3.4	22.10	-0.3	1.3	-1.4	-3.4
Current Liabilities / Inventory (%)	615.70	-384.2	-314.5	-384.2	-384.2	999.90	384.2	69.7	0	0	930.20	314.5	-69.7	-69.7	-69.7	999.90	384.2	0	69.7	0	999.90	384.2	0	69.7	0
Total Liabilities / Net Worth (%)	106.70	13.6	8.7	-2.8	-2.6	93.10	-13.6	-4.9	-16.4	-16.2	98.00	-8.7	4.9	-11.5	-11.3	109.50	2.8	16.4	11.5	0.2	109.30	2.6	16.2	11.3	-0.2
Fixed Assets / Net Worth (%)	142.60	4	-1.6	-18.7	-19	138.60	-4	-5.6	-22.7	-23	144.20	1.6	5.6	-17.1	-17.4	161.30	18.7	22.7	17.1	-0.29999999999998	161.60	19	23	17.4	0.29999999999998
Efficiency	Median	2010	2011	2012	2013	Median	2009	2011	2012	2013	Median	2009	2010	2012	2013	Median	2009	2010	2011	2013	Median	2009	2010	2011	2012
Collection Period (days)	53.90	-5.9	-1.9	3.7	-5.9	50.70	5.9	4.3	10.3	0.0	52.90	1.9	-4.3	5.7	-4.2	55.90	-3.7	-10.3	-5.7	-9.3	50.70	5.9	0.0	4.2	9.3
Sales / Inventory (times)	22.30	-64.1	-86.5	-70.9	-57.0	36.60	64.1	-13.7	-4.1	4.4	41.60	86.5	13.7	8.4	15.9	38.10	70.9	4.1	-8.4	8.1	35.00	57.0	-4.4	-15.9	-8.1
Assets / Sales (%)	369.70	-30.2	21.2	-12.8	5.8	399.90	30.2	51.4	17.4	36	348.50	-21.2	-51.4	-34	-15.4	382.50	12.8	-17.4	34	18.6	363.90	-5.8	-36	15.4	-18.6
Sales / Net Working Capital (times)	3.90	5.1	25.6	2.6	-105.1	3.70	-5.1	21.6	-2.7	-116.2	2.90	-25.6	-21.6	-31.0	-175.9	3.80	-2.6	2.7	31.0	-110.5	8.00	105.1	116.2	175.9	110.5
Accounts Payable / Sales (%)	15.40	-2.4	1.3	-0.9	0.5	17.80	2.4	3.7	1.5	2.9	14.10	-1.3	-3.7	-2.2	-0.8	16.30	0.9	-1.5	2.2	1.4	14.90	-0.5	-2.9	0.8	-1.4
Profitability	Median	2010	2011	2012	2013	Median	2009	2011	2012	2013	Median	2009	2010	2012	2013	Median	2009	2010	2011	2013	Median	2009	2010	2011	2012
Return on Sales (%)	-12.90	-21.7	-26.3	-16.5	-18.8	8.80	21.7	-4.6	5.2	2.9	13.40	26.3	4.6	9.8	7.5	3.60	16.5	-5.2	-9.8	-2.3	5.90	18.8	-2.9	-7.5	2.3
Return on Assets (%)	-1.70	-3.9	-5.3	-2.3	-3.3	2.20	3.9	-1.4	1.6	0.6	3.60	5.3	1.4	3	2	0.60	2.3	-1.6	-3	-1	1.60	3.3	-0.6	-2	1
Return on Net Worth (%)	-2.30	-9	-12	-6	-7.2	6.70	9	-3	3	1.8	9.70	12	3	6	4.8	3.70	6	-3	-6	-1.2	4.90	7.2	-1.8	-4.8	1.2

Industry Norms Data	2009	2010	2011	2012	2013
Cash	25619122	11.60%	23073071	11.80%	32093376	9.60%	37037770	11.00%	102286158	11.40%
Accounts Receivable	13692979	6.20%	10363329	5.30%	25407256	7.60%	17845471	5.30%	54732067	6.10%
Notes Receivable	0	0.00%	1368742	0.70%	2674448	0.80%	0	0.00%	0	0.00%
Other Current	11484434	5.20%	12905276	6.60%	20392666	6.10%	19192299	5.70%	35889880	4.00%
Total Current	53446789	24.20%	48883625	25.00%	82907888	24.80%	77105903	22.90%	199188834	22.20%
Fixed Assets	143776280	65.10%	127488494	65.20%	212952922	63.70%	225930397	67.10%	576032574	64.20%
Other Current Assets	23631431	10.70%	19162381	9.80%	38445190	11.50%	33670700	10.00%	122025592	13.60%
Total Assets	220854500	100.00%	195534500	100.00%	334306000	100.00%	336707000	100.00%	897247000	100.00%
Accounts Payable	36440993	16.50%	20922192	10.70%	161804104	48.40%	82493215	24.50%	274557582	30.60%
Bank Loan	0	0.00%	0	0.00%	1337224	0.40%	0	0.00%	0	0.00%
Notes Payable	11042725	5.00%	15251691	7.80%	57834938	17.30%	2356949	0.70%	23328422	2.60%
Other Current	190155724	86.10%	129052770	66.00%	400832894	119.90%	41078254	12.20%	188421870	21.00%
Total Current	237639442	107.60%	165226653	84.50%	621809160	186.00%	125928418	37.40%	486307874	54.20%
Other Long Term	90550345	41.00%	98940457	50.60%	299872482	89.70%	236705021	70.30%	380432728	42.40%
Deferred Credits	441709	0.20%	782138	0.40%	1337224	0.40%	2020242	0.60%	2691741	0.30%
Net Worth	-107776996	-48.80%	-69414748	-35.50%	-588712866	-176.10%	-27946681	-8.30%	27814657	3.10%
Total Liabilities & Net Worth	220854500	100.00%	195534500	100.00%	334306000	100.00%	336707000	100.00%	897247000	100.00%
Net Sales	59738842	100.00%	48895849	100.00%	95927116	100.00%	88027974	100.00%	246564166	100.00%
Gross Profit	28077256	47.00%	25963696	53.10%	54390675	56.70%	45334407	51.50%	130432444	52.90%
Net Profit After Tax	-9080304	-15.20%	5965294	12.20%	13046088	13.60%	4137315	4.70%	4684719	1.90%
Working Capital	-184192653	0.00%	-116343028	0.00%	-538901272	0.00%	-48822515	0.00%	-287119040	0.00%

Bottom of Form