Week 7 - Risk Table - Google Sheets

	A	B	C	D	E	F	G	H	I
1		Ticker	S&P Qual Risk	S&P Bond Rating	LT Debt/ Eq	Debt/ EBITDA	1 yr Boll Bands	ROA	ML Variance Rating
2	1	XOM	Low	AAA	0.083	0.27	OUTSIDE	0.114	A
3	2	WMT	Low	AA	0.640	1.63	INSIDE	0.087	A
4	3	PG	Low	AA-	0.332	1.72	INSIDE	0.089	A
5	4	CVX	Low	AA	0.107	0.30	OUTSIDE	0.109	A
6	5	JNJ	Low	AAA	0.162	0.85	INSIDE	0.135	A
7	6	KO	Low	A+	0.453	2.25	INSIDE	0.194	A
8	7	IBM	Medium	A+	0.948	1.21	OUTSIDE	0.133	B
9	8	MCD	Medium	A	0.786	1.34	INSIDE	0.159	B
10	9	UTX	Low	A	0.468	1.16	INSIDE	0.077	B
11	10	MMM	Low	AA-	0.273	0.78	INSIDE	0.142	B
12	11	NSC	Medium	BBB+	0.618	2.01	OUTSIDE	0.052	B
13	12	NEE	Low	A-	1.250	3.99	INSIDE	0.039	B
14
15		(Margins & Ratios @ COB 8/16/11)
16