Analysis of the Average Company in the S&P 500

Z

zutalors212

I analyzed 493 out of the 500 companies on the SP500. With the people
of microsoft.public.excel giving me guidance, I was able to take the
weighted averages of many key ratios for that index:

PE = 17.9079254407758
PB = 2.93147754323935
Debt/BookValue = 1.17693944444072
PS = 1.4996896887304
ROE = 0.163697216237257
Net Profit Margins = 0.0837444679837484
 
L

Lawyerkill

zutalors
I analyzed 493 out of the 500 companies on the SP500. With the people
of microsoft.public.excel giving me guidance, I was able to take the
weighted averages of many key ratios for that index:


PE = 17.9079254407758
PB = 2.93147754323935
Debt/BookValue = 1.17693944444072
PS = 1.4996896887304
ROE = 0.163697216237257
Net Profit Margins = 0.0837444679837484


LK

And this means what?
 
B

Bruno R

I analyzed 493 out of the 500 companies on the SP500. With the people
of microsoft.public.excel giving me guidance, I was able to take the
weighted averages of many key ratios for that index:

PE = 17.9079254407758
PB = 2.93147754323935
Debt/BookValue = 1.17693944444072
PS = 1.4996896887304
ROE = 0.163697216237257
Net Profit Margins = 0.0837444679837484
Click to expand...
Excel has a feature for rounding to (at least!) 2 decimals <G>
 
Z

zutalors212

P/E ratio (price/earnings) and so on...
P/S is price to sales
ROE is return on equity
 
L

Lawyerkill

zutalors
P/E ratio (price/earnings) and so on...
P/S is price to sales
ROE is return on equity

LK

I know that, but what does it mean for investing?
 
Top